Thread: How to prevent vacuum again and again on the unchanged tables?

How to prevent vacuum again and again on the unchanged tables?

From
Haifeng Liu
Date:
I noticed postgresql would do vacuum to prevent wraparound of the transaction id, and I also tried to use vacuum
freeze,I am not quite sure about freeze, but it seems postgresql will still vacuum the frezzed unchanged tables
automatically.

My scenario is, I have a table with daily partitions, those partition table inherits the parent table, with date check.
Eachday there is tens of millions rows, and old partitions won't be updated, they may be treat as readonly table. 

Meanwhile, there is hot-stanby server, we treat it as a readonly db. when we query on that db, we often got version
conflicterror, even on the old partitions. 

Is there any way better to deal this?