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 A5F6C9FA5D2 for ; Thu, 15 Jun 2006 22:04:06 -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 75443-10 for ; Thu, 15 Jun 2006 22:03:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 14B7A9FA160 for ; Thu, 15 Jun 2006 22:03:57 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id s1so533834nze for ; Thu, 15 Jun 2006 18:03:56 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UjzFqti6ijsDB4yqnsKOE3Dn/5ZE8Ghm4V14COC4wkEhN4cZZv5P2kj7s5/OVoRUwPhe9isSbdfz8U+TbkXQqrwJjvCAZ4oTakegtEHm8FY0REGpqAc5iDjotjbguRIoBuTNbU5WVNVPe89WHHaZ5gzXZMqevb8YUoyHFU6xc2o= Received: by 10.65.189.20 with SMTP id r20mr1117256qbp; Thu, 15 Jun 2006 18:03:56 -0700 (PDT) Received: by 10.65.139.14 with HTTP; Thu, 15 Jun 2006 18:03:56 -0700 (PDT) Message-ID: Date: Thu, 15 Jun 2006 21:03:56 -0400 From: "Merlin Moncure" To: "John Vincent" Subject: Re: Performance of pg_dump on PGSQL 8.0 Cc: "Scott Marlowe" , "PGSQL Performance" , "Jim C. Nasby" In-Reply-To: <20060614212507.GR34196@pervasive.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <44902165.7020502@lusis.org> <1150303450.26538.9.camel@state.g2switchworks.com> <20060614211343.GP34196@pervasive.com> <20060614212507.GR34196@pervasive.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/337 X-Sequence-Number: 19694 Just couple of suggestions: I think on the current server you're pretty much hosed since you are look like you are cpu bottlenecked. You probably should take a good look at PITR and see if that meets your requirements. Also you definately want to go to 8.1...it's faster, and every bit helps. Good luck with the new IBM server ;) merlin