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.
--EDIT--
I upgraded PgAdmin to version 1.16.1 and query time is 19.038 seconds
, so no change with software revision.
psql
? I think this difference is a result of displaying the results, over which the user has no real influence...ERROR: character 0xefbfbd of encoding "UTF8" has no equivalent in "WIN1252"
so unfortunately I don't have data from psql. However your displaying comment makes sense. I will do some additional testing on a linux machine to see if there is any difference.