Soft Delete Postgres: deleted_at, Partial Indexes and Query Leaks
How soft delete in Postgres works with deleted_at, partial indexes, unique constraints and global query scopes, and how to stop deleted rows leaking.
18 min read
Tag
How soft delete in Postgres works with deleted_at, partial indexes, unique constraints and global query scopes, and how to stop deleted rows leaking.
18 min read
Compare deleted_at columns and archive tables for soft delete in Postgres: partial indexes, foreign keys, bloat, restore paths, and when to use each.
18 min read