Postgres Pro
Downloads
Home   >   mailing lists

Re: estimated row count way off. - Mailing list pgsql-novice

From Tom Lane
Subject Re: estimated row count way off.
Date
Msg-id 5939.1081316883@sss.pgh.pa.us
Whole thread Raw
In response to estimated row count way off.  (Michael Guerin <guerin@rentec.com>)
List pgsql-novice
Tree view 
Michael Guerin <guerin@rentec.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

pgsql-novice by date:

Previous
From: Michael Guerin
Date:
Subject: estimated row count way off.
Next
From: DAVANNE Eric - NTR
Date:
Subject: uninstall postgres_beta4