Unix Technical Forum

Re: pgAdmin III very slow if working on localhost

This is a discussion on Re: pgAdmin III very slow if working on localhost within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> ________________________________ From: Petr Bouda [mailto:boudino@gmail.com] Sent: 30 May 2006 12:41 To: Dave Page Subject: Re: [pgadmin-support] pgAdmin III very ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:26 PM
Dave Page
 
Posts: n/a
Default Re: pgAdmin III very slow if working on localhost




________________________________

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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:06 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com