Expand PostgreSQL configuration to fit hardware

[kmatt]

PostgreSQL defaults are very conservative. Suggest using http://pgtune.leopard.in.ua to at least open up basic settings to make full use of testing platform.

[arangodb-release-bot]

Hi kmat, thanks a lot for the suggestion. We have used
http://pgtune.leopard.in.ua, which was recommended on hackernews, to tune the config. 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