4 ms·
Thanks a lot for the suggestion. We have used http://pgtune.leopard.in.ua http://pgtune.leopard.in.ua I have appended the resulting config. The result is that
by fceller 9y ago
Thanks a lot for the suggestion. We have used
http://pgtune.leopard.in.ua http://pgtune.leopard.in.ua I have appended the resulting config.
The result is that the default config is already very good for our benchmark. There is no visible difference between the old and new config when running the benchmark. We will publish an update to the blog post and show the numbers using the tuned config.
best Frank
DBVersion: 10
Linux,
Type: "Mixed type of Applications"
122GB RAM
25 Connections
SSD Storage
=>
max_connections = 25
shared_buffers = 31232MB
effective_cache_size = 93696MB
work_mem = 639631kB
maintenance_work_mem = 2GB
min_wal_size = 1GB
max_wal_size = 2GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100
random_page_cost = 1.1