public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sophie Alpert <[email protected]>
To: Bernice Southey <[email protected]>
To: [email protected]
Subject: Re: Is this expected concurrency behaviour for EvalPlanQual and ctid?
Date: Thu, 05 Feb 2026 11:16:29 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAEDh4nxKnq1txtjRfBd2eDtRdeXEq5Dbi+n+z0MXkqMMBk=vBA@mail.gmail.com>
References: <CAEDh4ny-6xDG5FJ9Zp_EQKnTL+ouef_JqKACUo2RNQ9KFKKnXA@mail.gmail.com>
	<CAEDh4nxKnq1txtjRfBd2eDtRdeXEq5Dbi+n+z0MXkqMMBk=vBA@mail.gmail.com>

Bernice,

Perhaps you'll find this explanation I wrote around interactions between EvalPlanQual and ctid filters helpful: https://stackoverflow.com/a/79757326/49485

The short answer is that even after my fix, you likely don't want to filter an UPDATE or DELETE on ctid values that were first retrieved in the same SQL statement, because the ctid can have changed in between the time of the initial read and the time of locking (and thus the recheck will fail).

Sophie

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Is this expected concurrency behaviour for EvalPlanQual and ctid?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox