| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Kouhei Kaigai <kaigai(at)ak(dot)jp(dot)nec(dot)com>, Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>, Jeff Davis <pgsql(at)j-davis(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Amit Langote <amitlangote09(at)gmail(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Fabrízio Mello <fabriziomello(at)gmail(dot)com>, Thom Brown <thom(at)linux(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Parallel Seq Scan |
| Date: | 2015-09-17 02:03:32 |
| Message-ID: | CAA4eK1KhKwR4g-zTN04c-OKyiRmfFaQSLfH0QmONgQ4+qfow6w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Sep 17, 2015 at 6:29 AM, Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
wrote:
>
> On Thu, Sep 17, 2015 at 6:10 AM, Robert Haas <robertmhaas(at)gmail(dot)com>
wrote:
> > On Thu, Sep 10, 2015 at 12:12 AM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
wrote:
> >>> 2. I think it's probably a good idea - at least for now, and maybe
> >>> forever - to avoid nesting parallel plans inside of other parallel
> >>> plans. It's hard to imagine that being a win in a case like this, and
> >>> it certainly adds a lot more cases to think about.
> >>
> >> I also think that avoiding nested parallel plans is a good step
forward.
> >
> > Doing that as a part of the assess parallel safety patch was trivial,
so I did.
> >
>
> I tried with latest HEAD code, seems to be problem is present in other
> scenarios.
>
As mentioned previously [1], we have to do two different things to make
this work, Robert seems to have taken care of one of those (basically
second point in mail[1]) and still another one needs to be taken care
which is to provide support of reading subplans in readfuncs.c and that
will solve the problem you are seeing now.
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haribabu Kommi | 2015-09-17 02:15:35 | Re: Parallel Seq Scan |
| Previous Message | Robert Haas | 2015-09-17 01:28:04 | Re: Parallel Seq Scan |