 |
Page History
| Wiki Markup |
|---|
{scrollbar:icons=false}
h1. { |
| Scrollbar | ||
|---|---|---|
|
page-info |
...
:title} *PostgresSQL Properties - Modifying the posgresql.conf File for PostgreSQL |
...
* The following file contains properties controlling the behavior of the PostgreSQL database server: |
...
{code |
} {PostgreSQL_HOME_DIRECTORY}/posgresql.conf |
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. |
...
{code}
|| 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. |
{scrollbar:icons=false} |
