Try SELECT count(*) FROM ... instead and see if the times are closer.
Correct. That executes in 300ms flat:
So your problem is data transfer, not the query per se.
Well, based on PgAdmin times I suspected some sort of heavy 'data
preparation before it's sent out' overhead
How old a pgAdmin are you using?
1.4.3
I tried 1.5 but it was too slow rendering results from SELECT queries...
maybe it's fixed by now
Peter
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
