PostgreSQL Database Setup

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

Increase PostgresSQL Memory Allocations

The default maximum memory allocated 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.

Parameter Default Capstorm PostgreSQL Servers
shared_buffers 128MB 4GB
work_mem 4MB 1GB
maintenance_work_mem 64MB 1GB
effective_cache_size 4GB 12GB
For additional help see:
  • https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server