Extremely slow queries in pgAdminIII

From: "Asger Petersen" <asger(at)jo-informatik(dot)dk>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Extremely slow queries in pgAdminIII
Date: 2005-03-18 14:36:46
Message-ID: 6A0257B028DA47499B5A843683051A36068D29@server01.jo-informatik.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

I would really appreciate any ideas to solve the problem, as this
problem at the moment is prohibiting widespread use of postgres in our
company.

Regards
Asger Petersen

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2005-03-18 16:40:03 Re: Extremely slow queries in pgAdminIII
Previous Message Igor Katrayev 2005-03-17 19:21:57 pgAdmin III v 1.2.0 (Nov 29 2004) bug. New table dialog does not save comments for columns