Re: Parallel Seq Scan
От | Amit Kapila |
---|---|
Тема | Re: Parallel Seq Scan |
Дата | |
Msg-id | CAA4eK1KhKwR4g-zTN04c-OKyiRmfFaQSLfH0QmONgQ4+qfow6w@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Parallel Seq Scan (Haribabu Kommi <kommi.haribabu@gmail.com>) |
Ответы |
Re: Parallel Seq Scan
|
Список | pgsql-hackers |
On Thu, Sep 17, 2015 at 6:29 AM, Haribabu Kommi <kommi.haribabu@gmail.com> wrote:
>
> On Thu, Sep 17, 2015 at 6:10 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> > On Thu, Sep 10, 2015 at 12:12 AM, Amit Kapila <amit.kapila16@gmail.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
>
> On Thu, Sep 17, 2015 at 6:10 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> > On Thu, Sep 10, 2015 at 12:12 AM, Amit Kapila <amit.kapila16@gmail.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.
>
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.
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: