How to prevent vacuum again and again on the unchanged tables? - Mailing list pgsql-admin

From Haifeng Liu
Subject How to prevent vacuum again and again on the unchanged tables?
Date
Msg-id BLU0-SMTP10794DFB213526581A52553B9BB0@phx.gbl
Whole thread Raw
List pgsql-admin
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?

pgsql-admin by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Best practice to create a read-only user?
Next
From: Achilleas Mantzios
Date:
Subject: Re: Installing multiple instances of Postgred on one FreeBSD server