Re: Querying with multicolumn index

From: Eric Jiang <eric(at)doublemap(dot)com>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Querying with multicolumn index
Date: 2016-12-09 18:58:01
Message-ID: CAOfJSTzOP0-=oZZhq8S2AAk=TrbK1RdUP+=QusCqqcmhGEGfEA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Dec 9, 2016 at 9:56 AM, Andreas Joseph Krogh <andreas(at)visena(dot)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(at)doublemap(dot)com | www.doublemap.com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2016-12-09 23:51:41 Re: Querying with multicolumn index
Previous Message Andreas Joseph Krogh 2016-12-09 17:56:21 Re: Querying with multicolumn index