Tom Lane wrote:
> Jeff Boes <mur(at)qtm(dot)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 ?
In response to
pgsql-admin by date
|Next:||From: tatel||Date: 2004-05-20 19:00:34|
|Subject: tcpip_socket=false and psql is working?|
|Previous:||From: Kris Kiger||Date: 2004-05-20 18:30:53|
|Subject: Clustering Postgres|