Re: [COMMITTERS] pgsql: Improve access to parallel query from procedural languages. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [COMMITTERS] pgsql: Improve access to parallel query from procedural languages.
Date
Msg-id 15354.1490621119@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Improve access to parallel queryfrom procedural languages.  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [COMMITTERS] pgsql: Improve access to parallel queryfrom procedural languages.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Mar 27, 2017 at 1:48 AM, Rafia Sabih
> <rafia.sabih@enterprisedb.com> wrote:
>> This is caused because trigger related functions are marked safe and
>> using global variables, hence when executed in parallel are giving
>> incorrect  output.

> If it's just that they are relying on unsynchronized global variables,
> then it's sufficient to mark them parallel-restricted ('r').  Do we
> really need to go all the way to parallel-unsafe ('u')?

Color me confused, but under what circumstances would triggers get
executed by a parallel worker at all?  I thought we did not allow
updating queries to be parallelized.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Dilip Kumar
Date:
Subject: Re: Parallel bitmap heap scan
Next
From: "Daniel Verite"
Date:
Subject: Re: PATCH: Batch/pipelining support for libpq