Re: 7.0.2 issues / Geocrawler

Поиск
Список
Период
Сортировка
От Tim Perdue
Тема Re: 7.0.2 issues / Geocrawler
Дата
Msg-id 396CB0C1.84505FB4@valinux.com
обсуждение исходный текст
Ответ на Re: 7.0.2 issues / Geocrawler  (The Hermit Hacker <scrappy@hub.org>)
Ответы Re: 7.0.2 issues / Geocrawler  (The Hermit Hacker <scrappy@hub.org>)
Re: 7.0.2 issues / Geocrawler  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
The Hermit Hacker wrote:
> just curious, but what if you remove the ORDER BY, just to test ... is it
> that much faster without then with?  Just want to narrow down *if* its a
> sorting issue or not, that's all ...

Good call - it was instantaneous as it used to be.

> If it is a sorting issue, what if you raise the -S value?

-S is 32768 right now

Tim

-- 
Founder - PHPBuilder.com / Geocrawler.com
Lead Developer - SourceForge
VA Linux Systems
408-542-5723


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tim Perdue
Дата:
Сообщение: Re: AW: 7.0.2 issues / Geocrawler
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Serious Performance Loss in 7.0.2??