At 19:52 +0300 on 29/06/1999, Mark Dalphin wrote:
> ... a program called AutoVac which loops over all the databases controlled by
> Postgresql, drops each index, VACUUM ANALYZE each table and then re-creates
> the index. An interesting mixture of shell, Perl and psql (no complaint,
> mind you; it is more than I have done) about which he asked for comments.
Shouldn't vacuum analyze be ran when the indices are in place? I think the
indices tell vacuum analyze which fields are important for stats gathering?
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma
