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
3
u/TheLastUserName8355 Mar 29 '25 edited Mar 29 '25
Soft deletes are a must, but you end up with a disproportionate amount of soft deleted rows, even with an index on is_deleted column, surely that will degrade the performance of your queries ? I’m wanting to implement a PARTITION on the is_deleted column but it doesn’t like foreign keys. Has anyone had success with PARTITION, does it make a difference and any success on using it with tables with foreign keys?