On Tue, Jun 28, 2016 at 5:22 PM, Amit Kapila <amit.kapil...@gmail.com> wrote: > On Tue, Jun 28, 2016 at 8:25 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> In the appendrel case, I tend to agree that the easiest solution is to >> scan all the children of the appendrel and just mark the whole thing as >> not consider_parallel if any of them have unsafe functions. >> > > Thats what I had in mind as well, but not sure which is the best place > to set it. Shall we do it in set_append_rel_size() after setting the > size of each relation (after foreach loop) or is it better to do it in > set_append_rel_pathlist(). Is it better to do it as a separate patch > or to enhance your patch for this change? >
I have done it as a separate patch. I think doing it in set_append_rel_size() has an advantage that we don't need to scan the child rels separately. If you think that attached patch is on right lines, then I can add test cases as well. -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
set-consider-parallel-append-rels-v1.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers