From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
---|---|
To: | Tobias Bussmann <t(dot)bussmann(at)gmx(dot)net> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
Subject: | Re: Parallel execution and prepared statements |
Date: | 2016-12-03 03:29:43 |
Message-ID: | CAA4eK1++=ZVveRnDO8ibaRNkbE59rUvsm1PWA17kP-t=8LrVTA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Fri, Dec 2, 2016 at 3:31 PM, Tobias Bussmann <t(dot)bussmann(at)gmx(dot)net> wrote:
>
>> On Thu, Dec 1, 2016 at 9:40 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>>>
>>> OK, then my vote is to do it that way for now.
>
> Thanks for your opinion. That's fine with me.
>
>> Am 02.12.2016 um 07:22 schrieb Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>:
>> Done that way in attached patch.
>
> Did a quick review:
>
Thanks for the review.
> You should however include a sentence in the documentation on that parallel plan w/o workers corner-case behaviour. Feel free to take that from my patch or phase a better wording.
>
I have taken it from your patch.
> And again my question regarding back patching to 9.6:
> - 9.6 is currently broken as Laurenz showed in [1]
> - 9.6 does not have documented that SQL PREPARE prepared statements cannot not use parallel query
>
> The former could be fixed by back patching the full patch which would void the latter.
>
I think if we don't see any impact then we should backpatch this
patch. However, if we decide to go some other way, then I can provide
a separate patch for back branches. BTW, what is your opinion?
--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
prepared_stmt_parallel_query_v4.patch | application/octet-stream | 1.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Kapila | 2016-12-03 03:54:17 | Re: Hash Indexes |
Previous Message | Amit Kapila | 2016-12-03 03:04:39 | Re: [sqlsmith] Failed assertion in _hash_splitbucket_guts |