Re: parallel plan in insert query - Mailing list pgsql-bugs

From Greg Stark
Subject Re: parallel plan in insert query
Date
Msg-id CAM-w4HNETsJS0+KPwF-ar7FRiSdz9PmM9A=XCAVL6gqxEkukEQ@mail.gmail.com
Whole thread Raw
In response to parallel plan in insert query  (Grigory Smolkin <g.smolkin@postgrespro.ru>)
Responses Re: parallel plan in insert query
List pgsql-bugs
The query doesn't look like a write query from the sql or the plan you
sent. My guess is that one of the PostGIS
functions does an update or insert internally. It should probably be
marked VOLATILE in that case which I'm not sure but would assume would
disable parallel queries as well. But there are reasons why they might
not want to do that too in which case this is the kind of risk that
would come with.

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #14365: drop big schema will hang the standby's apply
Next
From: Grigory Smolkin
Date:
Subject: Re: parallel plan in insert query