Re: Autonomous Transaction is back

From: Noah Misch <noah(at)leadboat(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Rajeev rastogi <rajeev(dot)rastogi(at)huawei(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Autonomous Transaction is back
Date: 2015-09-12 03:16:19
Message-ID: 20150912031619.GB3238938@tornado.leadboat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Sep 11, 2015 at 02:30:53PM -0500, Merlin Moncure wrote:
> On Thu, Sep 10, 2015 at 8:39 PM, Noah Misch <noah(at)leadboat(dot)com> wrote:
> > It's an exceptionally-challenging development project, agreed. So much code
> > assumes the 1:1 relationship between backends and top-level transactions.
>
> I guess I'm being obtuse, but can you explain why that assumption must
> be revisited?

It's not imperative, but the proposal on the table does so. Robert described
doing so as "a key design goal for this feature"[1]. I have a general picture
of why the proposers chose that, but I will defer to them for any elaboration.

[1] http://www.postgresql.org/message-id/CA+TgmoZE__KOHfUyVZpxvTJSB85xm34KC_t41-OXhTB_111SHQ@mail.gmail.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Takashi Horikawa 2015-09-12 03:49:53 Re: Partitioned checkpointing
Previous Message Amit Kapila 2015-09-12 03:01:51 Re: Speed up Clog Access by increasing CLOG buffers