pgsql: Make it cheap to check if a relation is modified by a query

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Make it cheap to check if a relation is modified by a query
Date: 2026-03-30 13:38:37
Message-ID: E1w7CpB-0029eQ-09@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Make it cheap to check if a relation is modified by a query

Save the range table indexes of result relations and row mark relations
in separate bitmapsets in the PlannedStmt. Precomputing them allows
cheap membership checks during execution. Together, these two groups
approximate all relations that will be modified by a query. This
includes relations targeted by INSERT, UPDATE, DELETE, and MERGE as well
as relations with any row mark (like SELECT FOR UPDATE).

Future work will use information on whether or not a relation is
modified by a query in a heuristic.

PlannedStmt->resultRelations is only used in a membership check, so it
will be removed in a separate commit.

Author: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Reviewed-by: Andres Freund <andres(at)anarazel(dot)de>
Reviewed-by: David Rowley <dgrowleyml(at)gmail(dot)com>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Discussion: https://postgr.es/m/F5CDD1B5-628C-44A1-9F85-3958C626F6A9%40gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/0f4c170cf3b85ef8b092990a88e5b7b50892f7d5

Modified Files
--------------
src/backend/executor/execParallel.c | 7 +++++++
src/backend/optimizer/plan/planner.c | 15 ++++++++++++++-
src/include/nodes/plannodes.h | 6 ++++++
3 files changed, 27 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Melanie Plageman 2026-03-30 13:53:33 pgsql: Remove PlannedStmt->resultRelations in favor of resultRelationRe
Previous Message Álvaro Herrera 2026-03-30 12:04:00 pgsql: Have table_insert and siblings use an unsigned type for options