Greenplum patch for estimated rowcounts being wrong.

From: Chuck McDevitt <cmcdevitt(at)greenplum(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Greenplum patch for estimated rowcounts being wrong.
Date: 2009-04-15 02:24:19
Message-ID: 2106D8DC89010842BABA5CD03FEA4061B86B2AAD@EXVMBX018-10.exch018.msoutlookonline.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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.

Attachment Content-Type Size
temp.diff application/octet-stream 2.6 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message svn 2009-04-15 09:06:29 SVN Commit by dpage: r7807 - trunk/pgadmin3/pgadmin/schema
Previous Message svn 2009-04-13 16:15:15 SVN Commit by dpage: r7806 - trunk/pgadmin3/pgadmin/debugger