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! -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
