Commitfest 2024-01
Status summary: Committed: 75. Moved to next CF: 210. Withdrawn: 16. Rejected: 2. Returned with Feedback: 49. Total: 352.
Closed patches
| Patch | ID | Status | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | ||||||||||
| Fix assertion failure in SnapBuildInitialSnapshot() | 4149 | Returned with feedback | Not processed | Masahiko Sawada (masahikosawada) | 5 | 1 year ago | ||||
| pg_get_indexdef modification to access catalog based on the TxnSnapshot | 4369 | Returned with feedback | Not processed | vigneshwaran C (vignesh.postgres) | 4 | 1 year ago | ||||
| Allow SIGINT to cancel psql database reconnections | 4474 | Moved to next CF | Not processed | Tristan Partin (tristan957) | Robert Haas (rhaas) | 4 | 11 months ago | |||
| Fix bogus Asserts in calc_non_nestloop_required_outer | 4478 | Committed | Not processed | Richard Guo (richardguo) | Tom Lane (tgl) | 3 | 1 year ago | |||
| Archive current timeline history file on archiver startup if needed | 4502 | Returned with feedback | Not processed | Jimmy Yih (jyih) | 3 | 1 year ago | ||||
| Unlogged relation copy is not fsync'd | 4517 | Returned with feedback | Not processed | Heikki Linnakangas (heikki) | 3 | 1 year ago | ||||
| Fix incorrect memory access in ExecBRUpdateTriggers() | 4576 | Committed | Not processed | Alexander Lakhin (law) | Tom Lane (tgl) | 2 | 1 year ago | |||
| Recovering from detoast-related catcache invalidations | 4630 | Committed | stable | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 1 year ago | ||
| Fix mismatched nullingrels when inlining functions | 4652 | Committed | stable | Not processed | Richard Guo (richardguo) | Tom Lane (tgl) | 1 | 1 year ago | ||
| typo in fallback implementation for pg_atomic_test_set_flag() | 4659 | Committed | stable | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Fix file descriptor leak on error in async FDW | 4661 | Committed | stable | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 1 | 1 year ago | ||
| simplehash: preserve consistency in case of OOM | 4664 | Committed | 17 | Not processed | Jeff Davis (jdavis) | Jeff Davis (jdavis) | 1 | 1 year ago | ||
| LockAcquireExtended improvement | 4680 | Moved to next CF | 17 | Not processed | Jingxian Li (jingxian) | Robert Haas (rhaas) | 2 | 1 year ago | ||
| Thread-safe gai_strerror() for Windows | 4682 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 2 | 1 year ago | |||
| Forbid the use of invalidated physical slots in streaming replication. | 4686 | Returned with feedback | Not processed | Hou Zhijie (houzj) | 1 | 1 year ago | ||||
| autovacuum may skip tables when session_authorization/role is set on database | 4702 | Returned with feedback | stable | Not processed | Sami Imseih (simseih) | 1 | 1 year ago | |||
| Dump-restore loosing 'attnotnull' bit for DEFERRABLE PRIMARY KEY column(s) | 4729 | Rejected | 17 | Not processed | Amul Sul (sulamul) | 1 | 10 months ago | |||
| Fix 'negative bitmapset member' error | 4732 | Committed | Not processed | Richard Guo (richardguo) | Alexander Korotkov (smagen) | 1 | 1 year ago | |||
| Fix the issue that SJE mistakenly omits qual clauses | 4733 | Committed | Not processed | Richard Guo (richardguo) | Alexander Korotkov (smagen) | 1 | 1 year ago | |||
| Network failure may prevent promotion | 4748 | Moved to next CF |
7/7
|
+52−202 | Kyotaro Horiguchi (horiguti) | 7 | 1 week 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 | Withdrawn | Not processed | Pavel Stehule (okbobcz) | 5 | 1 year ago | ||||
| Tab completion for ATTACH PARTITION | 4561 | Returned with feedback | Not processed | Tung Nguyen (tngngn) | 2 | 1 year ago | ||||
| Call pqPipelineFlush from PQsendFlushRequest | 4651 | Committed | 17 | Not processed | Jelte Fennema-Nio (jeltef) | Álvaro Herrera (alvherre) | 1 | 1 year ago | ||
| pgbench log file headers | 4660 | Moved to next CF | 17 | Not processed | Adam Hendel (adamhendel) | 2 | 11 months ago | |||
| Password leakage avoidance function for libpq | 4719 | Committed | Not processed | Joe Conway (jconway) | Joe Conway (jconway) | 1 | 1 year ago | |||
| Libpq Compression | 4746 | Moved to next CF | Not processed | Jacob Burroughs (maths22) | 3 | 10 months ago | ||||
| Code Comments | ||||||||||
| Fix a comment in basic_archive about NO_INSTALLCHECK | 4706 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| Documentation | ||||||||||
| Generate Doxygen documentation | 4641 | Returned with feedback | Not processed | John Morris (coyotebush) | 2 | 1 year ago | ||||
| Quick Start Guide to PL/pgSQL and PL/Python Documentation | 4705 | Moved to next CF | 17 | Not processed | Ishaan Adarsh (requi3m) | 2 | 1 year ago | |||
| doc patch: note AttributeRelationId passed to FDW validator function | 4730 | Committed | stable | Not processed | Ian Barwick (barwick) | Michael Paquier (michael-kun) | 1 | 1 year ago | ||
| Simplify documentation related to Windows builds | 4745 | Moved to next CF | 17 | Not processed | Michael Paquier (michael-kun) | 3 | 10 months ago | |||
| Miscellaneous | ||||||||||
| Unlinking Parallel Hash Join inner batch files sooner | 4314 | Moved to next CF | Not processed | Thomas Munro (macdice) | 9 | 5 months ago | ||||
| Clean up some signal usage mainly related to Windows | 4475 | Committed | Not processed | Tristan Partin (tristan957) | Nathan Bossart (bossartn) | 3 | 1 year ago | |||
| Add pg_wait_for_lockers() function | 4480 | Moved to next CF | Not processed | Will Mortensen (will-extrahop) | 5 | 8 months ago | ||||
| Make documentation builds reproducible | 4530 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 3 | 1 year ago | |||
| Reduce size of postgres.bki | 4544 | Moved to next CF | Not processed | Matthias van de Meent (mmeent) | 4 | 10 months ago | ||||
| Make the am_xxx function Asserts consistent | 4570 | Withdrawn | 17 | Not processed | Peter Smith (smithpb2250) | 2 | 1 year ago | |||
| common signal handler protection | 4669 | Moved to next CF | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 2 | 1 year ago | ||
| Add code indentation check to cirrus-ci | 4691 | Withdrawn | Not processed | Bharath Rupireddy (bharathrupireddy) | 1 | 1 year ago | ||||
| Set all variable-length fields of pg_attribute to null on column drop | 4701 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 1 year ago | |||
| Add SQL syntax check | 4704 | Moved to next CF | Not processed | Josef Šimánek (retro) | 3 | 10 months ago | ||||
| Making the initial and maximum DSA segment sizes configurable | 4708 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | Masahiko Sawada (masahikosawada) | 2 | 1 year ago | |||
| Tidy fill hstv array (src/backend/access/heap/pruneheap.c) | 4734 | Moved to next CF | 17 | Not processed | Ranier Vilela (raniervilela) | 2 | 1 year ago | |||
| Add Index-level REINDEX with multiple jobs | 4740 | Moved to next CF | 17 | Not processed | Maxim Orlov (m.orlov), Svetlana Derevyanko (getsusun) | Alexander Korotkov (smagen) | 2 | 1 year ago | ||
| Monitoring & Control | ||||||||||
| Fix inconsistency in reporting checkpointer stats | 4078 | Returned with feedback | Not processed | Nitin Jadhav (nitinjadhav11) | 6 | 5 months ago | ||||
| backtrace_on_internal_error | 4696 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 1 year ago | |||
| Performance | ||||||||||
| More scalable multixacts buffers and locking | 2627 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | Álvaro Herrera (alvherre) | 20 | 11 months ago | |||
| nbtree performance improvements through specialization on key shape | 3672 | Moved to next CF | Not processed | Matthias van de Meent (mmeent) | 14 | 4 months ago | ||||
| Improve dead tuple storage for lazy vacuum | 3687 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada), John Naylor (john.naylor) | Masahiko Sawada (masahikosawada) | 10 | 11 months ago | |||
| asynchronous execution support for Custom Scan | 3813 | Returned with feedback | Not processed | KaiGai Kohei (kaigai), kazutaka onishi (onishi) | 8 | 1 year ago | ||||
| Prefetch the next tuple's memory during seqscans | 3978 | Withdrawn | Not processed | David Rowley (davidrowley), Thomas Munro (macdice) | 7 | 1 year ago | ||||
| Lockless queue of waiters based on atomic operations for LWLock | 3983 | Returned with feedback | Not processed | Alexander Korotkov (smagen), Pavel Borisov (pborisov) | 7 | 1 year ago | ||||
| Partial aggregates push down | 4019 | Returned with feedback | Not processed | Yuki Fujii (fujiiyuki) | 6 | 7 months ago | ||||
| Index Prefetching | 4351 | Moved to next CF | Needs rebase! | Tomas Vondra (fuzzycz) | 10 | 4 months ago | ||||
| XLog size reductions: Reduced XLog record header size | 4386 | Moved to next CF | Not processed | Matthias van de Meent (mmeent) | 6 | 9 months ago | ||||
| Use ReadRecentBuffer() for btree root page | 4419 | Moved to next CF | Not processed | Thomas Munro (macdice) | 7 | 1 year ago | ||||
| Ignore is not null quals on not null columns | 4459 | Committed | Not processed | David Rowley (davidrowley), Richard Guo (richardguo) | David Rowley (davidrowley) | 3 | 1 year ago | |||
| Allow parallel plan for referential integrity checks | 4507 | Returned with feedback | 17 | Not processed | Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com), Frédéric Yhuel (yhuelf) | 3 | 1 year ago | |||
| GROUP BY optimization | 4562 | Committed | 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 next CF |
6/7
|
+357−77 | Ashutosh Bapat (ashutoshbapat) | 8 | 10 hours ago | |||
| Fix a performance issue with Memoize | 4621 | Committed | Not processed | Richard Guo (richardguo) | David Rowley (davidrowley) | 2 | 1 year ago | |||
| Index Insert Prefetching | 4622 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | 4 | 1 year ago | ||||
| SLRU optimizations | 4626 | Moved to next CF | Not processed | Dilip Kumar (dilip.kumar), Andrey Borodin (x4m) | Álvaro Herrera (alvherre) | 3 | 11 months ago | |||
| nbtree: implement dynamic prefix truncation | 4635 | Moved to next CF | Not processed | Matthias van de Meent (mmeent) | 7 | 4 months ago | ||||
| nbtree: downlink right separator/HIKEY optimization | 4638 | Moved to next CF | Not processed | Matthias van de Meent (mmeent) | 7 | 1 year ago | ||||
| autovectorize page checksum code included elsewhere | 4649 | Moved to next CF | 18 | Not processed | Nathan Bossart (bossartn) | 3 | 1 year ago | |||
| GUC hashtable optimizations | 4663 | Moved to next CF | 17 | Not processed | Jeff Davis (jdavis), John Naylor (john.naylor) | John Naylor (john.naylor) | 2 | 11 months ago | ||
| Vacuum reaps dead items sooner for index-less tables | 4665 | Committed | Not processed | Melanie Plageman (melanieplageman) | Robert Haas (rhaas) | 1 | 1 year ago | |||
| Don't constrain self join removal due to PHVs | 4668 | Committed | Not processed | Richard Guo (richardguo) | Alexander Korotkov (smagen) | 1 | 1 year ago | |||
| pg_convert improvement | 4673 | Withdrawn | Not processed | 1 | 1 year ago | |||||
| add AVX2 support to simd.h | 4675 | Moved to next CF | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 2 | 1 year ago | ||
| optimized atomic exchanges | 4676 | Committed | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| micro-optimizing json.c | 4687 | Committed | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Adjust tuples estimate for appendrel | 4711 | Moved to next CF | Not processed | Richard Guo (richardguo) | 4 | 1 year ago | ||||
| Avoid computing ORDER BY junk columns unnecessarily | 4717 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | 2 | 1 year ago | ||||
| An improvement on parallel DISTINCT | 4724 | Moved to next CF | Not processed | Richard Guo (richardguo) | David Rowley (davidrowley) | 2 | 1 year ago | |||
| Not to invalidate CatalogSnapshot for local invalidation messages | 4739 | Moved to next CF | Not processed | Xiaoran Wang (fanfuxiaoran) | 2 | 1 year ago | ||||
| Make vacuum opportunistic freezing adaptive | 4756 | Moved to next CF | Not processed | Melanie Plageman (melanieplageman) | 2 | 1 year ago | ||||
| shared detoast datum | 4759 | Moved to next CF | Not processed | Andy Fan (andy2) | 6 | 9 months ago | ||||
| Refactoring | ||||||||||
| SetLatches() | 3998 | Moved to next CF | Not processed | Thomas Munro (macdice) | 12 | 4 months ago | ||||
| Rework LogicalOutputPluginWriterUpdateProgress | 4004 | Returned with feedback | Not processed | wei wang (wangwei) | 6 | 1 year ago | ||||
| Use AF_UNIX for tests on Windows (ie drop fallback TCP code) | 4033 | Returned with feedback | Not processed | Thomas Munro (macdice) | 6 | 1 year ago | ||||
| Some revises in adding sorting path | 4119 | Committed | Not processed | Richard Guo (richardguo) | David Rowley (davidrowley) | 5 | 1 year ago | |||
| some namespace.c refactoring | 4212 | Returned with feedback | Not processed | Peter Eisentraut (petere) | 5 | 1 year ago | ||||
| Refactor fork+exec code | 4376 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 5 | 8 months ago | |||
| Unified file access using virtual file descriptors | 4420 | Returned with feedback | 17 | Not processed | John Morris (coyotebush) | 4 | 1 year ago | |||
| Revises for the check of parameterized partial paths | 4425 | Moved to next CF | Not processed | Richard Guo (richardguo) | Richard Guo (richardguo) | 6 | 7 months ago | |||
| Relation bulk write facility | 4575 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | Heikki Linnakangas (heikki) | 3 | 1 year ago | |||
| Set minimum LLVM version to 10 | 4640 | Committed | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 2 | 1 year ago | |||
| retire MemoryContextResetAndDeleteChildren backwards compatibility macro | 4657 | Committed | 17 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| New [relation] options engine | 4688 | Moved to next CF | Needs rebase! | Nikolay Shaplov (nataraj) | 7 | 1 week ago | ||||
| Move walreceiver state assignment (to WALRCV_STREAMING) in WalReceiverMain() | 4698 | Withdrawn | 17 | Not processed | Bertrand Drouvot (bertranddrouvot.pg) | 1 | 1 year ago | |||
| Revise the Asserts added to bimapset manipulation functions | 4731 | Committed | Not processed | Richard Guo (richardguo) | David Rowley (davidrowley) | 1 | 1 year ago | |||
| Replication & Recovery | ||||||||||
| pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory | 3503 | Returned with feedback | Not processed | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | 11 | 1 year ago | ||||
| Skip collecting decoded changes of already-aborted transactions | 4436 | Returned with feedback | Not processed | Masahiko Sawada (masahikosawada) | 3 | 1 week ago | ||||
| logicalrep_worker_launch - counting/checking the type limits | 4499 | Moved to next CF | Not processed | Peter Smith (smithpb2250) | 4 | 11 months ago | ||||
| Force the old transactions logs cleanup even if checkpoint is skipped | 4619 | Moved to next CF | Not processed | Daniil Zakhlystov (daniil.zakhlystov) | 4 | 1 year ago | ||||
| incremental backup | 4648 | Committed | 17 | Not processed | Robert Haas (rhaas) | Robert Haas (rhaas) | 1 | 1 year ago | ||
| Lockless exit path for ReplicationOriginExitCleanup | 4692 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Álvaro Herrera (alvherre) | 1 | 1 year ago | |||
| Security | ||||||||||
| USAGE privilege on PUBLICATION | 3641 | Withdrawn | Not processed | Antonin Houska (a.houska) | 9 | 2 years ago | ||||
| User functions for building SCRAM secrets | 3988 | Returned with feedback | Not processed | Jonathan Katz (jkatz05) | 7 | 1 year ago | ||||
| Server Features | ||||||||||
| Update relfrozenxmin when truncating temp tables | 3358 | Returned with feedback | 16 | Not processed | Greg Stark (stark) | 12 | 1 year ago | |||
| BCP 47 locale names for Windows | 3772 | Moved to next CF | Not processed | Thomas Munro (macdice) | 8 | 7 months ago | ||||
| Add the ability to limit the amount of memory that can be allocated to backends. | 3867 | Moved to next CF | Not processed | Reid Thompson (jreidthompsoncd), John Morris (coyotebush) | 11 | 1 year ago | ||||
| Multi-version ICU | 3956 | Moved to next CF | Not processed | Thomas Munro (macdice) | 10 | 1 year ago | ||||
| Post-special Page Storage TDE support (aka Reserved Page Size) | 3986 | Moved to next CF | Not processed | David Christensen (davidchristensen) | 12 | 3 months ago | ||||
| ltree hash functions | 4375 | Moved to next CF | Not processed | Tommy Pavlicek (tommyp) | Tom Lane (tgl) | 5 | 1 year ago | |||
| Variable Block Size | 4429 | Withdrawn | 17 | Not processed | David Christensen (davidchristensen) | 4 | 1 year ago | |||
| pg_stat_logmsg | 4431 | Moved to next CF | Not processed | Joe Conway (jconway) | 7 | 8 months ago | ||||
| Multiple passwords, interval expirations | 4432 | Returned with feedback | Not processed | Gurjeet Singh (gurjeet), Joshua Brindle (joshuab) | 4 | 1 year ago | ||||
| Support run-time partition pruning for hash join | 4512 | Moved to next CF | 17 | Not processed | Richard Guo (richardguo) | 6 | 6 months ago | |||
| Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING | 4617 | Moved to next CF | Not processed | Marko Tiikkaja (johto) | 5 | 6 months ago | ||||
| Mark search_path as GUC_REPORT | 4646 | Moved to next CF | Not processed | Alexander Kukushkin (cyberdem0n), Jelte Fennema-Nio (jeltef) | Tomas Vondra (fuzzycz) | 4 | 7 months ago | |||
| Add support function for containment operators | 4647 | Committed | 17 | Not processed | Tom Lane (tgl) | 1 | 1 year ago | |||
| Sequence Access Methods, round two | 4677 | Moved to next CF |
7/7
|
+2753−795 | Michael Paquier (michael-kun) | 8 | 9 hours ago | |||
| Union Replacement of OR logic | 4715 | Moved to next CF | 16 | Not processed | 3 | 11 months ago | ||||
| Switch to FullTransactionId for PGPROC->xid and XLogRecord->xl_xid | 4741 | Moved to next CF | Not processed | Maxim Orlov (m.orlov) | 3 | 1 year ago | ||||
| SQL Commands | ||||||||||
| Incremental View Maintenance (IVM), take 2 | 4337 | Moved to next CF | Needs rebase! | Yugo Nagata (yugo.nagata) | 10 | 7 months ago | ||||
| Remaining sql/json patches | 4377 | Moved to next CF | Not processed | Amit Langote (amitlan), Nikita Glukhov (n.glukhov) | Amit Langote (amitlan) | 5 | 11 months ago | |||
| [PoC] Implementation of distinct in Window Aggregates: take two | 4519 | Returned with feedback | Not processed | Ankit Kumar Pandey (ankitkpandey) | 3 | 1 year ago | ||||
| RETURNING OLD/NEW values | 4723 | Moved to next CF | 18 | Not processed | Dean Rasheed (deanr) | Dean Rasheed (deanr) | 6 | 2 months ago | ||
| System Administration | ||||||||||
| recovery modules | 4082 | Moved to next CF | 18 | Not processed | Nathan Bossart (bossartn) | 8 | 8 months ago | |||
| PITR shutdown should not report error by pg_ctl | 4653 | Withdrawn | 17 | Not processed | Zhao Junwang (zhjwpku), TianXiang Li (krisdiano) | 1 | 8 months ago | |||
| Testing | ||||||||||
| CI and test improvements | 3709 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | 14 | 4 months ago | ||||
| Detect test suite sideeffects in pg_regress | 4321 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | 5 | 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 next CF | Not processed | Nazir Bilal Yavuz (nbyavuz) | 4 | 10 months ago | ||||
| Add test module for Table Access Method | 4588 | Returned with feedback | Not processed | Fabrízio Mello (fabriziomello) | 2 | 1 year ago | ||||
| Add a perl function in Cluster.pm to generate WAL | 4693 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Michael Paquier (michael-kun) | 1 | 1 year ago | |||
| pg_stat_statements: more test coverage | 4726 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 1 year ago | |||
| change regexp_substr first argument make tests more easier to understand | 4744 | Moved to next CF | stable | Not processed | jian he (universality) | 4 | 6 months ago | |||