Connecting to the database server just took 62 seconds, which defaults to the 
database that has almost all of the 36,000+ objects.  Another 40 seconds to 
open any of the schemas within that database.   Once the schema is opened any 
of the tabs within are very fast, unless we refresh them.  Another tool our 
other developers use has the same issues.

Most of the objects are GIS maps that are generated by our users.  The tables 
and views vary in structure based on options the user chooses when generating 
them.

We'll be adding many clients in the next few months so the number of tables and 
views will grow tenfold very quickly. 

-----Original Message-----
From: Guillaume Lelarge [mailto:guilla...@lelarge.info] 
Sent: Friday, January 04, 2013 4:30 AM
To: Robert Klaus
Cc: pgadmin-support@postgresql.org
Subject: Re: [pgadmin-support] Large number of rows in pg_type and slow gui 
(pgadmin) refresh

On Thu, 2013-01-03 at 13:43 -0600, Robert Klaus wrote:
>  
> This message was posted in the pgsql-general and novice lists, and I 
> was cirected here . . . sorry for those of you receiving multiple posts.
> 
>  
> 
> 
> 
> We have 36,000+ rows returned by " SELECT oid, format_type(oid, 
> typtypmod) AS typname FROM pg_type".
> 
>  
> 
> My manager says this is only a small number compared to what is 
> expected by next summer.
> 
>  
> 
> When I run this select statement on the database server it returns in 
> under
> 1 second but it takes a minute to open some tabs using pgAmin III (1.16.1).
> 

Which tabs? because we now have a cache for types, so that we don't need to 
query them each time we need them. Maybe we forgot to use that cache for some 
dialogs or tabs.


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com




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

Reply via email to