Re: Indexes not being used. - Mailing list pgsql-general

From Sam Tregar
Subject Re: Indexes not being used.
Date
Msg-id Pine.LNX.4.30.0106221337380.20091-100000@localhost.localdomain
Whole thread Raw
In response to Re: Indexes not being used.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Daniel Åkerud
Date:
Subject: Multiple Indexing, performance impact
Next
From: Matt Beauregard
Date:
Subject: Re: Suggested improvement : Adjust SEQUENCES to accept an INCREMENT of functionname(parameters) instead of an integer