Search Postgresql Archives

Re: Seq scan vs index scan

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Seq scan vs index scan
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Fri, 22 Mar 2024 21:02:49 -0700
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAA23SdtXY94TGASWxVAV9ffx0H3GXBR7fuQnT_Ba20GZsbkZ=w@mail.gmail.com>
References: <CAA23SdtXY94TGASWxVAV9ffx0H3GXBR7fuQnT_Ba20GZsbkZ=w@mail.gmail.com>

On Fri, Mar 22, 2024 at 8:55 PM arun chirappurath <arunsnmimt@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Seq scan vs index scan
  - From: arun chirappurath

Prev by Date: Re: Seq scan vs index scan
Next by Date: Re: Seq scan vs index scan
Previous by thread: Re: Seq scan vs index scan
Next by thread: Re: Seq scan vs index scan
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux