Re: Table maintenance: order of operations important? - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Table maintenance: order of operations important?
Date
Msg-id 40ACFEBF.7000406@bigfoot.com
Whole thread Raw
In response to Re: Table maintenance: order of operations important?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tom Lane wrote:

> Jeff Boes <mur@qtm.net> 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



pgsql-admin by date:

Previous
From: Kris Kiger
Date:
Subject: Clustering Postgres
Next
From: "David F. Skoll"
Date:
Subject: Exponential behaviour with UPDATE collisions?