| From: | "Kevin Grittner" <kgrittn(at)mail(dot)com> |
|---|---|
| To: | "Igor Neyman" <ineyman(at)perceptron(dot)com>,"Thomas Kellerer" <spam_eater(at)gmx(dot)net>,pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Large number of rows in pg_type and slow gui (pgadmin) refresh |
| Date: | 2013-01-04 22:41:45 |
| Message-ID: | 20130104224145.4830@gmx.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 and one type the set (array) of
> table/view records.
Also, I think use of domains can help make a database more
self-documenting and aid in integrity enforcement, and it's not too
hard to get to a few thousand of those in a complex database.
Anyway, for problems with pgadmin, your best bet would be to post
to the pgadmin-support list.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Donald | 2013-01-04 23:42:01 | pgpool2 load balancing not working |
| Previous Message | Kevin Grittner | 2013-01-04 20:51:29 | Re: Permission for relationship but not for select is possible? |