Re: Tid scan improvements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Tid scan improvements
Дата
Msg-id 8469.1545344467@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Tid scan improvements  (Edmund Horner <ejrh00@gmail.com>)
Ответы Re: Tid scan improvements  (Andres Freund <andres@anarazel.de>)
Re: Tid scan improvements  (Edmund Horner <ejrh00@gmail.com>)
Список pgsql-hackers
Edmund Horner <ejrh00@gmail.com> writes:
> [ tid scan patches ]

I'm having a hard time wrapping my mind around why you'd bother with
backwards TID scans.  The amount of code needed versus the amount of
usefulness seems like a pretty bad cost/benefit ratio, IMO.  I can
see that there might be value in knowing that a regular scan has
"ORDER BY ctid ASC" pathkeys (mainly, that it might let us mergejoin
on TID without an explicit sort).  It does not, however, follow that
there's any additional value in supporting the DESC case.

            regards, tom lane


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: monitoring CREATE INDEX [CONCURRENTLY]
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Tid scan improvements