WAL Insertion Lock Improvements

Edit

ID 4141

Title WAL Insertion Lock Improvements

Topic Performance

Created 2023-01-24 07:32:56

Last modified 2023-07-26 03:18:39 (1 year, 5 months ago)

Latest email 2023-07-28 11:27:18 (1 year, 4 months ago)

Status

2023-07: Committed

2023-03: Moved to next CF

Target version

Authors Bharath Rupireddy (bharathrupireddy)

Reviewers Andres Freund (andresfreund), Michael Paquier (michael-kun), Nathan Bossart (bossartn)Become reviewer

Committer Michael Paquier (michael-kun)

Links CFbot results (CirrusCI) CFbot GitHub

Checkout latest CFbot patchset

Go to your local checkout of the PostgreSQL repository and run:

git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4141
git checkout commitfest/cf/4141

Emails

Avoid LWLockWaitForVar() for currently held WAL insertion lock in WaitXLogInsertionsToFinish(): First at 2022-11-24 12:43:10 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest at 2023-07-28 11:27:18 by Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
Latest attachment (v10-0001-Optimize-WAL-insertion-lock-acquisition-and-rele.patch) at 2023-07-22 07:38:49 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com>
    Attachment (v10-0001-Optimize-WAL-insertion-lock-acquisition-and-rele.patch) at 2023-07-22 07:38:49 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Optimize-WAL-insertion-lock-acquisition-and-relea.patch) at 2023-07-20 09:08:29 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Optimize-WAL-insertion-lock-acquisition-and-relea.patch) at 2023-05-19 15:04:16 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Optimize-WAL-insertion-lock-acquisition-and-relea.patch) at 2023-05-18 05:48:25 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (test-case 2 -T900 WAL ~256 bytes.png) at 2023-05-10 17:10:20 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: No)
    Attachment (TestArtifacts.zip) at 2023-05-08 12:27:09 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: No)
    Attachment (lwlock_test.tar.gz) at 2023-04-10 04:08:43 from Michael Paquier <michael at paquier.xyz> (Patch: No)
    Attachment (v5-0001-Optimize-WAL-insertion-lock-acquisition-and-relea.patch) at 2023-02-09 06:21:28 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Optimize-WAL-insertion-lock-acquisition-and-relea.patch) at 2023-02-02 13:30:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optimize-WAL-insertion-lock-acquisition-and-relea.patch) at 2023-01-24 13:30:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Make-insertingAt-64-bit-atomic.patch) at 2022-12-02 11:02:38 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-WAL-Insertion-Lock-Improvements.patch) at 2022-11-25 11:24:19 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Avoid-LWLockWaitForVar-for-currently-held-WAL-ins.patch) at 2022-11-24 12:43:10 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)

History

When	Who	What
2023-07-26 03:18:39	Michael Paquier (michael-kun)	Closed in commitfest 2023-07 with status: Committed
2023-05-24 02:57:34	Michael Paquier (michael-kun)	Added michael-kun as committer
2023-05-22 00:25:51	Michael Paquier (michael-kun)	New status: Ready for Committer
2023-05-22 00:25:35	Michael Paquier (michael-kun)	Changed reviewers to Andres Freund (andresfreund), Michael Paquier (michael-kun), Nathan Bossart (bossartn)
2023-05-18 11:55:22	Bharath Rupireddy (bharathrupireddy)	New status: Needs review
2023-04-10 05:15:33	Michael Paquier (michael-kun)	New status: Waiting on Author
2023-04-09 23:57:36	Michael Paquier (michael-kun)	Closed in commitfest 2023-03 with status: Moved to next CF
2023-02-21 05:49:55	Nathan Bossart (bossartn)	New status: Ready for Committer
2023-01-24 07:33:21	Bharath Rupireddy (bharathrupireddy)	Changed reviewers to Andres Freund (andresfreund), Nathan Bossart (bossartn)
2023-01-24 07:33:21	Bharath Rupireddy (bharathrupireddy)	Changed authors to Bharath Rupireddy (bharathrupireddy)
2023-01-24 07:32:56	Bharath Rupireddy (bharathrupireddy)	Attached mail thread CALj2ACVF+6jLvqKe6xhDzCCkr=rfd6upaGc3477Pji1Ke9G7Bg@mail.gmail.com
2023-01-24 07:32:56	Bharath Rupireddy (bharathrupireddy)	Created patch record

Edit