From: Marcos Ortiz <mlortiz@uci.cu>
To: Sergio Gabriel Rodriguez <sgrodriguez@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: problems with large objects dump
Date: Thu, 11 Oct 2012 18:26:19 -0400
Message-ID: <5077478B.5040509@uci.cu> (raw)
In-Reply-To: <CAMHBdEqPt+g+aAUVfE4zV01UOLPsBuU2kpJ2jJHWs2Lr_8x1yg@mail.gmail.com>
References: <CAMHBdEoS3b7XZ2JWWG+Y71MGpnDJFLM3U0WnFMxvhOe=Oq2q_w@mail.gmail.com>
<16863.1348151708@sss.pgh.pa.us>
<CAMHBdEroekZuQZdqXyX5m=_Z6L-+-k_jWvnEi5JbkS_iy_LQ+w@mail.gmail.com>
<CAMHBdEqPt+g+aAUVfE4zV01UOLPsBuU2kpJ2jJHWs2Lr_8x1yg@mail.gmail.com>
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 <mailto:sgrodriguez@gmail.com>> wrote:
>
> On Thu, Sep 20, 2012 at 11:35 AM, Tom Lane <tgl@sss.pgh.pa.us
> <mailto: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.
>
>
--
Marcos Luis Ortíz Valmaseda
about.me/marcosortiz <http://about.me/marcosortiz;
@marcosluis2186 <http://twitter.com/marcosluis2186;
10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
http://www.uci.cuhttp://www.facebook.com/universidad.ucihttp://www.flickr.com/photos/universidad_uci
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlortiz@uci.cu, sgrodriguez@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: problems with large objects dump
In-Reply-To: <5077478B.5040509@uci.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox