News for hackers. Stuff that matters.

A comment on Improved vacuum in PostgreSQL 13. Parent comment

Re:Improved vacuum in PostgreSQL 13 by blattimwind on Tuesday May 12, 2020 @09:20AM (#23153657)
Data is only inserted, not changed or deleted.
[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by PudgePacket on Tuesday May 12, 2020 @10:46AM (#23154561)
.
[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by 22c on Tuesday May 12, 2020 @10:51AM (#23154609)
You seem to be missing that data can still be read after it is insterted, provided it is not updated. So think if more like WORM rather than write-only.
[ Parent | on HN ]
Re:Improved vacuum in PostgreSQL 13 by sandGorgon on Tuesday May 12, 2020 @10:55AM (#23154649)
for compliance. you want this behavior to be enforced at the database level so that any buggy code does not edit a previous row.
[ Parent | on HN ]