From: | Pól Ua Laoínecháin <linehanp(at)tcd(dot)ie> |
---|---|
To: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Using PGTune - is it a good source for system configuration? |
Date: | 2021-09-01 16:19:25 |
Message-ID: | CAF4RT5RfAuwnAycn9pU+Hxqv1aaKiAnQKv0V_BsqjSX5TAymtw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi all,
I used PGTune to obtain system configuration recommendations. I'm
wondering if these can be taken as "gospel" or are there any caveats
or "gotchas" to be aware of?
Below is my config and the recommendations - any comments, advice,
URLs or anything else anybody else might find useful appreciated!
# DB Version: 13
# OS Type: linux
# DB Type: mixed
# Total Memory (RAM): 32 GB
# CPUs num: 2
# Data Storage: ssd
max_connections = 100
shared_buffers = 8GB
effective_cache_size = 24GB
maintenance_work_mem = 2GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1
effective_io_concurrency = 200
work_mem = 41943kB
min_wal_size = 1GB
max_wal_size = 4GB
max_worker_processes = 2
max_parallel_workers_per_gather = 1
max_parallel_workers = 2
max_parallel_maintenance_workers = 1
Should you require any further information, please don't hesitate to
get back to me here on-list.
TIA and rgs,
Pól...
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2021-09-01 16:45:25 | Re: Using PGTune - is it a good source for system configuration? |
Previous Message | hubert depesz lubaczewski | 2021-08-30 13:36:17 | Re: trigger fails |