Re: Why my query not using index to sort?

[Arup Rakshit <ar@xxxxxxx>]

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@xxxxxxx

On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> 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