fix spinlock contention in LogwrtResult

Edit

ID 2716

Title fix spinlock contention in LogwrtResult

Topic Performance

Created 2020-08-31 20:55:07

Last modified 2022-09-23 08:50:50 (2 years, 1 month ago)

Latest email 2024-04-08 16:13:22 (7 months, 1 week ago)

Status

2022-09: Withdrawn

2022-07: Moved to next CF

2022-03: Moved to next CF

2022-01: Moved to next CF

2021-11: Moved to next CF

2021-09: Moved to next CF

2021-07: Moved to next CF

2021-03: Moved to next CF

2021-01: Moved to next CF

2020-11: Moved to next CF

2020-09: Moved to next CF

Target version

Authors Álvaro Herrera (alvherre)

Reviewers Become reviewer

Committer

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

Emails

LogwrtResult contended spinlock: First at 2020-08-31 18:21:56 by Alvaro Herrera <alvherre at 2ndquadrant.com>
Latest at 2024-04-08 16:13:22 by Jeff Davis <pgsql at j-davis.com>
Latest attachment (v17-0002-Add-logCopyResult.patch) at 2024-04-05 17:55:32 from Alvaro Herrera <alvherre at alvh.no-ip.org>
    Attachment (v17-0002-Add-logCopyResult.patch) at 2024-04-05 17:55:32 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v16-0001-Make-XLogCtl-log-Write-Flush-Result-accessible-w.patch) at 2024-04-05 11:54:45 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v16-0001-Make-XLogCtl-log-Write-Flush-Result-accessible-w.patch) at 2024-04-04 17:45:04 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v15-0001-split-XLogCtl-LogwrtResult-into-separate-struct-.patch) at 2024-04-03 11:19:40 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v14-0001-Add-monotonic-advancement-functions-for-atomics.patch) at 2024-03-14 07:38:23 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Add-monotonic-advancement-functions-for-atomics.patch) at 2024-03-04 15:45:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-functions-for-monotonic-advancement-of-atomi.patch) at 2024-02-21 14:30:00 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v11j-0001-Make-XLogCtl-LogwrtResult-accessible-with-atomi.patch) at 2024-02-16 20:54:25 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v10-0001-Make-XLogCtl-LogwrtResult-accessible-with-atomic.patch) at 2022-07-28 06:59:20 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v9-0001-Make-XLogCtl-LogwrtResult-accessible-with-atomics.patch) at 2022-04-05 18:16:28 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v8-0001-Split-LogwrtResult-into-separate-variables.patch) at 2022-04-05 15:47:04 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v7-0001-Change-XLogCtl-LogwrtResult-to-use-atomic-ops.patch) at 2022-03-22 16:11:20 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v6-0001-Change-XLogCtl-LogwrtResult-to-use-atomic-ops.patch) at 2022-03-22 13:49:13 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v5-0001-make-LogwrtResult-atomic.patch) at 2021-11-22 21:56:43 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (logwrt-4.patch) at 2021-11-18 22:15:58 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-add-pg_atomic_monotonic_advance_u64.patch) at 2021-02-02 23:19:19 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (v2-0001-add-pg_atomic_monotonic_advance_u64.patch) at 2021-01-30 01:47:56 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (0001-use-an-LWLock-rather-than-spinlock-for-Logwrt-Result.patch) at 2020-08-31 18:21:56 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)

History

When	Who	What
2022-09-23 08:50:50	Álvaro Herrera (alvherre)	Closed in commitfest 2022-09 with status: Withdrawn
2022-07-28 07:04:19	Álvaro Herrera (alvherre)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-06-29 21:32:42	Jacob Champion (jchampion)	Closed in commitfest 2022-03 with status: Moved to next CF
2022-03-22 13:49:45	Álvaro Herrera (alvherre)	New status: Ready for Committer
2022-03-22 01:11:15	Andres Freund (andresfreund)	New status: Waiting on Author
2022-02-02 16:29:56	Julien Rouhaud (rjuju)	Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-02 11:08:17	Daniel Gustafsson (d_gustafsson)	Closed in commitfest 2021-11 with status: Moved to next CF
2021-12-02 11:08:12	Daniel Gustafsson (d_gustafsson)	New status: Needs review
2021-10-02 06:09:17	Jaime Casanova (jcasanov)	New status: Waiting on Author
2021-10-02 06:09:03	Jaime Casanova (jcasanov)	Closed in commitfest 2021-09 with status: Moved to next CF
2021-10-02 06:08:56	Jaime Casanova (jcasanov)	New status: Needs review
2021-08-03 02:43:40	Masahiko Sawada (masahikosawada)	New status: Waiting on Author
2021-08-03 02:42:44	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-07 with status: Moved to next CF
2021-08-03 02:42:41	Masahiko Sawada (masahikosawada)	New status: Needs review
2021-04-08 14:41:53	David Steele (dsteele)	New status: Waiting on Author
2021-04-08 14:41:39	David Steele (dsteele)	Closed in commitfest 2021-03 with status: Moved to next CF
2021-04-08 14:41:34	David Steele (dsteele)	New status: Needs review
2021-02-01 13:09:57	Masahiko Sawada (masahikosawada)	New status: Waiting on Author
2021-02-01 13:09:27	Masahiko Sawada (masahikosawada)	Closed in commitfest 2021-01 with status: Moved to next CF
2021-02-01 13:09:24	Masahiko Sawada (masahikosawada)	New status: Needs review
2020-12-01 14:15:20	Anastasia Lubennikova (lubennikovaav)	New status: Waiting on Author
2020-12-01 14:15:15	Anastasia Lubennikova (lubennikovaav)	Closed in commitfest 2020-11 with status: Moved to next CF
2020-12-01 14:15:11	Anastasia Lubennikova (lubennikovaav)	New status: Needs review
2020-10-23 08:37:39	Heikki Linnakangas (heikki)	New status: Waiting on Author
2020-10-01 04:11:11	Michael Paquier (michael-kun)	Closed in commitfest 2020-09 with status: Moved to next CF
2020-08-31 20:55:14	Álvaro Herrera (alvherre)	Changed authors to Álvaro Herrera (alvherre)
2020-08-31 20:55:07	Álvaro Herrera (alvherre)	Attached mail thread 20200831182156.GA3983@alvherre.pgsql
2020-08-31 20:55:07	Álvaro Herrera (alvherre)	Created patch record

Edit