Commitfest 2023-11 (2023-11-01 - 2023-12-04)
Status summary: Committed: 86. Moved to next CF: 235. Withdrawn: 14. Returned with Feedback: 9. Rejected: 3. Total: 347.
Closed patches
| Patch | ID | Status | Tags | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | |||||||||||
| Fix assertion failure in SnapBuildInitialSnapshot() | 4149 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada) | 5 | 1 year ago | |||||
| stopgap fix for signal handling during restore_command | 4159 | Committed | stable | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 4 | 1 year ago | |||
| pg_get_indexdef modification to access catalog based on the TxnSnapshot | 4369 | Moved to different CF | Not processed | vigneshwaran C (vignesh.postgres) | 4 | 1 year ago | |||||
| Allow SIGINT to cancel psql database reconnections | 4474 | Moved to different CF | Not processed | Tristan Partin (tristan957) | Robert Haas (rhaas) | 4 | 1 year ago | ||||
| Fix bogus Asserts in calc_non_nestloop_required_outer | 4478 | Moved to different CF | Not processed | Richard Guo (richardguo) | Tom Lane (tgl) | 3 | 1 year ago | ||||
| Archive current timeline history file on archiver startup if needed | 4502 | Moved to different CF | Not processed | Jimmy Yih (jyih) | 3 | 1 year ago | |||||
| Unlogged relation copy is not fsync'd | 4517 | Moved to different CF | Not processed | Heikki Linnakangas (heikki) | 3 | 1 year ago | |||||
| Fix incorrect memory access in ExecBRUpdateTriggers() | 4576 | Moved to different CF | Not processed | Alexander Lakhin (law) | Tom Lane (tgl) | 2 | 1 year ago | ||||
| Bug fix in vacuumdb --buffer-usage-limit xxx -Z | 4577 | Committed | Not processed | Ryoga Yoshida (bt23yoshidar) | David Rowley (davidrowley) | 1 | 1 year ago | ||||
| Doesn't pgstat_report_wal() handle the argument "force" incorrectly | 4580 | Committed | Not processed | Ryoga Yoshida (bt23yoshidar) | Michael Paquier (michael-kun) | 1 | 1 year ago | ||||
| BUG #18129: GiST index produces incorrect query results | 4584 | Committed | stable | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 1 | 1 year ago | |||
| Fix pgBufferUsage.blk_{read|write}_time are zero although there are pgBufferUsage.local_blks_{read|written} | 4586 | Committed | Not processed | Nazir Bilal Yavuz (nbyavuz) | Michael Paquier (michael-kun) | 1 | 1 year ago | ||||
| Incorrect handling of OOM in WAL replay leading to data loss | 4590 | Withdrawn | 17 | Not processed | Michael Paquier (michael-kun) | 1 | 1 year ago | ||||
| Fail hard if xlogreader.c fails on out-of-memory | 4591 | Committed | stable | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| pg_stat_get_activity(): integer overflow due to (int) * (int) for MemoryContextAllocHuge() | 4592 | Committed | 17 | Not processed | Jakub Wartak (jakub.wartak.tomtom) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| Fix receiving large legal tsvector from binary format | 4596 | Committed | Not processed | Tom Lane (tgl) | 1 | 1 year ago | |||||
| Defend against encoding ID version skew between libpq.so and callers | 4600 | Committed | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 1 year ago | ||||
| Defend against encoding ID version skew | 4601 | Withdrawn | Not processed | Tom Lane (tgl) | 1 | 1 year ago | |||||
| Avoid using SearchSysCacheExists in has_foo_privilege() functions | 4611 | Committed | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 1 year ago | ||||
| Fix incorrect asserts in heap_update/heap_delete | 4623 | Committed | Not processed | Alexander Lakhin (law) | Heikki Linnakangas (heikki) | 1 | 1 year ago | ||||
| Recovering from detoast-related catcache invalidations | 4630 | Moved to different CF | stable | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 1 year ago | |||
| Clients | |||||||||||
| Add new protocol message to make GUC_REPORT configurable and use it for psql prompt substitution of %N with the current user | 4166 | Moved to different CF | Not processed | Pavel Stehule (okbobcz) | 5 | 1 year ago | |||||
| Simplify sql query cancellation test using IPC::Run signal() | 4552 | Committed | Not processed | Yugo Nagata (yugo.nagata) | Michael Paquier (michael-kun) | 1 | 1 year ago | ||||
| Tab completion for ATTACH PARTITION | 4561 | Moved to different CF | Not processed | Tung Nguyen (tngngn) | 2 | 1 year ago | |||||
| make psql backslash commands honor "\pset null" | 4603 | Withdrawn | 17 | Not processed | Laurenz Albe (laurenz) | 1 | 1 year ago | ||||
| Code Comments | |||||||||||
| Fix GIST readme on LSN vs NSN | 4569 | Committed | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 1 | 1 year ago | ||||
| Documentation | |||||||||||
| Correct the documentation for work_mem | 4300 | Committed | 16 | Not processed | Sami Imseih (simseih) | Bruce Momjian (bmomjian) | 3 | 1 year ago | |||
| Clarify where the severity level is defined | 4582 | Committed | Not processed | Masaki Kuwamura (mackyson) | Daniel Gustafsson (d_gustafsson) | 1 | 1 year ago | ||||
| PGDOCS - inconsistent linkends to "monitoring" views | 4602 | Rejected | Not processed | Peter Smith (smithpb2250) | 1 | 1 year ago | |||||
| Simplify documentation of unnest(multirange) | 4631 | Committed | stable | Not processed | Laurenz Albe (laurenz) | Jeff Davis (jdavis) | 1 | 1 year ago | |||
| Generate Doxygen documentation | 4641 | Moved to different CF | Not processed | John Morris (coyotebush) | 2 | 1 year ago | |||||
| Miscellaneous | |||||||||||
| get_extension_version | 4242 | Returned with feedback | Not processed | Pavel Stehule (okbobcz) | 3 | 2 years ago | |||||
| vector search support | 4292 | Returned with feedback | 17 | Not processed | Nathan Bossart (bossartn) | 3 | 2 years ago | ||||
| Unlinking Parallel Hash Join inner batch files sooner | 4314 | Moved to different CF | Not processed | Thomas Munro (macdice) | 9 | 8 months ago | |||||
| Remove distprep | 4357 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 3 | 1 year ago | ||||
| add timing information to pg_upgrade | 4464 | Withdrawn | 17 | Not processed | Nathan Bossart (bossartn) | 2 | 1 year ago | ||||
| Clean up some signal usage mainly related to Windows | 4475 | Moved to different CF | Not processed | Tristan Partin (tristan957) | Nathan Bossart (bossartn) | 3 | 1 year ago | ||||
| Add pg_wait_for_lockers() function | 4480 | Moved to different CF | Not processed | Will Mortensen (will-extrahop) | 5 | 11 months ago | |||||
| Make documentation builds reproducible | 4530 | Moved to different CF | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 3 | 1 year ago | ||||
| Reduce size of postgres.bki | 4544 | Moved to different CF | Not processed | Matthias van de Meent (mmeent) | 4 | 1 year ago | |||||
| Make the am_xxx function Asserts consistent | 4570 | Moved to different CF | 17 | Not processed | Peter Smith (smithpb2250) | 2 | 1 year ago | ||||
| Switch logtape and tuplesort to use int64 instead of long | 4579 | Withdrawn | 17 | Not processed | Michael Paquier (michael-kun) | 1 | 1 year ago | ||||
| Change logtape/tuplestore code to use int64 for block numbers | 4589 | Committed | 17 | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| Add a new BGWORKER_BYPASS_ROLELOGINCHECK flag | 4594 | Committed | 17 | Not processed | Bertrand Drouvot (bertranddrouvot.pg) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| Monitoring & Control | |||||||||||
| Fix inconsistency in reporting checkpointer stats | 4078 | Moved to different CF | Not processed | Nitin Jadhav (nitinjadhav11) | 6 | 9 months ago | |||||
| Rethink the wait event names for postgres_fdw, dblink and etc | 4506 | Committed | Not processed | Masahiro Ikeda (masahiro.ikeda) | Michael Paquier (michael-kun) | 2 | 1 year ago | ||||
| Revised tracking of memory use | 4537 | Returned with feedback | 17 | Not processed | Reid Thompson (jreidthompson), John Morris (coyotebush) | 2 | 1 year ago | ||||
| Jumble the CALL command in pg_stat_statements | 4560 | Committed | 17 | Not processed | Sami Imseih (simseih) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| Performance | |||||||||||
| More scalable multixacts buffers and locking | 2627 | Moved to different CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | Álvaro Herrera (alvherre) | 20 | 1 year ago | ||||
| nbtree performance improvements through specialization on key shape | 3672 | Moved to different CF | Not processed | Matthias van de Meent (mmeent) | 14 | 7 months ago | |||||
| Improve dead tuple storage for lazy vacuum | 3687 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada), John Naylor (john.naylor) | Masahiko Sawada (masahikosawada) | 10 | 1 year ago | ||||
| asynchronous execution support for Custom Scan | 3813 | Moved to different CF | Not processed | KaiGai Kohei (kaigai), kazutaka onishi (onishi) | 8 | 1 year ago | |||||
| Prefetch the next tuple's memory during seqscans | 3978 | Moved to different CF | Not processed | David Rowley (davidrowley), Thomas Munro (macdice) | 7 | 1 year ago | |||||
| Lockless queue of waiters based on atomic operations for LWLock | 3983 | Moved to different CF | Not processed | Alexander Korotkov (smagen), Pavel Borisov (pborisov) | 7 | 1 year ago | |||||
| Partial aggregates push down | 4019 | Moved to different CF | Not processed | Yuki Fujii (fujiiyuki) | 6 | 10 months ago | |||||
| Index Prefetching | 4351 | Moved to different CF |
7/7
|
+4395−192 | Tomas Vondra (fuzzycz) | 11 | 2 months ago | ||||
| XLog size reductions: Reduced XLog record header size | 4386 | Moved to different CF | Not processed | Matthias van de Meent (mmeent) | 6 | 1 year ago | |||||
| Use ReadRecentBuffer() for btree root page | 4419 | Moved to different CF | Not processed | Thomas Munro (macdice) | 7 | 1 year ago | |||||
| Optimise index range scan by performing first check with upper page boundary | 4434 | Committed | 17 | Not processed | Konstantin Knizhnik (knizhnik) | Alexander Korotkov (smagen) | 3 | 1 year ago | |||
| Ignore is not null quals on not null columns | 4459 | Moved to different CF | Not processed | David Rowley (davidrowley), Richard Guo (richardguo) | David Rowley (davidrowley) | 3 | 1 year ago | ||||
| Allow parallel plan for referential integrity checks | 4507 | Moved to different CF | 17 | Not processed | Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com), Frédéric Yhuel (yhuelf) | 3 | 1 year ago | ||||
| Eliminate redundant tuple visibility check in vacuum | 4540 | Committed | Not processed | Melanie Plageman (melanieplageman) | Robert Haas (rhaas) | 2 | 1 year ago | ||||
| GROUP BY optimization | 4562 | Moved to different CF | Not processed | Fedor Sigaev (sigaev), Tomas Vondra (fuzzycz), Andrei Lepikhov (lepikhov) | Alexander Korotkov (smagen) | 2 | 1 year ago | ||||
| Reducing memory consumed by RestrictInfo list translations in partitionwise join planning | 4564 | Moved to different CF |
7/7
|
+389−77 | Ashutosh Bapat (ashutoshbapat) | Amit Langote (amitlan) | 8 | 2 months ago | |||
| Check each of base restriction clauses for constant-FALSE-or-NULL | 4605 | Committed | Not processed | Richard Guo (richardguo) | Tom Lane (tgl) | 1 | 1 year ago | ||||
| Fix a performance issue with Memoize | 4621 | Moved to different CF | Not processed | Richard Guo (richardguo) | David Rowley (davidrowley) | 2 | 1 year ago | ||||
| Index Insert Prefetching | 4622 | Moved to different CF | Not processed | Tomas Vondra (fuzzycz) | 4 | 1 year ago | |||||
| SLRU optimizations | 4626 | Moved to different CF | Not processed | Dilip Kumar (dilip.kumar), Andrey Borodin (x4m) | Álvaro Herrera (alvherre) | 3 | 1 year ago | ||||
| nbtree: implement dynamic prefix truncation | 4635 | Moved to different CF | Not processed | Matthias van de Meent (mmeent) | 7 | 7 months ago | |||||
| nbtree: downlink right separator/HIKEY optimization | 4638 | Moved to different CF | Not processed | Matthias van de Meent (mmeent) | 7 | 1 year ago | |||||
| Refactoring | |||||||||||
| SetLatches() | 3998 | Moved to different CF | Not processed | Thomas Munro (macdice) | 12 | 7 months ago | |||||
| Rework LogicalOutputPluginWriterUpdateProgress | 4004 | Moved to different CF | Not processed | wei wang (wangwei) | 6 | 1 year ago | |||||
| Use AF_UNIX for tests on Windows (ie drop fallback TCP code) | 4033 | Moved to different CF | Not processed | Thomas Munro (macdice) | 6 | 1 year ago | |||||
| Some revises in adding sorting path | 4119 | Moved to different CF | Not processed | Richard Guo (richardguo) | David Rowley (davidrowley) | 5 | 1 year ago | ||||
| New [relation] options engine | 4160 | Returned with feedback | Not processed | Nikolay Shaplov (nataraj) | 4 | 3 months ago | |||||
| some namespace.c refactoring | 4212 | Moved to different CF | Not processed | Peter Eisentraut (petere) | 5 | 1 year ago | |||||
| LLVM 16 and 17 | 4325 | Committed | Not processed | Dmitry Dolgov (erthalion), Thomas Munro (macdice) | Thomas Munro (macdice) | 3 | 1 year ago | ||||
| Refactor fork+exec code | 4376 | Moved to different CF | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 5 | 11 months ago | ||||
| Unified file access using virtual file descriptors | 4420 | Moved to different CF | 17 | Not processed | John Morris (coyotebush) | 4 | 1 year ago | ||||
| Revises for the check of parameterized partial paths | 4425 | Moved to different CF | Not processed | Richard Guo (richardguo) | Richard Guo (richardguo) | 6 | 11 months ago | ||||
| Refactor ListenSockets array | 4525 | Committed | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 2 | 11 months ago | ||||
| Remove IndexInfo.ii_OpclassOptions field | 4527 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 1 year ago | ||||
| Remove unnecessary 'always:' from CompilerWarnings task | 4550 | Withdrawn | Not processed | Nazir Bilal Yavuz (nbyavuz) | 1 | 1 year ago | |||||
| Relation bulk write facility | 4575 | Moved to different CF | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 3 | 1 year ago | ||||
| Retire has_multiple_baserels() | 4610 | Committed | Not processed | Richard Guo (richardguo) | Tom Lane (tgl) | 1 | 1 year ago | ||||
| always use runtime checks for CRC-32C instructions | 4634 | Withdrawn | 17 | Not processed | Nathan Bossart (bossartn), xiang gao (xiang.gao) | 1 | 1 year ago | ||||
| Set minimum LLVM version to 10 | 4640 | Moved to different CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 2 | 1 year ago | ||||
| Replication & Recovery | |||||||||||
| Add log messages when replication slots become active and inactive | 3492 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila) | 10 | 1 year ago | ||||
| pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory | 3503 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | 11 | 1 year ago | |||||
| Optimize walsender handling invalid messages of 'drop publication' | 4393 | Withdrawn | 13 | Not processed | Bowen Shi (zxwsbg) | 3 | 2 years ago | ||||
| Skip collecting decoded changes of already-aborted transactions | 4436 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada) | 3 | 3 months ago | |||||
| logicalrep_worker_launch - counting/checking the type limits | 4499 | Moved to different CF | Not processed | Peter Smith (smithpb2250) | 4 | 1 year ago | |||||
| Force the old transactions logs cleanup even if checkpoint is skipped | 4619 | Moved to different CF | Not processed | Daniil Zakhlystov (daniil.zakhlystov) | 4 | 1 year ago | |||||
| speed up a logical replication setup (pg_subscriber) | 4636 | Withdrawn | Not processed | 1 | 1 year ago | ||||||
| Security | |||||||||||
| USAGE privilege on PUBLICATION | 3641 | Moved to different CF | Not processed | Antonin Houska (a.houska) | 9 | 2 years ago | |||||
| User functions for building SCRAM secrets | 3988 | Moved to different CF | Not processed | Jonathan Katz (jkatz05) | 7 | 1 year ago | |||||
| Server Features | |||||||||||
| Update relfrozenxmin when truncating temp tables | 3358 | Moved to different CF | 16 | Not processed | Greg Stark (stark) | 12 | 1 year ago | ||||
| Add the ability to limit the amount of memory that can be allocated to backends. | 3867 | Moved to different CF | Not processed | Reid Thompson (jreidthompsoncd), John Morris (coyotebush) | 11 | 1 year ago | |||||
| Multi-version ICU | 3956 | Moved to different CF | Not processed | Thomas Munro (macdice) | 10 | 1 year ago | |||||
| Post-special Page Storage TDE support (aka Reserved Page Size) | 3986 | Moved to different CF | Not processed | David Christensen (davidchristensen) | 12 | 6 months ago | |||||
| ltree hash functions | 4375 | Moved to different CF | Not processed | Tommy Pavlicek (tommyp) | Tom Lane (tgl) | 5 | 1 year ago | ||||
| Variable Block Size | 4429 | Moved to different CF | 17 | Not processed | David Christensen (davidchristensen) | 4 | 1 year ago | ||||
| pg_stat_logmsg | 4431 | Moved to different CF | Not processed | Joe Conway (jconway) | 7 | 11 months ago | |||||
| Multiple passwords, interval expirations | 4432 | Moved to different CF | Not processed | Gurjeet Singh (gurjeet), Joshua Brindle (joshuab) | 4 | 1 year ago | |||||
| CREATE FUNCTION ... SEARCH { DEFAULT | SYSTEM | SESSION } | 4497 | Withdrawn | 17 | Not processed | Jeff Davis (jdavis) | 2 | 1 year ago | ||||
| Support run-time partition pruning for hash join | 4512 | Moved to different CF | 17 | Not processed | Richard Guo (richardguo) | 6 | 9 months ago | ||||
| Add inline comments to the pg_hba_file_rules view | 4546 | Withdrawn | 17 | Not processed | Jim Jones (jimus) | 1 | 1 year ago | ||||
| Unicode character general category functions. | 4604 | Committed | 17 | Not processed | Jeff Davis (jdavis) | Jeff Davis (jdavis) | 1 | 6 months ago | |||
| Add unicode_assigned() and unicode_version() | 4615 | Committed | 17 | Not processed | Jeff Davis (jdavis) | Jeff Davis (jdavis) | 1 | 6 months ago | |||
| Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING | 4617 | Moved to different CF | Not processed | Marko Tiikkaja (johto) | 5 | 9 months ago | |||||
| SQL Commands | |||||||||||
| Dynamic result sets from procedures | 2911 | Withdrawn | Not processed | Peter Eisentraut (petere) | 12 | 2 years ago | |||||
| Incremental View Maintenance (IVM), take 2 | 4337 | Moved to different CF | Needs rebase! | Yugo Nagata (yugo.nagata) | 11 | 10 months ago | |||||
| Remaining sql/json patches | 4377 | Moved to different CF | Not processed | Amit Langote (amitlan), Nikita Glukhov (n.glukhov) | Amit Langote (amitlan) | 5 | 1 year ago | ||||
| [PoC] Implementation of distinct in Window Aggregates: take two | 4519 | Moved to different CF | Not processed | Ankit Kumar Pandey (ankitkpandey) | 3 | 1 year ago | |||||
| Output affected rows in EXPLAIN | 4551 | Rejected | 17 | Not processed | Damir Belyalov (xhevx) | 1 | 1 year ago | ||||
| System Administration | |||||||||||
| recovery modules | 4082 | Moved to different CF | 18 | Not processed | Nathan Bossart (bossartn) | 8 | 11 months ago | ||||
| Testing | |||||||||||
| CI and test improvements | 3709 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby) | 14 | 7 months ago | |||||
| Testing autovacuum wraparound | 3729 | Committed | Not processed | Andres Freund (andresfreund), Masahiko Sawada (masahikosawada) | Masahiko Sawada (masahikosawada) | 8 | 1 year ago | ||||
| Add TAP tests for psql \g piped into program | 4101 | Committed | Not processed | Daniel Vérité (danielverite) | Heikki Linnakangas (heikki) | 5 | 1 year ago | ||||
| Detect test suite sideeffects in pg_regress | 4321 | Moved to different CF | Not processed | Daniel Gustafsson (d_gustafsson) | 5 | 1 year ago | |||||
| Use libpq for connection testing in pg_regress | 4528 | Committed | Not processed | Daniel Gustafsson (d_gustafsson) | Daniel Gustafsson (d_gustafsson) | 2 | 1 year ago | ||||
| Build the docs if there are changes in docs and don't run other tasks if the changes are only in docs | 4555 | Moved to different CF | Not processed | Nazir Bilal Yavuz (nbyavuz) | 4 | 1 year ago | |||||
| Add test module for Table Access Method | 4588 | Moved to different CF | Not processed | Fabrízio Mello (fabriziomello) | 2 | 1 year ago | |||||
| Clean up some pg_dump tests | 4607 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 1 year ago | ||||