PgAdmin3 on Mac OS X Observations - Mailing list pgadmin-support

From Mark Cotner
Subject PgAdmin3 on Mac OS X Observations
Date
Msg-id 754e3e451001151314s323556e4uadebccc0e18a8be@mail.gmail.com
Whole thread Raw
Responses Re: PgAdmin3 on Mac OS X Observations  (Guillaume Lelarge <guillaume@lelarge.info>)
List pgadmin-support
Hi all,<br />I would tell you what version I have, but I can't seem to get the About window to come up(very minor nag
#1). I just downloaded it so it's the latest Mac OS X binary you have on your site.<br /><br />Love the tool, just
comingback after a few years and the improvements are much appreciated.  I wanted to let you know I'm having a couple
ofproblems with it on the Mac, however I haven't tried to duplicate these problems yet on other platforms.  I'll give
ita shot later today and let you know how it goes.<br /><br />1.  The query times seem bloated.  It seems to render
ratherslowly, but the table I'm querying is wide and has several text columns so that is to be expected.  However, as a
DBAI'm testing queries to verify responsiveness on the server, not so much the client.  The time you're reporting
doesn'tmatch what I'm seeing on the server.<br /><br />Total query runtime: 963 ms.<br />87 rows retrieved.<br /><br
/>Versus(samequery run with explain analyze from pgadmin3):<br />"Sort  (cost=11.00..11.05 rows=20 width=3097) (actual
time=0.293..0.346rows=87 loops=1)"<br /> "  Sort Key: version"<br />"  Sort Method:  quicksort  Memory: 74kB"<br />" 
-> Index Scan using index_online_solutions_project_card_versions_on_card_id on
online_solutions_project_card_versions (cost=0.00..10.56 rows=20 width=3097) (actual time=0.017..0.145 rows=87
loops=1)"<br/> "        Index Cond: (card_id = 15633)"<br />"Total runtime: 0.494 ms"<br /><br />Or roughly 2000 times
sloweras reported by PgAdmin3.<br clear="all" /><br />It seems more likely people would be more interested in how long
thequery runs on the server vs round trip time, etc which seems to be built into your query time.<br /><br />2.  When
mynetwork or VPN connection drops PgAdmin3 locks up completely.  It may be retrying the connection, but I waited more
than30 minutes for it to time out and reconnect.  It has done this to me a number of times.  It seems the connection
managementneeds more intelligence.<br /><br />Very minor stuff, but I though you should be aware of it.  Again, nice
workand thanks for all you do.<br /><br />'njoy,<br />Mark<br /><br />-- <br />"Keynes observed that pragmatic
businessmenoften could not imagine that they were the slaves of defunct economists, but ironically, never is this more
truethan today of Keynes himself." -- John Train<br /> 

pgadmin-support by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: Forgotten Password
Next
From: Guillaume Lelarge
Date:
Subject: Re: can't get pgpass.conf to work with pgagent