Re: Query optimization problem
От | Dave Page |
---|---|
Тема | Re: Query optimization problem |
Дата | |
Msg-id | 200702031849540000@1768825143 обсуждение исходный текст |
Ответ на | Query optimization problem (Peter <peter@greatnowhere.com>) |
Список | pgsql-general |
> ------- Original Message ------- > From: Peter <peter@greatnowhere.com> > To: pgsql-general@postgresql.org > 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 renderingcode which eliminates rendering time from the equation. Regards, Dave
В списке pgsql-general по дате отправления: