pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@2ndquadrant.com>
Cc: Bruce Momjian <bruce@momjian.us>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: PostgreSQL Bugs <pgsql-bugs@postgresql.org>
Subject: Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts
Date: Sun, 20 Jul 2014 19:04:30 -0400
Message-ID: <18673.1405897470@sss.pgh.pa.us> (raw)
In-Reply-To: <20140720225653.GG5974@alap3.anarazel.de>
References: <20140720200225.GA5974@alap3.anarazel.de>
	<13755.1405887378@sss.pgh.pa.us>
	<20140720204852.GB5974@alap3.anarazel.de>
	<15685.1405891368@sss.pgh.pa.us>
	<20140720213258.GD5974@alap3.anarazel.de>
	<16274.1405892584@sss.pgh.pa.us>
	<20140720220253.GE5974@alap3.anarazel.de>
	<17255.1405894611@sss.pgh.pa.us>
	<20140720223010.GF5974@alap3.anarazel.de>
	<17935.1405895946@sss.pgh.pa.us>
	<20140720225653.GG5974@alap3.anarazel.de>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>

Andres Freund <andres@2ndquadrant.com> writes:
> If any *single* full table vacuum after that calls
> vac_update_datfrozenxid() which just needs its datfrozenxid advance by
> one we're in trouble: vac_truncate_clog() will be called with minMulti =
> GetOldestMultiXactId().

Uh, no, the cutoff is GetOldestMultiXactId minus
vacuum_multixact_freeze_min_age (or the autovac equivalent).
See vacuum_set_xid_limits.

			regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs



view thread (78+ messages)  latest in thread

Message-ID: <18673.1405897470@sss.pgh.pa.us>
Permalink:  ../18673.1405897470@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/18673.1405897470@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, andres@2ndquadrant.com, bruce@momjian.us, alvherre@2ndquadrant.com
  Subject: Re: pg_upgrade < 9.3 -> >=9.3 misses a step around multixacts
  In-Reply-To: <18673.1405897470@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox