Home > mailing lists

VACUUM FULL vs dump & restore - Mailing list pgsql-sql

From	Ilya A. Kovalenko
Subject	VACUUM FULL vs dump & restore
Date	September 24, 2005 04:56:42
Msg-id	1981474048079.20050924125612@oganer.net Whole thread Raw
Responses	Re: VACUUM FULL vs dump & restore Re: VACUUM FULL vs dump & restore
List	pgsql-sql

Tree view

     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@oganer.net)

pgsql-sql by date:

From: Matthew Peter
Date: 24 September 2005, 02:51:59
Subject: Re: delete item[5] from varchar[] array???

From: Aldor
Date: 24 September 2005, 11:19:48
Subject: Re: VACUUM FULL vs dump & restore

VACUUM FULL vs dump & restore - Mailing list pgsql-sql

Previous

Next