News for hackers. Stuff that matters.
Re:The State of Vacuum in Postgres by anarazel on Friday January 05, 2018 @06:04PM (#16082566)
> Postgres’s MVCC implementation with immutable tuples means every write (even updates to a column not in any indexes) to a table touches every index on that table.

The parenthetical comment is not true. If no indexed columns are updated, and there's space on the same page, a so called "HOT" update is performed. Basically a redirection is inserted triggering index scans to follow the update chain to the newest version:

https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f...

Re:The State of Vacuum in Postgres by dragonwriter on Friday January 05, 2018 @06:12PM (#16082612)
Edited the comment to correct the error in my original understanding; thanks for pointing it out!