To quickly find out a subset of slow queries on your production system, you
can use the pgfouine tool:
http://pgfouine.projects.postgresql.org/
If you then want to make some measurements of PostgreSQL performances with
some different settings and compare them, consider using the tsung tool (and
may be tsung-ploter companion tool to graph several benchs onto the same
charts for comparing purpose):
http://pgfouine.projects.postgresql.org/tsung.html
http://tsung.erlang-projects.org/
http://debian.dalibo.org/unstable/
Thanks for all the links! I'll check these out when I get back to work.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings