Re: Why my query not using index to sort?

From: Arup Rakshit <ar(at)zeit(dot)io>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Why my query not using index to sort?
Date: 2018-09-28 18:32:38
Message-ID: 05A26EE2-964C-4F53-8DB5-CD86D3D46D86@zeit.io
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes. But I thought I could improve it, so that it can be finished in 0.xx ms. It takes now between 1.7 to 1.9 ms in production.

Thanks,

Arup Rakshit
ar(at)zeit(dot)io

> On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> wrote:
>
>
>
> Am 28.09.2018 um 18:03 schrieb Arup Rakshit:
>> Also I meatn the execution time is less than I had before with enable_sort = off.
>
> yeah, but not that much. different plan.
>
>
> Regards, Andreas
>
> --
> 2ndQuadrant - The PostgreSQL Support Company.
> www.2ndQuadrant.com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-09-28 18:47:25 Re: Why my query not using index to sort?
Previous Message Adrian Klaver 2018-09-28 17:13:30 Re: regarding bdr extension