Tune
| Setting | Value |
|---|---|
| max_connections | 5000 |
| shared_buffers | 16235808kB |
| effective_cache_size | 32471616kB |
| work_mem | 4MB |
| maintenance_work_mem | 1064643kB |
| min_wal_size | 192MB |
| max_wal_size | 2GB |
| checkpoint_completion_target | 0.9 |
| wal_buffers | 64MB |
| default_statistics_target | 100 |
Check out PgTune for recommendations. DB version is 11.