Postgres Pro
Downloads
Home   >   mailing lists

Re: How do we hint a query to use index in postgre - Mailing list pgsql-performance

From Nikhil Shetty
Subject Re: How do we hint a query to use index in postgre
Date
Msg-id CAFpL5Vza1sEHv3+8djAs+N2RXDX8w1zVpJC+Gqj2DTiQPNb6rA@mail.gmail.com
Whole thread Raw
In response to Re: How do we hint a query to use index in postgre  (Manish Lad <manishlad7893@gmail.com>)
List pgsql-performance
Tree view
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 by date:

Previous
From: Geervan Hayatnagarkar
Date:
Subject: High-volume writes - what is the max throughput possible
Next
From: Frits Jalvingh
Date:
Subject: Re: High-volume writes - what is the max throughput possible