Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DFCE59FA48D for ; Mon, 8 Jan 2007 05:18:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 46120-01 for ; Mon, 8 Jan 2007 05:18:16 -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 7AAC19FA385 for ; Mon, 8 Jan 2007 05:18:30 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by achille.dalibo.net (Postfix) with ESMTP id C342615F5F; Mon, 8 Jan 2007 10:18:28 +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 18032-06; Mon, 8 Jan 2007 10:18:27 +0100 (CET) Received: from dalistar.local (cac94-7-82-243-27-82.fbx.proxad.net [82.243.27.82]) by achille.dalibo.net (Postfix) with ESMTP id E95EB15F5E; Mon, 8 Jan 2007 10:18:26 +0100 (CET) From: Dimitri Fontaine Organization: dalibo To: pgsql-performance@postgresql.org Subject: Re: tweaking under repeatable load Date: Mon, 8 Jan 2007 10:18:19 +0100 User-Agent: KMail/1.9.5 Cc: Ben References: <1554969B-3526-4E6F-941D-2DF845C77541@silentmedia.com> In-Reply-To: <1554969B-3526-4E6F-941D-2DF845C77541@silentmedia.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2143316.a0RbSJdERN"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200701081018.22202.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: 200701/96 X-Sequence-Number: 22697 --nextPart2143316.a0RbSJdERN Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le dimanche 7 janvier 2007 20:03, Ben a =E9crit=A0: > I'd like to optimize my postgres configuration for optimal > performance under typical load. Unfortunately, as I understand > things, that implies that I have to have a way to repeat the same > load each time I try out new settings, so that I can fairly compare. [...] > > Has anybody done anything similar to this? Anything better? Did it > end up being a waste of time, or was it helpful? Please have a look at this: http://pgfouine.projects.postgresql.org/tsung.html =2D-=20 Dimitri Fontaine http://www.dalibo.com/ --nextPart2143316.a0RbSJdERN Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBFogxel4JX7QVNfwQRArAmAJ4sw/WBkLCP8+C5JobtM2TUiqxvfgCeKblJ +4JE23QOzxog1AmzW0y/xm4= =2oWz -----END PGP SIGNATURE----- --nextPart2143316.a0RbSJdERN--