> ------- Original Message -------
> From: Peter <[EMAIL PROTECTED]>
> To: [email protected]
> Sent: 03/02/07, 10:58:08
> Subject: Re: [GENERAL] Query optimization problem
>
> >>> 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
1.5 was development code - it could have been broken in any number of ways. Get
1.6.2 - it has redesigned grid rendering code which eliminates rendering time
from the equation.
Regards, Dave
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
