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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Robert Klaus <rklaus(at)nexgenwireless(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Large number of rows in pg_type and slow gui (pgadmin) refresh
Date: 2013-01-06 17:16:18
Message-ID: 1357492578.336.1.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Fri, 2013-01-04 at 09:18 -0600, Robert Klaus wrote:
> Connecting to the database server just took 62 seconds, which defaults to the database that has almost all of the 36,000+ objects. Another 40 seconds to open any of the schemas within that database. Once the schema is opened any of the tabs within are very fast, unless we refresh them. Another tool our other developers use has the same issues.
>

It doesn't quite surprise me. We have performance issue with databases
with huge number of objects. Not sure what we can do about this.

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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Robert Klaus 2013-01-06 17:27:13 Re: Large number of rows in pg_type and slow gui (pgadmin) refresh
Previous Message Guillaume Lelarge 2013-01-06 17:15:15 Re: Large number of rows in pg_type and slow gui (pgadmin) refresh