On 9/28/18 11:32 AM, Arup Rakshit wrote:
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.
That is not what you showed in your first post:
Planning time: 0.178 ms
Execution time: 0.527 ms
Thanks,
Arup Rakshit
ar@xxxxxxx <mailto:ar@xxxxxxx>
On 28-Sep-2018, at 9:46 PM, Andreas Kretschmer
<andreas@xxxxxxxxxxxxxxx <mailto: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 <http://www.2ndQuadrant.com>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
