3 ms·
Shouldn’t partitioning help with that? (I have no experience with Postgres.)
by layer8 4y ago
Shouldn’t partitioning help with that? (I have no experience with Postgres.)
- tomnipotent 4y agoOnly 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.