Re: [HACKERS] Speedup twophase transactions - Mailing list pgsql-hackers

From Stas Kelvich
Subject Re: [HACKERS] Speedup twophase transactions
Date
Msg-id 148B32B4-747B-4569-8B38-D4718757E123@postgrespro.ru
Whole thread Raw
In response to Re: Speedup twophase transactions  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [HACKERS] Speedup twophase transactions  (Michael Paquier <michael.paquier@gmail.com>)
Re: [HACKERS] Speedup twophase transactions  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers

On 27 Sep 2016, at 03:30, Michael Paquier <michael.paquier@gmail.com> wrote:

OK. I am marking this patch as returned with feedback then. Looking
forward to seeing the next investigations.. At least this review has
taught us one thing or two.

So, here is brand new implementation of the same thing.

Now instead of creating pgproc entry for prepared transaction during recovery,
I just store recptr/xid correspondence in separate 2L-list and deleting entries in that
list if redo process faced commit/abort. In case of checkpoint or end of recovery
transactions remaining in that list are dumped to files in pg_twophase.

Seems that current approach is way more simpler and patch has two times less
LOCs then previous one.

-- 
Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Attachment

pgsql-hackers by date:

Previous
From: Antonin Houska
Date:
Subject: Re: [HACKERS] Slow I/O can break throttling of base backup
Next
From: Fujii Masao
Date:
Subject: [HACKERS] invalid number of sync standbys in synchronous_standby_names