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 |
---|
} {PostgreSQL_HOME_DIRECTORY}/posgresql.conf {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} |
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 | ||
---|---|---|
|