Precise wait-event timing and tracing
needs reviewLow-overhead core timing, trace capture, coverage analysis, independent observer-effect benchmarks, and related work to expose currently invisible waits.
postgres=# select * from work;
Patch lines.
What is moving, what needs review, what is blocked, and where the durable artifacts live.
5already committed upstreamAlready in Postgres and available to everyone
[merged]transaction_timeoutStop transactions that remain open longer than the configured limit.[merged]bounded psql \watchLet psql users stop \watch automatically after a fixed number of executions.[merged]UUIDv7 generationTurn the original ULID exercise into PostgreSQL's sortable uuidv7() implementation.[merged]MultiXact standby deadlock fixFix MultiXact creation, deadlock, and corruption edge cases on standbys.[merged]COPY file and PROGRAM wait eventsExpose blocking reads and writes for COPY FROM/TO files, pipes, and programs.
open
Log the correct commit-record LSN for DROP TABLE and related destructive operations to make PITR recovery less guessy.
Keep logical slots usable on a standby fed by WAL archives by pausing and safely resuming recovery around conflicts.
Partial materialized-view refresh
needs reviewInspired by the October 29 Hacking Postgres session, viewer Adam Brusselback implemented WHERE support for targeted REFRESH MATERIALIZED VIEW and has continued revising it through review.
Whole-WAL-record compression
blockedCompress or batch larger WAL records, originating in B-tree build experiments.
Custom protocol command tags
explorationNegotiate custom command-completion tags through a _pq_ protocol capability.
Salma El-Sayed’s implementation, mentored by Kirk Wolak, merges sparse siblings and reclaims merged-away tombstone pages without rebuilding the entire index.
pg_dump table-data placeholders
needs reviewKeep loadable slots for excluded table data so replacement data is restored before dependent indexes and constraints.
also supporting
TRACE / wait-event tracing
Dmitry FominDmitry’s pg_wait_tracer and core wait-event timing work, supported here with design sessions, reviews, coverage analysis, and independent benchmarks.
wait-event coverage gaps
Seongjun ShinA proposed GSoC project that continued independently: systematically identify invisible waits and add coverage, starting with blocking writes to server logging destinations.
pg_stat_statements scalability
Quan Hoang Truong + AWS contributorsQuan continued the proposed GSoC work on LWLock contention. In parallel, an AWS-led patch series implements a broader pgstat-based redesign for the same scalability problem.
known blockers
Precise wait-event timing and tracingNeeds more reviewer cycles and benchmark scrutiny in CommitFest.Recovery landmarks for destructive DDLThe corrected PR changes have not yet been posted back to -hackers and CommitFest.Logical decoding from archive-fed standbysCrash-safety and promotion behavior need complete end-to-end coverage before upstream submission.Partial materialized-view refreshThe current patch has acknowledged privilege-escalation and error-cleanup bugs; the next revision has not been posted yet.Whole-WAL-record compressionClosed CommitFest entry is waiting on the author.Custom protocol command tagsNo CommitFest entry and the protocol design needs broader consensus.B-tree bloat removal (page merge)The active prototype still needs concurrency, backward-scan, VACUUM, WAL/recovery, and crash-safety review before CommitFest.pg_dump table-data placeholdersThe first review raised interface questions; the patch needs a revised option design and another version.
other public outcomes
unqualified DML guardspatch proposed · Prototype server-side protection against UPDATE or DELETE without qualification.pg_stat_kcache observer-effect fixpatch proposed · Reduce self-hidden I/O accounting caused by extension locking.whole-WAL-record compressionCommitFest patch · Compress or batch large WAL records, originating in B-tree build work.recovery landmarks for destructive DDLCommitFest patch · Record a useful commit LSN for recovering from DROP TABLE and related operations.ANALYZE steps in dump outputpatch proposed · Preserve or trigger statistics collection during dump and restore workflows.B-tree bloat removal (page merge)patch proposed · Salma El-Sayed’s mentored implementation now covers page merge plus cleanup of merged-away tombstone pages.partial materialized-view refreshCommitFest patch · Adam Brusselback turned the October 29 session’s idea into a REFRESH MATERIALIZED VIEW ... WHERE patch.precise wait-event timing and tracingCommitFest patch · Publish low-overhead timing, trace capture, coverage analysis, and benchmarks.custom protocol command tagspatch proposed · Negotiate command-completion formats through the _pq_ protocol capability.pglz compression experimentpublic experiment · Build and publish an agent-assisted testbed for improving pglz compression.logical decoding from archive-fed standbyspatch series · Pause and safely resume recovery instead of invalidating conflicting logical slots.pg_dump table-data placeholderspatch proposed · Keep loadable slots for excluded table data so replacement data follows the normal restore order.
shipped work lines
MultiXact standby deadlock
shippedFix standby MultiXact creation and deadlock/corruption edge cases.