Re: [PERFORM] planner's midjudge number of rows resulting, despite pretty obvious join

Hello 2009/2/24 Grzegorz Jaśkiewicz : > explain select ss, ARRAY(select id from foo where ss>0 and id between > 7 and 156 order by random() limit 3) as v from > generate_series(1,100) ss; >                                     QUERY PLAN > ---

[PERFORM] planner's midjudge number of rows resulting, despite pretty obvious join

explain select ss, ARRAY(select id from foo where ss>0 and id between 7 and 156 order by random() limit 3) as v from generate_series(1,100) ss; QUERY PLAN Function Scan on