Which version are you running?

 

  I use pgAdmin3 v. 1.16.1 on an  Air with 4Gb of RAM, OS X 10.7.5 and it works 
just fine without any noticeable lag.

 

From: pgadmin-support-ow...@postgresql.org 
[mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Tim Uckun
Sent: 19 April 2013 01:36
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] Why is pgadmin so slow to display data on a Mac?

 

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?

Reply via email to