Horton

Re: Disabling Heap-Only Tuples

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: James Locke <james.locke.uk@gmail.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>, Laurenz Albe <laurenz.albe@cybertec.at>, Andres Freund <andres@anarazel.de>, Thomas Munro <thomas.munro@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Thom Brown <thom@linux.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2026-05-08T14:35:50Z
Lists: pgsql-hackers 
On 2026-May-08, James Locke wrote:

> It's the same invariant a cross-page UPDATE relies on, and heap_relocate
> inherits it because the on-disk and WAL record are identical to a regular
> update.

Ah, that makes sense, and I understand why you say this would cause
index bloat.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"The Gord often wonders why people threaten never to come back after they've
been told never to return" (www.actsofgord.com)