Re: Multi-key index not beeing used - bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tobias Brox <tobias(at)nordicbet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Multi-key index not beeing used - bug?
Date: 2006-10-04 20:33:54
Message-ID: 21283.1159994034@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tobias Brox <tobias(at)nordicbet(dot)com> writes:
> NBET=> explain select * from account_transaction where users_id=123456 order by created desc, id desc limit 10;

> 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.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tobias Brox 2006-10-04 20:41:48 Re: Multi-key index not beeing used - bug?
Previous Message Tom Lane 2006-10-04 20:28:43 Re: UPDATE becomes mired / win32