PostgreSQL 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

Increase PostgreSQL Memory Allocations

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.

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