Home > mailing lists

Re: Seq scan vs index scan - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Seq scan vs index scan
Date	March 23 07:02:49
Msg-id	CAKFQuwZba6j1-_d8cdFiLgq9uoZ1WA1EdmGUR0B_R-K_NLNJKA@mail.gmail.com Whole thread Raw
In response to	Seq scan vs index scan (arun chirappurath <arunsnmimt@gmail.com>)
List	pgsql-general

On Fri, Mar 22, 2024 at 8:55 PM arun chirappurath <arunsnmimt@gmail.com> wrote:

I am trying to force query to use indexes using query hints.

Set enable indexscan to ON,
Same for bitmap and index only scan

Everything is on by default in the planner. You need to think in terms of what you don't want to happen and disabled those things.

David J.

From: Christophe Pettus
Date: 23 March, 07:02:18
Subject: Re: Seq scan vs index scan

From: Tom Lane
Date: 23 March, 07:13:16
Subject: Re: Seq scan vs index scan