Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

In MySQL there are tools like mysqltuner.pl and tuning-primer.sh, that can help you optimize the performance of your databases.

Is there something similar for Postgresql?


locked by HopelessN00b Jan 26 at 6:38

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

closed as off-topic by HopelessN00b Jan 26 at 0:37

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

As far as I know there are no good scripts to automatically tune Postgresql. The defaults are pretty sane for a small installation, and it's hard to write a script that does much better guesses for large scale databases, as it is so dependant on your application.

Instead of relying on a script I would strongly recommend that you read up a bit on Postgresql tuning. Start with:



Beyond the basic settings, my experience is that the most commonly overlooked factor is indexes and analysis to ensure the query planner have good data to work with.

+1 - database tuning isn't something that should be left to a script. Even the commercial DBs that have tuning applications (like MSSQL) surround them with the caveat that you should evaluate their suggestions carefully before implementing them. –  voretaq7 Feb 11 '11 at 15:28