Re: Greenplum patch for estimated rowcounts being wrong.

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Chuck McDevitt <cmcdevitt(at)greenplum(dot)com>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Greenplum patch for estimated rowcounts being wrong.
Date: 2009-04-15 09:06:44
Message-ID: 937d27e10904150206s155fd6a8l180179b70e45fa9e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Thanks, applied.

On Wed, Apr 15, 2009 at 3:24 AM, Chuck McDevitt <cmcdevitt(at)greenplum(dot)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

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2009-04-15 09:18:20 SVN Commit by dpage: r7808 - trunk/pgadmin3/pgadmin/frm
Previous Message svn 2009-04-15 09:06:29 SVN Commit by dpage: r7807 - trunk/pgadmin3/pgadmin/schema