- Good data model, database design, & data organization
- Performant hardware, disk layout, & file system configuration
- Tuning the database configuration parameters in accordance with the above
PostgreSQL has over 200 coniguration parameters. These parameters can be tuned by editing the postgresql.conf file which is usually located at /var/lib/pgsql/data/postgresql.conf. Configuring the parameters is necessary as the default parameters are not tuned for the specific hardware where the database will functional. This CheatSheet provides a quick overview of the most critical set of parameters which should be looked at and tuned for performance. Along with the parameters present in the PostfreSQL configuration file (Autovacuum, Memory, Asynchronous behaviour, Write-Ahead log and logging), the CheatSheet also lists some Kernel setting parameters, which also affects the PostgreSQL performance and should definetely be looked at. The CheatSheet thus provides a quick overview along with the parameter name, their default values, a small description and the recommended setting. The recommended parameter values should be used meticulously with peformance benchmarking.
-
The column headers indicate the category of the parameters
-
The bold text in each block is the specific parameter name
-
The second line is the descrption
-
The third line is the recommended setting
-
The value in circle/rectangle is the Default setting
