2013/2/1 Casey Allen Shobe <casey(at)shobe(dot)info>:
> Hopefully some improvements to the planner can come from this information?
>
> Here is the CTE version of the query:
> http://pgsql.privatepaste.com/2f7fd3f669
> ...and here is it's explain analyze: http://explain.depesz.com/s/5ml
Estimated rows for ‘hewitt_1_0_factors_precalc_new’ are 1000x less then actual.
And for ‘census_user’ estimation is 100x less, then actual.
How many rows are in those tables and what is your statistics target?
--
Victor Y. Yegorov