Tom Lane wrote: > > mlw <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
