From: Dimitri Fontaine <dim@dalibo.com>
To: pgsql-performance@postgresql.org
Cc: Steinar H. Gunderson <sgunderson@bigfoot.com>
Cc: tsuraan <tsuraan@gmail.com>
Subject: Re: Scaling concerns
Date: Sat, 16 Dec 2006 22:32:59 +0100
Message-ID: <200612162233.02192.dim@dalibo.com> (raw)
In-Reply-To: <20061216173221.GA25410@uio.no>
References: <84fb38e30612160926l609ec55cs352b2495289bae0c@mail.gmail.com>
<20061216173221.GA25410@uio.no>
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.htmlhttp://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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dim@dalibo.com, sgunderson@bigfoot.com, tsuraan@gmail.com
Subject: Re: Scaling concerns
In-Reply-To: <200612162233.02192.dim@dalibo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox