Re: Index Scans become Seq Scans after VACUUM ANALYSE

Tom Lane wrote:
> 
> 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.
> 

You completely ignored the point I was trying to make. Statistics are a
summation of the data, not the actual data. As such, it can not possibly
represent all possible configurations of tables.

Adding huristics, such as weighting for index scans, is not making the planner
stupider. It is making it smarter and more flexable.