Tune
Setting | Value |
---|---|
max_connections | 200 |
shared_buffers | 14848MB |
effective_cache_size | 44544MB |
work_mem | 19005kB |
maintenance_work_mem | 2GB |
min_wal_size | 1GB |
max_wal_size | 2GB |
checkpoint_completion_target | 0.7 |
wal_buffers | 16MB |
default_statistics_target | 100 |
Check out PgTune for recommendations. DB version is 11.3 (Ubuntu 11.