Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AB26B9F9F46 for ; Sat, 16 Dec 2006 17:33:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 98627-03 for ; Sat, 16 Dec 2006 17:33:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from achille.dalibo.net (achille.dalibo.net [212.85.153.230]) by postgresql.org (Postfix) with ESMTP id EA20A9F9398 for ; Sat, 16 Dec 2006 17:33:05 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by achille.dalibo.net (Postfix) with ESMTP id 4101115F79; Sat, 16 Dec 2006 22:33:04 +0100 (CET) Received: from achille.dalibo.net ([127.0.0.1]) by localhost (achille [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06694-09; Sat, 16 Dec 2006 22:33:03 +0100 (CET) Received: from [192.168.1.1] (cac94-7-82-243-27-82.fbx.proxad.net [82.243.27.82]) by achille.dalibo.net (Postfix) with ESMTP id 6805815F5E; Sat, 16 Dec 2006 22:33:03 +0100 (CET) From: Dimitri Fontaine Organization: dalibo To: pgsql-performance@postgresql.org Subject: Re: Scaling concerns Date: Sat, 16 Dec 2006 22:32:59 +0100 User-Agent: KMail/1.9.5 Cc: "Steinar H. Gunderson" , tsuraan References: <84fb38e30612160926l609ec55cs352b2495289bae0c@mail.gmail.com> <20061216173221.GA25410@uio.no> In-Reply-To: <20061216173221.GA25410@uio.no> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart35346105.h2HWLqeWOs"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200612162233.02192.dim@dalibo.com> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at dalibo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/447 X-Sequence-Number: 22503 --nextPart35346105.h2HWLqeWOs Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le samedi 16 d=C3=A9cembre 2006 18:32, Steinar H. Gunderson a =C3=A9crit=C2= =A0: > 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= =20 can use the pgfouine tool: http://pgfouine.projects.postgresql.org/ If you then want to make some measurements of PostgreSQL performances with= =20 some different settings and compare them, consider using the tsung tool (an= d=20 may be tsung-ploter companion tool to graph several benchs onto the same=20 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=20 you're not running a debian system. Dependencies are python and matplotlib. Regards, =2D-=20 Dimitri Fontaine http://www.dalibo.com/ --nextPart35346105.h2HWLqeWOs Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD4DBQBFhGYOl4JX7QVNfwQRAgYHAJ9yGebPF6zknypybZcyNCpyRT4J5gCUCc9Q fq/Oz3NyrVs5uryz39+Xpg== =ITPy -----END PGP SIGNATURE----- --nextPart35346105.h2HWLqeWOs--