Thread: pgAdmin III very slow if working on localhost

pgAdmin III very slow if working on localhost

From
"Petr Bouda"
Date:
Hi all

I'am facing strang problem while using pgAdmin III to browse DB running on the same machine (localhost) - it is very very slow. Coonect is quite quict, but listing all schemas takes tens of seconds, listing tables in schema takes other tens of seconds, refresing table details takes other seocnds. If I connect to postresql running on onother machine in our network, the pgAdmin works fine. Also my local databse seems to work quickly if it deals with data. Just the pgAdmin is the one who prevents me from working.

Could anyone help?
Thanks
 
P.S. Maybe I¨ve sent this post second time due to some inconsistence in my mails. If so, I'm sorry.

Re: pgAdmin III very slow if working on localhost

From
"Dave Page"
Date:
 


From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Petr Bouda
Sent: 30 May 2006 12:00
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgAdmin III very slow if working on localhost

Hi all

I'am facing strang problem while using pgAdmin III to browse DB running on the same machine (localhost) - it is very very slow. Coonect is quite quict, but listing all schemas takes tens of seconds, listing tables in schema takes other tens of seconds, refresing table details takes other seocnds. If I connect to postresql running on onother machine in our network, the pgAdmin works fine. Also my local databse seems to work quickly if it deals with data. Just the pgAdmin is the one who prevents me from working.

Could anyone help?
Thanks
 
P.S. Maybe I¨ve sent this post second time due to some inconsistence in my mails. If so, I'm sorry. 
 
Is there any difference if you connect to the machines external IP address instead of localhost?
 
Regards, Dave, 

Re: pgAdmin III very slow if working on localhost

From
"Dave Page"
Date:
 


From: Petr Bouda [mailto:boudino@gmail.com]
Sent: 30 May 2006 12:41
To: Dave Page
Subject: Re: [pgadmin-support] pgAdmin III very slow if working on localhost

I cannot. At leas, performance on large table while queriyng seems adequate to size of the table. If still beleive that my propblem is primary in pgAdmin and the way in which it works wtih database metada.
 
I would like to know if it is common problem/behavior or it is something wrong with my environment.

 
Almost certainly your environment, given that this is the first complaint in a few hundred thousand downloads.
 
More specifically though, I suspect a problem with PostgreSQL rather than pgAdmin because PostgreSQL's libpq library is responsible for all network communication, and as you say it works fine with remote databases that points to either a problem in the way that libpq is talking to your local machine, or a problem with your local installation of PostgreSQL.
 
How responsive is your local database when accessed from a remote machine? Is it a personal development database on your desktop? If so, it may just be that the server has cached all the data on the server, thus is quite responsive, but on your local machine you are accessing data for the first time since boot.
 
Regards, Dave.