X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2DABFD1B1E3 for ; Thu, 20 May 2004 16:19:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82829-05 for ; Thu, 20 May 2004 16:19:36 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 18D4AD1B445 for ; Thu, 20 May 2004 16:19:35 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i4KJJYSx093403 for ; Thu, 20 May 2004 19:19:34 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i4KIs6Ee088071 for pgsql-admin@postgresql.org; Thu, 20 May 2004 18:54:06 GMT From: Gaetano Mendola X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Table maintenance: order of operations important? Date: Thu, 20 May 2004 20:53:51 +0200 Organization: PYRENET Midi-pyrenees Provider Lines: 25 Message-ID: <40ACFEBF.7000406@bigfoot.com> References: <3030.1085075532@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: abuse@pyrenet.fr To: Tom Lane User-Agent: Mozilla Thunderbird 0.6 (Windows/20040502) X-Accept-Language: en-us, en In-Reply-To: <3030.1085075532@sss.pgh.pa.us> To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200405/218 X-Sequence-Number: 13534 Tom Lane wrote: > Jeff Boes writes: > >> DELETE FROM foo WHERE date_expires < now(); >> VACUUM ANALYZE foo; >> CLUSTER foo; >> REINDEX TABLE foo; > > >>How would you choose to order these (under 7.4.x) for fastest >>turn-around? Does it matter? > > > If you are going to CLUSTER then the VACUUM and the REINDEX are both > utterly redundant. Without cluster with 7.4.2 a REINDEX is redundant after a VACUUM FULL ? Regards Gaetano Mendola