Hi,

 

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 users open pgAdminIII and click the database 
node under the Databases node it takes a long time for pgAdminIII to “restoring 
previous environment….”, when users click one of the schemas, it also takes a 
long time for pgAdminIII to “retrieving Schema 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 retrieve it when user really need it, 
especially for high cost operations such as select count(*) from table.

 

Xiaobo Gu

Reply via email to