Re: Parallel Append can break run-time partition pruning - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Parallel Append can break run-time partition pruning
Date
Msg-id 8281.1587597065@sss.pgh.pa.us
Whole thread Raw
In response to Re: Parallel Append can break run-time partition pruning  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Parallel Append can break run-time partition pruning  (David Rowley <dgrowleyml@gmail.com>)
List pgsql-hackers
David Rowley <dgrowleyml@gmail.com> writes:
> Given the same set of paths, when would a non-parallel append be
> cheaper than a parallel one?

Well, anytime the parallel startup cost is significant, for starters.
But maybe we account for that at some other point, like when building
the Gather?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: sqlsmith crash incremental sort
Next
From: David Rowley
Date:
Subject: Re: Parallel Append can break run-time partition pruning