> 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?
>
stats are gathered on all fields.
--
Bruce Momjian | http://www.op.net/~candle
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
