Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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?

share|improve this question
add comment

1 Answer

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:

http://wiki.postgresql.org/wiki/Performance_Optimization

http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server

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.

share|improve this answer
    
+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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.