https://pgtune.leopard.in.ua/#/
例えばこんな感じで計算してくれます。
ax_connections = 10
shared_buffers = 512MB
effective_cache_size = 48GB
maintenance_work_mem = 2047MB
checkpoint_completion_target = 0.7
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 4
work_mem = 554871kB
min_wal_size = 1GB
max_wal_size = 2GB
max_worker_processes = 8
max_parallel_workers_per_gather = 4
0 件のコメント:
コメントを投稿