-Original Message-
From: Thomas Kellerer [mailto:spam_ea...@gmx.net]
Sent: Thursday, January 03, 2013 12:31 PM
To: pgsql-general@postgresql.org
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+
Igor Neyman wrote:
Thomas Kellerer wrote:
Why do you need so many types?
Probably those are not the types Robert created explicitly.
There must be lots of tables/views (m.b. lots of partitions) in
the database. Every table/view adds couple records to pg_type:
one type for table/view record
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
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
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-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Thursday, January 03,
Robert Klaus wrote on 03.01.2013 18:45:
Yes, I consider it a tool issue and not a database issue. Is there
somewhere else I should be posting this to?
There is a pgAdmin mailing list, see here:
http://www.postgresql.org/community/lists/
Thomas
--
Sent via pgsql-general mailing list