Re: Query optimization problem

[Peter <peter@xxxxxxxxxxxxxxxx>]

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