Re: Parallel execution and prepared statements

Tobias Bussmann <t.bussmann@gmx.net>

From: Tobias Bussmann <t.bussmann@gmx.net>

To: "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>

Cc: Albe Laurenz <laurenz.albe@wien.gv.at>, Amit Kapila <amit.kapila16@gmail.com>

Date: 2016-11-16T15:25:16Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Enable parallelism for prepared statements and extended query protocol.
- 57a6a72b6bc9 9.6.0 cited

> Can you once test by just passing CURSOR_OPT_PARALLEL_OK in
> PrepareQuery() and run the tests by having forc_parallel_mode=regress?
> It seems to me that the code in the planner is changed for setting a
> parallelModeNeeded flag, so it might work as it is.

Do you mean running a "make installcheck" with "force_parallel_mode=regress" in postgresql.conf? I did so with just CURSOR_OPT_PARALLEL_OK in PrepareQuery (like the original commit 57a6a72b) and still got 3 failed tests, all with CREATE TABLE .. AS EXECUTE .. . With my patch applied, all tests were successful.