Обсуждение: Speed
Hi,
I've been using pgAdmin for sometime now and find it to be a very useful tool. The only problem i've come across is that it is really slow when accessing the server. The server is on a seperate Linux box and network connection is very fast normally. Is it a problem with my system or is it a known fact about pgAdmin. If it is thats fine, I just want to make sure that I've not got anything setup wrong.
Thanks
Andy Pearce
On Wed, Dec 19, 2001 at 10:08:37PM -0000, Andy Pearce wrote: > I've been using pgAdmin for sometime now and find it to be a very > useful tool. The only problem i've come across is that it is really > slow when accessing the server. I've just started using SSH tunneling to connect pgAdmin II to a remote server and find that the SSH compression cuts the first delay (response to clicking on 'Databases' in the left panel) from 18sec to about 8sec. I also like the fact that the clear text Postgres passwords are now hidden in the SSH tunnel. I couldn't get pgAdmin to work with 'crypt' mode password authentication on the server. With this tunnel in place I might also completely disallow remote access to the postmaster port on the server. -- Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA
Hi Andy,
pgAdmin isn't normally slow, though there is usually a slight delay when you access the Databases node in the treeview for the first time in a session. You might want to check that you do not have ODBC Tracing switched on (check in the ODBC Driver Manager control panel applet), that the psqlODBC logs are switched off (Commlog & MyLog - these can be checked by setting up a temporary PostgreSQL DSN), and that pgAdmin's log level isn't set to full debug (Tools -> Options) - no logging is also fine here.
Regards, Dave.
-----Original Message-----
From: Andy Pearce [mailto:andyj@interra.demon.co.uk]
Sent: 19 December 2001 22:09
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] SpeedHi,I've been using pgAdmin for sometime now and find it to be a very useful tool. The only problem i've come across is that it is really slow when accessing the server. The server is on a seperate Linux box and network connection is very fast normally. Is it a problem with my system or is it a known fact about pgAdmin. If it is thats fine, I just want to make sure that I've not got anything setup wrong.ThanksAndy Pearce
> -----Original Message----- > From: fred@ontosys.com [mailto:fred@ontosys.com] > Sent: 19 December 2001 23:01 > To: Andy Pearce > Cc: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Speed > > > On Wed, Dec 19, 2001 at 10:08:37PM -0000, Andy Pearce wrote: > > I've been using pgAdmin for sometime now and find it to be a very > > useful tool. The only problem i've come across is that it is really > > slow when accessing the server. > > I've just started using SSH tunneling to connect pgAdmin II > to a remote server and find that the SSH compression cuts the > first delay (response to clicking on 'Databases' in the left > panel) from 18sec to about 8sec. Hi Fred, That's some change - are you working across a dialup link? Just for info, that initial delay occurs because when you click Databases, the pgSchema library queries the master connection database (usually template1) for a list of databases, then opens a connection to each one and retrieves it's comment. When we move into the v1.3 development code (probably beginning of Jan) one of the things I want to look at is caching those comments so the database connection is only opened if you actually double click on a database. Regards, Dave.
On Thu, Dec 20, 2001 at 08:15:52AM -0000, Dave Page wrote: > That's some change - are you working across a dialup link? I use a 128k ISDN connection. While we're on the general subject, I have a comment on the user interface in pgAdmin: Why aren't objects listed in the detail pane (upper right) double-clickable, as would be standard in a typical "explorer" type interface? For example, when I click on the 'Databases' object in the tree pane (left side) I get a list of databases on the right. But double-clicking any of those database names has no effect. I'd like it to drill into that database, just like what happens if I expand the Databases object in the tree pane and then single-click the database name in the same tree. -- Fred Yankowski fred@OntoSys.com tel: +1.630.879.1312 Principal Consultant www.OntoSys.com fax: +1.630.879.1370 OntoSys, Inc 38W242 Deerpath Rd, Batavia, IL 60510, USA