Tune
| Setting | Value |
|---|---|
| max_connections | 750 |
| shared_buffers | 2GB |
| effective_cache_size | 744152kB |
| maintenance_work_mem | 124025kB |
| checkpoint_completion_target | 0.9 |
| wal_buffers | 16MB |
| default_statistics_target | 500 |
| random_page_cost | 1.1 |
| effective_io_concurrency | 256 |
| work_mem | 32MB |
| huge_pages | try |
| min_wal_size | 512MB |
| max_wal_size | 1GB |
Check out PgTune for recommendations. DB version is 14.