It takes a long time for pgAdmin to retrieve database schema details - Mailing list pgadmin-support

From 顾小波
Subject It takes a long time for pgAdmin to retrieve database schema details
Date
Msg-id 002f01cb236c$08827a80$19876f80$@com
Whole thread Raw
Responses Re: It takes a long time for pgAdmin to retrieve database schema details  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: It takes a long time for pgAdmin to retrieve database schema details  ("Little, Douglas" <DOUGLAS.LITTLE@orbitz.com>)
List pgadmin-support
<div class="Section1"><p class="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US">Hi,</span><pclass="MsoNormal" style="margin-left:18.0pt"><span lang="EN-US"> </span><p class="MsoNormal"
style="margin-left:18.0pt"><spanlang="EN-US">we use gpAdminIII 1.10.3 with Greeenplum database 3.3.5.0 on Solaris X64
10u7,one of our databases has 36 schemas, one of which has 716 tables, and the whole database size is about 4~5T. When
usersopen pgAdminIII and click the database node under the Databases node it takes a long time for pgAdminIII to
“restoringprevious environment….”, when users click one of the schemas, it also takes a long time for pgAdminIII to
“retrievingSchema details…”, and the whole Interface is haling, I think this is due to this operation is single
threaded.Another suggestion is can you improve gpAdmin to retrieve as little detail information as possible, just to
retrieveit when user really need it, especially for high cost operations such as select count(*) from table.</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Xiaobo Gu</span></div> 

pgadmin-support by date:

Previous
From: Ashesh Vashi
Date:
Subject: Re: [Fwd: [TESTERS] pgAdmin 1.12.0 Beta 3 - Error viewing Server-Status]
Next
From: Guillaume Lelarge
Date:
Subject: Re: It takes a long time for pgAdmin to retrieve database schema details