From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sven R. Kunze <srkunze@tbz-pariv.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Reverse Key Index
Date: Sat, 14 Feb 2015 13:18:19 -0500
Message-ID: <7978.1423937899@sss.pgh.pa.us> (raw)
In-Reply-To: <54DF9036.8080502@tbz-pariv.de>
References: <54DF9036.8080502@tbz-pariv.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
"Sven R. Kunze" <srkunze@tbz-pariv.de> writes:
> does PostgreSQL support the concept of reverse key indexing as described
> here? I couldn't find any documentation on this yet.
> http://www.toadworld.com/platforms/oracle/w/wiki/11075.reverse-key-index-from-the-concept-to-interna...
There's nothing built-in for that (and frankly, it doesn't sound useful
enough that we'd ever add it). You could get the effect easily enough
with an expression index on a byte-reversing function. A related thing
that people often do is create an index on a hash function.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, srkunze@tbz-pariv.de
Subject: Re: Reverse Key Index
In-Reply-To: <7978.1423937899@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox