Re: 7.0.2 issues / Geocrawler

Поиск
Список
Период
Сортировка
От Tim Perdue
Тема Re: 7.0.2 issues / Geocrawler
Дата
Msg-id 396CA41E.DC5DE9B8@valinux.com
обсуждение исходный текст
Ответ на 7.0.2 issues / Geocrawler  (Tim Perdue <tperdue@valinux.com>)
Ответы Re: 7.0.2 issues / Geocrawler  (The Hermit Hacker <scrappy@hub.org>)
Список pgsql-hackers
"Ross J. Reedstrom" wrote:
> Mike Mascari gave you a detailed answer to that, which you seemd to just blow
> off, based on you guesstimate that it would run too long:

That is a separate issue - unrelated to this performance issue and it
was not "blown" off, I was merely making a comment.

> Right, as your explain output showed: the planner is picking this index
> and using it. I'd guess that your time is getting lost in the sort step.

I think you're probably right. It's hard to imagine that sorting is that
much slower, but it's hard to say.

Your ideas for selecting based on the date are intriguing, however the
schema of the db was not done with that in mind. Everyone thinks I'm a
nut when I say this, but the date is stored in a char(14) field in
gregorian format: 19990101125959

So perhaps sorting a char(14) field is somehow majorly slower now.

No I don't have 6.5.3 installed anymore - it was totally fubar and
wasn't running anymore.

Tim

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


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: Insert..returning (was Re: Re: postgres TODO)
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: postgres 7.2 features.