Horton

Re: Fix missing EvalPlanQual recheck for TID scans

Chao Li <li.evan.chao@gmail.com>

View thread View on postgr.es
From: Chao Li <li.evan.chao@gmail.com>
To: David Rowley <dgrowleyml@gmail.com>, Sophie Alpert <pg@sophiebits.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2025-09-15T08:12:23Z
Lists: pgsql-hackers 

> On Sep 15, 2025, at 14:27, David Rowley <dgrowleyml@gmail.com> wrote:
> 
> 
> I think you've only read the first sentence in that paragraph. Please
> read the entire paragraph. You'll see it goes on to explain "it will
> attempt to apply its operation to the updated version of the row".
> 


Ah… Sorry for missing the part of the paragraph. Now it’s clear to me.

Then the solution of TidListEval() is correct, and the only issue is repeatedly calling TidListEval() on every recheck.

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/

Commits

  1. Add missing EPQ recheck for TID Range Scan

  2. Add missing EPQ recheck for TID Scan

  3. Repair problems with EvalPlanQual where target table is scanned as

  4. Tid access method feature from Hiroshi Inoue, Inoue@tpf.co.jp