Simple script to analyse your PostgreSQL database config, give tuning advice

Simple script to analyse your PostgreSQL database config, give tuning advice

It is inspired by mysqltuner.pl

If available postgresqltuner.pl will use standard PostgreSQL variables like , , , , and password from file. When using it remotly, postgresqltuner.pl will use ssh to collect OS informations. You can configure the average number of work_mem buffers per connection (in percent):

When running in an hypervisor with SSD disks, detection is not accurate.

Source: github.com