Re: [COMMITTERS] pgsql: Improve access to parallel query from procedural languages.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [COMMITTERS] pgsql: Improve access to parallel query from procedural languages.
Дата
Msg-id 15354.1490621119@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Improve access to parallel queryfrom procedural languages.  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: [COMMITTERS] pgsql: Improve access to parallel queryfrom procedural languages.  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Dilip Kumar
Дата:
Сообщение: Re: Parallel bitmap heap scan
Следующее
От: "Daniel Verite"
Дата:
Сообщение: Re: PATCH: Batch/pipelining support for libpq