Re: pgAdmin enhancement request.

Hi Dave,

Although it's not the answer I'm expecting, but it do make things clear. I will check with Greenplum Engineer, see if we can push this forward from Greenplum side.

Regards,
Shawn Yan
Technical Support Engineer

-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Dave Page
Sent: Friday, May 10, 2013 6:02 PM
To: Yan, Shawn
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] pgAdmin enhancement request.

Hi

On Fri, May 10, 2013 at 8:27 AM, Yan, Shawn <Shawn(dot)Yan(at)emc(dot)com> wrote:
> Hi pgAdmin team,
>
>
>
> May I request an enhancement request for pgAdmin tool? We are the
> support team for Greenplum product. It’s found when using pgAdmin tool
> to connect Greenplum database, this tool would automatically query the
> Greenplum catalog tables, like ‘pg_class’. But the query generated
> from pgAdmin tool have a very high cost. This high cost query would
> cause customer with resource queue control (max cost limit) unable to use pgAdmin tool.

I'm certainly not against the idea of changing those queries in principle (they were written that way for historic reasons that aren't applicable any more I believe), however they are constructed in a way that would make this a non-trivial task that would require a lot of testing against the dozen or so database versions we support as it would likely require a lot of restructuring of version specific code.
This is because those queries are built with a lot of if-then-else blocks that test for different server versions and types. I suspect this is not something that any of the regular developers are likely to find to do in the foreseeable future; there are certainly higher priorities for most of us.

If one of the Greenplum team can work on this, it would certainly make it more likely to happen promptly.

As a related note - although I haven't mentioned anything on list yet, I've been wondering if we should drop Greenplum support from pgAdmin in the future. We haven't had any contributions from Greenplum in years, and whilst new features are not a requirement for us to maintain support, we certainly do need Greenplum users (from EMC or
otherwise) to help with testing of new versions of pgAdmin - right now, we have no idea if pgAdmin works at all with the latest versions of Greenplum. If you can pass my concerns onto the relevant people in EMC, maybe we can improve that situation.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company

--
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support