Re: Querying with multicolumn index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, Dec 9, 2016 at 9:56 AM, Andreas Joseph Krogh <andreas@xxxxxxxxxx> 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@xxxxxxxxxxxxx | www.doublemap.com

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux