Thread: Speed
Fellow pgAdministrators, Shortly I went trying to use pgAdmin. I know pgAdmin uses ODBC, and I know that it is not the quickest form of connection you can get. I can live with that... but I wondered if any of you is experiencing this kind of performance as well, or have experienceD, and know a solution ;-) Connecting itself takes 5 seconds (I can live with that, no problem) Clicking on 'Databases' makes me wait at least 10 minutes (I have only one database of my own, aside the default databases) I cannot live with that... Listing the tables takes another 10 minutes at least etc etc... everything just takes ages... I really do not exaggerate, and think there ought to be a way to fix it... I have: pgAdmin 1.2.0 with databases on Postgres 7.2.2 Today I upgraded pgODBC, but that did not really help... anyone?
I don't know how big your database is, but I have one with 23 tables of varying sizes, the largest of which is 25,000 records. Each step in the hierarchy, ie open connection, open database, open table, takes about 2 seconds. My server is a Dell P3 600mz and my client is a Dell P3 400mz. I use the same pgAdmin, but Postgres 7.2.1. Are you running any other protocols besides tcp/ip? Michiel_Lange@actuera.nl wrote: >Fellow pgAdministrators, > >Shortly I went trying to use pgAdmin. I know pgAdmin uses ODBC, and I know >that it is not the quickest form of connection you can get. >I can live with that... but I wondered if any of you is experiencing this >kind of performance as well, or have experienceD, and know a solution ;-) > >Connecting itself takes 5 seconds (I can live with that, no problem) >Clicking on 'Databases' makes me wait at least 10 minutes (I have only one >database of my own, aside the default databases) I cannot live with that... >Listing the tables takes another 10 minutes at least etc etc... everything >just takes ages... > >I really do not exaggerate, and think there ought to be a way to fix it... >I have: >pgAdmin 1.2.0 with databases on Postgres 7.2.2 >Today I upgraded pgODBC, but that did not really help... anyone? > > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) > > > >
> -----Original Message----- > From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl] > Sent: 09 October 2002 16:02 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Speed > > > Fellow pgAdministrators, > > Shortly I went trying to use pgAdmin. I know pgAdmin uses > ODBC, and I know that it is not the quickest form of > connection you can get. I can live with that... but I > wondered if any of you is experiencing this kind of > performance as well, or have experienceD, and know a solution ;-) > > Connecting itself takes 5 seconds (I can live with that, no > problem) Clicking on 'Databases' makes me wait at least 10 > minutes (I have only one database of my own, aside the > default databases) I cannot live with that... Listing the > tables takes another 10 minutes at least etc etc... > everything just takes ages... > > I really do not exaggerate, and think there ought to be a way > to fix it... I have: pgAdmin 1.2.0 with databases on Postgres > 7.2.2 Today I upgraded pgODBC, but that did not really help... anyone? Hi, It sounds like you have SQL Tracing and possibly Debug Logging turned on - pgAdmin is certainly not that slow in normal use. To turn off logging, in pgAdmin under Tools -> Options, make sure that the log level is not set to Debug or Full Debug. To turn off SQL Tracing, open the ODBC driver manager from the control panel (or Administrative Tools folder on newer Windows). On the Tracing tab, make sure the top-left button says 'Start Tracing Now' and *not* 'Stop Tracing Now' (this tab is a bit confusing). You may want to delete the left over SQL trace log as they can grow to hundreds of Mb quite quickly. Regards, Dave.
Thanks! It appeared to be that tracing, altough I cannot remember I ever put it on... strange world... Logging is set to Errors only and Tracing is off... it now goes as smooth as a glass of beer :) Michiel L. "Dave Page" <dpage@vale-housing.co.uk> To: <Michiel_Lange@actuera.nl>, <pgadmin-support@postgresql.org> Sent by: cc: pgadmin-support-owner@post Fax to: gresql.org Subject: Re: [pgadmin-support] Speed 10-10-2002 09:49 > -----Original Message----- > From: Michiel_Lange@actuera.nl [mailto:Michiel_Lange@actuera.nl] > Sent: 09 October 2002 16:02 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Speed > > > Fellow pgAdministrators, > > Shortly I went trying to use pgAdmin. I know pgAdmin uses > ODBC, and I know that it is not the quickest form of > connection you can get. I can live with that... but I > wondered if any of you is experiencing this kind of > performance as well, or have experienceD, and know a solution ;-) > > Connecting itself takes 5 seconds (I can live with that, no > problem) Clicking on 'Databases' makes me wait at least 10 > minutes (I have only one database of my own, aside the > default databases) I cannot live with that... Listing the > tables takes another 10 minutes at least etc etc... > everything just takes ages... > > I really do not exaggerate, and think there ought to be a way > to fix it... I have: pgAdmin 1.2.0 with databases on Postgres > 7.2.2 Today I upgraded pgODBC, but that did not really help... anyone? Hi, It sounds like you have SQL Tracing and possibly Debug Logging turned on - pgAdmin is certainly not that slow in normal use. To turn off logging, in pgAdmin under Tools -> Options, make sure that the log level is not set to Debug or Full Debug. To turn off SQL Tracing, open the ODBC driver manager from the control panel (or Administrative Tools folder on newer Windows). On the Tracing tab, make sure the top-left button says 'Start Tracing Now' and *not* 'Stop Tracing Now' (this tab is a bit confusing). You may want to delete the left over SQL trace log as they can grow to hundreds of Mb quite quickly. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html