Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TMRDF-0002I2-2x for pgsql-performance@postgresql.org; Thu, 11 Oct 2012 22:26:41 +0000 Received: from ns3.uci.cu ([200.55.140.180] helo=mx3.uci.cu) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TMRDB-0000RQ-G5 for pgsql-performance@postgresql.org; Thu, 11 Oct 2012 22:26:40 +0000 Received: (qmail 28404 invoked by uid 507); 11 Oct 2012 22:26:23 -0000 Received: from 10.0.0.184 by ns3.uci.cu (envelope-from , uid 501) with qmail-scanner-2.01st (avp: 5.0.2.0. spamassassin: 3.0.6. perlscan: 2.01st. Clear:RC:1(10.0.0.184):. Processed in 1.337726 secs); 11 Oct 2012 22:26:23 -0000 Received: from unknown (HELO ucimail3.uci.cu) (10.0.0.184) by 0 with SMTP; 11 Oct 2012 22:26:21 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by ucimail3.uci.cu (Postfix) with ESMTP id 7A45C1E8C008 for ; Thu, 11 Oct 2012 18:26:21 -0400 (CDT) X-Virus-Scanned: amavisd-new at uci.cu Received: from ucimail3.uci.cu ([127.0.0.1]) by localhost (ucimail3.uci.cu [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id OwZn1eqMzE8G; Thu, 11 Oct 2012 18:26:19 -0400 (CDT) Received: by ucimail3.uci.cu (Postfix, from userid 101) id 712C11E8C004; Thu, 11 Oct 2012 18:26:19 -0400 (CDT) Received: from [10.8.46.124] (unknown [10.8.46.124]) (Authenticated sender: mlortiz@uci.cu) by ucimail3.uci.cu (Postfix) with ESMTPSA id 599301E8C004; Thu, 11 Oct 2012 18:26:19 -0400 (CDT) Message-ID: <5077478B.5040509@uci.cu> Date: Thu, 11 Oct 2012 18:26:19 -0400 From: Marcos Ortiz User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120912 Thunderbird/15.0.1 MIME-Version: 1.0 To: Sergio Gabriel Rodriguez CC: Tom Lane , pgsql-performance@postgresql.org Subject: Re: problems with large objects dump References: <16863.1348151708@sss.pgh.pa.us> In-Reply-To: Content-Type: multipart/alternative; boundary="------------020903060907050301030600" X-Pg-Spam-Score: -4.0 (----) X-Archive-Number: 201210/155 X-Sequence-Number: 48114 This is a multi-part message in MIME format. --------------020903060907050301030600 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit On 10/11/2012 05:46 PM, Sergio Gabriel Rodriguez wrote: > Hi, > I tried with Postgresql 9.2 and the process used to take almost a > day and a half, was significantly reduced to 6 hours, before failing > even used to take four hours. My question now is, how long should it > take the backup for a 200GB database with 80% of large objects? Regards, Sergio. That´s depends of several things. > > Hp proliant Xeon G5 > 32 GB RAM > OS SLES 10 + logs --> raid 6 > data-->raid 6 Can you share your postgresql.conf here? Which filesystem are you using for your data directory? What options are you using to do the backup? > > thanks! > > On Thu, Sep 20, 2012 at 12:53 PM, Sergio Gabriel Rodriguez > > wrote: > > On Thu, Sep 20, 2012 at 11:35 AM, Tom Lane > wrote: > > You wouldn't happen to be > trying to use a 9.0 or later pg_dump would you? Exactly what > 8.4.x > release is this, anyway? > > > > Tom, thanks for replying, yes, we tried it with postgres postgres > 9.1 and 9.2 and the behavior is exactly the same. The production > version is 8.4.9 > > Greetings, > > sergio. > > -- Marcos Luis Ortíz Valmaseda about.me/marcosortiz @marcosluis2186 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS... CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION http://www.uci.cu http://www.facebook.com/universidad.uci http://www.flickr.com/photos/universidad_uci --------------020903060907050301030600 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit
On 10/11/2012 05:46 PM, Sergio Gabriel Rodriguez wrote:
Hi, 
    I tried with Postgresql 9.2 and the process used to take almost a day and a half, was significantly reduced to 6 hours, before failing even used to take four hours. My question now is, how long should it take the backup for a 200GB database with 80% of large objects?
Regards, Sergio.
That´s depends of several things.


Hp proliant Xeon G5
32 GB RAM
OS SLES 10 + logs --> raid 6
data-->raid 6
Can you share your postgresql.conf here?
Which filesystem are you using for your data directory?
What options are you using to do the backup?


thanks!

On Thu, Sep 20, 2012 at 12:53 PM, Sergio Gabriel Rodriguez <sgrodriguez@gmail.com> wrote:
On Thu, Sep 20, 2012 at 11:35 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
 You wouldn't happen to be
trying to use a 9.0 or later pg_dump would you?  Exactly what 8.4.x
release is this, anyway?



Tom, thanks for replying, yes, we tried it with postgres postgres 9.1 and 9.2 and the behavior is exactly the same. The production version is 8.4.9

Greetings, 

sergio. 



--


--------------020903060907050301030600--