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 process, we noticed that the decay process considerably to startup backup of large object, so we had to opt for physical backups.
We perform various tests on similar servers with the same version and postgres 9.2 and it is exactly the same, the database does not have other problems, nor has performance problems during everyday use.
Could someone suggest a solution? thanks
Sergio