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

SVN Commit by dpage: r7807 - trunk/pgadmin3/pgadmin/schema

From: svn(at)pgadmin(dot)org
To: pgadmin-hackers(at)postgresql(dot)org
Subject: SVN Commit by dpage: r7807 - trunk/pgadmin3/pgadmin/schema
Date: 2009-04-15 09:06:29
Message-ID: 200904150906.n3F96T1k030839@developer.pgadmin.org (view raw or flat)
Thread:
Lists: pgadmin-hackers
Author: dpage

Date: 2009-04-15 10:06:29 +0100 (Wed, 15 Apr 2009)

New Revision: 7807

Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7807&view=rev

Log:
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.
[Chuck McDevitt]



Modified:
   trunk/pgadmin3/pgadmin/schema/gpPartition.cpp
   trunk/pgadmin3/pgadmin/schema/pgTable.cpp

pgadmin-hackers by date

Next:From: Dave PageDate: 2009-04-15 09:06:44
Subject: Re: Greenplum patch for estimated rowcounts being wrong.
Previous:From: Chuck McDevittDate: 2009-04-15 02:24:19
Subject: Greenplum patch for estimated rowcounts being wrong.

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