> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
