Re: Speedup twophase transactions - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Speedup twophase transactions
Date
Msg-id 20160111190702.GC10941@awork2.anarazel.de
Whole thread Raw
In response to Re: Speedup twophase transactions  (Andres Freund <andres@anarazel.de>)
Responses Re: Speedup twophase transactions
List pgsql-hackers
On 2016-01-11 20:03:18 +0100, Andres Freund wrote:
> More generally, I'm doubtful that the approach of reading data from WAL
> as proposed here is a very good idea. It seems better to "just" dump the
> entire 2pc state into *one* file at checkpoint time.

Or better: After determining the checkpoint redo location, insert a WAL
record representing the entire 2PC state as of that moment. That way it
can easily restored during WAL replay and nothing special has to be done
on a standby. This way we'll need no extra wal flushes and fsyncs.



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Speedup twophase transactions
Next
From: Peter Geoghegan
Date:
Subject: Re: 2016-01 Commitfest