pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Nikhil Sontakke <nikhils@2ndquadrant.com>
Cc: David Steele <david@pgmasters.net>
Cc: Andres Freund <andres@anarazel.de>
Cc: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Craig Ringer <craig@2ndquadrant.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Petr Jelinek <petr.jelinek@2ndquadrant.com>
Cc: Sokolov Yura <y.sokolov@postgrespro.ru>
Cc: Stas Kelvich <s.kelvich@postgrespro.ru>
Cc: Dmitry Dolgov <9erthalion6@gmail.com>
Cc: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] logical decoding of two-phase transactions
Date: Mon, 16 Jul 2018 13:21:17 -0400
Message-ID: <15404.1531761677@sss.pgh.pa.us> (raw )
In-Reply-To: <CA+TgmoZfuGSRBv=LDK2mk4Q1MB9wjMuL3AQfXAax2orDWerFUw@mail.gmail.com >
References: <782517ca-1e99-06fe-eba9-34f826118289@2ndquadrant.com >
<CAMGcDxc-kuO9uq0zRCRwbHWBj_rePY9=raR7M9pZGWoj9EOGdg@mail.gmail.com >
<CAMGcDxc3sc-C928toHEvj2dH9t=wTP=BZwUv3rE1bnHzTr9R6Q@mail.gmail.com >
<9cac2837-7e58-1cad-3940-27ac0dd7c198@2ndquadrant.com >
<CAMGcDxfAnJtJ17hejKFDa3xXS2OWpys+p-PvGS+MZj4h73QqPA@mail.gmail.com >
<b1c6ba51-436c-b10d-895f-3805d3caf4a5@2ndquadrant.com >
<CAMGcDxeyO-vu4WEsX8ZZRkV7LB037Rd5EmekQuZ_bj0Y33KbBA@mail.gmail.com >
<CAMGcDxeW2xE51Rx8V8hwL7YMkVFBwtOwDco5=opWd-YACJMi0g@mail.gmail.com >
<CAA8=A7_c9jiNMzpHsH+wxEA91WUt_cRc-BN8U0S+MErhJnhZTw@mail.gmail.com >
<20180406162023.wcic5kw73bgswgb6@alap3.anarazel.de >
<CAMGcDxev9QiGpAkrNxvTKeGtYJTKRmo0UxJuQUyWGuOKgjEtdw@mail.gmail.com >
<9ea4c35b-f8ec-220b-2429-b860b49748f3@pgmasters.net >
<CAMGcDxfmy1nLtoukiHbavfqm+scvT9=WckaCtRYW1fq7LRFd9Q@mail.gmail.com >
<CAMGcDxdn8SQMuGWZ-hDVnkXv_eAbPzWRmFNU36a63b7zPeUhiw@mail.gmail.com >
<CAMGcDxdW0LMpjxwnC6_YT2UoPgY9onXAEAbJwYDeux2mSuekOw@mail.gmail.com >
<0c7e9fb9-01f7-32! 84-da9e-22b6dde679d4@2ndquadrant.com >
<CA+TgmoZfuGSRBv=LDK2mk4Q1MB9wjMuL3AQfXAax2orDWerFUw@mail.gmail.com >
Robert Haas <robertmhaas@gmail.com> writes:
> I agree. As a general statement, I think the idea of trying to
> prevent transactions from aborting is really scary. It's almost an
> axiom of the system that we're always allowed to abort, and I think
> there could be a lot of unintended and difficult-to-fix consequences
> of undermining that guarantee. I think it will be very difficult to
> create a sound system for delaying transactions, and I doubt very much
> that the proposed system is sound.
Ugh, is this patch really dependent on such a thing?
TBH, I think the odds of making that work are indistinguishable from zero;
and even if you managed to commit something that did work at the instant
you committed it, the odds that it would stay working in the face of later
system changes are exactly zero. I would reject this idea out of hand.
regards, tom lane
view thread (644+ messages) latest in thread
Message-ID: <15404.1531761677@sss.pgh.pa.us>
Permalink: ../15404.1531761677@sss.pgh.pa.us/
Also on: postgresql.org/message-id/15404.1531761677@sss.pgh.pa.us
copy link · copy postgr.es
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-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, robertmhaas@gmail.com, tomas.vondra@2ndquadrant.com, nikhils@2ndquadrant.com, david@pgmasters.net, andres@anarazel.de, andrew.dunstan@2ndquadrant.com, simon@2ndquadrant.com, craig@2ndquadrant.com, peter.eisentraut@2ndquadrant.com, petr.jelinek@2ndquadrant.com, y.sokolov@postgrespro.ru, s.kelvich@postgrespro.ru, 9erthalion6@gmail.com, sawada.mshk@gmail.com
Subject: Re: [HACKERS] logical decoding of two-phase transactions
In-Reply-To: <15404.1531761677@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