Re: Incorrect assumptions with low LIMITs

On Sat, Mar 17, 2012 at 9:34 AM, Simon Riggs  wrote:
> My wish was to register this as both a common and significant bug,

It has definitely come up here before many times.

However at root the problem is part of the general class of not
understanding how two different columns are related. Postgres is
assuming they're entirely independent and therefore all the values of
x are uniformly distributed over values of y.

To plan this better in your case it would have to know that blah_id <=
72572020 is not equally likely for user_id = ANY
('{....list....}'::integer[]) as it is for the table as a whole.


-- 
greg