pgtune

PostgreSQL config tuner

Install

All systems
curl cmd.cat/pgtune.sh
Debian Debian
apt-get install pgtune
Ubuntu
apt-get install pgtune
Fedora
dnf install pgtune
Windows (WSL2)
sudo apt-get update sudo apt-get install pgtune
OS X
brew install pgtune
Raspbian
apt-get install pgtune

pgtune

PostgreSQL config tuner

pgtune works by taking an existing postgresql.conf file as an input, making changes to it based on the amount of RAM in your server and suggested workload, and output a new file. pgtune will add a set of configuration values at the end of the output file. pgtune will set values for variables like maintenance_work_mem, effective_cache_size, work_mem, wal_buffers, checkpoint_segments, shared_buffers or max_connections