Commitfest PG19-1 (2025-07-01 – 2025-07-31)
No reviewers My patches My reviews
Status summary: Needs review: 81. Waiting on Author: 22. Ready for Committer: 9. Committed: 131. Moved to next CF: 125. Withdrawn: 14. Returned with Feedback: 6. Total: 388.
Active patches
| Patch | ID | Status | Tags | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | |||||||||||
| DirtyScanshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication | 5151 | Needs review | Bugfix Logical Replication | stable |
10/10
|
+123−8 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Luan Silva (luansilva) | 5 | 2 months ago | |
| Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY | 5160 | Needs review | Bugfix | stable |
10/10
|
+1567−50 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | 5 | 3 months ago | ||
| Fix buffer pinning logic in [SP-]Gist | 5542 | Needs review | Needs rebase! | Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Matthias van de Meent (mmeent), Mihail Nikalayeu (mihailnikalayeu) | 2 | 4 months ago | |||||
| Fix oldest LSN calculation for WAL segments removal when slots are advancing during checkpoint | 5627 | Needs review | Needs rebase! | Vitaly Davydov (vitprof) | 1 | 1 month ago | |||||
| [SP-]GiST IOS visibility bug (was: Why doens't GiST require super-exclusive lock) - backport | 5721 | Needs review | Needs rebase! | Matthias van de Meent (mmeent) | 1 | 4 months ago | |||||
| Fix a race condition in ConditionVariableTimedSleep() | 5736 | Needs review | stable |
10/10
|
+2−0 | Bertrand Drouvot (bertranddrouvot.pg) | 1 | 3 months ago | |||
| Incorrect calculation of path fraction value in MergeAppend | 5742 | Needs review |
10/10
|
+0−0 | Andrei Lepikhov (lepikhov) | 1 | 3 months ago | ||||
| Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly | 5770 | Needs review | stable | Needs rebase! | Vitaly Davydov (vitprof) | Alexander Korotkov (smagen) | Alexander Korotkov (smagen) | 1 | 1 month ago | ||
| Correct reltuples stats after VACUUM FULL and CLUSTER | 5777 | Needs review | stable |
10/10
|
+117−1 | Erik Nordström (enordstr) | 1 | 3 months ago | |||
| Cancel problems of query to pg_stat_statements | 5825 | Needs review |
10/10
|
+22−7 | Roman Khapov (rkhapov) | 1 | 3 months ago | ||||
| Clients | |||||||||||
| psql: Rethinking of \du command | 4738 | Needs review |
10/10
|
+72−126 | Pavel Luzanov (p.luzanov@postgrespro.ru) | David Johnston (polobo), Wen Yi (wenyi) | 7 | 2 months ago | |||
| Code Comments | |||||||||||
| Remove redundant comment regarding RelationBuildRowSecurity in relcache.c | 5739 | Needs review |
10/10
|
+1−4 | Tanzeel Khan (tanzeelk) | Dean Rasheed (deanr) | 1 | 1 month ago | |||
| Documentation | |||||||||||
| Streaming Replication vs Logical | 5296 | Needs review |
10/10
|
+31−22 | Paul Jungwirth (pjungwir) | Robert Treat (xzilla) | 3 | 6 months ago | |||
| Document how to run only specific regress tests | 5333 | Needs review |
10/10
|
+12−0 | Paul Jungwirth (pjungwir) | Robert Treat (xzilla) | 3 | 9 months ago | |||
| DOCS: Make the Server Application docs synopses more consistent | 5647 | Needs review |
10/10
|
+84−24 | Peter Smith (smithpb2250) | 1 | 4 months ago | ||||
| Parallel safety docs for CTEs | 5650 | Needs review |
10/10
|
+1−1 | James Coleman (jcole1989) | 1 | 5 months ago | ||||
| Fix Protocol documentation | 5783 | Needs review | 18 |
10/10
|
+138−84 | Dave Cramer (dcramer) | 1 | 2 weeks ago | |||
| Miscellaneous | |||||||||||
| dsm_registry: Add detach and destroy features | 5654 | Needs review | 19 | Needs rebase! | Sungwoo Chang (swchangdev) | 1 | 2 months ago | ||||
| Silence resource leaks alerts | 5701 | Needs review | 19 |
10/10
|
+3−3 | Ranier Vilela (raniervilela) | 1 | 4 months ago | |||
| Remove HeapTupleheaderSetXmin{Committed,Invalid} functions | 5870 | Needs review | Refactoring Only | 19 |
10/10
|
+0−14 | Andy Fan (andy2) | 1 | 2 months ago | ||
| Monitoring & Control | |||||||||||
| Improve monitoring of shared memory allocations | 5620 | Needs review | 18 | Needs rebase! | Rahila Syed (rahila) | Tomas Vondra (fuzzycz) | 2 | 3 months ago | |||
| Available disk space per tablespace | 5651 | Needs review | 18 |
10/10
|
+171−4 | Christoph Berg (myon) | 1 | 4 months ago | |||
| Add pg_stat_multixact view for multixact membership usage monitoring | 5869 | Needs review | 19 |
0/10
|
+435−4 | Andrew Johnson (andrewjmetronome) | 1 | 2 months ago | |||
| Support for basic ALTER TABLE progress reporting. | 5873 | Needs review | Monitoring |
10/10
|
+83−6 | Jiří Kavalík (jkavalik) | Jian He (stayreal) | 1 | 1 month ago | ||
| Adding wait events statistics | 5880 | Needs review | 19 |
0/10
|
+786−18 | Bertrand Drouvot (bertranddrouvot.pg) | 1 | 1 month ago | |||
| Performance | |||||||||||
| Teach predtest about IS [NOT] <boolean> proofs | 4690 | Needs review |
10/10
|
+1882−129 | James Coleman (jcole1989) | Tom Lane (tgl) | 8 | 1 year ago | |||
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots | 4971 | Needs review | Performance |
10/10
|
+3929−937 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Matthias van de Meent (mmeent) | 6 | 1 month ago | ||
| Limiting overshoot in nbtree SAOP parallel index scans | 5299 | Needs review |
10/10
|
+151−23 | Matthias van de Meent (mmeent) | 4 | 1 month ago | ||||
| Expanding HOT updates for expression and partial indexes | 5556 | Needs review | Performance | 19 |
10/10
|
+2302−140 | Greg Burd (gregburd) | 2 | 1 month ago | ||
| Introduce RWSpin lock and use it in sinvaladt.c and xlogrecovery.c | 5573 | Needs review | 18 |
10/10
|
+217−42 | Yura Sokolov (funny_falcon) | 2 | 1 month ago | |||
| Compress big WAL records | 5621 | Needs review | Needs rebase! | Andrey Borodin (x4m) | 2 | 1 month ago | |||||
| Lock-free XLog Reservation from WAL | 5633 | Needs review |
10/10
|
+532−55 | Yura Sokolov (funny_falcon) | 1 | 4 months ago | ||||
| Prune partitions by ScalarArrayOpExpr with an array parameter (partkey = ANY($1)) | 5656 | Needs review | 19 |
10/10
|
+311−4 | Andrei Lepikhov (lepikhov) | 1 | 4 months ago | |||
| Use CLOCK_MONOTONIC_COARSE for instr_time for explain analyze | 5669 | Needs review | stable |
7/10
|
+23−2 | Jianghua yang (yjhjstz.gmail.com) | 1 | 1 month ago | |||
| Small optimization set tuple block/tableOid once | 5683 | Needs review | 19 |
10/10
|
+40−18 | Ranier Vilela (raniervilela) | 1 | 4 months ago | |||
| New criteria for autovacuum | 5689 | Needs review | 19 | Needs rebase! | Konstantin Knizhnik (knizhnik) | 1 | 4 months ago | ||||
| ZStandard (with dictionaries) compression support for TOAST compression | 5702 | Needs review | 19 | Needs rebase! | Nikhil Kumar Veldanda (nikhilkumarv) | 1 | 1 month ago | ||||
| MergeAppend could consider sorting cheapest child path | 5719 | Needs review | 19 |
5/10
|
+2−2 | Andrei Lepikhov (lepikhov), Alexander Pyhalov (a.pyhalov) | 1 | 4 weeks ago | |||
| Proposal for enabling auto-vectorization for checksum calculations | 5726 | Needs review | 19 |
9/10
|
+357−23 | Matthew Sterrett (matthew.sterrett.intel.com) | 1 | 2 months ago | |||
| Disable parallel query by default | 5751 | Needs review | 18 |
5/10
|
+5−5 | Scott Mead (scott_mead) | 1 | 1 month ago | |||
| Incremental Sort Cost Estimation Instability | 5754 | Needs review | 19 | Needs rebase! | Andrei Lepikhov (lepikhov) | 1 | 2 months ago | ||||
| Optimize shared LWLock acquisition for high-core-count systems | 5784 | Needs review |
10/10
|
+88−16 | Zhiguo Zhou (zhiguozhou) | 1 | 1 month ago | ||||
| Vectorized CRC on Arm64 | 5789 | Needs review |
10/10
|
+271−2 | John Naylor (john.naylor) | 1 | 3 months ago | ||||
| parallel pg_restore: avoid disk seeks when jumping short distance forward | 5809 | Needs review | 19 |
10/10
|
+5−1 | Dimitrios Apostolou (jimis) | Nathan Bossart (bossartn) | 1 | 1 month ago | ||
| Add enable_groupagg GUC parameter to control GroupAggregate usage | 5814 | Needs review | 19 |
5/10
|
+232−1 | Tatsuro Yamada (tatsuro_yamada) | 1 | 2 months ago | |||
| parallel pg_restore: move offset-building phase to before forking | 5817 | Needs review |
10/10
|
+86−6 | Dimitrios Apostolou (jimis) | 1 | 2 months ago | ||||
| Implement "pg_restore --data-only --clean" as a way to skip WAL | 5821 | Needs review |
10/10
|
+187−12 | Dimitrios Apostolou (jimis) | 1 | 1 month ago | ||||
| pg_restore --freeze: issue a COPY FREEZE instead of just COPY | 5826 | Needs review | Needs rebase! | Dimitrios Apostolou (jimis) | Stepan Neretin (snpgg), warda bibi (warda) | 1 | 1 month ago | ||||
| vacuumlazy: Modernize count_nondeletable_pages | 5866 | Needs review | Good First Review |
10/10
|
+60−29 | Matthias van de Meent (mmeent) | 1 | 1 month ago | |||
| Refactoring | |||||||||||
| Clarify FileTag-based unlinking | 5454 | Needs review |
10/10
|
+10−7 | Matthias van de Meent (mmeent) | 3 | 8 months ago | ||||
| Thread-safe getopt() | 5760 | Needs review | 19 |
10/10
|
+268−163 | Heikki Linnakangas (heikki) | 1 | 3 months ago | |||
| Removing BTScanPosUnpinIfPinned idiom from nbtree, simplifying mark/restore support | 5816 | Needs review |
10/10
|
+133−78 | Peter Geoghegan (pgeoghegan) | 1 | 2 months ago | ||||
| Replication & Recovery | |||||||||||
| Extending FK check skipping on replicas to ADD FK and TRUNCATE | 5774 | Needs review |
10/10
|
+97−3 | Hannu Krosing (hannukrosing) | 1 | 1 month ago | ||||
| Security | |||||||||||
| add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl | 4390 | Needs review |
10/10
|
+255−32 | Cary Huang (cary) | Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) | 10 | 2 months ago | |||
| Check for TupleTableSlot nullness before dereferencing | 5662 | Needs review |
10/10
|
+2−1 | Alexander Kuznetsov (kuznetsovam) | 1 | 1 month ago | ||||
| Check for tuplestorestate nullness before dereferencing | 5705 | Needs review |
10/10
|
+1−1 | Alexander Kuznetsov (kuznetsovam) | 1 | 4 months ago | ||||
| Server Features | |||||||||||
| COPY ON_ERROR 'NULL' | 4810 | Needs review |
10/10
|
+247−36 | jian he (universality) | Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), Jim Jones (jimus) | 7 | 1 month ago | |||
| on_error table, saving error info to a table | 4817 | Needs review |
9/10
|
+582−13 | jian he (hellothere) | Nishant Sharma (nishant-at-edb) | 7 | 3 months ago | |||
| Make MultiXactOffset 64-bit type | 5205 | Needs review | 18 | Needs rebase! | Maxim Orlov (m.orlov) | Heikki Linnakangas (heikki) | 5 | 1 month ago | |||
| using index to speedup add not null constraints to a table | 5444 | Needs review | 18 |
10/10
|
+630−5 | Jian He (stayreal) | Tanzeel Khan (tanzeelk) | 3 | 3 months ago | ||
| refactor AlterDomainAddConstraint (alter domain add constraint) | 5455 | Needs review | 18 |
10/10
|
+79−8 | Jian He (stayreal) | Peter Eisentraut (petere) | 3 | 5 months ago | ||
| Warn, and disallow, clear text passwords via SQL | 5597 | Needs review |
10/10
|
+143−4 | Greg Sabino Mullane (greg) | Guillaume Lelarge (gleu) | 2 | 1 month ago | |||
| postgres_fdw: Inherit the local transaction's access/deferrable modes | 5624 | Needs review |
10/10
|
+347−8 | Etsuro Fujita (efujita) | Etsuro Fujita (efujita) | 1 | 2 months ago | |||
| Allow table AMs to define their own reloptions | 5631 | Needs review | stable |
7/10
|
+1234−35 | Julien Tachoires (julmon) | 1 | 3 months ago | |||
| support fast default for domain with constraints | 5641 | Needs review |
10/10
|
+217−16 | Jian He (stayreal) | 1 | 2 months ago | ||||
| support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint | 5645 | Needs review |
10/10
|
+48−27 | Jian He (stayreal) | 1 | 1 month ago | ||||
| support create index on virtual generated column. | 5667 | Needs review |
10/10
|
+916−73 | Jian He (stayreal) | 1 | 1 month ago | ||||
| Patch for migration of the pg_commit_ts directory | 5710 | Needs review |
10/10
|
+28−3 | Sergey Levin (lsv) | 1 | 4 months ago | ||||
| virtual generated column as partition key | 5720 | Needs review | 19 |
10/10
|
+467−139 | Jian He (stayreal) | 1 | 4 months ago | |||
| Introduce some randomness to autovacuum | 5732 | Needs review | 19 |
10/10
|
+76−0 | Zhao Junwang (zhjwpku) | 1 | 3 months ago | |||
| finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it | 5759 | Needs review | 19 |
10/10
|
+281−31 | Jian He (stayreal) | 1 | 3 months ago | |||
| ALTER DOMAIN ADD NOT NULL NOT VALID | 5768 | Needs review | 19 | Needs rebase! | Jian He (stayreal) | 1 | 3 months ago | ||||
| make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated | 5769 | Needs review | 19 |
10/10
|
+18−13 | Jian He (stayreal) | Peter Eisentraut (petere) | 1 | 3 months ago | ||
| Disallow concurrent ALTER DOMAIN and DROP DOMAIN | 5773 | Needs review | 19 |
7/10
|
+126−0 | Jian He (stayreal) | 1 | 3 months ago | |||
| foreign key on virtual generated column | 5782 | Needs review | 19 |
10/10
|
+315−93 | Jian He (stayreal) | 1 | 3 months ago | |||
| alter check constraint enforceability | 5796 | Needs review | 19 |
10/10
|
+346−11 | Jian He (stayreal) | Robert Treat (xzilla) | 1 | 1 month ago | ||
| Carefully exposing information without authentication | 5845 | Needs review | Monitoring | 19 |
9/10
|
+308−0 | Greg Sabino Mullane (greg) | 1 | 2 months ago | ||
| amcheck: support for GiST | 5879 | Needs review |
10/10
|
+1216−147 | Andrey Borodin (x4m) | 1 | 1 month ago | ||||
| array_random | 5881 | Needs review | 19 | Needs rebase! | Jian He (stayreal) | Dean Rasheed (deanr) | 1 | 1 month ago | |||
| SQL Commands | |||||||||||
| Make COPY format extendable: Extract COPY TO format implementations | 4681 | Needs review |
0/10
|
+701−463 | Kouhei Sutou (kou) | Masahiko Sawada (masahikosawada), Zhao Junwang (zhjwpku), Yong Li (yoli) | 8 | 1 month ago | |||
| COPY TO json | 4716 | Needs review | Needs rebase! | Joe Conway (jconway) | Masahiko Sawada (masahikosawada) | Joe Conway (jconway) | 7 | 1 month ago | |||