 |
Page History
| Scrollbar | ||
|---|---|---|
|
| Page info | ||||
|---|---|---|---|---|
|
PostgresSQL Properties - Modifying the posgresql.conf File for PostgreSQL
The following file contains properties controlling the behavior of the PostgreSQL database server:
| Code Block |
|---|
| Wiki Markup |
h2. PostgresSQL Properties || Modifying the posgresql.conf File for PostgreSQL | * The file {PostgreSQL_HOME_DIRECTORY}/posgresql.conf contains properties controlling the behavior of the PostgreSQL database server. | || _Property Name_ || _Description_ || | {{shared_buffers}} | Number of shared buffers. Value: 1000. | | {{work_mem }} | The amount of memory in kilobytes allocated to working memory Value: 51200. | | {{maintenance_work_mem}} | The amount of memory in kilobytes allocated to maintenance working memory. Value: 512000. | | {{enable_seqscan}} | We set the 'enable_seqscan' to false to use always use an index versus a table scan. | |
Property Name | Description |
|---|---|
| Number of shared buffers. |
| The amount of memory in kilobytes allocated to working memory |
| The amount of memory in kilobytes allocated to maintenance working memory. |
| We set the 'enable_seqscan' to false to use always use an index versus a table scan. |
| Scrollbar | ||
|---|---|---|
|
