From: | Dimitri Fontaine <dim(at)dalibo(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>, tsuraan <tsuraan(at)gmail(dot)com> |
Subject: | Re: Scaling concerns |
Date: | 2006-12-16 21:32:59 |
Message-ID: | 200612162233.02192.dim@dalibo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kostyrka | 2006-12-17 03:25:27 | Re: Scaling concerns |
Previous Message | Tom Lane | 2006-12-16 20:34:41 | Re: partition text/varchar check problem |