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