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.

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 42

changes.mady.by.user Unknown User (kanjamalapp)

Saved on

compared with

New Version 43

changes.mady.by.user Unknown User (kanjamalapp)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin
Wiki Markup
{scrollbar:icons=false}

Page info
title
title

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

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.

Wiki Markup
{scrollbar:icons=false}