News for hackers. Stuff that matters.

A comment on Soft deletion probably isn't worth it. Parent comment

Re:Soft deletion probably isn't worth it by layer8 on Tuesday July 19, 2022 @03:55PM (#32157080)
Shouldn’t partitioning help with that? (I have no experience with Postgres.)
[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by tomnipotent on Tuesday July 19, 2022 @05:57PM (#32158504)
Only if those partitions are on separate storage, otherwise you have the same number of dead tuples/dirty pages.
[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by klysm on Wednesday July 20, 2022 @09:24AM (#32165458)
Not sure that is true, Postgres can rule our entire partitions and scan less stuff I think?
[ Parent | on HN ]
Re:Soft deletion probably isn't worth it by tomnipotent on Thursday July 21, 2022 @06:12AM (#32177554)
Doesn't help with writes. More dead tuples can mean more pages scanned for the same amount of data.
[ Parent | on HN ]