[development] Good D6 test?

Ivan Sergio Borgonovo mail at webthatworks.it
Sat Dec 29 12:44:17 UTC 2007


On Sat, 29 Dec 2007 09:44:27 +0100
Dries Buytaert <dries.buytaert at gmail.com> wrote:

> http://lstigile.wordpress.com/2007/12/27/cms_mysql/

I just asked on pg mailing list if there are similar tools for
postgress and I got 2 suggestions:
1) Log Analyzer : pgFouine
http://pgfoundry.org/projects/pgfouine/
2) "set "log_min_duration_statement" in your postgresql.conf to log
all querys with a duration highter than that value"

thx to Andreas Kretschmer and Hervé Piedvache.

pfFouine is GPLed.

They don't help in tuning pgsql config but they help to track down
which are the most critical queries.

-- 
Ivan Sergio Borgonovo
http://www.webthatworks.it



More information about the development mailing list