Yes, I consider it a tool issue and not a database issue. Is there somewhere else I should be posting this to? Thanks, Robert -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Thomas Kellerer Sent: Thursday, January 03, 2013 11:31 AM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Large number of rows in pg_type and slow gui (pgadmin) refresh Robert Klaus wrote on 03.01.2013 16:50: > 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. Why do you need so many types? That sounds like something in your design is not right. > 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). > > Is there a workaround for this - most of the rows returned are from > one schema. If we could elimiate it from the listed schemas it would > help. Is this possible in pgAdmin III? > That sounds more like a pgAdmin problem and not a PostgreSQL problem. Thomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
