Re: Large number of rows in pg_type and slow gui (pgadmin) refresh

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:guillaume(at)lelarge(dot)info]
Sent: Friday, January 04, 2013 4:30 AM
To: Robert Klaus
Cc: pgadmin-support(at)postgresql(dot)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