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 ago)
Latest email 2019-09-22 15:48:07 (5 years 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