Re: estimated row count way off.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Guerin <guerin(at)rentec(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: estimated row count way off.
Date: 2004-04-07 05:48:03
Message-ID: 5939.1081316883@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Michael Guerin <guerin(at)rentec(dot)com> writes:
> I'm trying to understand why the row count is way off, setting the statistics_target higher seems to make it worse.

This is not a row count estimate, it's just ANALYZE telling you how many
rows it sampled to prepare the pg_stats statistics.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message DAVANNE Eric - NTR 2004-04-07 09:31:49 uninstall postgres_beta4
Previous Message Michael Guerin 2004-04-07 02:11:51 estimated row count way off.