Precise wait-event timing and tracing
needs reviewLow-overhead core timing, trace capture, coverage analysis, independent observer-effect benchmarks, and honest query/plan-node attribution.
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
SQL-queryable server-message counters
needs reviewExpose cumulative server-message counts by backend, database, user, severity, and SQLSTATE without parsing log files.
Faster, safer minor upgrades
explorationReduce shutdown latency and turn binary replacement, release-note remediation, and extension compatibility into a repeatable fleet workflow.
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, benchmark scrutiny, and a clear relationship with the separate EXPLAIN wait-event series.SQL-queryable server-message countersThe new contrib patch needs independent overhead, contention, and cardinality review plus agreement on contrib versus core placement.Faster, safer minor upgradesAdaptive checkpointing and cache handoff are design ideas without bounded benchmarks or a fail-closed compatibility protocol yet.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 patch needs a filter-file-oriented interface revision 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.SQL-queryable server-message countersCommitFest patch · Track cumulative log-message counts by workload dimensions and SQLSTATE without parsing log files.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.