Thread: PgAdmin3 on Mac OS X Observations
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 />
Hi, Le 15/01/2010 22:14, Mark Cotner a écrit : > [...] > 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. > I can't check that right now, cause I don't have my Mac Mini there. Will try later. > Love the tool, just coming back after a few years and the improvements are > much appreciated. I wanted to let you know I'm having a couple of problems > with it on the Mac, however I haven't tried to duplicate these problems yet > on other platforms. I'll give it a shot later today and let you know how it > goes. > > 1. The query times seem bloated. It seems to render rather slowly, but the > table I'm querying is wide and has several text columns so that is to be > expected. However, as a DBA I'm testing queries to verify responsiveness on > the server, not so much the client. The time you're reporting doesn't match > what I'm seeing on the server. > > Total query runtime: 963 ms. > 87 rows retrieved. > > Versus(same query run with explain analyze from pgadmin3): > "Sort (cost=11.00..11.05 rows=20 width=3097) (actual time=0.293..0.346 > rows=87 loops=1)" > " Sort Key: version" > " Sort Method: quicksort Memory: 74kB" > " -> 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)" > " Index Cond: (card_id = 15633)" > "Total runtime: 0.494 ms" > > Or roughly 2000 times slower as reported by PgAdmin3. > > It seems more likely people would be more interested in how long the query > runs on the server vs round trip time, etc which seems to be built into your > query time. > Sure. Right now, it just shows you the program didn't freeze. We can probably add this query run time. > 2. When my network or VPN connection drops PgAdmin3 locks up completely. > It may be retrying the connection, but I waited more than 30 minutes for it > to time out and reconnect. It has done this to me a number of times. It > seems the connection management needs more intelligence. > AFAICT, it's more a tcp config than a pgAdmin's config. You probably have the same issue with psql. -- Guillaume.http://www.postgresqlfr.orghttp://dalibo.com