Re: problems with large objects dump
От | Marcos Ortiz |
---|---|
Тема | Re: problems with large objects dump |
Дата | |
Msg-id | 5077478B.5040509@uci.cu обсуждение исходный текст |
Ответ на | Re: problems with large objects dump (Sergio Gabriel Rodriguez <sgrodriguez@gmail.com>) |
Список | pgsql-performance |
On 10/11/2012 05:46 PM, Sergio Gabriel Rodriguez wrote:
Hi,Regards, Sergio.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?
That´s depends of several things.
Can you share your postgresql.conf here?Hp proliant Xeon G532 GB RAMOS SLES 10 + logs --> raid 6data-->raid 6
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 betrying 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.9Greetings,sergio.
--
Marcos Luis Ortíz Valmaseda
about.me/marcosortiz
@marcosluis2186

В списке pgsql-performance по дате отправления: