Skip site navigation (1) Skip section navigation (2)

problems with large objects dump

From: Sergio Gabriel Rodriguez <sgrodriguez(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: problems with large objects dump
Date: 2012-09-20 12:06:35
Message-ID: CAMHBdEoS3b7XZ2JWWG+Y71MGpnDJFLM3U0WnFMxvhOe=Oq2q_w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2012-09-20 14:35:08
Subject: Re: problems with large objects dump
Previous:From: mal.oracledbaDate: 2012-09-19 12:34:59
Subject: Newbie performance problem - semop taking most of time ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group