Tom Lane wrote:
Jeff Boes <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
