4 ms·
Only if those partitions are on separate storage, otherwise you have the same number of dead tuples/dirty pages.
by tomnipotent 4y ago
Only if those partitions are on separate storage, otherwise you have the same number of dead tuples/dirty pages.
- klysm 4y agoNot sure that is true, Postgres can rule our entire partitions and scan less stuff I think?
- tomnipotent 4y agoDoesn't help with writes. More dead tuples can mean more pages scanned for the same amount of data.