| Bug Fixes |
|---|
| Incorrect error message for cancellation triggered by statement_timeout & flaky test | 5070 | Needs review | Bugfix Flakyfix | stable |   10/10 | +16−5 | Jelte Fennema-Nio (jeltef) | | | 8 | 7 months ago |
| DirtyScanshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication | 5151 | Needs review | Bugfix Logical Replication | stable | 10/10 | +604−46 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Luan Silva (luansilva) | | 6 | 3 weeks ago |
| Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY | 5160 | Needs review | Bugfix | stable | 10/10 | +1567−50 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | | | 6 | 4 months ago |
| bt_index_parent_check false alarm for indexes created concurrently | 5438 | Ready for Committer | Bugfix Backport | | 10/10 | +70−40 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Andrey Borodin (x4m) | | 5 | 2 weeks ago |
| Improve ACL checks in pg_prewarm for indexes | 5583 | Ready for Committer | | | 10/10 | +105−39 | Ayush Vatsa (developerayuva) | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 4 | 35 minutes ago |
| Random pg_upgrade 004_subscription test failure on drongo | 5673 | Needs review | | | 10/10 | +25−0 | vigneshwaran C (vignesh.postgres) | | | 3 | 2 weeks ago |
| Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION | 5681 | Needs review | | | 10/10 | +132−19 | Yugo Nagata (yugo.nagata) | Jim Jones (jimus), Daniil Davydov (dddaniil) | | 3 | 1 week ago |
| temporary file usage report with extended protocol and unnamed portals | 5724 | Ready for Committer | | |  9/10 | +116−0 | Sami Imseih (simseih), Frédéric Yhuel (yhuelf) | Mircea Cadariu (mcadariu) | | 3 | yesterday |
| problems with toast.* reloptions | 5839 | Waiting on Author | | stable | Needs rebase! | | Nathan Bossart (bossartn) | | | 3 | 2 months ago |
| Decouple C++ support in Meson's PGXS from LLVM enablement | 5885 | Needs review | Good First Review | stable | 8/10 | +24−14 | Tristan Partin (tristan957) | Jelte Fennema-Nio (jeltef) | Peter Eisentraut (petere) | 2 | 1 week ago |
| Fixing the btree_gist inet mess | 5944 | Needs review | | 19 | 10/10 | +117−7 | Tom Lane (tgl) | Peter Eisentraut (petere) | | 2 | 2 months ago |
| Panic during xlog building with big values | 5970 | Needs review | Bugfix | 19 | 10/10 | +51−0 | Maksim Melnikov (manaldush) | Andy Pogrebnoi (birdofdada) | | 2 | 2 weeks ago |
| disallow alter individual column if partition key contains wholerow reference | 5988 | Needs review | Bugfix Backport | 18 | 10/10 | +36−0 | Jian He (stayreal) | Matt Dailis (mattdailis) | | 2 | 2 weeks ago |
| Fix ALTER TABLE DROP EXPRESSION with ONLY option | 5992 | Ready for Committer | | stable | 10/10 | +36−5 | Jian He (stayreal) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 1 month ago |
| Fix a bug where ALTER SYSTEM SET with empty strings for GUC_LIST_QUOTE parameters (like shared_preload_libraries) results in malformed configuration entries that cause server crashes on restart. | 6026 | Needs review | Bugfix | stable | 10/10 | +104−12 | Andrew Klychkov (andreiklychkov) | | | 1 | 1 month ago |
| fix NOT VALID NOT NULL with ALTER COLUMN SET IDENTITY | 6030 | Needs review | Bugfix Backport | 18 | 10/10 | +37−0 | Jian He (stayreal) | | | 1 | 1 month ago |
| UPDATE with invalid domain constraint | 6031 | Needs review | Bugfix Backport | stable | 10/10 | +114−0 | Jian He (stayreal) | | | 1 | 1 month ago |
| Fix race condition in SSI when reading PredXact->SxactGlobalXmin | 6037 | Needs review | Bugfix Backport My First Patch | stable | 10/10 | +15−13 | Josh Curtis (joshcurtis) | | | 1 | 3 days ago |
| Fix read/write races with pg_control file in case when postgres was compiled with DEXEC_BACKEND option | 6040 | Needs review | Bugfix | 19 | 10/10 | +32−1 | Maksim Melnikov (manaldush) | | | 1 | 1 month ago |
| Fix pg_rewind false positives caused by shutdown-only WAL | 6041 | Needs review | Bugfix | | 9/10 | +29−7 | Srinath Reddy (srinath-reddy-sadipiralla) | | | 1 | 1 week ago |
| PostgreSQL crashes with ThreadSanitizer during early initialization | 6044 | Needs review | Bugfix My First Patch | | 9/10 | +62−28 | Emmanuel Sibi (emmanuelsibi) | | | 1 | 2 weeks ago |
| let ALTER TABLE DROP COLUMN drop whole-row referenced object | 6055 | Needs review | Bugfix Backport | stable | 10/10 | +492−3 | Jian He (stayreal) | | | 1 | 2 weeks ago |
| meson: Fix libpq search order | 6056 | Needs review | | | 10/10 | +37−35 | Thomas Munro (macdice) | | | 1 | 22 hours ago |
| MultiXact corruption and standby deadlock | 6070 | Needs review | Bugfix | | 10/10 | +123−144 | Andrey Borodin (x4m) | | | 1 | 1 month ago |
| We broke the defense against accessing other sessions' temp tables | 6073 | Needs review | | 17 | 10/10 | +13−11 | Tom Lane (tgl) | Jim Jones (jimus) | | 1 | 4 days ago |
| Add assertion for bmr.rel in ExtendBufferedRelTo function | 6075 | Needs review | Bugfix | 16 | Not processed | | Алена Васильева (eugenygoryachev) | | | 1 | 3 weeks ago |
| Fix const-simplification for index expressions and predicate | 6092 | Needs review | Bugfix | 19 | 10/10 | +102−10 | Richard Guo (richardguo) | | | 1 | 2 weeks ago |
| Fix pushdown of degenerate HAVING clauses | 6093 | Needs review | Bugfix | 18 | 10/10 | +57−7 | Richard Guo (richardguo) | | | 1 | 2 weeks ago |
| LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue | 6095 | Needs review | Bugfix Help - Bikeshedding | | 10/10 | +525−1 | Matheus Alcantara (matheus.alcantara) | Arseniy Mukhin (amukhin) | | 1 | 1 week ago |
| ecpg: check return value of replace_variables() | 6110 | Needs review | Bugfix | 19 | 9/10 | +7−1 | Aleksander Alekseev (a.alekseev) | | | 1 | 11 hours ago |
| Preserve index stats during ALTER TABLE ... TYPE ... | 6118 | Needs review | Bugfix | 19 | 10/10 | +157−4 | Bertrand Drouvot (bertranddrouvot.pg) | | | 1 | 3 hours ago |
| Clients |
|---|
| psql: Rethinking of \du command | 4738 | Needs review | | | 10/10 | +72−126 | Pavel Luzanov (p.luzanov@postgrespro.ru) | David Johnston (polobo), Wen Yi (wenyi) | | 8 | 3 months ago |
| libpq: Fix processing of SSL records >8kB on async API | 5251 | Needs review | Bugfix Backport | stable | 10/10 | +318−8 | Jacob Champion (jchampion), Lars Kanis (larsk) | Jacob Champion (jchampion) | | 6 | 2 months ago |
| psql: tab-completion support for COPY ... TO/FROM STDIN, STDOUT, and PROGRAM | 5800 | Needs review | | 19 | 10/10 | +124−29 | Yugo Nagata (yugo.nagata) | Masahiko Sawada (masahikosawada) | | 3 | 3 days ago |
| Improve tab completion for various SET/RESET forms | 5810 | Waiting on Author | | 19 | 10/10 | +49−9 | Dagfinn Ilmari Mannsåker (ilmari) | Shinya Kato (shinyakato) | | 2 | 1 month ago |
| Add prompt option to display read-only and read/write states in psql | 5872 | Ready for Committer | psql | 19 | 10/10 | +30−0 | Jim Jones (jimus) | Srinath Reddy (srinath-reddy-sadipiralla) | | 3 | 2 months ago |
| Making pg_rewind faster | 5902 | Waiting on Author | Performance | 19 | 8/10 | +254−97 | Justin Kwan (justinpkwan.outlook.com), John Hsu (johnhsu) | | | 3 | 11 hours ago |
| pgbench: extend variable usage in scripts | 6012 | Needs review | | 19 | 9/10 | +130−15 | Yugo Nagata (yugo.nagata) | | | 2 | 3 weeks ago |
| Code Comments |
|---|
| Add comments about fire_triggers argument in ri_triggers.c | 5679 | Needs review | | | 10/10 | +7−1 | Yugo Nagata (yugo.nagata) | | | 3 | 6 months ago |
| Improve coments on structures in trigger.c | 5680 | Waiting on Author | | | 10/10 | +47−40 | Yugo Nagata (yugo.nagata) | Phil Alger (paalger) | | 3 | 4 days ago |
| Fix incorrect comment in pg_get_shmem_allocations_numa() | 5927 | Needs review | | 19 | 10/10 | +6−9 | Bertrand Drouvot (bertranddrouvot.pg) | | | 2 | 2 months ago |
| Update parser README to include parse_jsontable.c | 6036 | Needs review | Comments Only | 19 | Needs rebase! | | Karthik S (karthikselvaam.gmail.com) | | | 1 | 1 month ago |
| Documentation |
|---|
| Docs and tests for RLS policies applied by command type | 5851 | Needs review | Testing | 19 | 10/10 | +394−13 | Dean Rasheed (deanr) | | | 3 | 6 months ago |
| docs: Update protocol changes checklist with 3.2 changes | 5863 | Needs review | Docs Only | 18 | 10/10 | +138−84 | Dave Cramer (dcramer), Jelte Fennema-Nio (jeltef) | | | 3 | 1 month ago |
| Document DSM Registry | 5914 | Waiting on Author | Docs Only | 19 | 10/10 | +46−17 | Florents Tselai (florentst) | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 2 | 3 days ago |
| ALTER TABLE ... OWNER TO affects permissions too | 5915 | Needs review | Good First Review Docs Only | 19 | 10/10 | +2−0 | Laurenz Albe (laurenz) | Shuntian Jiao (jiaoshuntian) | | 2 | 1 year ago |
| JIT works only partially with meson build | 5984 | Ready for Committer | Docs Only | | 10/10 | +12−2 | Yugo Nagata (yugo.nagata) | Laurenz Albe (laurenz) | | 2 | 1 week ago |
| CREATE/ALTER PUBLICATION improvements for syntax synopsis | 6062 | Needs review | Docs Only | stable | 10/10 | +2−2 | Peter Smith (smithpb2250) | | | 1 | 3 weeks ago |
| DOCS: What SGML markup to use for user objects like tables, columns, etc? | 6063 | Needs review | Docs Only | stable | 9/10 | +166−166 | Peter Smith (smithpb2250) | | | 1 | 3 weeks ago |
| Doc: add XML ID attributes to <varlistentry> tags for create_foreign_table, alter_foreign_table | 6071 | Needs review | Docs Only | stable | 10/10 | +56−56 | Jian He (stayreal) | | | 1 | 2 weeks ago |
| Clarify EXPLAIN ANALYZE docs on fractional rows and parallelism | 6090 | Needs review | | | 10/10 | +76−4 | Tom Lane (tgl), Maciek Sakrejda (msakrejda) | | | 1 | 1 week ago |
| doc: Improve description of io_combine_limit and io_max_combine_limit GUCs | 6115 | Needs review | Backport Docs Only | | 10/10 | +4−0 | Karina Litskevich (karinalitskevich) | Chao Li (chaol) | | 1 | yesterday |
| Miscellaneous |
|---|
| Support a wildcard in backtrace_functions | 4735 | Needs review | GUC Help - Bikeshedding | | Needs rebase! | | Jelte Fennema-Nio (jeltef) | Daniel Gustafsson (d_gustafsson), Bharath Rupireddy (bharathrupireddy) | Daniel Gustafsson (d_gustafsson) | 10 | 6 months ago |
| Avoid orphaned objects dependencies, take 3 | 4942 | Needs review | | 18 | Needs rebase! | | Bertrand Drouvot (bertranddrouvot.pg) | | | 8 | 4 months ago |
| Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup | 5570 | Needs review | | | 3/10 | +243−45 | Jelte Fennema-Nio (jeltef) | | | 4 | 5 months ago |
| Produce LLVM bitcode files on meson builds | 5671 | Needs review | Performance | 19 | Needs rebase! | | Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) | | | 3 | 1 month ago |
| Add pg_buffercache_mark_dirty[_all]() functions to the pg_buffercache | 5694 | Needs review | | | 10/10 | +497−10 | Nazir Bilal Yavuz (nbyavuz) | Aidar Imamov (gipergeek) | | 3 | 2 months ago |
| Add --continue-on-abort option to pgbench | 5790 | Ready for Committer | | 19 | 9/10 | +133−29 | Yugo Nagata (yugo.nagata), Rintaro Ikeda (rintaro) | Yugo Nagata (yugo.nagata), Hayato Kuroda (ha-kun) | Fujii Masao (masaofujii) | 3 | 1 week ago |
| pgindent: improve formatting of multiline comments | 5831 | Needs review | | 19 | 10/10 | +29−0 | Aleksander Alekseev (a.alekseev) | | | 3 | 3 months ago |
| update-po for PGXS does not work | 5922 | Needs review | Bugfix Good First Review | | 10/10 | +5−0 | Álvaro Herrera (alvherre), Ryo Matsumura (ryo) | | | 2 | 1 year ago |
| Enhance Makefiles to rebuild objects on map file changes | 5953 | Needs review | | 19 | 10/10 | +97−0 | Chao Li (chaol) | | | 2 | yesterday |
| Enhance statistics reset functions to return reset timestamp | 5956 | Needs review | | 19 | Needs rebase! | | Shinya Kato (shinyakato) | | | 2 | 4 weeks ago |
| Add process updating for GNU/Hurd | 6013 | Needs review | | | 10/10 | +2−2 | Michael Banck (mbanck) | | | 2 | 1 month ago |
| Use streaming read I/O in BRIN vacuuming | 6022 | Needs review | | | 10/10 | +24−9 | Arseniy Mukhin (amukhin) | Masahiko Sawada (masahikosawada) | | 2 | yesterday |
| Fix an unnecessary cast calling elog in ExecHashJoinImpl | 6027 | Needs review | | | 10/10 | +1−1 | Tender Wang (tndrwang) | | | 1 | 1 month ago |
| Perform check for oversized WAL record before calculating record CRC | 6039 | Needs review | Performance | | 10/10 | +63−13 | Sergey Fukanchik (fukanchik) | | | 1 | 1 month ago |
| Improving the names generated for indexes on expressions | 6059 | Needs review | | | 10/10 | +295−164 | Tom Lane (tgl) | | | 1 | 3 weeks ago |
| Free memory allocated by waitonlock_error_callback() | 6069 | Needs review | | 19 | 10/10 | +2−0 | Aleksander Alekseev (a.alekseev) | | | 1 | 3 weeks ago |
| remove unnecessary include in src/backend/commands/policy.c | 6072 | Needs review | Good First Review | stable | 0/10 | +6−13 | Jian He (stayreal) | Shinya Kato (shinyakato) | | 1 | 1 week ago |
| Allow setting the collation strength in ICU tailoring rules. | 6084 | Needs review | | | 10/10 | +1−1 | Daniel Vérité (danielverite) | | | 1 | 2 weeks ago |
| Make GiST waldump output more descriptive | 6103 | Needs review | | stable | 9/10 | +41−6 | Kirill Reshke (reshke) | | | 1 | 4 days ago |
| add objects file path to oid2name | 6111 | Needs review | | | Needs rebase! | | david bidoc (dwayne) | | | 1 | 2 days ago |
| incremental autovacuum scheduling improvements | 6114 | Needs review | | 19 | 10/10 | +81−12 | Nathan Bossart (bossartn) | | | 1 | 24 minutes ago |
| Add Windows support for backtrace_functions (MSVC only) | 6116 | Needs review | My First Patch | 19 | 10/10 | +172−1 | Bryan Green (lispyone) | | | 1 | yesterday |
| Monitoring & Control |
|---|
| relfilenode statistics | 5007 | Waiting on Author | | 18 | Needs rebase! | | Bertrand Drouvot (bertranddrouvot.pg) | | | 8 | 1 week ago |
| Vacuum statistics | 5012 | Waiting on Author | | 18 | Needs rebase! | | Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) | Ilia Evdokimov (ilidock95) | | 8 | 2 weeks ago |
| Logging plan of the currently running query | 5330 | Needs review | Monitoring | 18 | Needs rebase! | | Atsushi Torikoshi (atsushitorikoshi) | Hironobu Suzuki (suzuki_hironobu), Akshat Jaimini (akshatj), Sadeq Dousti (msdousti) | | 6 | 1 week ago |
| Add storage I/O tracking to EXPLAIN BUFFERS | 5526 | Needs review | Monitoring | 18 | 9/10 | +1148−34 | Atsushi Torikoshi (atsushitorikoshi) | Jelte Fennema-Nio (jeltef) | | 4 | 5 months ago |
| Metadata and record block access stats for indexes | 5614 | Needs review | Monitoring My First Patch Help - User Testing | 19 | Needs rebase! | | Mircea Cadariu (mcadariu) | Frédéric Yhuel (yhuelf) | | 4 | 2 months ago |
| Add os_page_num to pg_buffercache | 5690 | Ready for Committer | | 19 | 10/10 | +383−16 | Bertrand Drouvot (bertranddrouvot.pg) | Mircea Cadariu (mcadariu) | | 3 | 1 month ago |
| amcheck support for BRIN indexes | 5715 | Needs review | | | 10/10 | +2156−30 | Arseniy Mukhin (amukhin) | Tomas Vondra (fuzzycz) | | 3 | 1 month ago |
| Expose internal MultiXact member count function for efficient monitoring | 5811 | Ready for Committer | | 19 | 1/10 | +355−6 | Naga Appani (naga.appani) | Atsushi Torikoshi (atsushitorikoshi) | | 3 | 3 weeks ago |
| Support for basic ALTER TABLE progress reporting. | 5873 | Needs review | Monitoring | | 10/10 | +83−6 | Jiří Kavalík (jkavalik) | Jian He (stayreal) | | 2 | 2 months ago |
| Enhancing Memory Context Statistics Reporting | 5938 | Needs review | | 19 | 9/10 | +1455−41 | Rahila Syed (rahila) | Atsushi Torikoshi (atsushitorikoshi) | | 2 | yesterday |
| Adding locks statistics | 5942 | Needs review | | 19 | 10/10 | +553−4 | Bertrand Drouvot (bertranddrouvot.pg) | | | 2 | 1 month ago |
| Adding per backend commit and rollback counters | 5947 | Needs review | | 19 | 10/10 | +296−2 | Bertrand Drouvot (bertranddrouvot.pg) | | | 2 | 1 month ago |
| Per backend relation statistics tracking | 5958 | Needs review | | 19 | 9/10 | +261−2 | Bertrand Drouvot (bertranddrouvot.pg) | | | 2 | 1 month ago |
| Add mode column to pg_stat_progress_vacuum | 5969 | Needs review | Monitoring | 19 | 10/10 | +59−6 | Shinya Kato (shinyakato) | Nathan Bossart (bossartn) | | 2 | yesterday |
| Add support for entry counting in pgstats | 6052 | Needs review | Monitoring | 19 | Needs rebase! | | Michael Paquier (michael-kun) | Sami Imseih (simseih) | | 1 | 1 week ago |
| Report reorder buffer size | 6053 | Waiting on Author | Monitoring Logical Replication | | 10/10 | +75−11 | Ashutosh Bapat (ashutoshbapat) | Masahiko Sawada (masahikosawada) | | 1 | 2 weeks ago |
| Termination of Background Workers for ALTER/DROP DATABASE | 6102 | Needs review | | | 10/10 | +189−1 | Aya Iwata (iwata.aya) | | | 1 | 8 hours ago |
| Performance |
|---|
| Index Prefetching | 4351 | Waiting on Author | | | 0/1 | +2380−868 | Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) | | | 12 | 3 weeks ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots | 4971 | Needs review | Performance | 19 | 10/10 | +3931−937 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Matthias van de Meent (mmeent) | | 7 | 1 week ago |
| Inline non-SQL SRFs | 5083 | Needs review | | 19 | 10/10 | +755−115 | Paul Jungwirth (pjungwir) | Tom Lane (tgl) | | 5 | 2 months ago |
| Parallel heap vacuum | 5326 | Needs review | | | Needs rebase! | | Masahiko Sawada (masahikosawada) | Hayato Kuroda (ha-kun) | | 6 | 3 weeks ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query | 5487 | Needs review | Performance | 19 | 10/10 | +1487−46 | Alena Rybakina (a.rybakina) | Ilia Evdokimov (ilidock95) | | 4 | 7 hours ago |
| Expanding HOT updates for expression and partial indexes | 5556 | Needs review | Performance | 19 | 10/10 | +2321−143 | Greg Burd (gregburd) | | | 3 | 21 hours ago |
| Introduce RWSpin lock and use it in sinvaladt.c and xlogrecovery.c | 5573 | Needs review | | 18 | 10/10 | +217−42 | Yura Sokolov (funny_falcon) | | | 3 | 1 month ago |
| Lock-free XLog Reservation from WAL | 5633 | Needs review | | | Needs rebase! | | Yura Sokolov (funny_falcon) | | | 2 | 5 months ago |
| Create DATA dump objects for partitioned tables too | 5692 | Needs review | | | 10/10 | +223−41 | Tom Lane (tgl) | | | 3 | 5 months ago |
| Enable auto-vectorization for page checksum calculations | 5726 | Waiting on Author | | 19 | 7/10 | +426−71 | Matthew Sterrett (matthew.sterrett.intel.com), Andrew Kim (andrewk1) | | | 2 | 1 week ago |
| Accounting for metapages in genericcostestimate() | 5727 | Needs review | | | 10/10 | +55−13 | Tom Lane (tgl) | | | 3 | 5 months ago |
| Improve hash join's handling of tuples with null join keys | 5738 | Waiting on Author | | | 10/10 | +381−71 | Tom Lane (tgl) | Chao Li (chaol) | | 3 | 1 month ago |
| Improve the performance of Unicode Normalization Forms. | 5802 | Ready for Committer | | | 10/10 | +55763−12827 | Alexander Borisov (lexborisov) | Victor Yegorov (vyegorov) | | 3 | 1 week ago |
| Optimize-transaction-waiting-during-logical-decoding | 5806 | Needs review | | 19 | 0/10 | +213−9 | Xuneng Zhou (dylanzhou) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 3 | 1 month ago |
| parallel pg_restore: avoid disk seeks when jumping short distance forward | 5809 | Needs review | | 19 | 10/10 | +5−1 | Dimitrios Apostolou (jimis) | Tom Lane (tgl) | | 2 | 2 months ago |
| parallel pg_restore: move offset-building phase to before forking | 5817 | Needs review | | | 10/10 | +86−6 | Dimitrios Apostolou (jimis) | Tom Lane (tgl) | | 2 | 3 months ago |
| Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume | 5841 | Needs review | | 19 | Needs rebase! | | Melanie Plageman (melanieplageman) | | | 3 | yesterday |
| Eagerly evict bulkwrite strategy ring | 5919 | Needs review | | 19 | Needs rebase! | | Melanie Plageman (melanieplageman) | | | 3 | 4 weeks ago |
| Use merge-based matching for MCVs in eqjoinsel | 5929 | Needs review | Performance | 19 | 10/10 | +190−40 | Ilia Evdokimov (ilidock95) | David Geier (geidav) | | 2 | 3 weeks ago |
| Making jsonb_agg() faster | 5930 | Needs review | | | 10/10 | +629−702 | Tom Lane (tgl) | | | 2 | 1 month ago |
| Stack-based tracking of per-node WAL/buffer usage | 6023 | Needs review | | 19 | Needs rebase! | | Lukas Fittl (lfittl) | | | 2 | 1 month ago |
| Improve read_local_xlog_page_guts by replacing polling with latch-based waiting | 6024 | Needs review | Performance Logical Replication | 19 | 9/10 | +781−15 | Xuneng Zhou (dylanzhou) | | | 1 | 4 days ago |
| Checkpointer write combining | 6043 | Needs review | | | Needs rebase! | | Melanie Plageman (melanieplageman) | | | 1 | 4 weeks ago |
| Adding basic NUMA awareness | 6049 | Needs review | Performance | 19 | Needs rebase! | | Tomas Vondra (fuzzycz) | | | 1 | 3 weeks ago |
| Speed up of vac_update_datfrozenxid. | 6060 | Needs review | Performance | 19 | 9/10 | +73−45 | Rustam Khamidullin (rustamkhamidullin) | | | 1 | 2 months ago |
| MPTCP - multiplexing many TCP connections through one socket to get better bandwidth | 6061 | Needs review | | 19 | 1/10 | +72−2 | Jakub Wartak (jakub.wartak.tomtom) | | | 1 | 1 month ago |
| Optimize LISTEN/NOTIFY | 6078 | Needs review | | |  1/10 | +659−91 | Joel Jacobson (joeljacobson) | Tom Lane (tgl) | | 1 | 20 minutes ago |
| Write Notifications Through WAL | 6079 | Needs review | Performance | 19 | 10/10 | +1294−476 | Rishu Bagga (rishub) | Arseniy Mukhin (amukhin) | | 1 | 2 days ago |
| use SIMD in GetPrivateRefCountEntry() | 6101 | Needs review | | 19 | 9/10 | +87−16 | Nathan Bossart (bossartn) | | | 1 | 6 days ago |
| Procedural Languages |
|---|
| plpython: Remove support for major version conflict detection | 5972 | Needs review | PL/Python | | 10/10 | +4−61 | Peter Eisentraut (petere) | Euler Taveira (eulerto), Mario Gonzalez (gonzalemario) | | 2 | 2 days ago |
| Disallow BEGIN ATOMIC SQL functions depending on temp relations | 6074 | Needs review | | 19 | 10/10 | +113−34 | Jim Jones (jimus) | Tom Lane (tgl) | | 2 | yesterday |
| Refactoring |
|---|
| Refactor SLRU to always use long file names | 5250 | Ready for Committer | | | 9/10 | +103−85 | Aleksander Alekseev (a.alekseev) | Rustam ALLAKOV (rustam.allakov) | | 6 | 1 month ago |
| Beautify read stream "per buffer data" APIs | 5617 | Needs review | | | 9/10 | +90−16 | Thomas Munro (macdice) | | | 3 | 2 months ago |
| Refactor bytea_sortsupport(), take two | 5889 | Needs review | | 19 | 10/10 | +207−41 | Aleksander Alekseev (a.alekseev) | | | 2 | 3 weeks ago |
| minor refactor on src/test/modules/test_ddl_deparse/sql/alter_table.sql | 6001 | Needs review | | 19 | 10/10 | +36−32 | Jian He (stayreal) | | | 2 | 1 month ago |
| ternary reloption type | 6021 | Needs review | | 19 | 10/10 | +314−130 | Nikolay Shaplov (nataraj) | | | 2 | 3 weeks ago |
| Get rid of pgstat_count_backend_io_op*() functions | 6025 | Needs review | Performance | 19 | 10/10 | +31−57 | Bertrand Drouvot (bertranddrouvot.pg) | | | 1 | 2 weeks ago |
| Mark ItemPointer arguments as const thoughoutly | 6046 | Needs review | Refactoring Only | | 10/10 | +100−100 | Chao Li (chaol) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 2 weeks ago |
| Mark function arguments of type "Datum *" as "const Datum *" where possible | 6081 | Needs review | Refactoring Only | 19 | 10/10 | +151−151 | Chao Li (chaol) | | | 1 | 1 week ago |
| Remove Item type | 6104 | Needs review | | | 10/10 | +109−184 | Peter Eisentraut (petere) | | | 1 | 1 week ago |
| Reorganize GUC structs | 6105 | Needs review | | | Needs rebase! | | Peter Eisentraut (petere) | | | 1 | yesterday |
| refactor CreateStatsStmt | 6106 | Needs review | | 19 | 10/10 | +15−32 | Jian He (stayreal) | | | 1 | 1 week ago |
| Preferred use of macro GetPGProcByNumber | 6108 | Needs review | Refactoring Only | 19 | 10/10 | +9−9 | Maksim Melnikov (manaldush) | | | 1 | 3 weeks ago |
| Remove unused #include's | 6112 | Needs review | Refactoring Only | 19 | 10/10 | +0−64 | Aleksander Alekseev (a.alekseev) | Nathan Bossart (bossartn) | | 1 | yesterday |
| Little refactoring of portalcmds.c | 6113 | Needs review | Refactoring Only | | 10/10 | +16−24 | Aleksander Alekseev (a.alekseev) | | | 1 | 2 days ago |
| Remove make_temptable_name_n() | 6120 | Needs review | Refactoring Only | 19 | 10/10 | +1−24 | Aleksander Alekseev (a.alekseev) | | | 1 | 3 hours ago |
| Replication & Recovery |
|---|
| Return pg_control from pg_backup_stop(). | 4997 | Needs review | | 19 | 10/10 | +178−28 | David Steele (dsteele) | | | 8 | 2 months ago |
| Synchronization of sequences to subscriber | 5111 | Needs review | Logical Replication | | 10/10 | +2306−534 | vigneshwaran C (vignesh.postgres) | Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Hayato Kuroda (ha-kun), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) | | 7 | 11 hours ago |
| Enable logical decoding when wal_level = 'replica' without a server restart | 5479 | Needs review | | | 2/10 | +1536−119 | Masahiko Sawada (masahikosawada) | Dilip Kumar (dilip.kumar), Hayato Kuroda (ha-kun) | | 5 | 10 hours ago |
| Extending FK check skipping on replicas to ADD FK and TRUNCATE | 5774 | Needs review | | | 10/10 | +97−3 | Hannu Krosing (hannukrosing) | | | 2 | 3 months ago |
| Invalid pointer access in logical decoding after error | 5903 | Needs review | Logical Replication | | Needs rebase! | | vigneshwaran C (vignesh.postgres) | Masahiko Sawada (masahikosawada) | | 2 | yesterday |
| Support existing publications in pg_createsubscriber. | 6028 | Needs review | | 19 | 9/10 | +237−16 | Shubham Khanna (skhanna) | Peter Smith (smithpb2250) | | 1 | 12 hours ago |
| Timeline switching with partial WAL records can break replica recovery | 6038 | Needs review | Bugfix | 18 | 10/10 | +128−109 | Alyona Vinter (dlaaren) | | | 1 | 1 month ago |
| Fix replica identity mismatch for partitioned tables with publish_via_partition_root | 6047 | Needs review | Bugfix Logical Replication | stable | 10/10 | +211−38 | Mikhail Kharitonov (mkharitonov) | | | 1 | 1 month ago |
| Add stats related to slot sync skip | 6082 | Needs review | | | Needs rebase! | | Shlok Kyal (shlokkyal) | | | 1 | 1 week ago |
| Accept connections post recovery without waiting for RemoveOldXlogFiles | 6091 | Needs review | | 19 | 10/10 | +61−1 | Nitin Motiani (nitinmotiani) | | | 1 | 1 month ago |
| Security |
|---|
| Serverside SNI for SSL connections | 4984 | Waiting on Author | | | Needs rebase! | | Daniel Gustafsson (d_gustafsson) | Jacob Champion (jchampion) | | 7 | 1 month ago |
| Extension security improvement: Add support for extensions with an owned schema | 5018 | Needs review | Security Extensions | | 10/10 | +517−130 | Jelte Fennema-Nio (jeltef) | Sadeq Dousti (msdousti), Artem Gavrilov (artem.gavrilov) | | 8 | 4 weeks ago |
| revamp row-security tracking | 5397 | Waiting on Author | | 19 | 10/10 | +25−17 | Nathan Bossart (bossartn) | | | 5 | 7 months ago |
| Server Features |
|---|
| Sequence Access Methods, round two | 4677 | Needs review | | | 10/10 | +2728−774 | Michael Paquier (michael-kun) | | | 10 | 3 days ago |
| COPY ON_ERROR 'NULL' | 4810 | Needs review | | | 9/10 | +247−36 | jian he (universality) | Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), Jim Jones (jimus) | | 8 | 2 months ago |
| on_error table, saving error info to a table | 4817 | Needs review | | | 10/10 | +584−14 | jian he (hellothere) | Nishant Sharma (nishant-at-edb) | | 8 | 1 month ago |
| Use WALReadFromBuffers in more places | 4952 | Needs review | | | 10/10 | +70−30 | Bharath Rupireddy (bharathrupireddy) | | | 5 | 2 weeks ago |
| VACUUM FULL / CLUSTER CONCURRENTLY | 5117 | Needs review | | 18 | 10/10 | +2481−543 | Antonin Houska (a.houska) | Álvaro Herrera (alvherre), Mihail Nikalayeu (mihailnikalayeu) | | 8 | 4 hours ago |
| using index to speedup add not null constraints to a table | 5444 | Needs review | | 18 | Needs rebase! | | Jian He (stayreal) | Tanzeel Khan (tanzeelk) | | 4 | 4 months ago |
| speedup COPY TO for partitioned table | 5467 | Needs review | | 19 | 10/10 | +266−33 | Jian He (stayreal) | vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), newtglobal postgresql_contributors (newtpostgrescontributors) | Peter Eisentraut (petere) | 5 | 9 hours ago |
| add function argument name to substring and substr | 5524 | Waiting on Author | | | Needs rebase! | | Jian He (stayreal) | David Johnston (polobo) | | 3 | 2 months ago |
| support fast default for domain with constraints | 5641 | Needs review | | | 9/10 | +301−18 | Jian He (stayreal) | | | 3 | 1 month ago |
| support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint | 5645 | Needs review | | | 10/10 | +48−27 | Jian He (stayreal) | | | 3 | 3 months ago |
| support create index on virtual generated column. | 5667 | Needs review | | | Needs rebase! | | Jian He (stayreal) | | | 3 | 2 months ago |
| Allow to collect statistics on virtual generated columns | 5714 | Needs review | | 19 | 10/10 | +167−28 | Yugo Nagata (yugo.nagata) | | | 3 | 1 month ago |
| virtual generated column as partition key | 5720 | Needs review | | 19 | 10/10 | +467−139 | Jian He (stayreal) | | | 3 | 5 months ago |
| domain over virtual generated column | 5725 | Needs review | | 19 | Needs rebase! | | Jian He (stayreal) | | | 3 | 4 months ago |
| finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it | 5759 | Needs review | | 19 | Needs rebase! | | Jian He (stayreal) | | | 3 | 4 months ago |
| ALTER DOMAIN ADD NOT NULL NOT VALID | 5768 | Needs review | | 19 | 10/10 | +214−26 | Jian He (stayreal) | | | 3 | 2 weeks ago |
| make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated | 5769 | Needs review | | 19 | 10/10 | +22−19 | Jian He (stayreal) | Peter Eisentraut (petere) | | 2 | 4 hours ago |
| Disallow concurrent ALTER DOMAIN and DROP DOMAIN | 5773 | Needs review | | 19 | 6/10 | +126−0 | Jian He (stayreal) | | | 3 | 4 months ago |
| foreign key on virtual generated column | 5782 | Needs review | | 19 | 9/10 | +315−93 | Jian He (stayreal) | Srinath Reddy (srinath-reddy-sadipiralla) | | 3 | 4 months ago |
| alter check constraint enforceability | 5796 | Needs review | | 19 | 10/10 | +345−11 | Jian He (stayreal) | Robert Treat (xzilla) | | 2 | 1 month ago |
| Support for 8-byte TOAST values (aka the TOAST infinite loop problem) | 5830 | Needs review | | 19 | 10/10 | +2213−376 | Michael Paquier (michael-kun) | Tom Lane (tgl), Nikhil Kumar Veldanda (nikhilkumarv) | | 3 | 1 week ago |
| Carefully exposing information without authentication | 5845 | Needs review | Monitoring | 19 | 1/10 | +391−0 | Greg Sabino Mullane (greg) | | | 2 | 1 week ago |
| no table rewrite when set column type to constrained domain | 5907 | Needs review | | 19 | 9/10 | +133−10 | Jian He (stayreal) | | | 2 | 1 month ago |
| pg_waldump: support decoding of WAL inside tarfile | 5955 | Needs review | | 19 | 8/10 | +1288−228 | Amul Sul (sulamul) | | | 2 | 1 hour ago |
| implement CAST(expr AS type FORMAT 'template') | 5957 | Needs review | | 19 | 10/10 | +881−10 | Jian He (stayreal) | | | 2 | 1 month ago |
| ALTER COLUMN SET EXPRESSION [GENERATED|STORED] | 6010 | Needs review | | 19 | Needs rebase! | | Jian He (stayreal) | | | 2 | 1 month ago |
| NOT NULL NOT ENFORCED | 6029 | Needs review | | 19 | 10/10 | +783−97 | Jian He (stayreal) | | | 1 | 2 weeks ago |
| AIX support | 6050 | Needs review | Refactoring Only | 19 | 10/10 | +223−52 | AIX PG user (pg-aixusr) | | | 1 | 2 weeks ago |
| let ALTER COLUMN SET DATA TYPE cope with POLICY dependency | 6054 | Needs review | | 19 | 10/10 | +546−55 | Jian He (stayreal) | | | 1 | 3 weeks ago |
| CREATE TABLE LIKE INCLUDING POLICIES | 6064 | Needs review | | 19 | 10/10 | +475−46 | Jian He (stayreal) | | | 1 | 3 weeks ago |
| let ALTER COLUMN SET DATA TYPE cope with trigger dependency | 6089 | Needs review | | 19 | 10/10 | +500−157 | Jian He (stayreal) | | | 1 | 1 week ago |
| Allow virtual columns in index expressions or predicate | 6094 | Needs review | | 19 | 10/10 | +69−46 | Richard Guo (richardguo) | | | 1 | 1 week ago |
| Add generic routine to retrieve PG_VERSION contents (Executing pg_createsubscriber with a non-compatible control file) | 6117 | Needs review | | 19 | 10/10 | +141−131 | Michael Paquier (michael-kun) | | | 1 | 12 hours ago |
| Patch for migration of the pg_commit_ts directory | 6119 | Needs review | | 19 | 9/10 | +137−3 | | | | 1 | 4 hours ago |
| SQL Commands |
|---|
| Add XMLCanonicalize function | 4237 | Ready for Committer | | 19 | 10/10 | +436−0 | Jim Jones (jimus) | Pavel Stehule (okbobcz), Oliver Ford (ojford), newtglobal postgresql_contributors (newtpostgrescontributors) | | 13 | 2 months ago |
| Incremental View Maintenance (IVM), take 2 | 4337 | Waiting on Author | | | Needs rebase! | | Yugo Nagata (yugo.nagata) | | | 13 | 4 weeks ago |
| Implement row pattern recognition feature | 4460 | Needs review | | 19 | Needs rebase! | | Tatsuo Ishii (ishii) | Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033) | | 12 | 2 weeks ago |
| COPY TO json | 4716 | Needs review | | | 10/10 | +410−67 | Joe Conway (jconway) | Masahiko Sawada (masahikosawada) | Joe Conway (jconway) | 8 | 1 week ago |
| Add XMLCast (SQL/XML X025) | 5110 | Needs review | | 19 | 10/10 | +2276−10 | Jim Jones (jimus) | Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) | | 8 | 4 months ago |
| Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) | 5279 | Needs review | | 19 | 10/10 | +1490−59 | Jim Jones (jimus) | newtglobal postgresql_contributors (newtpostgrescontributors) | | 6 | 2 months ago |
| Add XMLDocument (SQL/XML X030) | 5431 | Ready for Committer | | 19 | 10/10 | +258−1 | Jim Jones (jimus) | Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) | | 5 | 2 months ago |
| Add XMLNamespaces option to XMLElement | 5456 | Ready for Committer | | 19 | 10/10 | +1205−39 | Pavel Stehule (okbobcz), Jim Jones (jimus) | Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) | | 5 | 2 months ago |
| SQL:2011 Application Time Update & Delete | 5836 | Needs review | | 19 | 0/10 | +19265−526 | Paul Jungwirth (pjungwir) | Peter Eisentraut (petere) | | 3 | 5 days ago |
| Allow ON CONFLICT DO UPDATE to return EXCLUDED values | 5854 | Needs review | | 19 | 9/10 | +741−269 | Dean Rasheed (deanr) | | | 3 | 2 days ago |
| CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions | 5941 | Needs review | | 19 | 6/10 | +3103−316 | Jian He (stayreal) | | | 2 | 6 hours ago |
| CREATE SCHEMA ... CREATE DOMAIN support | 5985 | Needs review | | 19 | Needs rebase! | | Jian He (stayreal) | | | 2 | 1 month ago |
| Add jsonb_translate(jsonb, from, to) | 6086 | Needs review | | 19 | 10/10 | +210−0 | Florents Tselai (florentst) | | | 1 | 1 week ago |
| CREATE TABLE LIKE INCLUDING TRIGGERS | 6087 | Needs review | | 19 | 6/10 | +628−144 | Jian He (stayreal) | | | 1 | 1 week ago |
| create table like including storage parameter | 6088 | Needs review | | 19 | 8/10 | +200−1 | Jian He (stayreal) | | | 1 | 1 week ago |
| ON CONFLICT DO SELECT | 6109 | Needs review | My First Patch | 19 | 9/10 | +1389−215 | Viktor Holmberg (rutchkiwi) | | | 1 | 3 days ago |
| System Administration |
|---|
| log_min_messages per backend type | 5447 | Needs review | GUC | 19 | 10/10 | +364−43 | Euler Taveira (eulerto) | | | 5 | 5 days ago |
| Add log_autoanalyze_min_duration | 5797 | Ready for Committer | GUC | 19 | 9/10 | +120−31 | Shinya Kato (shinyakato) | Tatsuhito Kasahara (tatsuhito.kasahara) | Peter Eisentraut (petere) | 3 | 1 month ago |
| Include extension path on pg_available_extensions | 6067 | Needs review | Extensions | | 9/10 | +83−34 | Matheus Alcantara (matheus.alcantara) | | | 1 | 3 weeks ago |
| Testing |
|---|
| Allow CI to only run the compiler warnings task | 5249 | Waiting on Author | | 18 | Needs rebase! | | Bertrand Drouvot (bertranddrouvot.pg) | Rustam ALLAKOV (rustam.allakov) | | 5 | 4 months ago |
| Add 'make check-tests' behavior to the meson based builds | 5405 | Ready for Committer | Testing | 19 | 10/10 | +16−6 | Nazir Bilal Yavuz (nbyavuz) | Ashutosh Bapat (ashutoshbapat), Jian He (stayreal) | | 5 | 2 months ago |
| Improve error reporting in 027_stream_regress test | 5900 | Needs review | Good First Review Testing | 19 | 10/10 | +0−0 | Nazir Bilal Yavuz (nbyavuz) | | | 2 | 2 months ago |
| Align tests for stored and virtual generated columns | 5981 | Needs review | | | Needs rebase! | | Yugo Nagata (yugo.nagata) | Paul Jungwirth (pjungwir), mutaamba maasha (mutaambam) | | 2 | 1 week ago |