Using PGTune - is it a good source for system configuration?

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...

Responses

Browse pgsql-novice by date

  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