| From: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
|---|---|
| To: | Manish Lad <manishlad7893(at)gmail(dot)com> |
| Cc: | Gaetano Mendola <mendola(at)gmail(dot)com>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How do we hint a query to use index in postgre |
| Date: | 2021-03-26 11:41:00 |
| Message-ID: | CAFpL5Vza1sEHv3+8djAs+N2RXDX8w1zVpJC+Gqj2DTiQPNb6rA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmail(dot)com> wrote:
> Thank you for your response.
>
>
>
>
> On Thu, 18 Mar 2021, 14:46 Gaetano Mendola, <mendola(at)gmail(dot)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(at)gmail(dot)com>
>> wrote:
>>
>>
>>
>> --
>> cpp-today.blogspot.com
>>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Frits Jalvingh | 2021-03-26 12:48:36 | Re: High-volume writes - what is the max throughput possible |
| Previous Message | Geervan Hayatnagarkar | 2021-03-25 18:12:15 | High-volume writes - what is the max throughput possible |