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

Re: vacuum tx id wraparound issues

From: Kevin Kempter <kevink(at)consistentstate(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum tx id wraparound issues
Date: 2009-06-25 14:29:05
Message-ID: 200906250829.05622.kevink@consistentstate.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thursday 25 June 2009 08:25:53 Tom Lane wrote:
> Kevin Kempter <kevink(at)consistentstate(dot)com> writes:
> > I'm seeing a number of vacuum's in one of our db's that has a notation
> > (to prevent wraparound).
>
> This is a normal condition.  There isn't anything you can do that will
> make that stop permanently --- it's just routine housekeeping.
>
> 			regards, tom lane

I did a vacuumdb last nite and already this am I see vacuums to prevent 
wraparound. Do you have any thoughts on increasing the 
autovacuum_freeze_max_age value?


In response to

Responses

pgsql-admin by date

Next:From: Mark LehmannDate: 2009-06-25 14:33:31
Subject: Optimal Flexible Architecture or Optimal Configuration Layout for Postgres
Previous:From: Tom LaneDate: 2009-06-25 14:25:53
Subject: Re: vacuum tx id wraparound issues

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