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

Reply via email to