Re: [PERFORM] not using index for select min(...)

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [PERFORM] not using index for select min(...)
Дата
Msg-id 200302021323.50222.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: [PERFORM] not using index for select min(...)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom,

> I think you are leaping to conclusions about why there's a speed
> difference.  Or maybe I'm too dumb to see how an index could be used
> to speed these min/max operations --- but I don't see that one would
> be useful.  Certainly not an index on treeno alone.  Would you care to
> explain exactly how it's done?

If I knew that, I'd have proposed a patch already, yes?

I'm working on it.

--
Josh Berkus
Aglio Database Solutions
San Francisco


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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Interactive Documentation - how do you want it to
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Interactive Documentation - how do you want it towork?