>>> 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