Re: Reverse Key Index

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Reverse Key Index
Дата
Msg-id 54EF1370.2000006@iki.fi
обсуждение исходный текст
Ответ на Re: Reverse Key Index  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Reverse Key Index  ("Sven R. Kunze" <srkunze@tbz-pariv.de>)
Список pgsql-performance
On 02/26/2015 12:31 AM, Josh Berkus wrote:
> On 02/14/2015 10:35 AM, Sven R. Kunze wrote:
>> Thanks for the immediate reply.
>>
>> I understand the use case is quite limited.
>>
>> On the other hand, I see potential when it comes to applications which
>> use PostgreSQL. There, programmers would have to change a lot of code to
>> tweak existing (and more importantly working) queries to hash/reverse an
>> id column first. Using ORMs would make this change even more painful and
>> maybe even impossible.
>>
>> When reading
>> https://richardfoote.wordpress.com/2008/01/14/introduction-to-reverse-key-indexes-part-i/
>> carefully, it also seems to work with index scan partially in case of
>> equality comparisons.
>
> Seems like a good use for SP-GiST.  Go for it!

A b-tree opclass that just compares from right-to-left would work just
as well, and perform better.

- Heikki



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

Предыдущее
От: "Sven R. Kunze"
Дата:
Сообщение: Re: Reverse Key Index
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: Reverse Key Index