Horton

Re: Fighting the planner >:-(

Casey Allen Shobe <casey@shobe.info>

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