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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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