Re: Questionable coding in orderedsetaggs.c

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Questionable coding in orderedsetaggs.c
Дата
Msg-id 5069.1390680277@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Questionable coding in orderedsetaggs.c  (Jeremy Harris <jgh@wizmail.org>)
Ответы Re: Questionable coding in orderedsetaggs.c  (Atri Sharma <atri.jiit@gmail.com>)
Список pgsql-hackers
Jeremy Harris <jgh@wizmail.org> writes:
> In ordered_set_startup() sorts are initialised in non-randomAccess mode
> (tuplesort_begin_heap() and ~datum(), last argument).

> The use of tuplesort_skip_tuples() feels very like a random access to
> me.  I think it doesn't fail because the only use (and implementation)
> is to skip forwards; if backwards were tried (as the interface permits)
> external sorts would fail because multiple tapes are present for
> FINALMERGE.

Well, we certainly don't want to incur the overhead of randomAccess mode
when we're not actually going to use it, so I'd resist changing the code
in ordered_set_startup().

It's true that if tuplesort_skip_tuples() supported backwards skip, it
would need to insist that randomAccess mode be enabled *when a backwards
skip is used*.  But such a feature is purely hypothetical ATM.
        regards, tom lane



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: GIN improvements part2: fast scan
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Storing pg_stat_statements query texts externally, pg_stat_statements in core