Changes between Version 23 and Version 24 of phase3


Ignore:
Timestamp:
03/15/24 21:01:36 (8 months ago)
Author:
201166
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • phase3

    v23 v24  
    55
    66* 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
     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
    1717
    1818== Бекап