Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgadmin-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group