Replace buffer manager spinlock with atomic operations

Edit

ID 408

Title Replace buffer manager spinlock with atomic operations

Topic Performance

Created 2015-10-29 17:20:13

Last modified 2016-04-11 11:31:05 (8 years, 7 months ago)

Latest email 2016-04-11 05:10:04 (8 years, 7 months ago)

Status

2016-03: Committed

2016-01: Moved to next CF

2015-11: Moved to next CF

Target version

Authors Andres Freund (andresfreund), Alexander Korotkov (smagen)

Reviewers Become reviewer

Committer Andres Freund (andresfreund)

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

Emails

Move PinBuffer and UnpinBuffer to atomics: First at 2015-09-11 10:23:24 by YUriy Zhuravlev <u.zhuravlev at postgrespro.ru>
Latest at 2016-04-11 05:10:04 by Andres Freund <andres at anarazel.de>
Latest attachment (0001-Finish-09adc9a8c09c9640de05c7023b27fb83c761e91c.patch) at 2016-04-11 05:10:04 from Andres Freund <andres at anarazel.de>
    Attachment (0001-Finish-09adc9a8c09c9640de05c7023b27fb83c761e91c.patch) at 2016-04-11 05:10:04 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (0001-Allow-Pin-UnpinBuffer-to-operate-in-a-lockfree-manne.patch) at 2016-04-08 16:39:46 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (perf_pgbench_ro.sh) at 2016-04-06 14:04:43 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: No)
    Attachment (backoff.patch) at 2016-04-04 08:58:31 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (result.tar) at 2016-04-03 04:25:12 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: No)
    Attachment (graph.png) at 2016-03-31 20:14:15 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: No)
    Attachment (pinunpin-cas-9.patch) at 2016-03-31 17:21:02 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (pinunpin-cas-8.patch) at 2016-03-31 15:44:46 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (0001-WIP-Avoid-the-use-of-a-separate-spinlock-to-protect-.patch) at 2016-03-31 12:22:30 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (pinunpin-cas-7.patch) at 2016-03-29 17:22:00 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (pinunpin-cas-6.patch) at 2016-03-28 12:46:43 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (graph.png) at 2016-03-27 09:38:25 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: No)
    Attachment (pinunpin-cas-5.patch) at 2016-03-22 10:08:01 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (pinunpin-cas-4.patch) at 2016-03-19 20:10:29 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (clients_1.png) at 2016-03-13 21:39:40 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: No)
    Attachment (pinunpin-cas-3.patch) at 2016-02-29 11:48:25 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (pinunpin-cas-2.patch) at 2016-02-01 10:06:57 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (pinunpin-cas_rebased.patch) at 2016-01-19 10:31:51 from Dilip Kumar <dilipbalaut at gmail.com> (Patch: Yes)
    Attachment (ibm-scalability.png) at 2015-12-08 09:53:49 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: No)
    Attachment (pinunpin_readonly.png) at 2015-11-10 17:03:11 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: No)
    Attachment (pinunpin_v2.png) at 2015-11-09 16:54:59 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: No)
    Attachment (pinunpin.png) at 2015-11-06 20:31:37 from Jesper Pedersen <jesper.pedersen at redhat.com> (Patch: No)
    Attachment (pinunpin-comparison.csv) at 2015-10-30 13:28:22 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: No)
    Attachment (pinunpin-cas.patch) at 2015-10-29 17:18:49 from Alexander Korotkov <a.korotkov at postgrespro.ru> (Patch: Yes)
    Attachment (bufferpin.diff) at 2015-09-15 02:06:25 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (atomic_bufmgr_v5.patch) at 2015-09-11 10:23:24 from YUriy Zhuravlev <u.zhuravlev at postgrespro.ru> (Patch: Yes)

History

When	Who	What
2023-06-29 01:29:10	yongquan li (yongquanl)	Removed yongquanl from reviewers
2023-06-29 01:28:57	yongquan li (yongquanl)	Added yongquanl as reviewer
2016-04-11 11:31:05	David Steele (dsteele)	Closed in commitfest 2016-03 with status: Committed
2016-04-07 18:15:24	Robert Haas (rhaas)	New status: Ready for Committer
2016-04-01 08:57:31	Alexander Korotkov (smagen)	New status: Needs review
2016-03-29 15:14:36	David Steele (dsteele)	New status: Waiting on Author
2016-03-16 20:27:20	Andres Freund (andresfreund)	Added andresfreund as committer
2016-02-01 21:35:14	Álvaro Herrera (alvherre)	Closed in commitfest 2016-01 with status: Moved to next CF
2015-12-24 02:56:08	Michael Paquier (michael-kun)	Closed in commitfest 2015-11 with status: Moved to next CF
2015-10-29 17:20:29	Alexander Korotkov (smagen)	Changed authors to Andres Freund (andresfreund), Alexander Korotkov (smagen)
2015-10-29 17:20:13	Alexander Korotkov (smagen)	Attached mail thread 2400449.GjM57CE0Yg@dinodell
2015-10-29 17:20:13	Alexander Korotkov (smagen)	Created patch record

Edit