2013/2/1 Casey Allen Shobe <ca...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
