Le samedi 16 décembre 2006 18:32, Steinar H. Gunderson a écrit :
> Instead, try real queries on real data,
> and post here if some are too slow for you.

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/

This latter link also contains a .tar.gz archive of tsung-ploter in case 
you're not running a debian system. Dependencies are python and matplotlib.

Regards,
-- 
Dimitri Fontaine
http://www.dalibo.com/

Attachment: pgpyW4ZPkTS5m.pgp
Description: PGP signature

Reply via email to