Re: Long time when opening schema

-----Original Message-----
From: Masse Jacques [mailto:jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr]
Sent: 23 August 2002 13:52
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Long time when opening schema


Hello,

After installing last version (1.3.76) from .msi, very long time
for opening the list of tables (PG 7.1 on Slackware) when clicking for
the first time on Schema-Public (about 3 min.)
Tried with 1.3.60 give the same result but not with the version
I was using before (1.3.33)
Same delay with a very little database

Some idea ?

Hi,

Make sure you have logging (Tools -> Options) switched to the lowest
level possible - if it's on Full Debug, it will be *very* slow.

There are other mods in the later code that make clicking the schema
seem slow. It's actually an illusion - a number of queries are now run
at that point where previously they ran at different times.
Unfortunately this is difficult to fix, without losing many of the new
features and bug fixes.

Regards, Dave.