From: Rod Taylor <pg@rbt.ca>
To: Jamil <jamil.figueira@ibi.com.br>
Cc: 'pgsql-benchmarks@postgresql.org' <pgsql-benchmarks@postgresql.org>
Subject: Re: Largest DATABASE
Date: Tue, 14 Sep 2004 16:46:06 -0400
Message-ID: <1095194766.98565.102.camel@jester> (raw)
In-Reply-To: <A1529E2B5C106443B913EDFCB79854A11273E314@CEAMAIL>
References: <A1529E2B5C106443B913EDFCB79854A11273E314@CEAMAIL>
> I would like to know witch was the largest database that you ever
> had to administrate. My database is about to 160GB and I´ve got some
> problems to backup it using the pg_dump command and I too have some problems
> to run vaccum.
Tell me about it. We started to do more fine grained scheduling of
vacuum a little while back we we past the 120GB mark.
You can try out the vacuum daemon, but it really didn't help me (little
tables were ignored too much, big tables done too often).
Check VACUUM VERBOSE output to see if you need to vacuum all of the
structures at the current rate.
We're still doing the dump, but running pg_dump on a different machine.
Most of the CPU time it eats up is in formatting the data for the dump.
Another option (which can take some effort) is to take the database
offline, fsync, take a filesystem snapshot, restart the database, tar up
the snapshot, remove the snapshot.
Database downtime can be short enough that if clients reattempt a failed
connection for some time (a couple of minutes), they'll simply see a
hicup and not a failure.
Looking forward to PITR making backups much friendlier.
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-benchmarks@postgresql.org
Cc: pg@rbt.ca, jamil.figueira@ibi.com.br
Subject: Re: Largest DATABASE
In-Reply-To: <1095194766.98565.102.camel@jester>
* 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