X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 416429F9FE3 for ; Wed, 14 Jun 2006 14:29:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44350-01 for ; Wed, 14 Jun 2006 14:29:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from hs5.cfa.cmu.edu (HS5.CFA.cmu.edu [128.2.103.215]) by postgresql.org (Postfix) with ESMTP id 1CE489F9CAA for ; Wed, 14 Jun 2006 14:29:33 -0300 (ADT) Received: from webmail.webopticon.org (hs5.cfa.cmu.edu [127.0.0.1]) by hs5.cfa.cmu.edu (8.12.11.20060308/8.12.11) with ESMTP id k5EHTTRn031171; Wed, 14 Jun 2006 13:29:29 -0400 Received: from 216.41.12.254 (SquirrelMail authenticated user agentm) by webmail.webopticon.org with HTTP; Wed, 14 Jun 2006 13:29:29 -0400 (EDT) Message-ID: <43719.216.41.12.254.1150306169.squirrel@webmail.webopticon.org> In-Reply-To: References: <44902165.7020502@lusis.org> <1150303450.26538.9.camel@state.g2switchworks.com> Date: Wed, 14 Jun 2006 13:29:29 -0400 (EDT) Subject: Re: Performance of pg_dump on PGSQL 8.0 From: "A.M." To: "John Vincent" Cc: "Scott Marlowe" , "PGSQL Performance" User-Agent: SquirrelMail/1.5.1 [CVS] MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/262 X-Sequence-Number: 19619 On Wed, June 14, 2006 1:04 pm, John Vincent wrote: > I know it is but that's what we need for some of our queries. Our ETL > tool (informatica) and BI tool (actuate) won't let us set those things as > part of our jobs. We need it for those purposes. We have some really nasty > queries that will be fixed in our new server. You could modify pgpool to insert the necessary set commands and point the tools at pgpool. -M