| | 3 | |
| | 4 | == Редовно одржување на базите на податоци |
| | 5 | |
| | 6 | * Parameter Tuning |
| | 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 |
