I've been noticing that PgAdmin III isn't as responsive as I expected it to be.
For instance a query to
select * ... from a table containing 20,397 rows takes
19.531 seconds in PgAdmin III and
7.383 seconds in DbVisualizer 9.0.7. I initially thought this was a coincidence, but it has been consistent across all queries run.
As such it appears that PgAdmin III takes approximately twice as long to query my database over DbVisualizer. So how can I speed up PgAdmin III Queries?
I am using Heroku Postgres 9.1.9 on the Crane package and PgAdmin 1.16.0.
I upgraded PgAdmin to version 1.16.1 and query time is
19.038 seconds, so no change with software revision.