Kenneth Downs wrote:
> Dave Page wrote:
>>
>>
>> ------------------------------------------------------------------------
>> *From:* pgsql-general-owner@postgresql.org
>> [mailto:pgsql-general-owner@postgresql.org] *On Behalf Of
>> *Kenneth Downs
>> *Sent:* 12 May 2006 02:09
>> *To:* pgsql-general@postgresql.org
>> *Subject:* Re: [GENERAL] GUI Interface
>>
>> The longer you use it, the longer it takes to connect to
>> databases each time you start up. It says "Restoring previous
>> settings".
>>
>>
>> It should only take longer if the number of objects in your database
>> grows significantly, or if you've turned on debug logging. At that
>> point it is examining your database so that it can rebuild the
>> treeview to roughly the state that it was when you last used it.
> My database has 270+ tables. That's probably small for where it will
> be in a year. At the moment I have only a dozen or so databases per
> server, and four servers that I regularly connect to. I did not
> intentionally turn on debug logging.
Part of the problem is that pgAdmin III seems to preload object
properties instead of pulling them in as you need them.
I have noticed many times in pgAdmin III that when a function is edited
and saved by someone else on a different workstation I can't see those
changes until I manually
refresh the object. When you have a ton of tables etc that
preloading/caching has to be taking up some time.
PGLA only populates the tree with the object names, and when you double
click or right click to edit, then and only then is the object data
brought back and displayed.
When Lazarus(http://www.lazarus.freepascal.org/) becomes more stable I
will create a port of PGLA that will run on Linux and Mac OS X.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration