Re: Indexes not being used.

On Fri, 22 Jun 2001, Tom Lane wrote:

> You need to VACUUM ANALYZE your tables after you've finished with the
> bulk load step.

Thanks.  This information seems to be missing from the manual!  It should
probably go in "11.3.3. Remove Indices".  Currently the advice given
produces tables that don't use their indexes.

Better yet, Postgres could be modified to automatically VACUUM ANALYZE
after a CREATE INDEX.  Isn't it a pretty good bet that the user will want
to use the index after they've created it?

> And no, behavior on toy tables is not a guide to what the planner will
> choose to do with large tables.

Another pearl of wisdom that should probably go in the manual.

-sam