Horton

Re: out-of-order XID insertion in KnownAssignedXids

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Andres Freund <andres@anarazel.de>
Cc: Konstantin Knizhnik <k.knizhnik@postgrespro.ru>, pgsql-hackers@lists.postgresql.org, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2018-10-09T05:59:00Z
Lists: pgsql-hackers 
On Mon, Oct 08, 2018 at 09:30:49AM -0700, Andres Freund wrote:
> Sounds less terrible, but still pretty bad.  I think we should fix the
> underlying data inconsistency, not paper over it a couple hundred meters
> away.

+1.  I am looking at how to make that possible.
--
Michael

Commits

  1. Avoid duplicate XIDs at recovery when building initial snapshot