undefined | Better HN

0 pointslayer83y ago0 comments

Shouldn’t partitioning help with that? (I have no experience with Postgres.)

0 comments

3 comments · 1 top-level

tomnipotent3y ago· 2 in thread

Only if those partitions are on separate storage, otherwise you have the same number of dead tuples/dirty pages.

klysm3y ago

Not sure that is true, Postgres can rule our entire partitions and scan less stuff I think?

Doesn't help with writes. More dead tuples can mean more pages scanned for the same amount of data.

j / k navigate · click thread line to collapse