Re: [sqlsmith] Parallel worker crash on seqscan - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [sqlsmith] Parallel worker crash on seqscan
Date
Msg-id 23874.1479749345@sss.pgh.pa.us
Whole thread Raw
In response to Re: [sqlsmith] Parallel worker crash on seqscan  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [sqlsmith] Parallel worker crash on seqscan
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Mon, Nov 21, 2016 at 12:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It seems like maybe searching for individual Params is the wrong thing.
>> Why are we allowing it to generate a parameterized Gather path at all?
>> Given the lack of any way to transmit runtime param values to the worker,
>> I can't see how that would ever work.

> Hmm, so you're thinking it could be the job of generate_gather_paths()
> to make sure we don't do that?

Actually, the Gather path *isn't* parameterized.  The problem here is
that we're planning an unflattened subquery, and the only thing that
is parallel-unsafe is that there is an outer Param in its toplevel tlist,
and we're somehow deciding that we can stick that unsafe tlist into (and
beneath) the Gather node.  So something rotten in that area, but I've not
quite found it yet.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: delta relations in AFTER triggers
Next
From: Alvaro Herrera
Date:
Subject: Re: delta relations in AFTER triggers