1
The challenges of soft delete (atlas9.dev)
submitted 2 weeks ago by codeinabox@programming.dev to c/postgresql@programming.dev
1 comments fedilink hide all child comments
top 1 comments
sorted by: hot top new old
[-] stevestevesteve@lemmy.world 1 points 2 weeks ago

I don't feel like leaving the records in-table is that terrible. Maybe even partition on the deleted-at column to keep the performance impact minimal. The benefit of simplicity massively outweighs the rest for me

this post was submitted on 22 Jan 2026
1 points (100.0% liked)

PostgreSQL

1713 readers
2 users here now

The world's most advanced open source relational database

Project
Events
Podcasts
Related Fediverse communities

founded 2 years ago
MODERATORS
Ategon@programming.dev
jnovinger@programming.dev
starman@programming.dev