Re: [sqlsmith] Unpinning error in parallel worker - Mailing list pgsql-hackers

From Jonathan Rudenberg
Subject Re: [sqlsmith] Unpinning error in parallel worker
Date
Msg-id 1524008630.2186289.1341689208.31A2DB11@webmail.messagingengine.com
Whole thread Raw
In response to Re: [sqlsmith] Unpinning error in parallel worker  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: [sqlsmith] Unpinning error in parallel worker
List pgsql-hackers
On Tue, Apr 17, 2018, at 19:31, Thomas Munro wrote:
> On Wed, Apr 18, 2018 at 11:01 AM, Jonathan Rudenberg
> <jonathan@titanous.com> wrote:
> > On Tue, Apr 17, 2018, at 18:38, Thomas Munro wrote:
> >> Thanks, that would be much appreciated, as would any clues about what
> >> workload you're running.  Do you know what the query plan looks like
> >> for the queries that crashed?
> >
> > Yep, I think I know approximately what it looked like, I've attached a lightly redacted plan. All of the hung
querieswere running some variant of this plan as far as I can tell.
 
> 
> Hmm, that isn't a parallel query.  I was expecting to see "Gather" and
> "Parallel" in there.

Oops, I'm really sorry about that. I only have the first part of the hung queries, and there are a few variants. Here's
onethat's parallel. 

Attachment

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: [sqlsmith] Unpinning error in parallel worker
Next
From: David Rowley
Date:
Subject: Should we add GUCs to allow partition pruning to be disabled?