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