From: | "Robert Klaus" <rklaus(at)nexgenwireless(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
Date: | 2013-01-03 17:45:31 |
Message-ID: | 008101cde9da$2036ff70$60a4fe50$@com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Thomas Kellerer
Sent: Thursday, January 03, 2013 11:31 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] 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(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Bèrto ëd Sèra | 2013-01-03 17:49:43 | Re: Database Design: Maintain Audit Trail of Changes |
Previous Message | sk baji | 2013-01-03 17:36:02 | Re: [GENERAL] Unable to reload postgresql.conf without restarting |