I have a set up where most of the data located in partitions of the large table
and that data never changes. The only table that really changes is current
day's partition. The problem is that transaction wraparound vacuum generates a
lot of traffic quite frequently on partitions that never changed (technically
read only). This is especially a problem with streaming replication due to
enormous amounts of logging activity that is being generated. Is there a way
to limit or eliminate those frequent vacuum. Something akin to oralce read only
tablespace or a way to set frozen transaction xid on a partition level?
Basically anything to make it less frequent especially when there is zero
activity on those tables after initial loads.