Re: Fighting the planner >:-(

[Casey Allen Shobe <casey@xxxxxxxxxx>]

I'll get back to you on this Monday - I'm heading home for the week now.

However I was unable to adjust the statistics target using that command:

alter table opportunity.census_user set statistics 500;

ERROR:  syntax error at or near "statistics"

LINE 1: alter table opportunity.census_user set statistics 500;

                                             ^

On Fri, Feb 1, 2013 at 4:55 PM, Виктор Егоров <vyegorov@xxxxxxxxx> wrote:

2013/2/1 Casey Allen Shobe <casey@xxxxxxxxxx>:

> Rowcounts are shown in the earlier paste link, but apparently I forgot to
> include the census table - hewitt_1_0_factors_precalc_new has 4,135,890
> rows, and census_user has 1846439 rows.
>
> Statistics target is the default at 100.

I would try the following:
ALTER TABLE hewitt_1_0_factors_precalc_new SET STATISTICS 1000;
ALTER TABLE census_user SET STATISTICS 500;
ALTER TABLE census_output SET STATISTICS 500;
and analyzed them after. I hope I guessed ‘census_output’ name correctly.

And could you kindly share the plan after:
SET enable_nestloop TO off;


--
Victor Y. Yegorov

--
Casey Allen Shobe
casey@xxxxxxxxxx