Re: Forcing Index usage

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Zahir Lalani <ZahirLalani(at)oliver(dot)agency>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Forcing Index usage
Date: 2025-11-13 14:06:59
Message-ID: CAKAnmmLyb0xmdxYOyXgMh7xtYMKVnspJXQB7xESCbEaaFFwWNw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Please provide a self-contained use case, or (at the bare minimum) trim out
the irrelevant parts of your query and show us the schema for the tables in
question. Finally, please show the explain plans for the "good" and "bad"
runs you are experiencing. Thanks.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2025-11-13 15:28:36 Re: Forcing Index usage
Previous Message Zahir Lalani 2025-11-13 13:35:36 Forcing Index usage