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

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 (view raw or flat)
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: temp.diff
Description: application/octet-stream (2.6 KB)

In response to

Responses

pgadmin-hackers by date

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

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