NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 23 Next »

PostgresSQL Properties - Modifying the posgresql.conf File for PostgreSQL

The following file contains properties controlling the behavior of the PostgreSQL database server:

{PostgreSQL_HOME_DIRECTORY}/posgresql.conf

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.

  • No labels