| 7 | | * Max connections – to handle more concurrent connections |
| 8 | | * Shared buffers – allocate more memory for caching data |
| 9 | | * Work mem – allow more memory for each session (helpful for sorting and other memoryintensive operations) |
| 10 | | * Maintenance work mem – allocate more memory for tasks like index creation or vacuuming |
| 11 | | * Checkpoint segments and checkpoint timeout – this can help improve write operations |
| 12 | | * Commit delay – to allow multiple transactions to be batched together which can reduce the I/O load |
| 13 | | * Max wal size – to allow more WAL space for heavy write workloads |
| 14 | | * Max parallel workers – set the number of parallel workers |
| 15 | | * Мax parallel workers per gather – set the number of parallel workers per query |
| 16 | | * Effective cache size – helps the query planner estimate the amount of system memory available for caching data, it provides a hint to the query planner about the amount of cache that can be used for storing frequently accessed data |
| | 7 | * **Max connections** – to handle more concurrent connections |
| | 8 | * **Shared buffers** – allocate more memory for caching data |
| | 9 | * **Work mem** – allow more memory for each session (helpful for sorting and other memoryintensive operations) |
| | 10 | * **Maintenance work mem** – allocate more memory for tasks like index creation or vacuuming |
| | 11 | * **Checkpoint segments and checkpoint timeout** – this can help improve write operations |
| | 12 | * **Commit delay** – to allow multiple transactions to be batched together which can reduce the I/O load |
| | 13 | * **Max wal size** – to allow more WAL space for heavy write workloads |
| | 14 | * **Max parallel workers** – set the number of parallel workers |
| | 15 | * **Мax parallel workers per gather** – set the number of parallel workers per query |
| | 16 | * **Effective cache size** – helps the query planner estimate the amount of system memory available for caching data, it provides a hint to the query planner about the amount of cache that can be used for storing frequently accessed data |
