Db settings
Queries that have the highest frequency of execution
Queries that have the highest frequency of execution
| Name | Setting | Unit | Short desc |
|---|---|---|---|
| checkpoint_completion_target | 0.5 | Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval. | |
| default_statistics_target | 100 | Sets the default statistics target. | |
| effective_cache_size | 524288 | 8kB | Sets the planner's assumption about the total size of the data caches. |
| effective_io_concurrency | 1 | Number of simultaneous requests that can be handled efficiently by the disk subsystem. | |
| maintenance_work_mem | 65536 | kB | Sets the maximum memory to be used for maintenance operations. |
| max_connections | 100 | Sets the maximum number of concurrent connections. | |
| max_wal_size | 1024 | MB | Sets the WAL size that triggers a checkpoint. |
| min_wal_size | 80 | MB | Sets the minimum size to shrink the WAL to. |
| random_page_cost | 4 | Sets the planner's estimate of the cost of a nonsequentially fetched disk page. | |
| shared_buffers | 16384 | 8kB | Sets the number of shared memory buffers used by the server. |
| wal_buffers | 512 | 8kB | Sets the number of disk-page buffers in shared memory for WAL. |
| work_mem | 4096 | kB | Sets the maximum memory to be used for query workspaces. |