> -----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+ 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. > > Thomas >
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 and one type the set (array) of table/view records. Regards, Igor Neyman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
