From: | Igor Neyman <ineyman(at)perceptron(dot)com> |
---|---|
To: | Thomas Kellerer <spam_eater(at)gmx(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
Date: | 2013-01-04 14:36:58 |
Message-ID: | A76B25F2823E954C9E45E32FA49D70EC08F48D61@mail.corp.perceptron.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----Original Message-----
> From: Thomas Kellerer [mailto:spam_eater(at)gmx(dot)net]
> Sent: Thursday, January 03, 2013 12:31 PM
> To: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ali Pouya | 2013-01-04 16:26:37 | Re: Monitoring streaming replication from standby on Windows |
Previous Message | Amit Kapila | 2013-01-04 14:26:15 | Re: [GENERAL] Unable to reload postgresql.conf without restarting |