Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group