Why is pgadmin so slow to display data on a Mac?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>
Subject: Why is pgadmin so slow to display data on a Mac?
Date: 2013-04-19 00:35:52
Message-ID: CAGuHJrMgbCoAnEnEkVXbbZni82n-1re9QD-GRaVv_b6R2GuCdA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

PgAdmin extremely slow to display data on a Mac (I haven't tried it on
other platforms). I have a Macbook Air 2GHz i7 with eight gigs of ram and
of course the SSD drive and yet PgAdmin is painful to use.

I am almost certain this is due to some problem with rendering results and
not fetching the results. The more fields in the result the worse the times
get EVEN IF THERE ARE NO ROWS!.

For example if I do a Select * from table where 1=0 the query runs
instantly but there is a noticable lag in showing the results. If I do a
bunch of joins so that the number of fields grows it takes even longer to
display zero rows.

Of course if I have rows the lag is even longer. If for whatever reason one
of those rows has a text field with a large amount of data in it then you
might as well go have lunch while it's displaying even one row.

Once again this has nothing to do with network lag or speed of queries. The
queries run instantly and display instantly if I am using psql. PgAdmin
chokes on them though.

Is there anything that can be done about this?

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Brett Maton 2013-04-19 06:39:21 Re: Why is pgadmin so slow to display data on a Mac?
Previous Message Darren Duncan 2013-04-18 21:16:08 Re: feature request - automatic SSH tunnels