Thanks!
It appeared to be that tracing, altough I cannot remember I ever put it
on... strange world...
Logging is set to Errors only and Tracing is off... it now goes as smooth
as a glass of beer :)
Michiel L.
"Dave Page"
<dpage@vale-housing.co.uk> To: <Michiel_Lange@actuera.nl>,
<pgadmin-support@postgresql.org>
Sent by: cc:
pgadmin-support-owner@post Fax to:
gresql.org Subject: Re: [pgadmin-support] Speed
10-10-2002 09:49
> -----Original Message-----
> From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl]
> Sent: 09 October 2002 16:02
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Speed
>
>
> Fellow pgAdministrators,
>
> Shortly I went trying to use pgAdmin. I know pgAdmin uses
> ODBC, and I know that it is not the quickest form of
> connection you can get. I can live with that... but I
> wondered if any of you is experiencing this kind of
> performance as well, or have experienceD, and know a solution ;-)
>
> Connecting itself takes 5 seconds (I can live with that, no
> problem) Clicking on 'Databases' makes me wait at least 10
> minutes (I have only one database of my own, aside the
> default databases) I cannot live with that... Listing the
> tables takes another 10 minutes at least etc etc...
> everything just takes ages...
>
> I really do not exaggerate, and think there ought to be a way
> to fix it... I have: pgAdmin 1.2.0 with databases on Postgres
> 7.2.2 Today I upgraded pgODBC, but that did not really help... anyone?
Hi,
It sounds like you have SQL Tracing and possibly Debug Logging turned on
- pgAdmin is certainly not that slow in normal use. To turn off logging,
in pgAdmin under Tools -> Options, make sure that the log level is not
set to Debug or Full Debug. To turn off SQL Tracing, open the ODBC
driver manager from the control panel (or Administrative Tools folder on
newer Windows). On the Tracing tab, make sure the top-left button says
'Start Tracing Now' and *not* 'Stop Tracing Now' (this tab is a bit
confusing). You may want to delete the left over SQL trace log as they
can grow to hundreds of Mb quite quickly.
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
