Re: Parallel Append implementation

Amit Khandekar <amitdkhan.pg@gmail.com>

From: Amit Khandekar <amitdkhan.pg@gmail.com>

To: Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>

Cc: Robert Haas <robertmhaas@gmail.com>, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2017-03-24T07:53:01Z

Lists: pgsql-hackers

Attachments

ParallelAppend_v11.patch (application/octet-stream) patch v11

On 24 March 2017 at 13:11, Rajkumar Raghuwanshi
<rajkumar.raghuwanshi@enterprisedb.com> wrote:
> I have given patch on latest pg sources (on commit
> 457a4448732881b5008f7a3bcca76fc299075ac3). configure and make all
> install ran successfully, but initdb failed with below error.

> FailedAssertion("!(LWLockTranchesAllocated >=
> LWTRANCHE_FIRST_USER_DEFINED)", File: "lwlock.c", Line: 501)

Thanks for reporting, Rajkumar.

With the new PARALLEL_APPEND tranche ID, LWTRANCHE_FIRST_USER_DEFINED
value has crossed the value 64. So we need to increase the initial
size of LWLockTrancheArray from 64 to 128. Attached is the updated
patch.

Commits

Update parallel.sgml for Parallel Append
- ac535cd47806 11.0 landed
- e80f2b335ecd 12.0 landed
Support Parallel Append plan nodes.
- ab7271677812 11.0 landed
Remove BufFile's isTemp flag.
- 11e264517dff 11.0 cited
Improve comments for parallel executor estimation functions.
- 11c1d555cebe 11.0 landed
Separate reinitialization of shared parallel-scan state from ExecReScan.
- 41b0dd987d44 11.0 cited
Eat XIDs more efficiently in recovery TAP test.
- 08aed6604de2 10.0 cited
Avoid syntax error on platforms that have neither LOCALE_T nor ICU.
- 457a44487328 10.0 cited
Preparatory refactoring for parallel merge join support.
- a71f10189dc1 10.0 cited