Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 7554F63475C for ; Thu, 12 Mar 2009 10:48:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 28798-08 for ; Thu, 12 Mar 2009 10:48:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.hi-media-techno.com (smtp1.hi-media-techno.com [195.158.241.85]) by mail.postgresql.org (Postfix) with ESMTP id F08CE632F38 for ; Thu, 12 Mar 2009 10:48:33 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id E88E893D3D; Thu, 12 Mar 2009 14:48:30 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at smtp1.backbone.hi-media-techno.com Received: from smtp1.hi-media-techno.com ([127.0.0.1]) by localhost (smtp1.backbone.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 704mTWrWxGFk; Thu, 12 Mar 2009 14:48:24 +0100 (CET) Received: from mail1.hi-media-techno.com (unknown [192.168.27.12]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 69B2793C4C; Thu, 12 Mar 2009 14:48:24 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail1.hi-media-techno.com (Postfix) with ESMTP id 5ED8C6D9017; Thu, 12 Mar 2009 14:48:24 +0100 (CET) X-Virus-Scanned: amavisd-new at Received: from mail1.hi-media-techno.com ([127.0.0.1]) by localhost (mail1.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 5E8i-oLBMzOy; Thu, 12 Mar 2009 14:48:04 +0100 (CET) Received: from dim.localnet (unknown [83.167.62.196]) by mail1.hi-media-techno.com (Postfix) with ESMTP id 0BA566D8FFB; Thu, 12 Mar 2009 14:48:04 +0100 (CET) From: Dimitri Fontaine Organization: Hi-Media To: pgsql-performance@postgresql.org Subject: Re: Full statement logging problematic on larger machines? Date: Thu, 12 Mar 2009 14:45:32 +0100 User-Agent: KMail/1.11.0 (Linux/2.6.26-1-686; KDE/4.2.0; i686; ; ) Cc: Frank Joerdens , Tom Lane , Guillaume Smet , Nic Ferrier , Avleen Vig , Mike Rogers , Andrew Dunstan References: <7d10d2df0903111227g2e40e742g5992cba5158dd4d2@mail.gmail.com> <29255.1236822351@sss.pgh.pa.us> <7d10d2df0903120638s3908aadbm5f285220fc738843@mail.gmail.com> In-Reply-To: <7d10d2df0903120638s3908aadbm5f285220fc738843@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart12127197.lfBRxT6B2N"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200903121445.35481.dfontaine@hi-media.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/120 X-Sequence-Number: 33042 --nextPart12127197.lfBRxT6B2N Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On Thursday 12 March 2009 14:38:56 Frank Joerdens wrote: > I just put the patched .deb on staging and we'll give it a whirl there > for basic sanity checking - we currently have no way to even > approximate the load that we have on live for testing. Is it a capacity problem or a tool suite problem? If the latter, you could try out tsung: http://archives.postgresql.org/pgsql-admin/2008-12/msg00032.php http://tsung.erlang-projects.org/ Regards, =2D-=20 dim --nextPart12127197.lfBRxT6B2N Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEABECAAYFAkm5Ef0ACgkQlBXRlnbh1bkkngCfc9rCwFZEH8K1zeLFmvj/Vho7 p/gAn11KiuoVAyWfKy4eb0+VqZEIl/eJ =OV6k -----END PGP SIGNATURE----- --nextPart12127197.lfBRxT6B2N--