Re: Large number of rows in pg_type and slow gui (pgadmin) refresh

Get all schemas, except some of them. One schema will have 90+% of the database objects.

If we could eliminate that schema fewer rows would be returned by the underlying queries, allowing us to continue using pgAdmin.

I've only been working with this company (and postgresql) for 90 days so if there is a better way (other than rewriting the application that creates all those tables and views) please let me know how to proceed.

Thanks,
Robert

-----Original Message-----
From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Guillaume Lelarge
Sent: Sunday, January 06, 2013 11:15 AM
To: Robert Klaus
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Large number of rows in pg_type and slow gui (pgadmin) refresh

On Sat, 2013-01-05 at 12:38 -0600, Robert Klaus wrote:
> Below, I deleted the logfile, connected to a database server, and immediately copied the log here without doing anything else. It took 5+ minutes.
>
> Would someone be able to point me to a place in the source code where I can add predicates to the sql to elimate certain schemas with many tables and views? I believe that is the cause of the long elapsed time due to the network latency. Correct me if you think its something else.
>

Would you tell us what you are trying to do? get all tables, except some of them?

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

--
Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support