Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode - Mailing list pgsql-committers

From Robert Haas
Subject Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode
Date
Msg-id CA+TgmoaWMC8QF3gm0Uj8A-G6MrCd5APO9ew4F+HKe1HOmmjUWA@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-committers
On Mon, Mar 29, 2021 at 6:01 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
> A naive question about this scheme: What if the worker that acquires
> the XID writes some row and another worker reads that row before it
> gets to see the XID information? I think it won't treat such a row is
> written by its own transaction. Won't such a scheme lead to different
> behavior than serial inserts or where we have acquired XID before
> starting parallel-operation?

Well, this is the sort of thing that somebody would need to analyze as
part of implementing something like this, but off hand I don't quite
see what the problem is.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Clean up date_part tests a bit
Next
From: Robert Haas
Date:
Subject: Re: pgsql: Add a new GUC and a reloption to enable inserts in parallel-mode