Re: [HACKERS] Anyone working on optimizing subset min/max queries?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] Anyone working on optimizing subset min/max queries?
Дата
Msg-id 199807132131.RAA28670@candle.pha.pa.us
обсуждение исходный текст
Ответ на Anyone working on optimizing subset min/max queries?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> For now, I can live with scanning all the table entries, but it would be
> nice to know that someone is working on this and it'll be there by the
> time my tables get huge ;-).  I see something about
>     * Use indexes in ORDER BY, min(), max()(Costin Oproiu)
> in the TODO list, but is this actively being worked on, and will it
> solve my problem or just handle simpler cases?
>
> Alternatively, is there a better way to do predecessor/successor
> queries in SQL?

Costin is not working on it currently, and I have removed his name from
the item.  I know of no one working on it, though it is requested every
so often.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Anyone working on optimizing subset min/max queries?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] Sequence objects have no global currval operator?