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
Increase PostgresSQL 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|