Re: assessing parallel-safety

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Noah Misch <noah(at)leadboat(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: assessing parallel-safety
Date: 2015-03-18 16:01:14
Message-ID: CA+TgmobJSuefiPOk6+i9WERUgeAB3ggJv7JxLX+r6S5SYydBRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 17, 2015 at 9:48 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> On Tue, Mar 17, 2015 at 2:26 AM, Noah Misch <noah(at)leadboat(dot)com> wrote:
>> Neither that rule, nor its variant downthread, would hurt operator authors too
>> much. To make the planner categorically parallel-safe, though, means limiting
>> evaluate_function() to parallel-safe functions. That would dramatically slow
>> selected queries. It's enough for the PL scenario if planning a parallel-safe
>> query is itself parallel-safe. If the planner is parallel-unsafe when
>> planning a parallel-unsafe query, what would suffer?
>
> Good point. So I guess the rule can be that planning a parallel-safe
> query should be parallel-safe. From there, it follows that estimators
> for a parallel-safe operator must also be parallel-safe. Which seems
> fine.

More work is needed here, but for now, here is a rebased patch, per
Amit's request.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Attachment Content-Type Size
assess-parallel-safety-v4.patch binary/octet-stream 966.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-03-18 16:02:07 Re: parallel mode and parallel contexts
Previous Message Robert Haas 2015-03-18 15:56:17 Re: Custom/Foreign-Join-APIs (Re: [v9.5] Custom Plan API)