From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-performance@postgresql.org
Subject: Re: Reverse Key Index
Date: Thu, 26 Feb 2015 12:45:46 +0100
Message-ID: <mcn11a$lf8$1@ger.gmane.org> (raw)
In-Reply-To: <54EEFDA1.7020609@tbz-pariv.de>
References: <54DF9036.8080502@tbz-pariv.de>
<7978.1423937899@sss.pgh.pa.us>
<54DF9559.8080109@tbz-pariv.de>
<WM!ac1d64cef832673f1f6089d7c26e717d0c09326c990d42e4ac6c27c98e44612c4261de1a99f3eaf40ab4ae5310bbe616!@asav-1.01.com>
<54EE4D45.1060704@agliodbs.com>
<54EEFDA1.7020609@tbz-pariv.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Sven R. Kunze schrieb am 26.02.2015 um 12:04:
> I just thought about btree indexes here mainly because they well-known and well-used in ORM frameworks.
If your ORM framework needs to know about the internals of an index definition or even requires a certain index type, then you should ditch that ORM framework.
Apart from indexes supporting business constraints (e.g. a unique index) neither the application nor the the ORM framework should care about indexes at all.
> does PostgreSQL support the concept of reverse key indexing as described here?
The real question is: why do you think you need such an index?
Do you have any performance problems with the existing BTree index? If yes, which problem exactly?
Thomas
--
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: spam_eater@gmx.net
Subject: Re: Reverse Key Index
In-Reply-To: <mcn11a$lf8$1@ger.gmane.org>
* 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