Re: Greenplum patch for estimated rowcounts being wrong.

Thanks, applied.

On Wed, Apr 15, 2009 at 3:24 AM, Chuck McDevitt <cmcdevitt@greenplum.com> wrote:
> Greenplum stores the number of rows per segmentDatabase (actually the max of any of the segDBs) in
pg_class.reltuples,not the total number of tuples. 
>
> This causes the stats to display wrong values, and causes pgAdmin to warn that Analyze is needed when it is not.
>
> This simple patch multiplies the reltuples x gp_segments, so that we get a better value.
>
> Of course, it only does this for Greenplum connections.
>
>
>



--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com