Re: [PERFORM] problems with large objects dump

2012-09-20 Thread Tom Lane
Sergio Gabriel Rodriguez writes: > 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 a

Re: [PERFORM] problems with large objects dump

2012-09-20 Thread Sergio Gabriel Rodriguez
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.

Re: [PERFORM] problems with large objects dump

2012-09-20 Thread Tom Lane
Sergio Gabriel Rodriguez writes: > Our production database, postgres 8.4 has an approximate size of 200 GB, > most of the data are large objects (174 GB), until a few months ago we used > pg_dump to perform backups, took about 3-4 hours to perform all the > process. Some time ago the process becam

[PERFORM] problems with large objects dump

2012-09-20 Thread Sergio Gabriel Rodriguez
Our production database, postgres 8.4 has an approximate size of 200 GB, most of the data are large objects (174 GB), until a few months ago we used pg_dump to perform backups, took about 3-4 hours to perform all the process. Some time ago the process became interminable, take one or two days to pr