NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

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}
h1. {page-info:title}

*PostgresSQL Properties - Modifying the posgresql.conf File for PostgreSQL*

The following file contains properties controlling the behavior of the PostgreSQL database server:
{code}
{PostgreSQL_HOME_DIRECTORY}/posgresql.conf
{code}

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


{scrollbar:icons=false}