Horton

Re: Index Scans become Seq Scans after VACUUM ANALYSE

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: mlw <markw@mohawksoft.com>
Cc: Thomas Lockhart <thomas@fourpalms.org>, Lincoln Yeoh <lyeoh@pop.jaring.my>, Bruce Momjian <pgman@candle.pha.pa.us>, Louis-David Mitterrand <vindex@apartia.org>, pgsql-hackers@postgresql.org
Date: 2002-04-17T17:45:44Z
Lists: pgsql-hackers 
mlw <markw@mohawksoft.com> writes:
> ... I have seen many instances of when
> PostgreSQL refuses to use an index because the data distribution is uneven.

This is fixed, or at least attacked, in 7.2.  Again, I do not see this
as an argument for making the planner stupider instead of smarter.

			regards, tom lane