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 ?
Thanks in advance,
David Pradier -- Directeur Technique de Clarisys Informatique -- Chef de projet logiciels libres / open-source
pgsql-admin by date
|Next:||From: Pieter-Jan Savat||Date: 2005-10-11 10:18:17|
|Subject: Memory/Performance issue: server closed the connection unexpectedly|
|Previous:||From: Will Lewis||Date: 2005-10-11 07:56:08|
|Subject: Fwd: Question: 2 GB file limit on linux|