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