VACUUM FULL on 24/7 server

From: Aleksey Serba <aserba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: VACUUM FULL on 24/7 server
Date: 2004-10-01 14:55:37
Message-ID: 3e8ef54f0410010755421e6b52@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I have 24/7 production server under high load.
I need to perform vacuum full on several tables to recover disk
space / memory usage frequently ( the server must be online during
vacuum time )
The one trick that i see is to try to vacuum duplicate of
production database ( or just some tables ).
But there are some pitfalls:
http://www.postgresql.org/docs/7.4/interactive/backup-file.html
"If you have dug into the details of the file system layout of
the data you may be tempted to try to back up or restore only
certain individual tables or databases from their respective
files or directories. This will not work because the
information contained in these files contains only half the
truth. The other half is in the commit log files pg_clog/*,
which contain the commit status of all transactions. A table
file is only usable with this information. Of course it is also
impossible to restore only a table and the associated pg_clog
data because that would render all other tables in the database
cluster useless."

Any thoughts?

Thanks in advance,
Aleksey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Matt Roberts 2004-10-01 15:41:52 default select ordering
Previous Message Tom Lane 2004-10-01 14:52:10 Re: Bug with updateable Views and inherited tables?