LexEVS 6.0 Local Runtime PostgresSQL Properties Guide

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. |

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.