Optimize LISTEN/NOTIFY

Edit

6078

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v35, Patch count: 2, First patch: +195−1, All patches: +1161−184

Tags

Performance

Created

2025-09-24 20:41:46

Last modified

2026-01-15 19:12:49 (2 months ago)

Latest email

2026-01-15 18:55:35 (2 months ago)

Status

PG19-4 (2026-01-01 – 2026-01-31): Committed

PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF

Target version

Authors

Joel Jacobson (joeljacobson)

Reviewers

Tom Lane (tgl)Become reviewer

Committer

Tom Lane (tgl)

Links

Emails

Optimize LISTEN/NOTIFY: First at 2025-07-12 22:35:21 by "Joel Jacobson" <joel at compiler.org>
Latest at 2026-01-15 18:55:35 by Tom Lane <tgl at sss.pgh.pa.us>
Latest attachment (v35-0001-Improve-LISTEN-NOTIFY-test-coverage.patch) at 2026-01-14 23:09:05 from Tom Lane <tgl at sss.pgh.pa.us>

Attachment (v35-0001-Improve-LISTEN-NOTIFY-test-coverage.patch) at 2026-01-14 23:09:05 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v34.patch) at 2026-01-13 05:46:57 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v33.patch) at 2025-12-28 16:10:24 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v32.patch) at 2025-12-27 12:40:29 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v31.patch) at 2025-12-26 20:12:40 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v30.patch) at 2025-11-23 20:43:34 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v29.patch) at 2025-11-22 21:30:11 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v28.patch) at 2025-11-15 21:53:52 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v27.patch) at 2025-11-13 07:13:28 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v26.patch) at 2025-11-11 16:34:39 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v25.patch) at 2025-11-08 15:04:42 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0003-optimize_listen_notify-v24.txt) at 2025-11-07 18:59:41 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (async-notify-test-5.c) at 2025-11-06 08:33:18 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (async-notify-test-4.c) at 2025-11-05 00:58:23 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (0001-optimize_listen_notify-v22.patch) at 2025-10-28 21:45:57 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v21.patch) at 2025-10-26 23:24:54 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (fix-race.patch) at 2025-10-26 04:11:25 from Chao Li <li.evan.chao at gmail.com> (Patch: Yes)
    Attachment (0001-TAP-test-with-listener-pos-race.patch.nocfbot) at 2025-10-20 16:43:27 from Arseniy Mukhin <arseniy.mukhin.dev at gmail.com> (Patch: Yes)
    Attachment (0002-optimize_listen_notify-v20-alt1-v2.txt) at 2025-10-20 05:12:18 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v20.patch) at 2025-10-19 22:10:34 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v20.patch) at 2025-10-19 22:06:45 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v19.patch) at 2025-10-16 09:39:02 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v18.patch) at 2025-10-15 20:39:14 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (listen-notify-test.patch.nocfbot) at 2025-10-15 11:19:40 from Arseniy Mukhin <arseniy.mukhin.dev at gmail.com> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v17.patch) at 2025-10-15 03:22:59 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v16.patch) at 2025-10-14 16:40:11 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v15.patch) at 2025-10-11 07:43:22 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v14.patch) at 2025-10-11 06:43:51 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v13.patch) at 2025-10-10 18:46:04 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v12.patch) at 2025-10-08 14:31:24 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (optimize_listen_notify-v11.patch) at 2025-10-07 19:26:31 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (optimize_listen_notify-v10.patch) at 2025-10-07 17:28:22 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (optimize_listen_notify-v9.patch) at 2025-10-07 05:39:08 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (optimize_listen_notify-v8.patch) at 2025-10-06 20:22:05 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (optimize_listen_notify-v7.patch) at 2025-10-06 20:11:21 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (optimize_listen_notify-v6.patch) at 2025-10-01 05:47:27 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (optimize_listen_notify-v5.patch) at 2025-09-30 18:56:11 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-LISTEN-NOTIFY-make-the-latency-throughput-trade-off-v2.patch) at 2025-09-25 21:13:31 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-LISTEN-NOTIFY-make-the-latency-throughput-trade-off-.patch) at 2025-09-24 20:34:49 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (listen_notify_pgbench_perf.md) at 2025-08-07 00:16:05 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (pgbench-script.txt) at 2025-07-24 21:03:27 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (0001-Optimize-NOTIFY-signaling-to-avoid-redundant-backend.patch) at 2025-07-23 01:39:30 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v4.patch) at 2025-07-17 07:43:20 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-optimize_listen_notify-v3.patch) at 2025-07-15 21:50:42 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (0001-Subject-Optimize-LISTEN-NOTIFY-signaling-for-scalabi-v3.patch) at 2025-07-15 20:56:57 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)
    Attachment (pgbench_results_combined.csv) at 2025-07-15 07:20:58 from "Joel Jacobson" <joel at compiler.org> (Patch: No)
    Attachment (0001-Optimize-LISTEN-NOTIFY-signaling-for-single-listener.patch) at 2025-07-12 22:35:21 from "Joel Jacobson" <joel at compiler.org> (Patch: Yes)

History

When	Who	What
2026-01-15 19:12:49	Tom Lane (tgl)	Closed in commitfest PG19-4 with status: Committed
2026-01-15 19:12:49	Tom Lane (tgl)	Changed committer to tgl
2026-01-14 23:10:55	Tom Lane (tgl)	New status: Ready for Committer
2025-12-07 20:42:13	Tom Lane (tgl)	Moved from CF PG19-3 to CF PG19-4
2025-10-26 23:37:25	CFbot	Patch does not need rebase anymore
2025-10-26 04:43:25	CFbot	Patch needs rebase
2025-10-07 16:41:58	Tom Lane (tgl)	Added tgl as reviewer
2025-09-24 20:41:47	Joel Jacobson (joeljacobson)	Attached mail thread 6899c044-4a82-49be-8117-e6f669765f7e@app.fastmail.com
2025-09-24 20:41:46	Joel Jacobson (joeljacobson)	Created patch record

Edit

Open statuses

Closed statuses

Move to

Open statuses

Closed statuses

Move to

Flag as committed

Attach thread

Add annotation