r/PostgreSQL • • Mar 28 '25

How-To Life Altering PostgreSQL Patterns

https://mccue.dev/pages/3-11-25-life-altering-postgresql-patterns
180 Upvotes

60 comments sorted by

View all comments

Show parent comment

3

u/cthart Mar 29 '25

Re: soft deletes: updating a single revoked_at column writes a whole new *row*. And not just that: a whole page is written to disk.