Reduce overhead of NOTIFY with many databases

Edit
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 (1 month, 4 weeks ago)
Latest email 2019-09-22 15:48:07 (1 month, 4 weeks 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
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