Re: Indexes not being used.

On Fri, 22 Jun 2001, Tom Lane wrote:

> Sam Tregar <sam@tregar.com> writes:
> > Better yet, Postgres could be modified to automatically VACUUM ANALYZE
> > after a CREATE INDEX.
>
> Doesn't seem like a good idea --- what if you need to create several
> indexes?

A NOVACUUM option?  It seems like the general case - creating an index and
then wanting to use it - should be automatic.  I've never used an RDBMs
that required me to do a special dance to an index I just created!

Grumble, grumble.

-sam