Re: [GENERAL] Order of Daily VACUUM, CLUSTER, REINDEX

2010-03-19 Thread Alvaro Herrera
Leonardo F escribió: > > VACUUM ANALYZE; > > CLUSTER; > > REINDEX DATABASE "database"; > > ANALYZE has to go after CLUSTER; and CLUSTER already > vacuums the tables (I'm not 100% sure though). CLUSTER also > reindexes the whole table, so there's no need for another REINDEX. > > I think the right

Re: [GENERAL] Order of Daily VACUUM, CLUSTER, REINDEX

2010-03-19 Thread Leonardo F
> VACUUM ANALYZE; > CLUSTER; > REINDEX DATABASE "database"; ANALYZE has to go after CLUSTER; and CLUSTER already vacuums the tables (I'm not 100% sure though). CLUSTER also reindexes the whole table, so there's no need for another REINDEX. I think the right way of doing it would be: CLUSTER; ANA

Re: [GENERAL] Order of Daily VACUUM, CLUSTER, REINDEX

2010-03-19 Thread Grzegorz Jaśkiewicz
yes, if you really want to do it - analyze should be running following cluster, as it moves data around. plus, with 8.4 autovacuum should do the job.

[GENERAL] Order of Daily VACUUM, CLUSTER, REINDEX

2010-03-19 Thread APseudoUtopia
Hey list, I have a cron script that runs a couple cleanup commands on my database. It runs three commands: VACUUM ANALYZE; CLUSTER; REINDEX DATABASE "database"; They are run in the above order. I was wondering if there's a better order to do this in. For example, should the ANALYZE be run _after_