Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Gather Merge - Mailing list pgsql-hackers

From Andreas Joseph Krogh
Subject Re: [HACKERS] Gather Merge
Date
Msg-id VisenaEmail.2a.7febb91868fbbb2.15ab77c9e61@tc7-visena
Whole thread Raw
In response to Re: [HACKERS] Gather Merge  (Rushabh Lathia <rushabh.lathia@gmail.com>)
Responses Re: [HACKERS] Gather Merge  (Rushabh Lathia <rushabh.lathia@gmail.com>)
List pgsql-hackers
Tree view
På fredag 10. mars 2017 kl. 10:09:22, skrev Rushabh Lathia <rushabh.lathia@gmail.com>:
 
 
On Fri, Mar 10, 2017 at 2:33 PM, Andreas Joseph Krogh <andreas@visena.com> wrote:
[...]
The execution-plan seems (unsurprisingly) to depend on data-distribution, so is there a way I can force a GatherMerge?
 
Not directly. GatherMerge cost is mainly depend on parallel_setup_cost,
parallel_tuple_cost and cpu_operator_cost. May be you can force this
by setting this cost low enough. Or another way to force is by disable the
other plans.
 
What plan you are getting now? You not seeing the below error ?
 
ERROR:  GatherMerge child's targetlist doesn't match GatherMerge
 
I'm seeing the same error, it's just that for reproducing it I'd rather not copy my whole dataset.
 
--
Andreas Joseph Krogh

pgsql-hackers by date:

Previous
From: Rushabh Lathia
Date:
Subject: Re: [HACKERS] Gather Merge
Next
From: Surafel Temesgen
Date:
Subject: Re: [HACKERS] New CORRESPONDING clause design