PostgresSQL Properties
Modifying the posgresql.conf File for PostgreSQL |
---|
- The file
Unknown macro: {PostgreSQL_HOME_DIRECTORY}/posgresql.conf contains properties controlling the behavior of the PostgreSQL database server. |
Property Name |
Description |
---|---|
|
Number of shared buffers. |
Value: 1000. |
{{work_mem }} |
The amount of memory in kilobytes allocated to working memory |
Value: 51200. |
|
The amount of memory in kilobytes allocated to maintenance working memory. |
Value: 512000. |
|
We set the 'enable_seqscan' to false to use always use an index versus a table scan. |