Autovacuum and relfrozenxid

Started by Glyn Astillover 17 years ago3 messagesgeneral

glynastill@yahoo.co.uk

over 17 years ago

Hi chaps,

I've noticed age(relfrozenxid) of some of our tables approaching vacuum_freeze_min_age, am I right in thinking this is nothing to 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

Tom Lane

tgl@sss.pgh.pa.us

over 17 years ago

In reply to: Glyn Astill (#1)

Re: Autovacuum and relfrozenxid

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 is nothing 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

Glyn Astill

glynastill@yahoo.co.uk

over 17 years ago

In reply to: Tom Lane (#2)

Re: Autovacuum and relfrozenxid

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.