Re: Why my query not using index to sort?

Поиск
Список
Период
Сортировка
От Arup Rakshit
Тема Re: Why my query not using index to sort?
Дата
Msg-id 05A26EE2-964C-4F53-8DB5-CD86D3D46D86@zeit.io
обсуждение исходный текст
Ответ на Re: Why my query not using index to sort?  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Ответы Re: Why my query not using index to sort?
Список 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



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


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: regarding bdr extension
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Why my query not using index to sort?