VACUUM FULL vs dump & restore

From: "Ilya A(dot) Kovalenko" <shadow(at)oganer(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: VACUUM FULL vs dump & restore
Date: 2005-09-24 04:56:12
Message-ID: 1981474048079.20050924125612@oganer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greetings,

What advantages I lose, when using dump-truncate-restore (table
or whole DB) instead of performing VACUUM FULL ?
In both cases I have no access to data, but first is much faster
(by subjective estimate).

Thank you,

Ilya A. Kovalenko (mailto:shadow(at)oganer(dot)net)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aldor 2005-09-24 11:19:48 Re: VACUUM FULL vs dump & restore
Previous Message Matthew Peter 2005-09-24 02:51:53 Re: delete item[5] from varchar[] array???