Re: Tepid: selective index updates for heap relations

From: Greg Burd <greg(at)burd(dot)me>
To: Greg Burd <greg(at)burd(dot)me>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Bharath Rupireddy <bharath(dot)rupireddyforpostgres(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Nathan Bossart <nathandbossart(at)gmail(dot)com>
Subject: Re: Tepid: selective index updates for heap relations
Date: 2026-10-15 18:15:08
Message-ID: 10eD4qtjEu2S7fepnPrBqxg73zuMbBCHN1MOEsbrwlPgOoGVzpzOchAF1GqaU8tKrIVCykGm7HVl6EUUonIheJNr9OQ2C5uajOLd1WLThlI=@burd.me
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

Attached is v74: 21 patches against aa7b9cf13. Changes since posted v73:

In v74 I've folded the five repair patches into their introducing commits.
Dependent pageinspect and recovery tests move into amcheck patch18.
Statistics remain patch17. Patches 1-19 are the production series;
patches 20/21 are separate [DO NOT MERGE] test-AM and benchmark patches.

01. Name the locator contract between table and index access methods
02. Rename TM_FailureData.traversed to retargeted
03. Report table AM tuple failures without heap metadata
04. Let the executor say which version of a row it names
05. Let an index AM store a variable-width locator
06. Carry row copies in after-trigger events
07. Support table AMs that update rows in place
08. Let a table AM flag bitmap groups that do not combine exactly
09. Improve test coverage for heap-only tuple (HOT) update behavior
10. Let table AMs compare candidate attributes before an update
11. Implement the heap AM's modified-attrs comparison callback
12. Identify modified indexed attributes in the executor on UPDATE
13. Prepare index maintenance for selective updates.
14. Add the selective-indexed on-disk format: inline attr bitmap and stubs
15. Add a per-block locator-split bit to the visibility map
16. Implement heap HOT with selective index updates.
17. Extend heap statistics to include selective-indexed updates
18. Teach amcheck to verify HOT-indexed chains and index coverage
19. Add a subscription option for HOT-indexed updates
20. [DO NOT MERGE] Add test table AMs for the locator contract
21. [DO NOT MERGE] Add a HOT-indexed benchmark harness

best.

-greg

Attachment Content-Type Size
tepid-v74.tar.gz application/gzip 262.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Zsolt Parragi 2026-10-15 18:24:13 Re: Serverside SNI support in libpq
Previous Message Haibo Yan 2026-10-15 18:03:00 Re: Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan()