Re: Autovacuum and relfrozenxid

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: glynastill(at)yahoo(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Autovacuum and relfrozenxid
Date: 2008-10-29 12:10:17
Message-ID: 10889.1225282217@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Glyn Astill <glynastill(at)yahoo(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2008-10-29 12:14:37 Re: [Help] Config Failure on Mac OSX: psqlodbc-08.03.0300
Previous Message Tom Lane 2008-10-29 11:58:31 Re: UUID-OSSP Contrib Module Compilation Issue