Reduce overhead of NOTIFY with many databases

Edit

Title

Topic

Performance

Created

2019-06-09 20:29:29

Last modified

2019-09-22 15:46:46 (4 years, 6 months ago)

Latest email

2019-09-22 15:48:07 (4 years, 6 months 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