Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Indexes not being used.
Date
Msg-id 4709.993231402@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indexes not being used.  (Sam Tregar <sam@tregar.com>)
Responses Re: Indexes not being used.  (Sam Tregar <sam@tregar.com>)
List pgsql-general
Tree view 
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?

I agree that the "Populating a Database" tips probably should mention
vacuuming.

            regards, tom lane

pgsql-general by date:

Previous
From: Sam Tregar
Date:
Subject: Re: Indexes not being used.
Next
From: Daniel Åkerud
Date:
Subject: Multiple Indexing, performance impact