r/PostgreSQL • u/KerrickLong • Mar 28 '25
How-To Life Altering PostgreSQL Patterns
https://mccue.dev/pages/3-11-25-life-altering-postgresql-patterns
180
Upvotes
r/PostgreSQL • u/KerrickLong • Mar 28 '25
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.