From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Asger Petersen" <asger(at)jo-informatik(dot)dk>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Extremely slow queries in pgAdminIII |
Date: | 2005-03-18 16:40:03 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E472BC7F@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Asger Petersen
> Sent: 18 March 2005 14:37
> To: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Laurent Birckel | 2005-03-18 16:51:00 | No way to have error message on pgadmin III pg 8.0 |
Previous Message | Asger Petersen | 2005-03-18 14:36:46 | Extremely slow queries in pgAdminIII |