http://pqa.projects.postgresql.org/ You need to have ruby installed, though. On 11.10.2005 11:59, David Pradier wrote:
Hi everybody, i'd like to know if my database (settings, indexes, materialized views, etc) is correctly tuned. To do this, i think the best way is to watch the queries actually processed and the time needed. The postgres log is the right way to do this, i think. But well, it's a bit dense. Nothing i can't go through, but would you know a better tool than grep to parse the file and extract the problematic points ? As it might be a common problem, maybe somebody as already written a generic tool to do this ?
-- Regards, Hannes Dorbath ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
