Re: Catalog/Metadata consistency during changeset extraction from wal - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: Catalog/Metadata consistency during changeset extraction from wal
Date
Msg-id 99FDAE17-E669-4E9B-A744-63A9C206F1EE@phlo.org
Whole thread Raw
In response to Catalog/Metadata consistency during changeset extraction from wal  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Catalog/Metadata consistency during changeset extraction from wal
List pgsql-hackers
On Jun21, 2012, at 13:41 , Andres Freund wrote:
> 3b)
> Ensure that enough information in the catalog remains by fudging the xmin
> horizon. Then reassemble an appropriate snapshot to read the catalog as the
> tuple in question has seen it.

The ComboCID machinery makes that quite a bit harder, I fear. If a tuple is
updated multiple times by the same transaction, you cannot decide whether a
tuple was visible in a certain snapshot unless you have access to the updating
backend's ComboCID hash.

best regards,
Florian Pflug



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Resource Owner reassign Locks
Next
From: Tom Lane
Date:
Subject: Re: Pruning the TODO list