| 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: | Whole Thread | Raw Message | 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 |