> ------- Original Message ------- > From: Peter <peter@xxxxxxxxxxxxxxxx> > To: pgsql-general@xxxxxxxxxxxxxx > 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
