docs: add raspberry pi results - Githubissues

gbartolini / postgres-kubernetes-playground

Apache License 2.0

14 stars 7 forks source link

docs: add raspberry pi results #4

Closed jbattiato closed 9 months ago

jbattiato commented 9 months ago

Tests

I've only tested the following clusters:

01-pgdata-only.yaml
02-pgdata-wal.yaml

On two different storage classes:

longhorn-pg
localpath

The tablespace ones would not make sense for my use case.

Environment

Hardware:

3 Raspberry Pi v4 8GB
3 SSD 1TB attached through USB 3.0 on each of the 8GB Rpi
1 Raspberry Pi v4 4GB
1 HDD 1TB attached to 4GB RPi through USB 3.0

Kubernetes:

k3s 1.28.6
- 3 CP nodes with etcd in high availability mode
- 1 worker node
Longhorn 1.6.0
Calico 1.26.1

StorageClass

longhorn-pg:

no replicas
data locality: strict-local

localpath

provisioner: rancher.io/local-path
no replicas
data locality

Node Labels

workload: postgres set in one of the master nodes with 8GB RAM
workload: pgbench set in the Rpi with 4GB RAM

Cluster Parameters

  # Request Guaranteed QoS
  resources:
    requests:
      memory: '4Gi'
      cpu: 1.5 
    limits:
      memory: '4Gi'
      cpu: 1.5

      # Memory configuration
      shared_buffers: '4GB'
      maintenance_work_mem: '1GB'
      effective_cache_size: '3GB'