Re: Possible performance bug in enumerating schema objects?

From: Avi Blackmore <support(at)satshot(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Cc: Dave Page <dpage(at)pgadmin(dot)org>
Subject: Re: Possible performance bug in enumerating schema objects?
Date: 2012-11-13 18:57:29
Message-ID: C52B558F-0CBC-4A35-9E26-3A8B7647BC9E@satshot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 could be 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 the patch applies against? Current release?
--
Avi Blackmore
Head Programmer/System Administrator
Agri ImaGIS Technologies, Inc.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Craig Ringer 2012-11-13 23:08:23 Re: pgAdmin dying when renaming a function
Previous Message Deborah Kubicek 2012-11-13 18:21:50 pgAdmin dying when renaming a function