On Tue, Dec 5, 2023 at 10:51 AM James Coleman <jtc...@gmail.com> wrote: > > Hello, > > While working on my talk for PGConf.NYC next week I came across this > bullet in the docs on heap only tuples: > > > Old versions of updated rows can be completely removed during normal > > operation, including SELECTs, instead of requiring periodic vacuum > > operations. (This is possible because indexes do not reference their page > > item identifiers.) > > But when a HOT update happens the entry in an (logically unchanged) > index still points to the original heap tid, and that line item is > updated with a pointer to the new line pointer in the same page. > > Assuming I'm understanding this correctly, attached is a patch > correcting the description. > > I have Reviewed the patch. Patch applies neatly without any issues. > Documentation build was successful and there was no Spell-check issue also. I > did not find any issues. The patch looks >good to me. > >Thanks and Regards, >Shubham Khanna.
