| Bug Fixes |
|---|
| Network failure may prevent promotion | 4748 | Committed | |   7/7 | +52−202 | Kyotaro Horiguchi (horiguti) | | Heikki Linnakangas (heikki) | 7 | 1 month ago |
| Fix BackgroundPsql to report error on query timeout rather than calling die | 4959 | Moved to next CF | 18 |  6/7 | +17−16 | Daniel Gustafsson (d_gustafsson) | Heikki Linnakangas (heikki) | | 6 | 2 months ago |
| windows compilation fails when gssapi & openssl are enabled | 5060 | Committed | 17 | 7/7 | +46−30 | Imran Zaheer (imranzaheer) | Daniel Gustafsson (d_gustafsson), vigneshwaran C (vignesh.postgres), Yasir Shah (yasir.hussain.shah.gmail.com) | Daniel Gustafsson (d_gustafsson) | 5 | 1 month ago |
| Incorrect error message for cancellation triggered by statement_timeout & flaky test | 5070 | Moved to next CF | stable | 6/7 | +16−5 | Jelte Fennema-Nio (jeltef) | | | 6 | 3 months ago |
| inplace update: send nontransactional invalidations | 5091 | Moved to next CF | stable | 7/7 | +3−0 | Noah Misch (nmisch) | | Noah Misch (nmisch) | 6 | 1 week ago |
| DirtyScanshot index scan skips concurrently updated tuples | 5151 | Moved to next CF | stable | 6/7 | +146−8 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Luan Silva (luansilva) | | 5 | 1 hour ago |
| Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY | 5160 | Moved to next CF | stable |  4/7 | +1567−50 | Michail Nikolaev (nkey) | | | 5 | 33 minutes ago |
| Fix RelationTruncate() corruption | 5242 | Committed | | Not processed | | Robert Haas (rhaas), Thomas Munro (macdice) | | Thomas Munro (macdice) | 3 | 1 month ago |
| ensure we have a snapshot when dropping an index concurrently | 5262 | Moved to next CF | 19 | Needs rebase! | | Nathan Bossart (bossartn) | | Nathan Bossart (bossartn) | 4 | 1 week ago |
| Fix incorrect Assert in gistFindCorrectParent() | 5268 | Committed | | 6/7 | +2−1 | | Tender Wang (tndrwang) | Heikki Linnakangas (heikki) | 3 | 1 month ago |
| Fix bug with accessing to temporary tables of other sessions | 5379 | Moved to next CF | 18 | 6/7 | +55−23 | Daniil Davydov (dddaniil) | Rafia Sabih (rafia.sabih) | | 3 | 1 month ago |
| bt_index_parent_check false alarm for indexes created concurrently | 5438 | Moved to next CF | | 7/7 | +69−39 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | | | 3 | 5 months ago |
| Incorrect result of bitmap heap scan. | 5448 | Committed | stable | 7/7 | +127−132 | Matthias van de Meent (mmeent) | | Andres Freund (andresfreund) | 2 | 1 month ago |
| Fix logging for invalid recovery timeline | 5468 | Committed | stable | 7/7 | +3−3 | David Steele (dsteele) | | Michael Paquier (michael-kun) | 2 | 2 months ago |
| Re: BUG #18741: Detaching a partition referencing a partitioned table fails with a trigger-related error | 5484 | Withdrawn | stable | 7/7 | +104−6 | | | | 1 | 4 months ago |
| lower default value of autovacuum_worker_slots in initdb as needed | 5491 | Committed | 18 | Not processed | | Nathan Bossart (bossartn) | | Nathan Bossart (bossartn) | 1 | 4 months ago |
| ecpg command does not warn COPY ... FROM STDIN; | 5497 | Committed | stable | Not processed | | Ryo Kanbayashi (ryokanbayashi) | | Fujii Masao (masaofujii) | 1 | 4 months ago |
| Avoid possible null pointer dereference | 5506 | Withdrawn | 17 | Not processed | | Ranier Vilela (raniervilela) | Ilia Evdokimov (ilidock95) | | 1 | 3 months ago |
| At update of non-LP_NORMAL TID, fail instead of corrupting page header | 5518 | Committed | stable | 0/1 | +0−0 | Noah Misch (nmisch) | | Noah Misch (nmisch) | 1 | 1 month ago |
| SIGSEGV, FPE fix in pg_controldata | 5527 | Committed | stable | Not processed | | Anton Voloshin (a.voloshin), Ian Ilyasov (ianilyasov) | | Alexander Korotkov (smagen) | 1 | 3 months ago |
| Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData | 5532 | Moved to next CF | stable | 7/7 | +388−190 | Michael Paquier (michael-kun) | Noah Misch (nmisch) | | 2 | 1 week ago |
| Fix buffer pinning logic in [SP-]Gist | 5542 | Moved to next CF | | 6/7 | +1429−140 | Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Matthias van de Meent (mmeent), Mihail Nikalayeu (mihailnikalayeu) | | | 2 | 3 weeks ago |
| Prevent COPY FREEZE on Foreign tables | 5544 | Committed | 18 | Not processed | | Sami Imseih (simseih) | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 3 months ago |
| Fix Potential Memory in pg_amcheck Code | 5555 | Committed | stable | 7/7 | +1−0 | Shuntian Jiao (jiaoshuntian) | xueyu gao (hope) | Daniel Gustafsson (d_gustafsson) | 1 | 2 months ago |
| Invalid cached plan in check_foreign_key; cascade update in check_primary_key; refint.c | 5577 | Committed | | 7/7 | +91−34 | Dmitrii Bondar (difesu) | Tom Lane (tgl), Paul Jungwirth (pjungwir), Lilian Ontowhee (ontowhee) | Tom Lane (tgl) | 1 | 1 month ago |
| fix for bug #18815 | 5582 | Committed | stable | 7/7 | +35−21 | Tom Lane (tgl) | | Tom Lane (tgl) | 1 | 1 month ago |
| Improve ACL checks in pg_prewarm for indexes | 5583 | Moved to next CF | | 6/7 | +39−3 | Ayush Vatsa (developerayuva) | Nathan Bossart (bossartn) | | 2 | 2 months ago |
| Fix api misuse (src/bin/pg_amcheck/pg_amcheck.c) | 5586 | Committed | 18 | 6/7 | +0−0 | Ranier Vilela (raniervilela) | vigneshwaran C (vignesh.postgres) | Michael Paquier (michael-kun) | 1 | 2 months ago |
| Missing [NO] INDENT flag in XMLSerialize backward parsing | 5587 | Committed | 16 | 7/7 | +0−0 | Jim Jones (jimus) | | Michael Paquier (michael-kun) | 1 | 2 months ago |
| Fix race condition between role grants and DROP ROLE | 5589 | Committed | stable | Needs rebase! | | Tom Lane (tgl) | | Tom Lane (tgl) | 1 | 2 months ago |
| The walsender does not update its IO statistics until it exits | 5596 | Committed | stable | 7/7 | +74−18 | Bertrand Drouvot (bertranddrouvot.pg) | vigneshwaran C (vignesh.postgres) | Michael Paquier (michael-kun) | 1 | 1 month ago |
| Orphaned users in PG16 and above can only be managed by Superusers | 5608 | Moved to next CF | | 7/7 | +178−0 | Ashutosh Sharma (ashu_coek) | Nathan Bossart (bossartn) | | 2 | 1 month ago |
| Avoid infinite loop in checkpointer | 5612 | Moved to next CF | | 7/7 | +109−41 | Maxim Orlov (m.orlov) | | | 2 | 1 month ago |
| Corrupted FSM page is not saved after zeroing. | 5615 | Moved to next CF | | 6/7 | +3−0 | Anton Melnikov (antonmel) | | | 2 | 1 month ago |
| Not-terribly-safe checks for CRC intrinsic support | 5653 | Committed | | 34/35 | +0−0 | Tom Lane (tgl) | | Tom Lane (tgl) | 1 | 1 month ago |
| Clients |
|---|
| psql meta-command conninfo+ | 4814 | Committed | | 7/7 | +162−33 | Maiquel Grassi (maiquel), Hunaid Sohail (hunaid) | Álvaro Herrera (alvherre), Nathan Bossart (bossartn), Sami Imseih (simseih), Jim Jones (jimus), Erik Wienhold (ewie) | Álvaro Herrera (alvherre) | 6 | 2 months ago |
| libpq: Fix processing of SSL records >8kB on async API | 5251 | Moved to next CF | stable | 6/7 | +13−0 | Lars Kanis (larsk) | Jacob Champion (jchampion) | | 4 | 2 months ago |
| Allow default \watch interval in psql to be configured | 5353 | Committed | | 6/7 | +141−2 | Daniel Gustafsson (d_gustafsson) | Ashutosh Bapat (ashutoshbapat), Masahiro Ikeda (masahiro.ikeda) | Daniel Gustafsson (d_gustafsson) | 3 | 1 month ago |
| Add Option to Check All Addresses For Matching target_session_attr | 5396 | Moved to next CF | 18 | 7/7 | +306−10 | Andrew Jackson (andrewjackson) | | | 3 | yesterday |
| Add Pipelining support to psql | 5407 | Committed | 18 | Needs rebase! | | Anthonin Bonnefoy (bonnefoa) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 2 | 3 weeks ago |
| Tab completion for ALTER USER RESET | 5414 | Committed | 18 | 7/7 | +28−0 | Robins Tharakan (robins) | | Tomas Vondra (fuzzycz) | 2 | 3 months ago |
| Adding extension default version to \dx | 5498 | Committed | | 7/7 | +9−6 | Magnus Hagander (mha), Jelte Fennema-Nio (jeltef) | Nathan Bossart (bossartn) | Magnus Hagander (mha) | 1 | 1 month ago |
| Add --no-policies to pg_dump, pg_dumpall, pg_restore | 5499 | Committed | 18 | 7/7 | +67−0 | Nikolay Samokhvalov (nikolay) | vigneshwaran C (vignesh.postgres), Greg Sabino Mullane (greg), Jim Jones (jimus), newtglobal postgresql_contributors (newtpostgrescontributors) | Tom Lane (tgl) | 1 | 2 months ago |
| Adding support for SSLKEYLOGFILE in the frontend | 5500 | Committed | 18 | 7/7 | +120−2 | Abhishek Chanda (abhishekc) | Jacob Champion (jchampion), Daniel Gustafsson (dege) | Daniel Gustafsson (d_gustafsson) | 1 | 1 month ago |
| Add -k/--link option to pg_combinebackup | 5508 | Committed | 18 | Needs rebase! | | Israel Barth (barthisrael) | vigneshwaran C (vignesh.postgres) | Robert Haas (rhaas) | 1 | 1 month ago |
| Better title output for psql \dt \di \dv \dm \ds \dE | 5540 | Committed | 18 | Not processed | | Greg Sabino Mullane (greg) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 3 months ago |
| Add missing tab complete for VACUUM and ANALYZE ONLY option | 5552 | Committed | | 7/7 | +20−9 | Umar Hayat (pgwizard) | vigneshwaran C (vignesh.postgres) | Tom Lane (tgl) | 1 | 1 month ago |
| Code Comments |
|---|
| Fix outdated code comments in nodeAgg.c | 5580 | Committed | 18 | 7/7 | +2−4 | Mingli Zhang (zml) | Richard Guo (richardguo) | Jeff Davis (jdavis) | 1 | 2 months ago |
| Documentation |
|---|
| Document NULL Concepts and Behaviors | 5086 | Moved to next CF | | 6/7 | +1279−160 | David Johnston (polobo) | | | 6 | 2 months ago |
| Doc: Move and modify standalone hot backups section | 5087 | Moved to next CF | | 7/7 | +139−139 | David Johnston (polobo) | Marlene Reiterer (marlene.rte) | | 6 | 1 month ago |
| Doc: Improve hostssl related descriptions and option presentation | 5088 | Withdrawn | | Needs rebase! | | David Johnston (polobo) | | | 5 | 2 months ago |
| Clarify the behavior of AT TIME ZONE | 5146 | Committed | | 7/8 | +0−0 | Aleksander Alekseev (a.alekseev) | Laurenz Albe (laurenz) | Bruce Momjian (bmomjian) | 4 | 2 months ago |
| Use "protocol options" name instead of "protocol extensions" everywhere | 5341 | Rejected | | 7/7 | +4−4 | Jelte Fennema-Nio (jeltef) | | | 3 | 2 months ago |
| explain pgstatindex fragmentation | 5381 | Moved to next CF | 18 | 7/7 | +9−0 | Frédéric Yhuel (yhuelf) | Laurenz Albe (laurenz), Bertrand Drouvot (bertranddrouvot), Benoit Lobréau (benoitl), Ahmed Ashour (ahmedashour) | | 3 | 2 months ago |
| Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN | 5418 | Committed | | 7/7 | +0−0 | Masahiro Ikeda (masahiro.ikeda) | Robert Treat (xzilla) | Álvaro Herrera (alvherre) | 2 | 1 month ago |
| doc: Mention clock synchronization recommendation for hot_standby_feedback | 5425 | Committed | stable | 5/7 | +7−0 | Jakub Wartak (jakub.wartak.tomtom) | vigneshwaran C (vignesh.postgres) | Peter Eisentraut (petere) | 2 | 1 month ago |
| DOCS for generated column replication | 5502 | Rejected | | 7/7 | +146−0 | Peter Smith (smithpb2250) | | | 1 | 2 months ago |
| split func.sgml to separated individual sgml files | 5515 | Moved to next CF | | 7/7 | +44−1 | Jian He (stayreal) | | | 2 | 1 month ago |
| TOAST is acronym so should be uppercase | 5530 | Moved to next CF | | 7/7 | +13−13 | Peter Smith (smithpb2250) | David Johnston (polobo) | | 2 | 1 month ago |
| Doc fix of aggressive vacuum threshold for multixact members storage | 5537 | Committed | stable | 7/7 | +3−2 | Alex Friedman (afriedman) | Sami Imseih (simseih) | John Naylor (john.naylor) | 1 | 2 months ago |
| Document how commit handles aborted transactions | 5546 | Moved to next CF | | 6/7 | +48−3 | David Johnston (polobo) | Ahmed Ashour (ahmedashour) | | 2 | 2 months ago |
| Doc: Create table improvements | 5547 | Moved to next CF | | 7/7 | +22−5 | David Johnston (polobo) | Laurenz Albe (laurenz) | | 2 | 2 months ago |
| Document custom settings more consistently | 5548 | Moved to next CF | | 6/7 | +22−5 | David Johnston (polobo) | Mingli Zhang (zml) | | 2 | 1 month ago |
| Document hostssl related concepts better | 5549 | Withdrawn | | Needs rebase! | | David Johnston (polobo) | | | 1 | 2 months ago |
| DOCS - Generated Column Logical Replication Examples | 5590 | Withdrawn | 18 | 7/7 | +146−0 | Peter Smith (smithpb2250) | | | 1 | 2 months ago |
| A small correction to doc and comment of FSM for indexes | 5598 | Committed | stable | 7/7 | +2−2 | Alex Friedman (afriedman) | | Michael Paquier (michael-kun) | 1 | 1 month ago |
| Doc: clarify possibility of ephemeral discrepancies between state and wait_event in pg_stat_activity | 5600 | Committed | stable | 7/7 | +3−1 | Alex Friedman (afriedman) | Sami Imseih (simseih) | Michael Paquier (michael-kun) | 1 | 1 month ago |
| Documentation modifications for UUID. "Section 9.14. UUID Functions" formats the UUID functions in table form, similar to other function docs. "Section 8.12. UUID Type" mentions the various UUID versions and describes that the PostgreSQL UUID datatype supports all versions, including those generated outside of PostgreSQL. | 5604 | Committed | 18 | 7/7 | +155−36 | Andrew Alsup (ahalsup) | Laurenz Albe (laurenz) | Masahiko Sawada (masahikosawada) | 1 | 2 months ago |
| Miscellaneous |
|---|
| Support a wildcard in backtrace_functions | 4735 | Moved to next CF | | 7/7 | +161−11 | Jelte Fennema-Nio (jeltef) | Daniel Gustafsson (d_gustafsson), Bharath Rupireddy (bharathrupireddy) | Daniel Gustafsson (d_gustafsson) | 8 | 2 months ago |
| Avoid orphaned objects dependencies, take 3 | 4942 | Moved to next CF | 18 | Needs rebase! | | Bertrand Drouvot (bertranddrouvot.pg) | | | 6 | 3 months ago |
| gamma() and lgamma() functions | 5098 | Committed | 18 | 7/7 | +212−0 | Dean Rasheed (deanr) | Alexandra Wang (alexandrawang) | Dean Rasheed (deanr) | 5 | 1 month ago |
| Allow casting between bytea and integer types | 5176 | Committed | | 7/7 | +274−0 | Aleksander Alekseev (a.alekseev) | Joel Jacobson (joeljacobson) | Dean Rasheed (deanr) | 4 | 2 months ago |
| [PROPOSAL] : Disallow use of empty column name in (column_name '') in ALTER or CREATE of foreign table. | 5184 | Rejected | | 7/7 | +61−0 | Nishant Sharma (nishant-at-edb) | | | 4 | 1 month ago |
| Truncate logs by max_log_size | 5272 | Moved to next CF | | 6/7 | +112−2 | Kirill Gavrilov (diphantxm) | Fujii Masao (masaofujii), Jim Jones (jimus) | | 4 | 1 month ago |
| Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c | 5291 | Committed | | 6/7 | +2−3 | Tender Wang (tndrwang) | | Alexander Korotkov (smagen) | 3 | 1 month ago |
| System views for versions reporting | 5318 | Moved to next CF | stable | Needs rebase! | | Dmitry Dolgov (erthalion) | | | 4 | 1 month ago |
| Tweak access BufferDescriptors array codes in BufferGetLSNAtomic() | 5373 | Committed | | 7/7 | +2−0 | Tender Wang (tndrwang) | Xuneng Zhou (egoa) | Richard Guo (richardguo) | 2 | 2 months ago |
| postgres_fdw could deparse ArrayCoerceExpr | 5409 | Moved to next CF | 18 | 7/7 | +80−0 | Alexander Pyhalov (a.pyhalov) | Maxim Orlov (m.orlov) | | 3 | 3 months ago |
| Add maintainer-defined module info into shared library | 5465 | Committed | 18 | 7/7 | +596−112 | Andrei Lepikhov (lepikhov) | Yurii Rashkovskii (yrashk) | Tom Lane (tgl) | 2 | 1 month ago |
| Unicode 16 update | 5472 | Committed | | 7/7 | +7442−6609 | Peter Eisentraut (petere), Jeff Davis (jdavis) | | Peter Eisentraut (petere) | 2 | 1 month ago |
| read stream on amcheck | 5488 | Committed | | 7/7 | +79−24 | Matheus Alcantara (matheus.alcantara) | | Melanie Plageman (melanieplageman) | 1 | 1 month ago |
| Add new API to stringinfo | 5489 | Committed | 18 | Not processed | | Tatsuo Ishii (ishii) | Michael Paquier (michael-kun), David Rowley (davidrowley), Nathan Bossart (bossartn), Gurjeet Singh (gurjeet) | Tatsuo Ishii (ishii) | 1 | 4 months ago |
| Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions | 5493 | Committed | | 7/7 | +479−39 | Nazir Bilal Yavuz (nbyavuz) | Joseph Koshakow (jkoshakow), Aidar Imamov (gipergeek) | Andres Freund (andresfreund) | 1 | 1 month ago |
| Optimizing FastPathTransferRelationLocks() | 5494 | Committed | | 7/7 | +16−12 | Fujii Masao (masaofujii) | | Fujii Masao (masaofujii) | 1 | 2 months ago |
| EXPLAIN ANALYZE rows=%.f | 5501 | Committed | 18 | Needs rebase! | | Ilia Evdokimov (ilidock95) | Robert Haas (rhaas), Tom Lane (tgl), Andres Freund (andresfreund), Guillaume Lelarge (gleu), Andrei Lepikhov (lepikhov), Jelte Fennema-Nio (jeltef), Alena Rybakina (alenka), Matheus Alcantara (matheus.alcantara) | Robert Haas (rhaas) | 1 | 1 month ago |
| convert libpgport's pqsignal() to a void function | 5507 | Committed | 18 | Not processed | | Nathan Bossart (bossartn) | | Nathan Bossart (bossartn) | 1 | 4 months ago |
| Remove unused helpers that don't compile anymore | 5510 | Committed | | Not processed | | Jacob Brazeal (polkerty) | | Tom Lane (tgl) | 1 | 3 months ago |
| Add a function to get the version of installed extension | 5514 | Withdrawn | | 0/1 | +0−0 | Yugo Nagata (yugo.nagata) | | | 1 | 1 month ago |
| Show plperl version in the meson setup summary screen. | 5539 | Committed | | 7/7 | +4−2 | | vigneshwaran C (vignesh.postgres) | Andrew Dunstan (adunstan) | 1 | 2 months ago |
| pg_upgrade check for Unicode update | 5563 | Withdrawn | 18 | 7/7 | +7442−6609 | Jeff Davis (jdavis) | Nathan Bossart (bossartn) | | 1 | 1 month ago |
| describe special values in GUC descriptions more consistently | 5564 | Committed | 18 | Not processed | | Nathan Bossart (bossartn) | | Nathan Bossart (bossartn) | 1 | 2 months ago |
| Make pg_trgm aware the default 'char' signedness difference in cross-arch replication | 5569 | Committed | | 7/7 | +15−3 | Masahiko Sawada (masahikosawada) | | Masahiko Sawada (masahikosawada) | 1 | 1 month ago |
| Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup | 5570 | Moved to next CF | 18 | 7/7 | +243−45 | Jelte Fennema-Nio (jeltef) | | | 2 | 1 month ago |
| noreturn attribute for MSVC, C11 | 5571 | Committed | | Needs rebase! | | Peter Eisentraut (petere) | | Peter Eisentraut (petere) | 1 | 2 months ago |
| Fix MINGW build on ARM64 on Windows | 5610 | Returned with feedback | | 7/7 | +5−5 | Lars Kanis (larskanis) | vigneshwaran C (vignesh.postgres) | Andrew Dunstan (adunstan) | 1 | 1 month ago |
| Increase maximum allowed io_combine_limit to 1MB | 5618 | Committed | | Needs rebase! | | Thomas Munro (macdice) | | Thomas Munro (macdice) | 1 | 2 months ago |
| Monitoring & Control |
|---|
| pg_stat_statements and "IN" conditions | 2837 | Committed | | 6/7 | +945−23 | Dmitry Dolgov (erthalion) | Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih) | Álvaro Herrera (alvherre) | 22 | 1 month ago |
| Amcheck verification of GiST and GIN | 3733 | Committed | | 6/7 | +1508−215 | Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) | José Villanova (azlev), Mark Dilger (mark.dilger) | Tomas Vondra (fuzzycz) | 15 | 1 month ago |
| Set log_lock_waits=on by default | 4718 | Moved to next CF | | 6/7 | +6−5 | Laurenz Albe (laurenz) | Michael Banck (mbanck), Nathan Bossart (bossartn) | | 8 | 1 month ago |
| Add local address to log_line_prefix | 4907 | Committed | | 7/7 | +24−0 | Greg Sabino Mullane (greg) | David Steele (dsteele), Cary Huang (cary), Jim Jones (jimus) | Tom Lane (tgl) | 5 | 1 month ago |
| pg_stat_activity: make slow/hanging authentication more visible | 4974 | Withdrawn | 18 | 7/7 | +127−6 | Jacob Champion (jchampion) | Michael Paquier (michael-kun) | | 5 | 1 month ago |
| relfilenode statistics | 5007 | Moved to next CF | 18 | Needs rebase! | | Bertrand Drouvot (bertranddrouvot.pg) | | | 6 | 2 months ago |
| Vacuum statistics | 5012 | Moved to next CF | 18 | 0/10 | +2805−21 | Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) | Ilia Evdokimov (ilidock95) | | 6 | 4 days ago |
| Track the amount of time waiting due to cost_delay | 5027 | Committed | 18 | Not processed | | Bertrand Drouvot (bertranddrouvot.pg) | Nathan Bossart (bossartn), Masahiro Ikeda (masahiro.ikeda) | Nathan Bossart (bossartn) | 5 | 3 months ago |
| Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) | 5183 | Committed | | 7/7 | +306−49 | Peter Geoghegan (pgeoghegan) | Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (alenka) | Peter Geoghegan (pgeoghegan) | 4 | 2 months ago |
| Enhance file_fdw to report processed and skipped tuples in COPY progress | 5282 | Withdrawn | | Needs rebase! | | Fujii Masao (masaofujii) | | | 3 | 2 months ago |
| Add “FOR UPDATE NOWAIT” lock details to the log. | 5294 | Committed | | 7/7 | +4−2 | Yuki Seino (seinoyu) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 3 | 1 month ago |
| Logging plan of the currently running query | 5330 | Moved to next CF | 18 | 7/7 | +613−43 | Atsushi Torikoshi (atsushitorikoshi) | Akshat Jaimini (akshatj), Sadeq Dousti (msdousti) | | 4 | 2 weeks ago |
| Enhance memory context statistics reporting for all PostgreSQL processes. | 5355 | Committed | 18 | 6/7 | +1383−45 | Rahila Syed (rahila) | Daniel Gustafsson (d_gustafsson), Atsushi Torikoshi (atsushitorikoshi) | Daniel Gustafsson (d_gustafsson) | 3 | 1 month ago |
| Sampling in pg_stat_statements | 5390 | Returned with feedback | 18 | 7/7 | +291−8 | Ilia Evdokimov (ilidock95) | Andrey Borodin (x4m), Sami Imseih (simseih), Alena Rybakina (alenka) | | 2 | 1 month ago |
| Log connection establishment timings | 5442 | Committed | | 7/7 | +508−25 | Melanie Plageman (melanieplageman) | Fujii Masao (masaofujii), Jacob Champion (jchampion), Bertrand Drouvot (bertranddrouvot.pg) | Melanie Plageman (melanieplageman) | 2 | 2 months ago |
| track vacuum/analyze cumulative time per relation | 5485 | Committed | | Not processed | | Sami Imseih (simseih) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 3 months ago |
| Optionally record Plan IDs to track plan changes for a query | 5486 | Returned with feedback | | 28/28 | +0−0 | Lukas Fittl (lfittl) | Sami Imseih (simseih) | | 1 | 1 month ago |
| improve DEBUG1 logging of parallel workers for CREATE INDEX | 5490 | Withdrawn | | Not processed | | Sami Imseih (simseih) | | | 1 | 3 months ago |
| per backend WAL statistics | 5492 | Committed | 18 | 7/7 | +183−26 | Bertrand Drouvot (bertranddrouvot.pg) | | Michael Paquier (michael-kun) | 1 | 1 month ago |
| Non-text mode for pg_dumpall | 5495 | Committed | 18 | 7/8 | +1951−430 | Mahendra Singh Thalor (mahithalor) | | Andrew Dunstan (adunstan) | 1 | 1 month ago |
| pg_stat_statements: improve loading and saving routines for the dump file. | 5512 | Rejected | | 7/7 | +10−4 | Mikhail Litsarev (mikhail.litsarev) | | | 1 | 1 month ago |
| Add storage I/O tracking to EXPLAIN BUFFERS | 5526 | Moved to next CF | 18 | 7/7 | +1148−34 | Atsushi Torikoshi (atsushitorikoshi) | Jelte Fennema-Nio (jeltef) | | 2 | 1 week ago |
| Move wal_buffers_full to WalUsage (and report it in pgss/explain) | 5551 | Committed | 18 | Not processed | | Bertrand Drouvot (bertranddrouvot.pg) | | Michael Paquier (michael-kun) | 1 | 3 months ago |
| Draft for basic NUMA observability | 5558 | Committed | 18 | 7/7 | +1179−11 | Jakub Wartak (jakub.wartak.tomtom) | | Tomas Vondra (fuzzycz) | 1 | 1 month ago |
| Change log level for notifying hot standby is waiting non-overflowed snapshot | 5567 | Committed | 18 | 7/7 | +38−13 | Atsushi Torikoshi (atsushitorikoshi) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 1 | 1 month ago |
| add cost delay time to VACUUM/ANALYZE (VERBOSE) and autovacuum logs | 5572 | Committed | 18 | Not processed | | Bertrand Drouvot (bertranddrouvot.pg) | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 3 months ago |
| allow extensions to set a plan identifier | 5593 | Committed | 18 | 7/7 | +95−0 | Sami Imseih (simseih) | | Michael Paquier (michael-kun) | 1 | 1 month ago |
| Improve monitoring of shared memory allocations | 5620 | Moved to next CF | 18 | 6/7 | +198−51 | Rahila Syed (rahila) | | Tomas Vondra (fuzzycz) | 2 | 5 days ago |
| Performance |
|---|
| AcquireExecutorLocks() and run-time pruning | 3478 | Committed | | Needs rebase! | | Amit Langote (amitlan) | Tom Lane (tgl) | Amit Langote (amitlan) | 17 | 2 months ago |
| Reducing planning time when tables have many partitions | 3701 | Committed | | 7/7 | +446−120 | Yuya Watari (watari) | Tom Lane (tgl), Thom Brown (thom), Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), newtglobal postgresql_contributors (newtpostgrescontributors) | David Rowley (davidrowley) | 15 | 1 month ago |
| Index Prefetching | 4351 | Moved to next CF | | 7/7 | +4395−192 | Tomas Vondra (fuzzycz) | | | 11 | 2 weeks ago |
| Statistics Import and Export | 4538 | Committed | | 7/7 | +267−64 | Corey Huinker (coreyh) | Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) | Jeff Davis (jdavis) | 9 | yesterday |
| Reducing memory consumed by RestrictInfo list translations in partitionwise join planning | 4564 | Committed | | 7/7 | +389−77 | Ashutosh Bapat (ashutoshbapat) | | Amit Langote (amitlan) | 8 | 1 month ago |
| Special-case executor expression steps for common combinations | 4627 | Committed | | 7/7 | +194−39 | Andres Freund (andresfreund), Daniel Gustafsson (d_gustafsson) | Andreas Karlsson (kandreas) | Daniel Gustafsson (d_gustafsson) | 8 | 2 months ago |
| Teach predtest about IS [NOT] <boolean> proofs | 4690 | Moved to next CF | | 7/7 | +1882−129 | James Coleman (jcole1989) | Tom Lane (tgl) | | 8 | 1 year ago |
| Parallel CREATE INDEX for GIN indexes | 4966 | Moved to next CF | | 5/7 | +7−0 | Tomas Vondra (fuzzycz) | Matthias van de Meent (mmeent), Andy Fan (andy2) | | 6 | 2 weeks ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots | 4971 | Moved to next CF | | 4/7 | +3956−933 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Matthias van de Meent (mmeent) | | 6 | 40 minutes ago |
| Sort functions with specialized comparators | 5036 | Committed | | 6/7 | +34−48 | Andrey Borodin (x4mmm), Stepan Neretin (fenixrnd.mail.ru) | | John Naylor (john.naylor) | 5 | 3 months ago |
| Remove self join on a unique column | 5043 | Committed | | 7/7 | +53−28 | Andrei Lepikhov (lepikhov) | Dean Rasheed (deanr) | Alexander Korotkov (smagen) | 5 | 1 month ago |
| nbtree skip scan | 5081 | Committed | | 7/7 | +3840−565 | Peter Geoghegan (pgeoghegan) | Aleksander Alekseev (a.alekseev), Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (a.rybakina) | Peter Geoghegan (pgeoghegan) | 5 | 1 month ago |
| Vacuum | 5089 | Committed | | Not processed | | Thomas Munro (macdice), Melanie Plageman (melanieplageman) | | Melanie Plageman (melanieplageman) | 5 | 2 months ago |
| Improved crc32c performance with AVX-512 algorithm. | 5100 | Returned with feedback | 18 | Needs rebase! | | Paul Amonson (pamonson), Raghuveer Devulapalli (rdevulap) | Nathan Bossart (bossartn) | | 4 | 3 months ago |
| MergeJoin beats HashJoin in the case of multiple hash clauses | 5114 | Committed | | Needs rebase! | | Andrei Lepikhov (lepikhov) | | Alexander Korotkov (smagen) | 4 | 3 weeks ago |
| Use read streams in autoprewarm | 5162 | Committed | | 7/8 | +178−76 | Nazir Bilal Yavuz (nbyavuz) | Daniel Gustafsson (d_gustafsson) | Melanie Plageman (melanieplageman) | 4 | 1 month ago |
| AIO | 5227 | Committed | | 7/7 | +5611−79 | Andres Freund (andresfreund) | Noah Misch (nmisch) | Andres Freund (andresfreund) | 4 | 1 month ago |
| Allow SQL functions use CachedPlan machinery | 5246 | Committed | 18 | 7/7 | +2109−972 | Alexander Pyhalov (a.pyhalov) | Tom Lane (tgl), Pavel Stehule (okbobcz) | Tom Lane (tgl) | 3 | 1 month ago |
| Improve statistics estimation considering GROUP-BY as a 'uniqueiser' | 5269 | Committed | 18 | 2/7 | +37−0 | Andrei Lepikhov (lepikhov) | | Alexander Korotkov (smagen) | 3 | 2 months ago |
| Replace IN VALUES with ANY in WHERE clauses during optimization | 5283 | Committed | 18 | Needs rebase! | | Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) | newtglobal postgresql_contributors (newtpostgrescontributors) | Alexander Korotkov (smagen) | 3 | 1 month ago |
| Limiting overshoot in nbtree SAOP parallel index scans | 5299 | Moved to next CF | | 5/7 | +151−23 | Matthias van de Meent (mmeent) | | | 4 | 4 days ago |
| Trigger more frequent autovacuums for insert-heavy tables | 5320 | Committed | | 7/7 | +37−16 | Melanie Plageman (melanieplageman) | Nathan Bossart (bossartn) | Melanie Plageman (melanieplageman) | 3 | 2 months ago |
| Add sortsupport for range types and btree_gist | 5325 | Committed | | 7/7 | +870−8 | Bernd Helmle (psoo), Christoph Heiss (christoph.heiss) | Andrey Borodin (x4m), jian he (hellothere) | Heikki Linnakangas (heikki) | 3 | 1 month ago |
| Parallel heap vacuum | 5326 | Moved to next CF | | 7/7 | +1617−380 | Masahiko Sawada (masahikosawada) | Hayato Kuroda (ha-kun) | | 4 | 2 weeks ago |
| Use read_stream in index vacuum | 5327 | Committed | | 7/7 | +167−25 | Andrey Borodin (x4m) | Melanie Plageman (melanieplageman), Kirill Reshke (reshke), Rahila Syed (rahila), Zhao Junwang (zhjwpku) | Melanie Plageman (melanieplageman) | 3 | 1 month ago |
| Let an Append to consider a tuple fraction when choosing fractional subpaths | 5361 | Committed | 18 | Needs rebase! | | Andrei Lepikhov (lepikhov), Nikita Malakhov (nmalakh) | | Alexander Korotkov (smagen) | 2 | 2 months ago |
| Using Expanded Objects other than Arrays from plpgsql | 5364 | Committed | | Not processed | | Tom Lane (tgl) | | Tom Lane (tgl) | 2 | 3 months ago |
| Eagerly scan all-visible pages to amortize aggressive vacuum | 5366 | Committed | | Not processed | | Melanie Plageman (melanieplageman) | | Melanie Plageman (melanieplageman) | 2 | 3 months ago |
| optimize file transfer in pg_upgrade | 5369 | Committed | 18 | 7/7 | +642−80 | Nathan Bossart (bossartn) | | Nathan Bossart (bossartn) | 2 | 1 month ago |
| Adding compression of temporary files | 5382 | Moved to next CF | | 6/7 | +3842−16 | Filip Januš (fjanus) | | | 3 | 3 weeks ago |
| [PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause | 5422 | Withdrawn | 18 | 7/7 | +0−0 | Ravi Revathy (revathyraavi) | | | 2 | 1 month ago |
| Eliminating SPI / SQL from some RI trigger functions | 5450 | Moved to next CF | 19 | Needs rebase! | | Amit Langote (amitlan) | | | 3 | 1 month ago |
| Speed up ICU case conversions | 5474 | Returned with feedback | | 2/7 | +86−41 | Andreas Karlsson (kandreas) | | | 2 | 1 month ago |
| handle batch explosion in hash joins | 5482 | Committed | | 2/7 | +5635−0 | Tomas Vondra (fuzzycz) | | Tomas Vondra (fuzzycz) | 2 | 2 months ago |
| Exists pull-up application with JoinExpr | 5487 | Moved to next CF | | Needs rebase! | | Alena Rybakina (alenka) | | | 2 | 1 month ago |
| Allow to use an index for ILIKE in more cases | 5505 | Withdrawn | 18 | Needs rebase! | | Yugo Nagata (yugo.nagata) | | | 1 | 1 month ago |
| Get rid of WALBufMappingLock | 5511 | Committed | 18 | 7/7 | +0−0 | Alexander Korotkov (smagen), Yura Sokolov (funny_falcon) | Alexander Korotkov (smagen), Yura Sokolov (funny_falcon), Pavel Borisov (pborisov) | Alexander Korotkov (smagen) | 1 | 1 month ago |
| quick and dirty fix: Quadratic planning time for ordered paths over partitioned tables | 5516 | Rejected | 18 | Not processed | | | | | 1 | 3 months ago |
| SVE enablement for pop-count | 5520 | Committed | 18 | 7/7 | +714−17 | Chiranmoy Bhattacharya (chiranmoy), Susmitha Devanga (susmithad) | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 month ago |
| SVE popcount support | 5521 | Withdrawn | | Not processed | | | | | 1 | 1 month ago |
| SVE enablement for hex-encode and hex-decode | 5538 | Moved to next CF | 19 | Needs rebase! | | Chiranmoy Bhattacharya (chiranmoy), Susmitha Devanga (susmithad) | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 2 | 2 months ago |
| Improve CRC32C performance with AVX-512, take 2 | 5545 | Committed | | 7/7 | +419−60 | Raghuveer Devulapalli (rdevulap) | John Naylor (john.naylor) | John Naylor (john.naylor) | 1 | 1 month ago |
| Expanding HOT updates for expression and partial indexes | 5556 | Moved to next CF | 19 | 6/7 | +1639−105 | Greg Burd (gregburd) | | | 2 | 1 month ago |
| Reduce TupleHashEntryData struct size by half | 5561 | Committed | 18 | 7/7 | +72−73 | Jeff Davis (jdavis) | | Jeff Davis (jdavis) | 1 | 1 month ago |
| Use Bump allocator for HashAgg | 5562 | Committed | 18 | Needs rebase! | | Jeff Davis (jdavis) | | Jeff Davis (jdavis) | 1 | 3 months ago |
| sinvaladt.c: remove msgnumLock | 5573 | Moved to next CF | 18 | 7/7 | +36−44 | Yura Sokolov (funny_falcon) | | | 2 | 1 week ago |
| Optimization for lower(), upper(), casefold() functions. | 5574 | Committed | | Needs rebase! | | Alexander Borisov (lexborisov) | Jeff Davis (jdavis) | Jeff Davis (jdavis) | 1 | 1 month ago |
| Avoid O(N^2) script parsing cost in pgbench | 5599 | Committed | | 7/7 | +98−66 | Tom Lane (tgl) | | Tom Lane (tgl) | 1 | 2 months ago |
| Read stream scalability improvements and AIO-compatibility | 5619 | Committed | | Needs rebase! | | Thomas Munro (macdice) | | Thomas Munro (macdice) | 1 | 1 month ago |
| Compress big WAL records | 5621 | Moved to next CF | | Needs rebase! | | Andrey Borodin (x4m) | | | 2 | 3 months ago |
| Procedural Languages |
|---|
| declarative session variables, LET command | 1608 | Moved to next CF | | 7/7 | +9966−64 | Pavel Stehule (okbobcz) | Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), newtglobal postgresql_contributors (newtpostgrescontributors) | | 36 | 3 days ago |
| new plpgsql.extra_errors check - strict_expr_check | 5044 | Moved to next CF | | 6/7 | +177−18 | Pavel Stehule (okbobcz) | Gilles Darold (darold), newtglobal postgresql_contributors (newtpostgrescontributors) | | 6 | 2 months ago |
| Use Python "Limited API" in PL/Python | 5416 | Committed | | 7/7 | +0−0 | Peter Eisentraut (petere) | | Peter Eisentraut (petere) | 2 | 2 months ago |
| allow to use standard syntax for named arguments for plpgsql cursor arguments | 5565 | Committed | | 7/7 | +22−9 | Pavel Stehule (okbobcz) | Gilles Darold (darold) | Tom Lane (tgl) | 1 | 2 months ago |
| Refactoring |
|---|
| Revise get_cheapest_parallel_safe_total_inner | 4285 | Moved to next CF | | 6/7 | +11−4 | Richard Guo (richardguo) | wenhui qiu (wenhuiqiu) | | 11 | 8 months ago |
| Retiring is_pushed_down | 4458 | Moved to next CF | | Needs rebase! | | Richard Guo (richardguo) | Tom Lane (tgl) | | 10 | 4 months ago |
| BitmapHeapScan table AM violation removal (and use read API) | 4874 | Committed | | 7/7 | +826−911 | Melanie Plageman (melanieplageman) | Heikki Linnakangas (heikki), Andres Freund (andresfreund), Tomas Vondra (fuzzycz) | Melanie Plageman (melanieplageman) | 6 | 1 month ago |
| Use XLOG_CONTROL_FILE macro everywhere | 4941 | Committed | 18 | 7/7 | +30−9 | Anton Melnikov (antonmel) | Daniel Gustafsson (d_gustafsson) | Fujii Masao (masaofujii) | 5 | 1 month ago |
| Make ECPG locale usage thread-safe | 5166 | Moved to next CF | | Needs rebase! | | Thomas Munro (macdice) | Peter Eisentraut (petere) | | 5 | 1 month ago |
| Thread-safe nl_langinfo(), localeconv(), check_locale() | 5170 | Committed | | 7/7 | +71−52 | Thomas Munro (macdice) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 4 | 1 month ago |
| Refactor SLRU to always use long file names | 5250 | Moved to next CF | | 7/7 | +103−85 | Aleksander Alekseev (a.alekseev) | Rustam ALLAKOV (rustam.allakov) | | 4 | 1 month ago |
| Refactor bytea_sortsupport() | 5288 | Returned with feedback | | Not processed | | Aleksander Alekseev (a.alekseev) | | | 3 | 5 months ago |
| Collation and ctype method tables and extension hooks | 5301 | Moved to next CF | | Needs rebase! | | Jeff Davis (jdavis) | | | 4 | 4 months ago |
| Adopt <inttypes.h> macros in format strings. | 5429 | Committed | | Needs rebase! | | Thomas Munro (macdice) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 1 month ago |
| Clarify FileTag-based unlinking | 5454 | Moved to next CF | | 7/7 | +10−7 | Matthias van de Meent (mmeent) | | | 3 | 4 months ago |
| Don't dirty pages while they are getting flushed out | 5483 | Moved to next CF | | Needs rebase! | | Andres Freund (andresfreund) | | | 3 | 1 month ago |
| Getting rid of CaseTestExpr | 5531 | Withdrawn | | Not processed | | Tom Lane (tgl) | | | 1 | 3 months ago |
| ctype method table | 5559 | Withdrawn | 18 | Not processed | | Jeff Davis (jdavis) | | | 1 | 3 months ago |
| Elimination of the repetitive code at the SLRU bootstrap functions | 5575 | Moved to next CF | 18 | 6/7 | +78−255 | Evgeny Voropaev (evoro) | Álvaro Herrera (alvherre), Aleksander Alekseev (a.alekseev), Andrey Borodin (x4mmm) | | 2 | 2 months ago |
| Remove wal_[sync|write][_time] from pg_stat_wal and track_wal_io_timing | 5579 | Committed | 18 | 7/7 | +30−227 | Bertrand Drouvot (bertranddrouvot.pg) | | Michael Paquier (michael-kun) | 1 | 2 months ago |
| Extend postgres_fdw_get_connections to return remote backend pid | 5581 | Committed | | 7/7 | +76−32 | Sagar Shedge (sdshedge) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 1 | 2 months ago |
| moving some code out of explain.c | 5584 | Committed | | 7/7 | +0−0 | Robert Haas (rhaas) | | Robert Haas (rhaas) | 1 | 2 months ago |
| Replication & Recovery |
|---|
| CREATE SUBSCRIPTION ... SERVER | 4529 | Moved to next CF | | Needs rebase! | | Jeff Davis (jdavis) | vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) | | 10 | 1 month ago |
| Introduce XID age and inactive timeout based replication slot invalidation | 4770 | Committed | | Needs rebase! | | Bharath Rupireddy (bharathrupireddy), Nisha Moond (nishamoond) | Nathan Bossart (bossartn), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) | Amit Kapila (amitkapila) | 6 | 2 months ago |
| Return pg_control from pg_backup_stop(). | 4997 | Moved to next CF | 18 | 6/7 | +181−30 | David Steele (dsteele) | | | 6 | 3 months ago |
| Synchronization of sequences to subscriber | 5111 | Moved to next CF | | 6/7 | +2986−738 | vigneshwaran C (vignesh.postgres) | Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Peter Smith (smithpb2250) | | 5 | 2 days ago |
| Skip logical decoding of already-aborted transactions. | 5338 | Committed | | Not processed | | Masahiko Sawada (masahikosawada) | vigneshwaran C (vignesh.postgres) | Masahiko Sawada (masahikosawada) | 3 | 2 months ago |
| Conflict detection for update_deleted in logical replication | 5378 | Moved to next CF | | 7/7 | +2178−169 | Zhijie Hou (houzj) | Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres) | Amit Kapila (amitkapila) | 3 | 2 days ago |
| Adding a '--two-phase' option to 'pg_createsubscriber' utility. | 5433 | Committed | | Needs rebase! | | Shubham Khanna (skhanna) | vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) | Amit Kapila (amitkapila) | 2 | 2 months ago |
| Separate GUC for replication origins | 5441 | Committed | 18 | 7/7 | +92−92 | Euler Taveira (eulerto) | Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres) | Masahiko Sawada (masahikosawada) | 2 | 1 month ago |
| Enable logical decoding when wal_level = 'replica' without a server restart | 5479 | Moved to next CF | | Needs rebase! | | Masahiko Sawada (masahikosawada) | | | 3 | 5 hours ago |
| Log a warning in pg_createsubscriber for max_slot_wal_keep_size | 5496 | Committed | | 7/7 | +26−0 | Shubham Khanna (skhanna) | Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250) | Amit Kapila (amitkapila) | 1 | 3 months ago |
| Don't ignore recovery conflict interrupt on blocked writing | 5504 | Withdrawn | | Needs rebase! | | Anthonin Bonnefoy (bonnefoa) | | | 1 | 3 months ago |
| SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica | 5513 | Withdrawn | 18 | 7/7 | +215−140 | Mikhail Litsarev (mikhail.litsarev) | | | 1 | 1 month ago |
| Allow pg_createsubscriber to drop replication objects from new subscriber | 5541 | Committed | | 6/7 | +128−17 | Shubham Khanna (khannashubham) | David Johnston (polobo), Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) | Amit Kapila (amitkapila) | 1 | 1 month ago |
| Enhance 'pg_createsubscriber' to retrieve databases | 5566 | Committed | | 7/7 | +351−21 | Shubham Khanna (khannashubham) | Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) | Amit Kapila (amitkapila) | 1 | 1 month ago |
| Filter irrelevant change before reassemble transactions during logical decoding | 5585 | Moved to next CF | | 7/7 | +770−71 | Jie Li (adger), Ajin Cherian (ajinc), Zhijie Hou (houzj) | vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 2 | 2 days ago |
| Conflict detection for multiple_unique_conflicts in logical replication | 5591 | Committed | | 7/7 | +0−0 | Nisha Moond (nishamoond) | Hayato Kuroda (ha-kun) | Amit Kapila (amitkapila) | 1 | 1 month ago |
| Filter irrelevant change before reassemble transactions during logical decoding | 5592 | Withdrawn | | 7/7 | +0−0 | Jie Li (adger), Ajin Cherian (ajinc), Zhijie Hou (houzj) | | Amit Kapila (amitkapila) | 1 | 2 days ago |
| Security |
|---|
| Client authentication via OAuth 2.0 | 4412 | Committed | | 7/7 | +0−0 | Jacob Champion (jchampion) | Peter Eisentraut (petere), Daniel Gustafsson (d_gustafsson), Antonin Houska (a.houska) | Daniel Gustafsson (d_gustafsson) | 10 | 1 week ago |
| Make query cancellation keys longer | 4870 | Committed | | 7/7 | +786−161 | Heikki Linnakangas (heikki), Jelte Fennema-Nio (jeltef) | | Heikki Linnakangas (heikki) | 4 | 1 month ago |
| Extend ALTER DEFAULT PRIVILEGES for large objects | 4945 | Committed | | 7/7 | +20−0 | Yugo Nagata (yugo.nagata) | Fujii Masao (masaofujii), Laurenz Albe (laurenz) | Fujii Masao (masaofujii) | 5 | 1 month ago |
| Serverside SNI for SSL connections | 4984 | Moved to next CF | | 5/7 | +937−50 | Daniel Gustafsson (d_gustafsson) | Jacob Champion (jchampion) | | 6 | 5 days ago |
| Extension security improvement: Add support for extensions with an owned schema | 5018 | Moved to next CF | 18 | 6/7 | +326−62 | Jelte Fennema-Nio (jeltef) | | | 6 | 7 months ago |
| revamp row-security tracking | 5397 | Moved to next CF | 19 | 6/7 | +25−17 | Nathan Bossart (bossartn) | | | 3 | 3 months ago |
| Modern SHA2- based password hashes for pgcrypto | 5481 | Committed | 18 | 7/7 | +1164−2 | Bernd Helmle (psoo) | | Álvaro Herrera (alvherre) | 2 | 1 month ago |
| pgcrypto: support for CFB mode in AES encryption | 5529 | Committed | 18 | Not processed | | Umar Hayat (pgwizard) | Álvaro Herrera (alvherre), Daniel Gustafsson (d_gustafsson) | Daniel Gustafsson (d_gustafsson) | 1 | 3 months ago |
| Server Features |
|---|
| Sequence Access Methods, round two | 4677 | Moved to next CF | | 7/7 | +2753−795 | Michael Paquier (michael-kun) | | | 8 | 2 weeks ago |
| Add new protocol message to change GUCs to be able to change protocol extension parameters | 4736 | Withdrawn | 18 | Needs rebase! | | Jelte Fennema-Nio (jeltef) | Robert Haas (rhaas) | | 7 | 2 months ago |
| COPY ON_ERROR 'NULL' | 4810 | Moved to next CF | | 7/7 | +277−52 | jian he (universality) | Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Jim Jones (jimus) | | 7 | 1 month ago |
| on_error table, saving error info to a table | 4817 | Moved to next CF | | 7/7 | +582−13 | jian he (hellothere) | Nishant Sharma (nishant-at-edb) | | 7 | 3 weeks ago |
| Eager aggregation, take 3 | 4881 | Moved to next CF | 19 | Needs rebase! | | Richard Guo (richardguo) | | | 6 | 3 months ago |
| CREATE DATABASE ... STRATEGY=FILE_CLONE | 4886 | Committed | | 2/7 | +170−3 | Thomas Munro (macdice), Nazir Bilal Yavuz (nbyavuz) | | Thomas Munro (macdice) | 5 | 1 month ago |
| Add extension_destdir GUC | 4913 | Committed | | 6/7 | +29−4 | Peter Eisentraut (petere), Christoph Berg (myon), David Wheeler (theory) | Peter Eisentraut (petere), Marco Nenciarini (mnencia), Gabriele Bartolini (gbartolini), Nathan Bossart (bossartn) | Peter Eisentraut (petere) | 5 | 1 month ago |
| CREATE INDEX CONCURRENTLY for partitioned tables | 5004 | Moved to next CF | | 2/7 | +520−78 | Justin Pryzby (justinpryzby), Ilya Gladyshev (qoops) | | | 6 | 6 months ago |
| Index AM API cleanup | 5195 | Committed | | 6/7 | +399−334 | Mark Dilger (mark.dilger) | Peter Eisentraut (petere), Andrew Dunstan (adunstan), Alexandra Wang (l-wang) | Peter Eisentraut (petere) | 4 | 1 month ago |
| Make MultiXactOffset 64-bit type | 5205 | Moved to next CF | 18 | 7/7 | +102−0 | Maxim Orlov (m.orlov) | Heikki Linnakangas (heikki) | | 5 | 2 weeks ago |
| Add column name to error description | 5266 | Committed | 18 | 0/1 | +0−0 | Marcos Pegoraro (pegorarof10), Jian He (stayreal) | Vladlen Popolitov (vladlenpopolitov) | Tom Lane (tgl) | 3 | 2 months ago |
| NOT ENFORCED constraint feature | 5285 | Committed | 18 | 7/7 | +1048−286 | Amul Sul (sulamul) | Peter Eisentraut (petere), Alexandra Wang (alexandrawang) | Peter Eisentraut (petere) | 3 | 1 month ago |
| Changing shared_buffers without restart | 5319 | Moved to next CF | | Needs rebase! | | Dmitry Dolgov (erthalion) | Vladlen Popolitov (vladlenpopolitov) | | 4 | 5 days ago |
| Support enabling checksums online | 5323 | Moved to next CF | | Needs rebase! | | Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) | Tomas Vondra (fuzzycz) | | 4 | 1 month ago |
| using index to speedup add not null constraints to a table | 5444 | Moved to next CF | 18 | 7/7 | +630−5 | Jian He (stayreal) | Tanzeel Khan (tanzeelk) | | 3 | 4 days ago |
| refactor AlterDomainAddConstraint (alter domain add constraint) | 5455 | Moved to next CF | 18 | 6/7 | +79−8 | Jian He (stayreal) | Peter Eisentraut (petere) | | 3 | 2 months ago |
| WAL-logging facility for pgstats kinds | 5466 | Withdrawn | 18 | Not processed | | Michael Paquier (michael-kun) | | | 2 | 3 months ago |
| speedup COPY TO for partitioned table | 5467 | Moved to next CF | 19 | 7/7 | +151−32 | Jian He (stayreal) | vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), newtglobal postgresql_contributors (newtpostgrescontributors) | | 3 | 1 month ago |
| Proposal: Progressive explain | 5473 | Returned with feedback | | Needs rebase! | | Rafael Castro (rafaelthca) | Robert Haas (rhaas) | | 2 | 1 month ago |
| SQL/JSON json_table PLAN clause | 5478 | Moved to next CF | 18 | 7/7 | +2308−168 | Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrew Dunstan (adunstan), Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Anton Melnikov (antonmel), Nikita Malakhov (nmalakh) | Amit Langote (amitlan), Vladlen Popolitov (vladlenpopolitov) | | 3 | 1 month ago |
| Extended Statistics set/restore/clear functions | 5517 | Moved to next CF | | 6/7 | +2961−35 | Corey Huinker (coreyh) | | | 2 | 1 month ago |
| add function argument name to substring and substr | 5524 | Moved to next CF | | 6/7 | +135−25 | Jian He (stayreal) | David Johnston (polobo) | | 2 | 1 month ago |
| COPY materialized view TO | 5533 | Committed | | 7/7 | +39−15 | Jian He (stayreal) | vigneshwaran C (vignesh.postgres), newtglobal postgresql_contributors (newtpostgrescontributors) | Fujii Masao (masaofujii) | 1 | 1 month ago |
| SCRAM pass-through authentication for dblink connections | 5534 | Committed | | 7/7 | +503−9 | Matheus Alcantara (matheus.alcantara) | | Peter Eisentraut (petere) | 1 | 1 month ago |
| Cross-type index comparison support in contrib/btree_gin | 5535 | Moved to next CF | | 6/7 | +2548−116 | Tom Lane (tgl) | | | 2 | 1 month ago |
| support virtual generated column not null constraint | 5578 | Committed | | 7/7 | +384−123 | Jian He (stayreal) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 1 month ago |
| making EXPLAIN extensible | 5613 | Committed | | 7/7 | +0−0 | Robert Haas (rhaas) | | Robert Haas (rhaas) | 1 | 1 month ago |
| SQL Commands |
|---|
| Add XMLCanonicalize function | 4237 | Moved to next CF | 18 | 7/7 | +398−0 | Jim Jones (jimus) | Pavel Stehule (okbobcz), Oliver Ford (ojford), newtglobal postgresql_contributors (newtpostgrescontributors) | | 11 | 1 month ago |
| SQL:2011 application time | 4308 | Committed | | Needs rebase! | | Paul Jungwirth (pjungwir) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 10 | 1 week ago |
| Incremental View Maintenance (IVM), take 2 | 4337 | Moved to next CF | | Needs rebase! | | Yugo Nagata (yugo.nagata) | | | 11 | 8 months ago |
| Implement row pattern recognition feature | 4460 | Moved to next CF | 19 | 7/7 | +4207−35 | Tatsuo Ishii (ishii) | Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033) | | 10 | 1 week ago |
| SQL Property Graph Queries (SQL/PGQ) | 4904 | Moved to next CF | | Needs rebase! | | Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat) | Vik Fearing (xocolatl), Zhao Junwang (zhjwpku) | | 6 | 1 month ago |
| Virtual generated columns | 4972 | Committed | | Not processed | | Peter Eisentraut (petere) | | Peter Eisentraut (petere) | 5 | 2 months ago |
| Add XMLCast (SQL/XML X025) | 5110 | Moved to next CF | 18 | 3/7 | +2201−9 | Jim Jones (jimus) | Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) | | 5 | 2 months ago |
| Support POSITION with nondeterministic collations | 5209 | Committed | | 7/7 | +247−48 | Peter Eisentraut (petere) | | Peter Eisentraut (petere) | 4 | 2 months ago |
| SQL:2023 JSON simplified accessor support | 5214 | Moved to next CF | 18 | 7/7 | +1567−202 | Alexandra Wang (alexandrawang) | Peter Eisentraut (petere), Vik Fearing (xocolatl) | | 5 | 3 weeks ago |
| Add IGNORE NULLS to Window functions | 5230 | Moved to next CF | 18 | 7/7 | +773−28 | Oliver Ford (ojford) | Krasiyan Andreev (krasiyan) | | 4 | 1 month ago |
| Add parameter in jsonb_strip_nulls(jsonb, bool) to strip nulls from arrays | 5260 | Committed | | 7/7 | +95−5 | Florents Tselai (florentst) | Andrew Dunstan (adunstan) | Andrew Dunstan (adunstan) | 3 | 2 months ago |
| Introduce the ability to enable/disable indexes using ALTER INDEX | 5274 | Moved to next CF | 18 | 6/7 | +1703−26 | Shayon Mukherjee (shayonj) | Sami Imseih (simseih), newtglobal postgresql_contributors (newtpostgrescontributors) | | 4 | 2 weeks ago |
| general purpose array_sort | 5277 | Committed | 18 | 7/7 | +425−0 | Zhao Junwang (zhjwpku) | Tom Lane (tgl) | Tom Lane (tgl) | 3 | 1 month ago |
| Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) | 5279 | Moved to next CF | 18 | 6/7 | +738−32 | Jim Jones (jimus) | newtglobal postgresql_contributors (newtpostgrescontributors) | | 4 | 2 months ago |
| Add XMLDocument (SQL/XML X030) | 5431 | Moved to next CF | 18 | 7/7 | +258−1 | Jim Jones (jimus) | Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) | | 3 | 3 months ago |
| Allow subfield references without parentheses | 5449 | Returned with feedback | | Not processed | | Peter Eisentraut (petere) | | | 2 | 5 months ago |
| Add XMLNamespaces option to XMLElement | 5456 | Moved to next CF | 18 | 6/7 | +1200−34 | Pavel Stehule (okbobcz), Jim Jones (jimus) | Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) | | 3 | 2 months ago |
| NOT VALID foreign key constraints on partitioned tables | 5503 | Committed | 18 | 0/1 | +0−0 | Amul Sul (sulamul) | | Álvaro Herrera (alvherre) | 1 | 3 months ago |
| Support for NO INHERIT to INHERIT state change with named NOT NULL constraints | 5528 | Committed | 18 | 7/7 | +901−16 | Suraj Kharage (surajk) | | Álvaro Herrera (alvherre) | 1 | 1 month ago |
| Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints | 5554 | Committed | 18 | 7/7 | +1101−106 | Rushabh Lathia (rlathia) | | Álvaro Herrera (alvherre) | 1 | 1 month ago |
| CREATE FOREIGN TABLE LIKE | 5557 | Committed | 18 | 6/7 | +244−12 | Mingli Zhang (zml) | Álvaro Herrera (alvherre), Sami Imseih (simseih) | Michael Paquier (michael-kun) | 1 | 2 months ago |
| System Administration |
|---|
| Reduce the log spam by excluding certain SQLSTATEs | 4964 | Withdrawn | 18 | 7/7 | +218−0 | Laurenz Albe (laurenz) | Jim Jones (jimus) | | 5 | 1 month ago |
| New GUC autovacuum_max_threshold | 5046 | Committed | 18 | Not processed | | Nathan Bossart (bossartn), Frédéric Yhuel (yhuelf) | Nathan Bossart (bossartn), wenhui qiu (qiuwenhuifx.163.com) | Nathan Bossart (bossartn) | 5 | 3 months ago |
| pg_upgrade: Support for upgrading to checksums enabled | 5206 | Returned with feedback | | Needs rebase! | | Peter Eisentraut (petere) | Nathan Bossart (bossartn), Ilya Kosmodemiansky (hydrobiont) | | 4 | 1 month ago |
| log_min_messages per backend type | 5447 | Moved to next CF | 18 | 2/7 | +352−25 | Euler Taveira (eulerto) | | | 3 | 2 months ago |
| Improve verification of recovery_target_timeline GUC. | 5519 | Moved to next CF | 19 | 7/7 | +64−3 | David Steele (dsteele) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 2 | 3 weeks ago |
| vacuumdb changes for stats import/export | 5523 | Committed | 18 | 7/7 | +406−139 | Corey Huinker (coreyh), Nathan Bossart (bossartn) | | Nathan Bossart (bossartn) | 1 | 1 month ago |
| add vacuum_truncate GUC | 5605 | Committed | 18 | 7/7 | +116−15 | Nathan Bossart (bossartn), Gurjeet Singh (gurjeet) | Fujii Masao (masaofujii) | Nathan Bossart (bossartn) | 1 | 1 month ago |
| Testing |
|---|
| CREATE SUBSCRIPTION - add missing test case | 5190 | Committed | | 6/7 | +14−0 | Peter Smith (smithpb2250) | vigneshwaran C (vignesh.postgres) | Heikki Linnakangas (heikki) | 4 | 1 month ago |
| Allow CI to only run the compiler warnings task | 5249 | Moved to next CF | 18 | 7/7 | +14−13 | Bertrand Drouvot (bertranddrouvot.pg) | | | 4 | 2 months ago |
| Improve code coverage of network address functions | 5354 | Committed | 18 | Not processed | | Aleksander Alekseev (a.alekseev) | Jacob Champion (jchampion), keisuke kuroda (keisuke.kuroda.3862) | Michael Paquier (michael-kun) | 3 | 3 months ago |
| Add NetBSD and OpenBSD OSes to Postgres CI | 5360 | Committed | | Needs rebase! | | Nazir Bilal Yavuz (nbyavuz) | | Andres Freund (andresfreund) | 3 | 1 month ago |
| Add 'make check-tests' behavior to the meson based builds | 5405 | Moved to next CF | | 7/7 | +16−6 | Nazir Bilal Yavuz (nbyavuz) | Ashutosh Bapat (ashutoshbapat), Jian He (stayreal) | | 3 | 1 month ago |
| Disable installcheck for tap and regress tests for injection_points module | 5410 | Withdrawn | 18 | 2/7 | +77−0 | Michail Nikolaev (nkey) | | | 2 | 2 months ago |
| Parallel tests publication and subscription might fail due to concurrent tuple update | 5459 | Rejected | 16 | 6/7 | +4−2 | Jelte Fennema-Nio (jeltef) | | | 2 | 1 month ago |
| tests for pg_stat_progress_copy.tuples_skipped | 5536 | Committed | stable | 7/7 | +17−4 | Jian He (stayreal) | | Fujii Masao (masaofujii) | 1 | 2 months ago |
| Add regression tests of ecpg command notice (error / warning) | 5543 | Committed | 18 | 7/7 | +138−0 | Ryo Kanbayashi (ryokanbayashi) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 1 | 2 months ago |
| Injection points for HashAgg | 5560 | Committed | 18 | Needs rebase! | | Jeff Davis (jdavis) | | Jeff Davis (jdavis) | 1 | 3 months ago |
| Fix 035_standby_logical_decoding.pl race conditions | 5568 | Committed | 18 | Needs rebase! | | Bertrand Drouvot (bertranddrouvot.pg) | | Amit Kapila (amitkapila) | 1 | 1 month ago |
| Cover POSITION(bytea,bytea) with tests | 5603 | Committed | | 6/7 | +36−0 | Aleksander Alekseev (a.alekseev) | Rustam ALLAKOV (rustam.allakov) | David Rowley (davidrowley) | 1 | 1 month ago |