Re: Fighting the planner >:-(

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(at)gmail(dot)com> wrote:

> 2013/2/1 Casey Allen Shobe <casey(at)shobe(dot)info>:
> > 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(at)shobe(dot)info