NIH | National Cancer Institute | NCI Wiki  

WIKI MAINTENANCE NOTICE

Please be advised that NCI Wiki will be undergoing maintenance Monday, July 22nd between 1700 ET and 1800 ET and will be unavailable during this period.
Please ensure all work is saved before said time.

If you have any questions or concerns, please contact the CBIIT Atlassian Management Team.

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.