Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Querying with multicolumn index - Mailing list pgsql-performance

From Eric Jiang
Subject Re: [PERFORM] Querying with multicolumn index
Date
Msg-id CAOfJSTzOP0-=oZZhq8S2AAk=TrbK1RdUP+=QusCqqcmhGEGfEA@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Querying with multicolumn index  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-performance
Tree view
On Fri, Dec 9, 2016 at 9:56 AM, Andreas Joseph Krogh <andreas@visena.com> wrote:
You should be having this index:
 
create index updates_driver_time_idx ON updates(driver_id, "time" DESC);

I'm not sure I understand the intent of this fix - are you saying that btree indexes only work in a certain direction?

I created this index and the query plans did not change.

--
Eric Jiang, DoubleMap
eric@doublemap.com | www.doublemap.com

pgsql-performance by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: [PERFORM] Querying with multicolumn index
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] Querying with multicolumn index