pgsql: Use CompactAttribute more often, when possible

From: David Rowley <drowley(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Use CompactAttribute more often, when possible
Date: 2025-10-21 22:36:49
Message-ID: E1vBKyH-002qhm-1P@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Use CompactAttribute more often, when possible

5983a4cff added CompactAttribute for storing commonly used fields from
FormData_pg_attribute. 5983a4cff didn't go to the trouble of adjusting
every location where we can use CompactAttribute rather than
FormData_pg_attribute, so here we change the remaining ones.

There are some locations where I've left the code using
FormData_pg_attribute. These are mostly in the ALTER TABLE code. Using
CompactAttribute here seems more risky as often the TupleDesc is being
changed and those changes may not have been flushed to the
CompactAttribute yet.

I've also left record_recv(), record_send(), record_cmp(), record_eq()
and record_image_eq() alone as it's not clear to me that accessing the
CompactAttribute is a win here due to the FormData_pg_attribute still
having to be accessed for most cases. Switching the relevant parts to
use CompactAttribute would result in having to access both for common
cases. Careful benchmarking may reveal that something can be done to
make this better, but in absence of that, the safer option is to leave
these alone.

In ReorderBufferToastReplace(), there was a check to skip attnums < 0
while looping over the TupleDesc. Doing this is redundant since
TupleDescs don't store < 0 attnums. Removing that code allows us to
move to using CompactAttribute.

The change in validateDomainCheckConstraint() just moves fetching the
FormData_pg_attribute into the ERROR path, which is cold due to calling
errstart_cold() and results in code being moved out of the common path.

Author: David Rowley <dgrowleyml(at)gmail(dot)com>
Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Discussion: https://postgr.es/m/CAApHDvrMy90o1Lgkt31F82tcSuwRFHq3vyGewSRN=-QuSEEvyQ@mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/2470ca435c452fe4def9dcc4a831b5101691d541

Modified Files
--------------
contrib/dblink/dblink.c | 2 +-
contrib/file_fdw/file_fdw.c | 4 +---
contrib/postgres_fdw/deparse.c | 10 ++++------
src/backend/access/gin/gininsert.c | 2 +-
src/backend/commands/typecmds.c | 3 ++-
src/backend/optimizer/util/plancat.c | 2 +-
src/backend/parser/parse_relation.c | 8 ++++----
src/backend/replication/logical/reorderbuffer.c | 6 +-----
src/backend/replication/logical/worker.c | 5 +++--
src/backend/replication/pgoutput/pgoutput.c | 2 +-
src/backend/utils/adt/expandedrecord.c | 2 +-
src/backend/utils/adt/ruleutils.c | 4 ++--
src/backend/utils/cache/catcache.c | 5 +----
src/pl/plpython/plpy_typeio.c | 4 ++--
14 files changed, 25 insertions(+), 34 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2025-10-22 00:59:20 pgsql: Add error_on_null(), checking if the input is the null value
Previous Message Nathan Bossart 2025-10-21 21:40:01 pgsql: Add .abi-compliance-history to back-branches.

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2025-10-21 22:38:41 Re: Use CompactAttribute more often, when possible
Previous Message Jim Jones 2025-10-21 22:18:25 Re: [PATCH] Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement