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