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 по дате отправления: