Greenplum patch for estimated rowcounts being wrong. - Mailing list pgadmin-hackers

From Chuck McDevitt
Subject Greenplum patch for estimated rowcounts being wrong.
Date
Msg-id 2106D8DC89010842BABA5CD03FEA4061B86B2AAD@EXVMBX018-10.exch018.msoutlookonline.net
Whole thread Raw
In response to Re: Debugger hung on dummy function  (Dave Page <dpage@pgadmin.org>)
Responses Re: Greenplum patch for estimated rowcounts being wrong.
List pgadmin-hackers
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.



Attachment

pgadmin-hackers by date:

Previous
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r7806 - trunk/pgadmin3/pgadmin/debugger
Next
From: svn@pgadmin.org
Date:
Subject: SVN Commit by dpage: r7807 - trunk/pgadmin3/pgadmin/schema