...
The host VMs for the DB have 8GB of RAM.
Until we have some real metrics, let's set aside 2GB for the OS and assume we have 6GB for the DBdifferent amounts of RAM as shown in the table below.
Here I discuss the settings in the postgresql.conf file.
The default settings are for low resource environments and will result in relatively poor performance.
These settings are my "best guess" based on some reading (see links below).
We'll need to do some monitoring in PROD to tune these values.
parameter | value | value | value | links (below) |
|---|---|---|---|---|
VM GB RAM | 4 | 6 | 6 |
|
shared_buffers | 2GB | 2GB | 2GB | 1,2 |
work_mem | 16MB | 16MB | 16MB | 2 |
maintenance_work_mem | 128MB | 128MB | 128MB | 2 |
wal_buffers | 1MB | 1MB | 1MB | 2 |
checkpoint_segments | 6 | 6 | 6 | 2 |
random_page_cost | 2 | 2 | 2 | 2 |
seq_page_cost | 1 | 1 | 1 | 2 |
effective_cache_size | 4GB | 4GB | 4GB | 1 |
max_connections | 100 | 100 | 100 | default |
A restart is needed for these configurations to take affect.
...