Fix quadratic LWLock wait queue behaviour

Title

Topic

Performance

Created

2022-11-01 01:11:13

Last modified

2022-11-21 23:07:33 (1 year, 11 months ago)

Latest email

2022-11-21 15:31:14 (1 year, 11 months ago)

Status

2022-11: Committed

Target version

Authors

Andres Freund (andresfreund)

Reviewers

Bharath Rupireddy (bharathrupireddy)Become reviewer

Committer

Andres Freund (andresfreund)

Links

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/3992
git checkout commitfest/cf/3992

Emails

heavily contended lwlocks with long wait queues scale badly: First at 2022-10-27 16:59:14 by Andres Freund <andres at anarazel.de>
Latest at 2022-11-21 15:31:14 by "Jonathan S. Katz" <jkatz at postgresql.org>
Latest attachment (v3-0001-lwlock-fix-quadratic-behaviour-with-very-long-wai.patch) at 2022-10-31 23:51:14 from Andres Freund <andres at anarazel.de>
Attachment (v3-0001-lwlock-fix-quadratic-behaviour-with-very-long-wai.patch) at 2022-10-31 23:51:14 from Andres Freund <andres at anarazel.de> (Patch: Yes)
Attachment (fix-lwlock-queue.diff) at 2022-10-27 16:59:14 from Andres Freund <andres at anarazel.de> (Patch: Yes)

History

When	Who	What
2022-11-21 23:07:33	Andres Freund (andresfreund)	Closed in commitfest 2022-11 with status: Committed
2022-11-21 23:07:33	Andres Freund (andresfreund)	Changed committer to andresfreund
2022-11-01 11:07:15	Bharath Rupireddy (bharathrupireddy)	Added bharathrupireddy as reviewer
2022-11-01 01:11:25	Andres Freund (andresfreund)	Changed authors to Andres Freund (andresfreund)
2022-11-01 01:11:13	Andres Freund (andresfreund)	Attached mail thread 20221027165914.2hofzp4cvutj6gin@awork3.anarazel.de
2022-11-01 01:11:13	Andres Freund (andresfreund)	Created patch record