Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizer showing wrong rows in plan - Mailing list pgsql-performance

From Jeremy Harris
Subject Re: Optimizer showing wrong rows in plan
Date
Msg-id 4BAF8D1D.2050109@wizmail.org
Whole thread Raw
In response to Re: Optimizer showing wrong rows in plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Optimizer showing wrong rows in plan
List pgsql-performance
Tree view 
On 03/28/2010 05:27 PM, Tom Lane wrote:
>   This is intentional: the size estimates for a never-yet-analyzed
> table are *not* zero.  This is because people frequently create and load
> up a table and then immediately query it without an explicit ANALYZE.

Does the creation of an index also populate statistics?

Thanks,
     Jeremy

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Optimizer showing wrong rows in plan
Next
From: Tom Lane
Date:
Subject: Re: Optimizer showing wrong rows in plan