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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])