Postgres Pro
Downloads
Home   >   mailing lists

Large number of rows in pg_type and slow gui (pgadmin) refresh - Mailing list pgsql-general

From Robert Klaus
Subject Large number of rows in pg_type and slow gui (pgadmin) refresh
Date
Msg-id 003201cde9ca$0bed0240$23c706c0$@com
Whole thread Raw
Responses Re: Large number of rows in pg_type and slow gui (pgadmin) refresh  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view

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.

Schaumburg, IL

 

 

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Database Design: Maintain Audit Trail of Changes
Next
From: Adrian Klaver
Date:
Subject: Re: Database Design: Maintain Audit Trail of Changes