Re: Possible performance bug in enumerating schema objects? - Mailing list pgadmin-support

From Avi Blackmore
Subject Re: Possible performance bug in enumerating schema objects?
Date
Msg-id C52B558F-0CBC-4A35-9E26-3A8B7647BC9E@satshot.com
Whole thread Raw
In response to Re: Possible performance bug in enumerating schema objects?  (Dave Page <dpage@pgadmin.org>)
Responses Re: Possible performance bug in enumerating schema objects?
List pgadmin-support
Hi, just got back to the office.  Thanks for the response!

On Nov 8, 2012, at 10:25 AM, Dave Page wrote:

>> Given the size of the pg_class result set, this strikes me as really, really inefficient.  Perhaps these options
couldbe queried in one go, by joining against the main query for the listing of tables and other objects? 
>
> I've attached a patch that attempts to do exactly that. Are you able to test it?
>
I installed a binary image for my MacOS X workstation.  I'd have to grab the source and build that.  What's the version
thepatch applies against?  Current release? 
--
Avi Blackmore
Head Programmer/System Administrator
Agri ImaGIS Technologies, Inc.







pgadmin-support by date:

Previous
From: Deborah Kubicek
Date:
Subject: pgAdmin dying when renaming a function
Next
From: Craig Ringer
Date:
Subject: Re: pgAdmin dying when renaming a function