Re: Instability in partition_prune test? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Instability in partition_prune test?
Date
Msg-id 20180413142545.gc4lbnvq6owijozb@alvherre.pgsql
Whole thread Raw
In response to Re: Instability in partition_prune test?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Instability in partition_prune test?
List pgsql-hackers
Tom Lane wrote:
> David Rowley <david.rowley@2ndquadrant.com> writes:
> > The attached basically adds:
> > set max_parallel_workers = 0;
> 
> It seems quite silly to be asking for a parallel plan and then insisting
> it not run in parallel.

The idea is to use the parallel append code, but run it in the leader.

Now that you mention it, this probably decreases coverage for the
choose_next_subplan_for_worker function.

> Maybe the right solution is to strip out the loop_count from what's
> printed.  We've already done that sort of thing in at least one other
> test, using some plpgsql code to "sed" the EXPLAIN output.

Ah, explain_parallel_sort_stats() ... maybe that's an idea, yeah.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Instability in partition_prune test?
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] path toward faster partition pruning