 |
Page History
| Wiki Markup |
|---|
{scrollbar:icons=false}
h1. { |
| 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 |
|---|
} {PostgreSQL_HOME_DIRECTORY}/posgresql.conf {code} || Property Name || Description || | {{shared_buffers}} | Number of shared buffers. Value: 1000. | | {{work_mem}} | The |
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. |
| Wiki Markup |
|---|
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} |
