Re: Faster inserts with mostly-monotonically increasing values

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Faster inserts with mostly-monotonically increasing values
Дата
Msg-id CAGTBQpY2AF8GbBPBW7Q=cuXjJmb=-ihYw=vtwfft8C9j8c_6yg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Faster inserts with mostly-monotonically increasing values  (Simon Riggs <simon.riggs@2ndquadrant.com>)
Список pgsql-hackers
On Tue, Mar 6, 2018 at 9:06 AM, Simon Riggs <simon.riggs@2ndquadrant.com> wrote:
>> Simon had raised concerns about DESC indexes and whether we need to do the
>> checks for leftmost page in that case. I haven't yet figured out if DESC
>> indexes are actually stored in the reverse order. I am gonna look at that
>> too.
>
> No, I meant that you were testing whether the value was higher (> 0),
> whereas it should be lower (< 0) on DESC indexes.

Isn't that already handled by _bt_compare?


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

Предыдущее
От: Ildus Kurbangaliev
Дата:
Сообщение: Re: committing inside cursor loop
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: General purpose hashing func in pgbench