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

From svn@pgadmin.org
Subject SVN Commit by dpage: r7807 - trunk/pgadmin3/pgadmin/schema
Date
Msg-id 200904150906.n3F96T1k030839@developer.pgadmin.org
Whole thread Raw
List 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,
notthe 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:

Previous
From: Chuck McDevitt
Date:
Subject: Greenplum patch for estimated rowcounts being wrong.
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r7808 - trunk/pgadmin3/pgadmin/frm