Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C29629F9F44 for ; Wed, 3 Jan 2007 13:21:57 -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 48055-01 for ; Wed, 3 Jan 2007 13:21:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 412FF9F938C for ; Wed, 3 Jan 2007 13:21:41 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l03HLdlK013360; Wed, 3 Jan 2007 12:21:39 -0500 (EST) To: Erik Jones cc: Guillaume Smet , pgsql-performance@postgresql.org Subject: Re: More 8.2 client issues (Was: [Slow dump?) In-reply-to: <459BE4BB.4070601@myemma.com> References: <459AD5A8.7030102@myemma.com> <22512.1167779361@sss.pgh.pa.us> <459BD61C.3030202@myemma.com> <11617.1167841479@sss.pgh.pa.us> <459BDC98.8030008@myemma.com> <1d4e0c10701030850h78f19e74hfa7c25c01ded9a61@mail.gmail.com> <459BE4BB.4070601@myemma.com> Comments: In-reply-to Erik Jones message dated "Wed, 03 Jan 2007 11:15:39 -0600" Date: Wed, 03 Jan 2007 12:21:38 -0500 Message-ID: <13359.1167844898@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/40 X-Sequence-Number: 22641 Erik Jones writes: > Guillaume Smet wrote: >> Could you set log_min_duration_statement=0 on your server and enable > Heh, unfortunately, setting log_min_duration_statement=0 would be a > total last resort as the last we counted (2 months ago) we were doing > approximately 3 million transactions per hour. Do it just for the pg_dump: export PGOPTIONS="--log_min_duration_statement=0" pg_dump ... I don't think that the regex issue explains pg_dump being slow, unless perhaps you are making use of the table-selection switches? regards, tom lane