Re: 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