Horton

Re: Fighting the planner >:-(

Victor Yegorov <vyegorov@gmail.com>

View thread View on postgr.es
From: Виктор Егоров <vyegorov@gmail.com>
To: Casey Allen Shobe <casey@shobe.info>
Cc: Richard Huxton <dev@archonet.com>, pgsql-performance@postgresql.org
Date: 2013-02-01T21:12:43Z
Lists: pgsql-performance 
2013/2/1 Casey Allen Shobe <casey@shobe.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