Re: How do we hint a query to use index in postgre

Поиск
Список
Период
Сортировка
От Nikhil Shetty
Тема Re: How do we hint a query to use index in postgre
Дата
Msg-id CAFpL5Vza1sEHv3+8djAs+N2RXDX8w1zVpJC+Gqj2DTiQPNb6rA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How do we hint a query to use index in postgre  (Manish Lad <manishlad7893@gmail.com>)
Список pgsql-performance
Дерево обсуждения
How about using pg_hint_plans?

Check it out if it helps your case.

Thanks and Regards,
Nikhil

On Thu, Mar 18, 2021, 15:07 Manish Lad <manishlad7893@gmail.com> wrote:
Thank you for your response. 




On Thu, 18 Mar 2021, 14:46 Gaetano Mendola, <mendola@gmail.com> wrote:
There is not such functionality, you can enable/disable special joins,
or update statistics to drive the engine to use the most appropriate
one.


On Thu, Mar 18, 2021 at 10:14 AM Manish Lad <manishlad7893@gmail.com> wrote:



--
cpp-today.blogspot.com

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

Предыдущее
От: Geervan Hayatnagarkar
Дата:
Сообщение: High-volume writes - what is the max throughput possible
Следующее
От: Frits Jalvingh
Дата:
Сообщение: Re: High-volume writes - what is the max throughput possible