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: (view raw, whole thread or download thread mbox)
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:

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-2017 The PostgreSQL Global Development Group