From: Tobias Brox <tobias@nordicbet.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Tobias Brox <tobias@nordicbet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Multi-key index not beeing used - bug?
Date: Wed, 4 Oct 2006 22:41:48 +0200
Message-ID: <20061004204148.GA24672@oppetid.no> (raw)
In-Reply-To: <21283.1159994034@sss.pgh.pa.us>
References: <20061004181243.GB9871@oppetid.no>
<21283.1159994034@sss.pgh.pa.us>
[Tom Lane - Wed at 04:33:54PM -0400]
> > We have indices on the users_id field and the (users_id, created)-tuple.
>
> Neither of those indexes can provide the sort order the query is asking
> for.
Ah; that's understandable - the planner have two options, to do a index
traversion without any extra sorting, or to take out everything and then
sort. What I'd like postgres to do is to traverse the index and do some
sorting for every unique value of created. Maybe such a feature can be
found in future releases - like Postgres 56.3? ;-)
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: tobias@nordicbet.com, tgl@sss.pgh.pa.us
Subject: Re: Multi-key index not beeing used - bug?
In-Reply-To: <20061004204148.GA24672@oppetid.no>
* 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