Reduce overhead of NOTIFY with many databases

Edit

ID 2142

Title Reduce overhead of NOTIFY with many databases

Topic Performance

Created 2019-06-09 20:29:29

Last modified 2019-09-22 15:46:46 (5 years, 1 month ago)

Latest email 2019-09-22 15:48:07 (5 years, 1 month ago)

Status

2019-09: Committed

2019-07: Moved to next CF

Target version

Authors Martijn van Oosterhout (martijnvoosterhout)

Reviewers Tom Lane (tgl)Become reviewer

Committer Tom Lane (tgl)

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

Emails

[PATCH] Improve performance of NOTIFY over many databases (issue blocking on AccessExclusiveLock on object 0 of class 1262 of database 0): First at 2019-06-04 07:08:15 by Martijn van Oosterhout <kleptog at gmail.com>
Latest at 2019-08-01 10:53:34 by Thomas Munro <thomas.munro at gmail.com>
Latest attachment (0003-Quickly-bail-if-queue-tail-can-t-be-moved.patch) at 2019-06-05 16:10:04 from Martijn van Oosterhout <kleptog at gmail.com>
Attachment (0003-Quickly-bail-if-queue-tail-can-t-be-moved.patch) at 2019-06-05 16:10:04 from Martijn van Oosterhout <kleptog at gmail.com> (Patch: Yes)
Attachment (0001-Only-try-advancing-tail-pointer-when-it-s-useful.patch) at 2019-06-04 07:08:15 from Martijn van Oosterhout <kleptog at gmail.com> (Patch: Yes)
[PATCH] Improve performance of NOTIFY over many databases (v2): First at 2019-08-02 15:40:17 by Martijn van Oosterhout <kleptog at gmail.com>
Latest at 2019-09-22 15:48:07 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (Improve-performance-of-async-notifications-v4.patch) at 2019-09-15 22:14:24 from Tom Lane <tgl at sss.pgh.pa.us>
    Attachment (Improve-performance-of-async-notifications-v4.patch) at 2019-09-15 22:14:24 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0002-Improve-performance-of-async-notifications-v3.patch) at 2019-09-14 12:04:25 from Martijn van Oosterhout <kleptog at gmail.com> (Patch: Yes)
    Attachment (0002-Improve-performance-of-async-notifications.patch) at 2019-09-11 14:07:17 from Martijn van Oosterhout <kleptog at gmail.com> (Patch: Yes)
    Attachment (0001-Maintain-queue-of-listening-backends-to-speed-up-loo.patch) at 2019-08-02 15:40:17 from Martijn van Oosterhout <kleptog at gmail.com> (Patch: Yes)

History

When	Who	What
2019-09-22 15:46:46	Tom Lane (tgl)	Closed in commitfest 2019-09 with status: Committed
2019-09-18 15:00:25	Álvaro Herrera (alvherre)	New status: Needs review
2019-09-10 22:19:29	Tom Lane (tgl)	New status: Waiting on Author
2019-09-10 22:19:25	Tom Lane (tgl)	Added tgl as committer
2019-08-02 15:57:10	Martijn van Oosterhout (martijnvoosterhout)	New status: Needs review
2019-08-02 15:56:11	Martijn van Oosterhout (martijnvoosterhout)	Attached mail thread CADWG95vtRBFDdrx1JdT1_9nhOFw48KaeTev6F_LtDQAFVpSPhA@mail.gmail.com
2019-08-01 10:53:10	Thomas Munro (macdice)	New status: Waiting on Author
2019-08-01 10:53:05	Thomas Munro (macdice)	Closed in commitfest 2019-07 with status: Moved to next CF
2019-08-01 10:53:01	Thomas Munro (macdice)	New status: Needs review
2019-07-13 19:15:41	Tom Lane (tgl)	New status: Waiting on Author
2019-07-13 18:36:52	Tom Lane (tgl)	Added tgl as reviewer
2019-06-09 20:30:01	Martijn van Oosterhout (martijnvoosterhout)	Changed authors to Martijn van Oosterhout (martijnvoosterhout)
2019-06-09 20:29:29	Martijn van Oosterhout (martijnvoosterhout)	Attached mail thread CADWG95uFj8rLM52Er80JnhRsTbb_AqPP1ANHS8XQRGbqLrU+jA@mail.gmail.com
2019-06-09 20:29:29	Martijn van Oosterhout (martijnvoosterhout)	Created patch record

Edit