pgtune

PostgreSQL configuration tuning wizard for optimizing postgresql.conf

brewmacoslinux
Try with needOr install directly
Source

About

Tuning wizard for postgresql.conf

Commands

pgtune

Examples

Generate tuning recommendations for a system with 4GB RAM$ pgtune -i /etc/postgresql/postgresql.conf -o /etc/postgresql/postgresql.conf.tuned -M 4GB
Create optimized config for a dedicated database server with 16GB RAM$ pgtune -i /var/lib/postgresql/data/postgresql.conf -M 16GB -T DW > postgresql.conf.optimized
Display tuning recommendations without modifying the config file$ pgtune -i /etc/postgresql/postgresql.conf -M 8GB -S SSD