Re: Fighting the planner >:-( - Mailing list pgsql-performance

From Casey Allen Shobe
Subject Re: Fighting the planner >:-(
Date
Msg-id CAFmVg3hDmEcU-3zv9OkupgxVL7OBot8KxR9b9=SCv_0ODDjZcQ@mail.gmail.com
Whole thread Raw
In response to Re: Fighting the planner >:-(  (Виктор Егоров <vyegorov@gmail.com>)
Responses Re: Fighting the planner >:-(  (Виктор Егоров <vyegorov@gmail.com>)
List pgsql-performance
On Fri, Feb 1, 2013 at 4:12 PM, Виктор Егоров <vyegorov@gmail.com> wrote:
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?

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.

--
Casey Allen Shobe
casey@shobe.info


pgsql-performance by date:

Previous
From: Виктор Егоров
Date:
Subject: Re: Fighting the planner >:-(
Next
From: Виктор Егоров
Date:
Subject: Re: Fighting the planner >:-(