Thread: Autovacuum and relfrozenxid

Hi chaps,

I've noticed age(relfrozenxid) of some of our tables approaching vacuum_freeze_min_age, am I right in thinking this is
nothingto worry about, autovacuum will just get invoked for those tables? 

Even if it isn't, should I be tuning autovacuum so that those tables should have been vacuumed before it comes to this?

Glyn

Glyn Astill <glynastill@yahoo.co.uk> writes:
> I've noticed age(relfrozenxid) of some of our tables approaching vacuum_freeze_min_age, am I right in thinking this
isnothing to worry about, autovacuum will just get invoked for those tables? 

If there's no update activity on that table, this is to be expected.

            regards, tom lane

>
> If there's no update activity on that table, this is to
> be expected.
>

Hmm, there is activity on the table, so I'm guessing I've not got autovacuumm tuned aggressively enough.