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

Fwd: vacuum tx id wraparound issues

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Fwd: vacuum tx id wraparound issues
Date: 2009-06-25 16:05:13
Message-ID: 407d949e0906250905q6b54f8acnaf6f781da633ee53@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Sorry, meant to reply on-list. Unfortunately gmail has made it awkward
to stay on-list despite many people complaining about the change.


---------- Forwarded message ----------
From: Greg Stark <gsstark(at)mit(dot)edu>
Date: Thu, Jun 25, 2009 at 4:28 PM
Subject: Re: vacuum tx id wraparound issues
To: Kevin Kempter <kevink(at)consistentstate(dot)com>


On Thu, Jun 25, 2009 at 3:29 PM, Kevin
Kempter<kevink(at)consistentstate(dot)com> wrote:
>
> 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?


You can safely raise this value substantially. The main cost is that
the clog will take extra space to record the status of all these old
transactions. Beware that if you set this to something like 2 billion
then the vacuums that kick in at that point have a limited amount of
time to complete before the whole database shuts down.

However it's unusual to run into this situation at all, let alone
after a just one day. That would be over 2,000 transactions per second
every second for 24 hours.

I suspect your vacuumdb didn't actually vacuum some tables. Do you
have multiple databases? Did you do vacuumdb -a? What database and
table is the autovacuum process kicking in for?



--
greg
http://mit.edu/~gsstark/resume.pdf



-- 
greg
http://mit.edu/~gsstark/resume.pdf

In response to

pgsql-admin by date

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

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