X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 2DACDD6F35
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 24 Sep 2005 01:56:41 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 10032-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat, 24 Sep 2005 04:56:38 +0000 (GMT)
Received: from relay.oganer.net (relay.oganer.net [217.150.206.19])
	by svr1.postgresql.org (Postfix) with ESMTP id 35548D9414
	for <pgsql-sql@postgresql.org>; Sat, 24 Sep 2005 01:56:33 -0300 (ADT)
Received: from forest.bear.oganer.net (forest.bear.oganer.net
 [192.168.114.31])
	by relay.oganer.net (8.13.0/8.13.0) with ESMTP id j8O4uCTZ017216
	for <pgsql-sql@postgresql.org>; Sat, 24 Sep 2005 12:56:12 +0800 (KRAST)
Date: Sat, 24 Sep 2005 12:56:12 +0800
From: "Ilya A. Kovalenko" <shadow@oganer.net>
Reply-To: "Ilya A. Kovalenko" <shadow@oganer.net>
Organization: JSC Oganer-Service
X-Priority: 3 (Normal)
Message-ID: <1981474048079.20050924125612@oganer.net>
To: pgsql-sql@postgresql.org
Subject: VACUUM FULL vs dump & restore
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.234 required=5 tests=[AWL=0.049,
	PRIORITY_NO_NAME=1.185]
X-Spam-Level: *
X-Archive-Number: 200509/240
X-Sequence-Number: 22787

     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)