Re: Extremely slow queries in pgAdminIII

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Asger Petersen
> Sent: 18 March 2005 14:37
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Extremely slow queries in pgAdminIII
>
> Hi list
>
> We are using pgAdminIII to access a postgresql 8.0.0 rc2 on a win2k
> machine.
>
> The problem is, that performance of queries done with pgAdmin varies
> extremely between clients. For instance we have two winXp machines w.
> pgAdminIII v. 1.2.0. Executing a simple 'SELECT * FROM sometable' w.
> 40000 rows takes 10 secs on one and 450 secs on the other machine.
> Executing EXPLAIN is equally fast on the two machines.
> Network capacity
> should not be the problem as the slow machine has 10 times
> the bandwith
> of the fast. Actually the machine running the database also has speed
> problems with pgAdminIII.

HI Asger,

It sounds like you have the loglevel set to debug on the slower machines
- this causes massive overhead and will slow things to a crawl. You can
check this on the Logging tab under File->Options. The default level is
'Errors Only'.

Regards Dave.