How do we hint a query to use index in postgre

From:	Manish Lad <manishlad7893(at)gmail(dot)com>
To:	pgsql-performance(at)lists(dot)postgresql(dot)org
Subject:	How do we hint a query to use index in postgre
Date:	2021-03-18 09:14:23
Message-ID:	CADPrz7-4hRu7kJ-4btqUGyAaifG3S6NZ_TyK-8uwUgP3BT2tjw@mail.gmail.com
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2021-03-06 21:40:00 from Francesco De Angelis <franc(dot)tozzus(at)gmail(dot)com>  2021-03-07 14:51:05 from "Michel SALAIS" <msalais(at)msym(dot)fr>   2021-03-07 15:08:18 from Julien Rouhaud <rjuju123(at)gmail(dot)com>    2021-03-07 16:37:22 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>     2021-03-08 17:03:25 from Michael Lewis <mlewis(at)entrata(dot)com>      2021-03-09 22:58:05 from Francesco De Angelis <franc(dot)tozzus(at)gmail(dot)com>       2021-03-10 08:27:53 from Justin Pryzby <pryzby(at)telsasoft(dot)com>        2021-03-10 11:48:25 from Francesco De Angelis <franc(dot)tozzus(at)gmail(dot)com>         2021-03-10 13:29:18 from Michael Lewis <mlewis(at)entrata(dot)com>          2021-03-12 13:39:13 from Francesco De Angelis <franc(dot)tozzus(at)gmail(dot)com>  2021-03-18 09:14:23 from Manish Lad <manishlad7893(at)gmail(dot)com>   2021-03-18 09:15:58 from Gaetano Mendola <mendola(at)gmail(dot)com>    2021-03-18 09:37:17 from Manish Lad <manishlad7893(at)gmail(dot)com>     2021-03-26 11:41:00 from Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com>
Lists:	pgsql-performance

In response to

• Fwd: different execution time for the same query (and same DB status) at 2021-03-06 21:40:00 from Francesco De Angelis

Responses

• Re: How do we hint a query to use index in postgre at 2021-03-18 09:15:58 from Gaetano Mendola

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Gaetano Mendola	2021-03-18 09:15:58	Re: How do we hint a query to use index in postgre
Previous Message	Marcin Gozdalik	2021-03-17 21:27:18	Re: Extremely inefficient merge-join