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

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

Compare with Current View Page History

Version 1 Next »

PostgresSQL Properties

Modifying the posgresql.conf File for PostgreSQL

  • The file
    Unknown macro: {PostgreSQL_HOME_DIRECTORY}
    /posgresql.conf contains properties controlling the behavior of the PostgreSQL database server. |

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