| From: | "Robert Klaus" <rklaus(at)nexgenwireless(dot)com> |
|---|---|
| To: | <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Large number of rows in pg_type and slow gui (pgadmin) refresh |
| Date: | 2013-01-03 19:43:41 |
| Message-ID: | 00aa01cde9ea$a2bbd410$e8337c30$@com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
This message was posted in the pgsql-general and novice lists, and I was
cirected here . . . sorry for those of you receiving multiple posts.
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 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?
Our database server is at 8.4
Robert
Nexgen Wireless, Inc.
1701 East Woodfield Road, Suite 430
Schaumburg, IL 60173
Office: (847) 944-8003 ext 121
Mobile: (847) 721-6477
Fax: (847) 874-7050
<http://www.nexgenwireless.com/> www.nexgenwireless.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Annette Ketils | 2013-01-04 06:18:42 | update postgreSQL 9.0 |
| Previous Message | Campbell, Lance | 2013-01-03 16:11:31 | Server Status window issue |