Re: [PATCH] Add sortsupport for range types and btree_gist

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: [PATCH] Add sortsupport for range types and btree_gist
Дата
Msg-id 96CDC1AB-53AC-4543-A139-ED7C61F17B5A@yandex-team.ru
обсуждение исходный текст
Ответ на [PATCH] Add sortsupport for range types and btree_gist  (Christoph Heiss <christoph.heiss@cybertec.at>)
Ответы Re: [PATCH] Add sortsupport for range types and btree_gist  (Jacob Champion <jchampion@timescale.com>)
Список pgsql-hackers
Hi Christoph!

> On 15 Jun 2022, at 15:45, Christoph Heiss <christoph.heiss@cybertec.at> wrote:
>
> By sorting the data before inserting it into the index results in a much better index structure, leading to
significantperformance improvements. 

Here's my version of the very similar idea [0]. It lacks range types support.
On a quick glance your version lacks support of abbreviated sort, so I think benchmarks can be pushed event further :)
Let's merge our efforts and create combined patch?

Please, create a new entry for the patch on Commitfest.

Thank you!

Best regards, Andrey Borodin.

[0] https://commitfest.postgresql.org/37/2824/


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: replacing role-level NOINHERIT with a grant-level option
Следующее
От: Aleksander Alekseev
Дата:
Сообщение: Re: CREATE TABLE ( .. STORAGE ..)