Re: Yet another fast GiST build

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Yet another fast GiST build
Дата
Msg-id a2a08c27-6094-74f7-026e-b0064a6e2f8d@iki.fi
обсуждение исходный текст
Ответ на Yet another fast GiST build  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers
On 26/08/2019 10:59, Andrey Borodin wrote:
> Hi!
> 
> In many cases GiST index can be build fast using z-order sorting.
> 
> I've looked into proof of concept by Nikita Glukhov [0] and it looks very interesting.
> So, I've implemented yet another version of B-tree-like GiST build.

Cool!

> My biggest concern is that passing function to relation option seems
> a bit hacky. You can pass there any function matching sort support
> signature. Embedding this function into opclass makes no sense: it
> does not affect scan anyhow.

I think it should be a new, optional, GiST "AM support function", in 
pg_amproc. That's how the sort support functions are defined for B-tree 
opfamilies, too.

- Heikki



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

Предыдущее
От: Darafei "Komяpa" Praliaskouski
Дата:
Сообщение: Re: Yet another fast GiST build
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [Proposal] Table-level Transparent Data Encryption (TDE) and KeyManagement Service (KMS)