PostgreSQL Database Setup

To get the most out of your PostgreSQL database there are a number of tasks you will want to do after you have installed the PostgreSQL Server

The default maximum memory allocated to a default PostgresQL is minuscule. Yes, this means that a stock PostgreSQL will run on a computer with less capability than a modern cell phone but it also means a lot of unnecessary disk swapping. There are a handful of parameters you will want to bump — all found in postgresql.conf.

The following table lists a few key default PostgreSQL parameters and the parameters used in Capstorm’s labs.

• https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server