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
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
We have a number of tables from which we expire (delete) rows nightly.
Is there any value to ordering the operations, in terms of either table
physical organization or elapsed time?
E.g.,
DELETE FROM foo WHERE date_expires < now();
VACUUM ANALYZE foo;
CLUSTER foo;
REINDEX TABLE foo;
How