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
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 |