Re: pgAdmin2 and the ODBC driver for postgresql

> -----Original Message-----
> From: mhepwort@xmission.com [mailto:mhepwort@xmission.com]
> Sent: 10 October 2002 15:53
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] pgAdmin2 and the ODBC driver for postgresql
>
>
> I have used pgAdmin2 and postgresql for over a year and have had no
> problems.  Recently, I upgraded pgAdmin2 to version
> 1.3.83-Dev and updated
> the postgresql odbc drive to version 7.2.2.  Since then
> pgAdmin2 performs
> miserable slow while navigating from node to node in the
> tree.  It is the
> only application that I use with the odbc driver.  I know it's not my
> database, pgAdmin, or postgresql because the person in the
> cubicle next to
> me has the same configuration and connects to my db just fine
> without any
> slowness.  I've uninstalled pgAdmin2 and the odbc driver and
> completely
> installed fresh to no avail.  Anybody have any idea's.  As of
> now, pgAdmin2
> is totally useless to me and am currently suffering the pain of psql
> command line work.
>
> PLEASE HELP......

OK :-)

It sounds like you have SQL Tracing and possibly Debug Logging turned
on. 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.