Postgres performance tuning

April 4, 2008
By

After a bit of work, I have managed to optimize the performance of my Postgresql Server.

I have spent a saturday morning digging around postgresql, using the fantastic komodo editor, and I am happy with the final solution.

I followed  some suggestion on power PostgreSQL site, and now my postgres is blazing fast. For small needs, tuning postgres is easy as working with MySql.
And with postgres you get for free Transaction and PL/SQL without the need to do extra configuration or tuning or your database.

The major trick is extending  the shared_buffer, and tuning the max_connections, trying to reducing it to the minimum

For tuning max_connections, remember, for instance,  10 max connections can be able to serve about 100 concurrent “real” users; this metric is not valid for robot like wget robot or similia, which generate much more traffic.

Anyway is not difficult to get a fast PostgreSQL installation “out of the box”, and the resulting database is very robust.

Tags: , ,

Leave a Reply