Commitfest PG19-3 (2025-11-01 – 2025-11-30)

No reviewers My patches My reviews New patch
Text Status Target version Tag (type to search) Author (type to search) Reviewer (type to search)
Clear


Status summary: Needs review: 239. Waiting on Author: 38. Ready for Committer: 25. Committed: 48. Moved to next CF: 15. Withdrawn: 9. Total: 374.

Active patches

Patch ID Status Tags Ver CI status Stats Author Reviewers Committer Num cfs Latest mail
Bug Fixes
pg_ctl start may return 0 even if the postmaster has been already started on Windows 4573 Waiting on Author 9/10 +369−153 Kyotaro Horiguchi (horiguti) Hayato Kuroda (ha-kun), Yasir Shah (yasir.hussain.shah.gmail.com) 10 5 days ago
Fix rare recovery shutdown hang 4884 Waiting on Author Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch), Martijn Wallet (mwallet) 7 10 months ago
WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts 4986 Waiting on Author 10/10 +6−2 Matthias van de Meent (mmeent) Akshat Jaimini (akshatj) 7 10 months ago
Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state 5029 Needs review Needs rebase! ChangAo Chen (chenchangao) harinath kanchu (harinath001), Lilian Ontowhee (ontowhee) 7 3 months ago
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 8 months ago
Incremental Sort Cost Estimation Instability 5093 Needs review 18 Needs rebase! Andrei Lepikhov (lepikhov) 7 4 months ago
Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() 5124 Waiting on Author Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch) 6 7 months ago
DirtySnapshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication 5151 Needs review Bugfix Logical Replication stable 10/10 +612−46 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Luan Silva (luansilva) 6 yesterday
Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 5160 Needs review Bugfix stable 9/10 +1525−50 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) 6 yesterday
Fix standby may crash when switching-over in certain special cases 5199 Needs review 9/10 +2−2 pixian shi (pxshi) 6 10 months ago
Fix race between WAL flush and InstallXLogFileSegment() 5276 Needs review 10/10 +45−0 Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) 5 11 months ago
Fix for consume_xids advancing XIDs incorrectly 5303 Waiting on Author stable Needs rebase! Yushi Ogiwara (yushi) 5 10 months ago
Fix creation of empty .log files during log rotation 5365 Waiting on Author 10/10 +15−12 Arseny Kositsin (arseny114) 4 7 months ago
Fix bug with accessing to temporary tables of other sessions 5379 Needs review Bugfix Backport 18 10/10 +293−20 Daniil Davydov (dddaniil) Rafia Sabih (rafia.sabih), Jim Jones (jimus) 5 yesterday
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 1 month ago
Corrupted FSM page is not saved after zeroing. 5615 Waiting on Author 10/10 +3−0 Anton Melnikov (antonmel) 5 1 week ago
Random pg_upgrade 004_subscription test failure on drongo 5673 Waiting on Author 10/10 +25−0 vigneshwaran C (vignesh.postgres) 3 1 week ago
Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION 5681 Waiting on Author 10/10 +132−19 Yugo Nagata (yugo.nagata) Jim Jones (jimus), Daniil Davydov (dddaniil) 3 4 weeks ago
temporary file usage report with extended protocol and unnamed portals 5724 Ready for Committer 10/10 +14−7 Sami Imseih (simseih), Frédéric Yhuel (yhuelf) Mircea Cadariu (mcadariu) 3 7 hours ago
Add guard to prevent recursive memory context logging. 5766 Needs review 10/10 +40−18 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 3 3 months ago
problems with toast.* reloptions 5839 Waiting on Author stable Needs rebase! Nathan Bossart (bossartn) 3 3 months ago
Decouple C++ support in Meson's PGXS from LLVM enablement 5885 Needs review Good First Review stable 9/10 +24−14 Tristan Partin (tristan957) Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 2 1 month ago
Correction of RowMark Removal During Sel-Join Elimination 5943 Needs review Refactoring Only Bugfix 19 Needs rebase! Andrei Lepikhov (lepikhov) 2 1 month 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 Waiting on Author Bugfix 19 10/10 +52−0 Maksim Melnikov (manaldush) Andy Pogrebnoi (birdofdada) 2 1 week ago
Non-blocking archiver process 5971 Needs review Bugfix 19 9/10 +94−2 Patrick Stählin (packi) Artem Gavrilov (artem.gavrilov) 2 2 weeks ago
disallow alter individual column if partition key contains wholerow reference 5988 Waiting on Author Bugfix Backport 18 10/10 +36−0 Jian He (stayreal) Sergey Dudoladov (sdudoladov), Matt Dailis (mattdailis) 2 yesterday
bug: virtual generated column can be partition key 5989 Needs review Bugfix Backport 18 10/10 +86−40 Ashutosh Bapat (ashutoshbapat) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 2 months ago
Fix ALTER TABLE DROP EXPRESSION with ONLY option 5992 Ready for Committer Bugfix stable 2/10 +6−6 Jian He (stayreal) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 1 week ago
Reset recovery target parameters in pg_createsubscriber 6004 Needs review Bugfix My First Patch 18 7/10 +128−21 Alyona Vinter (dlaaren) Ian Ilyasov (ianilyasov), mutaamba maasha (mutaambam) 2 2 hours 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) Álvaro Herrera (alvherre) 1 1 month ago
UPDATE with invalid domain constraint 6031 Needs review Bugfix Backport stable 10/10 +114−0 Jian He (stayreal) 1 2 months 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) Mihail Nikalayeu (mihailnikalayeu) 1 1 week 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 +193−24 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 1 month 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 1 month ago
meson: Fix libpq search order 6056 Needs review 10/10 +37−35 Thomas Munro (macdice) Mario Gonzalez (gonzalemario) 1 2 weeks ago
MultiXact corruption and standby deadlock 6070 Needs review Bugfix 9/10 +123−144 Andrey Borodin (x4m) Ivan Bykov (ibykov) 1 5 days 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 3 weeks ago
Add assertion for bmr.rel in ExtendBufferedRelTo function 6075 Needs review Bugfix 16 Not processed Алена Васильева (eugenygoryachev) 1 1 week ago
Fix const-simplification for index expressions and predicate 6092 Needs review Bugfix 19 10/10 +102−10 Richard Guo (richardguo) 1 1 month ago
Fix pushdown of degenerate HAVING clauses 6093 Needs review Bugfix 18 10/10 +0−0 Richard Guo (richardguo) 1 1 week ago
LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 6095 Needs review Bugfix Help - Bikeshedding 9/10 +324−32 Matheus Alcantara (matheus.alcantara) Arseniy Mukhin (amukhin) 1 4 hours ago
Preserve index stats during ALTER TABLE ... TYPE ... 6118 Needs review Bugfix 19 10/10 +576−4 Bertrand Drouvot (bertranddrouvot.pg) 1 1 week ago
avoid call ATPostAlterTypeCleanup twice 6121 Needs review Bugfix Backport stable 10/10 +88−0 Jian He (stayreal) 1 1 week ago
Bug in pg_stat_statements 6167 Needs review 18 10/10 +122−15 Sami Imseih (simseih) 1 10 hours ago
COPY WHERE clause generated/system column reference 6179 Needs review Bugfix Backport stable 10/10 +116−2 Jian He (stayreal) 1 yesterday
Clients
psql: Rethinking of \du command 4738 Needs review 9/10 +72−126 Pavel Luzanov (p.luzanov@postgrespro.ru) David Johnston (polobo), Wen Yi (wenyi) 8 4 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
Add Option to Check All Addresses For Matching target_session_attr 5396 Needs review 18 10/10 +306−10 Andrew Jackson (andrewjackson) 5 2 months ago
psql \dh: List High-Level (Root) Tables and Indexes 5594 Ready for Committer stable 9/10 +170−7 Sadeq Dousti (msdousti) Greg Sabino Mullane (greg), Sergey Dudoladov (sdudoladov), Matt Dailis (mattdailis) 3 3 months ago
Adding error messages to a few slash commands 5699 Waiting on Author 19 2/10 +258−145 Abhishek Chanda (abhishekc) Robin Haberkorn (rhaberkorn) 2 1 week 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 weeks 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 2 months ago
Add \pset options for boolean value display 5828 Needs review psql 19 10/10 +120−1 David Johnston (polobo) Álvaro Herrera (alvherre) 3 1 week ago
Add prompt option to display read-only and read/write states in psql 5872 Ready for Committer psql 19 10/10 +31−0 Jim Jones (jimus) Nathan Bossart (bossartn), Srinath Reddy (srinath-reddy-sadipiralla) 3 20 hours ago
pgbench: extend variable usage in scripts 6012 Waiting on Author 19 9/10 +130−15 Yugo Nagata (yugo.nagata) 2 1 week ago
libpq: Bump protocol version to version 3.2 at least until the first/second beta 6157 Needs review libpq 10/10 +39−22 Jelte Fennema-Nio (jeltef) 1 6 days 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 9/10 +47−40 Yugo Nagata (yugo.nagata) 3 3 weeks ago
Documentation
Windows meson build 5522 Ready for Committer 10/10 +45−12 Kohei Harikae (koheiharikae) Vladlen Popolitov (vladlenpopolitov) Peter Eisentraut (petere) 3 8 months ago
Document how commit handles aborted transactions 5546 Ready for Committer Backport Docs Only 10/10 +55−5 David Johnston (polobo) Ahmed Ashour (ahmedashour) 4 2 months ago
pg_restore documentation and --create/--single-transaction limitation 5676 Ready for Committer Docs Only 18 10/10 +6−1 Ashutosh Bapat (ashutoshbapat) Laurenz Albe (laurenz) 3 4 weeks ago
pg_restore add note about -n 5818 Needs review 10/10 +21−40 Florents Tselai (florentst) 3 4 days ago
Docs and tests for RLS policies applied by command type 5851 Ready for Committer Testing 19 10/10 +61−15 Dean Rasheed (deanr) Viktor Holmberg (rutchkiwi) 3 yesterday
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 2 months ago
Document DSM Registry 5914 Waiting on Author Docs Only 19 10/10 +46−17 Florents Tselai (florentst) Nathan Bossart (bossartn) 2 3 weeks 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
Document AccessExclusive lock behaviour on standbys 5920 Needs review 10/10 +8−0 Anthonin Bonnefoy (bonnefoa) 2 3 months 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 4 weeks ago
CREATE/ALTER PUBLICATION improvements for syntax synopsis 6062 Needs review Docs Only stable 10/10 +2−2 Peter Smith (smithpb2250) 1 1 month ago
DOCS: What SGML markup to use for user objects like tables, columns, etc? 6063 Needs review Docs Only stable 10/10 +166−166 Peter Smith (smithpb2250) 1 1 month 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 1 month 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 month ago
doc: Improve description of io_combine_limit and io_max_combine_limit GUCs 6115 Ready for Committer Backport Docs Only 10/10 +4−0 Karina Litskevich (karinalitskevich) Chao Li (chaol) 1 1 week ago
refactor func-matching.sgml, make regexp* function more readable 6144 Needs review Docs Only 19 9/10 +114−76 Jian He (stayreal) 1 1 week ago
docs: Link to the correct protocol version inspection function External 6154 Needs review Docs Only 10/10 +1−1 Jelte Fennema-Nio (jeltef) 1 6 days ago
Add a warning on stats manipulation functions 6155 Needs review Docs Only 19 10/10 +6−0 Yugo Nagata (yugo.nagata) 1 5 days ago
Consistently use uppercase keywords 6159 Needs review Docs Only 19 10/10 +105−105 Erik Wienhold (ewie) Nathan Bossart (bossartn) 1 21 minutes ago
copy.sgml: add XML ID attributes to <varlistentry> tags. 6181 Needs review 19 9/10 +25−25 Jian He (stayreal) 1 8 hours ago
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 7 months ago
Avoid orphaned objects dependencies, take 3 4942 Needs review 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 8 4 months ago
System views for versions reporting 5318 Needs review stable Needs rebase! Dmitry Dolgov (erthalion) 6 6 months ago
Waiting for LSN replay with WAIT FOR command 5550 Needs review 10/10 +1471−14 Alexander Korotkov (smagen), Xuneng Zhou (egoa) Yura Sokolov (funny_falcon) 3 6 days ago
Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup 5570 Waiting on Author Multithreading 5/10 +243−45 Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 4 11 hours 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 2 months 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
Silence resource leaks alerts 5701 Needs review 19 10/10 +3−3 Ranier Vilela (raniervilela) 2 6 months ago
contrib/xml2: xslt_process() should report XSLT-related error details and accept xmltype 5718 Needs review 19 Needs rebase! Robin Haberkorn (rhaberkorn) 3 3 months ago
Add --continue-on-abort option to pgbench 5790 Ready for Committer 19 10/10 +170−33 Yugo Nagata (yugo.nagata), Rintaro Ikeda (rintaro) Yugo Nagata (yugo.nagata), Hayato Kuroda (ha-kun) Fujii Masao (masaofujii) 3 yesterday
pgindent: improve formatting of multiline comments 5831 Needs review 19 10/10 +36−0 Aleksander Alekseev (a.alekseev) Nathan Bossart (bossartn) 3 yesterday
Enhance Makefiles to rebuild objects on map file changes 5953 Needs review 19 10/10 +97−0 Chao Li (chaol) 2 2 weeks ago
Add process updating for GNU/Hurd 6013 Needs review 10/10 +2−2 Michael Banck (mbanck) 2 2 months ago
Use streaming read I/O in BRIN vacuuming 6022 Needs review 10/10 +24−9 Arseniy Mukhin (amukhin) Masahiko Sawada (masahikosawada) 2 2 weeks ago
Use enum type replacing #define for exec state of hashjoin and mergejoin 6027 Needs review 10/10 +36−27 Tender Wang (tndrwang) 1 1 week 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
AIX support 6050 Needs review 19 Needs rebase! AIX PG user (pg-aixusr) 1 1 week ago
Improving the names generated for indexes on expressions 6059 Needs review 10/10 +295−164 Tom Lane (tgl) 1 1 month ago
remove unnecessary include in src/backend/commands/policy.c 6072 Waiting on Author Good First Review stable 10/10 +6−6 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 1 month ago
Make GiST waldump output more descriptive 6103 Needs review stable 9/10 +41−6 Kirill Reshke (reshke) 1 yesterday
add objects file path to oid2name 6111 Needs review Needs rebase! david bidoc (dwayne) 1 3 weeks ago
incremental autovacuum scheduling improvements 6114 Needs review 19 10/10 +158−40 Nathan Bossart (bossartn) 1 5 hours ago
Add Windows support for backtrace_functions (MSVC only) 6116 Needs review My First Patch 19 9/10 +179−0 Bryan Green (lispyone) 1 8 hours ago
A tidyup for match_orclause_to_indexcol() 6149 Needs review 9/10 +1−27 Tender Wang (tndrwang) 1 1 week ago
minor error message enhance: print RLS policy name when only one permissive policy exists 6180 Needs review 19 2/10 +41−33 Jian He (stayreal) 1 yesterday
Monitoring & Control
Add pg_stat_session 3405 Waiting on Author Needs rebase! Rafia Sabih (rafia.sabih), Sergey Dudoladov (sdudoladov) Bertrand Drouvot (bdrouvot), Atsushi Torikoshi (atsushitorikoshi), Andrei Zubkov (zubkov), Sadeq Dousti (msdousti) 19 6 months ago
relfilenode statistics 5007 Waiting on Author 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 8 3 weeks ago
Vacuum statistics 5012 Waiting on Author 19 Needs rebase! Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) Ilia Evdokimov (ilidock95) 8 1 month ago
Logging plan of the currently running query 5330 Needs review Monitoring 18 10/10 +647−34 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 10/10 +1156−34 Atsushi Torikoshi (atsushitorikoshi) Jelte Fennema-Nio (jeltef) 4 yesterday
Leaf and internal 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 3 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 2 months ago
amcheck support for BRIN indexes 5715 Needs review 10/10 +2156−30 Arseniy Mukhin (amukhin) Tomas Vondra (fuzzycz) 3 2 months ago
Expose internal MultiXact member count function for efficient monitoring 5811 Needs review 19 10/10 +356−6 Naga Appani (naga.appani) Atsushi Torikoshi (atsushitorikoshi) 3 1 week ago
Support for basic ALTER TABLE progress reporting. 5873 Needs review Monitoring 10/10 +83−6 Jiří Kavalík (jkavalik) Jian He (stayreal) 2 3 months ago
Report bytes and transactions actually sent downtream 5877 Needs review 10/10 +364−89 Ashutosh Bapat (ashutoshbapat) 3 6 hours ago
Enhancing Memory Context Statistics Reporting 5938 Needs review Monitoring 19 10/10 +1484−24 Rahila Syed (rahila) Atsushi Torikoshi (atsushitorikoshi) 2 yesterday
Adding locks statistics 5942 Needs review 19 10/10 +553−4 Bertrand Drouvot (bertranddrouvot.pg) 2 2 months ago
Adding per backend commit and rollback counters 5947 Needs review 19 10/10 +296−2 Bertrand Drouvot (bertranddrouvot.pg) 2 2 months ago
Per backend relation statistics tracking 5958 Needs review 19 9/10 +261−2 Bertrand Drouvot (bertranddrouvot.pg) 2 1 month ago
Add mode and reason columns to pg_stat_progress_vacuum 5969 Needs review Monitoring 19 9/10 +121−6 Shinya Kato (shinyakato) Nathan Bossart (bossartn) 2 5 days ago
Termination of Background Workers for ALTER/DROP DATABASE 6102 Needs review 10/10 +245−6 Aya Iwata (iwata.aya) 1 1 week ago
Add wal_fpi_bytes to pg_stat_wal 6150 Needs review Monitoring 19 10/10 +11−5 Shinya Kato (shinyakato) 1 yesterday
Performance
Index Prefetching 4351 Waiting on Author 9/10 +2397−868 Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) 12 2 weeks ago
[CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots 4971 Needs review Performance 19 10/10 +3932−937 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Matthias van de Meent (mmeent) 7 yesterday
Inline non-SQL SRFs 5083 Needs review 19 10/10 +755−115 Paul Jungwirth (pjungwir) Tom Lane (tgl) 5 2 months ago
Asynchronous MergeAppend Execution 5129 Needs review 10/10 +915−14 Alexander Pyhalov (a.pyhalov) 6 4 days ago
Parallel heap vacuum 5326 Needs review Needs rebase! Masahiko Sawada (masahikosawada) Hayato Kuroda (ha-kun) 6 1 month ago
Adding compression of temporary files 5382 Waiting on Author 1/10 +7693−22 Filip Januš (fjanus) 5 1 week 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 2 weeks ago
starjoin join order planning 5553 Waiting on Author 2/10 +444−0 Tomas Vondra (fuzzycz) Tom Lane (tgl) 3 1 month ago
Expanding HOT updates for expression and partial indexes 5556 Needs review Performance 19 10/10 +2321−143 Greg Burd (gregburd) 3 2 weeks 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 2 months ago
Compress big WAL records 5621 Needs review Needs rebase! Andrey Borodin (x4m) 3 3 months ago
Reduce timing overhead of EXPLAIN ANALYZE using rdtsc 5622 Needs review 10/10 +414−43 Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) 3 1 week ago
Lock-free XLog Reservation from WAL 5633 Needs review Needs rebase! Yura Sokolov (funny_falcon) 2 5 months ago
Small optimization set tuple block/tableOid once 5683 Needs review 19 10/10 +40−18 Ranier Vilela (raniervilela) 2 6 months ago
Create DATA dump objects for partitioned tables too 5692 Needs review 10/10 +223−41 Tom Lane (tgl) 3 6 months ago
Enable auto-vectorization for page checksum calculations 5726 Waiting on Author 19 8/10 +370−32 Matthew Sterrett (matthew.sterrett.intel.com), Andrew Kim (andrewk1) John Naylor (john.naylor) 2 18 hours 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 2 months ago
Parallel processing of indexes in autovacuum 5755 Needs review 18 10/10 +886−20 Maxim Orlov (m.orlov), Daniil Davydov (dddaniil) Masahiko Sawada (masahikosawada), Sami Imseih (simseih) 3 yesterday
Improve the performance of Unicode Normalization Forms. 5802 Ready for Committer 10/10 +55763−12827 Alexander Borisov (lexborisov) Victor Yegorov (vyegorov) 3 1 month 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: move offset-building phase to before forking 5817 Needs review 10/10 +86−6 Dimitrios Apostolou (jimis) Tom Lane (tgl) 2 1 week ago
Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume 5841 Needs review 19 10/10 +1134−959 Melanie Plageman (melanieplageman) 3 10 hours ago
Don't keep closed WAL segment in page cache after replay 5894 Needs review Performance 19 10/10 +51−4 Anthonin Bonnefoy (bonnefoa) 2 3 months ago
Eagerly evict bulkwrite strategy ring 5919 Needs review 19 9/10 +475−136 Melanie Plageman (melanieplageman) 3 2 weeks ago
Optimize join selectivity estimation for tables with large number of MCVs 5929 Needs review Performance 19 10/10 +193−40 David Geier (geidav), Ilia Evdokimov (ilidock95) 2 2 days ago
Making jsonb_agg() faster 5930 Needs review 10/10 +629−702 Tom Lane (tgl) 2 2 months ago
Optimize ProcSignal to avoid redundant SIGUSR1 signals 5931 Needs review 19 10/10 +57−49 Joel Jacobson (joeljacobson) 2 3 months ago
Optimize JsonbContainerTypeName by reordering type checks 6000 Needs review Refactoring Only 19 10/10 +5−5 Chao Li (chaol) 2 1 month ago
Stack-based tracking of per-node WAL/buffer usage 6023 Needs review 19 10/10 +572−320 Lukas Fittl (lfittl) 2 1 week ago
Improve read_local_xlog_page_guts by replacing polling with latch-based waiting 6024 Needs review Performance Logical Replication 19 10/10 +731−15 Xuneng Zhou (dylanzhou) 1 2 weeks ago
Checkpointer write combining 6043 Needs review 8/10 +1012−203 Melanie Plageman (melanieplageman) 1 yesterday
Adding basic NUMA awareness 6049 Needs review Performance 19 10/10 +2591−196 Tomas Vondra (fuzzycz) 1 2 weeks ago
Speed up of vac_update_datfrozenxid. 6060 Needs review Performance 19 10/10 +73−45 Rustam Khamidullin (rustamkhamidullin) 1 3 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 9/10 +748−52 Joel Jacobson (joeljacobson) Tom Lane (tgl) 1 11 hours ago
Write Notifications Through WAL 6079 Needs review Performance 19 10/10 +1165−474 Rishu Bagga (rishub) Arseniy Mukhin (amukhin) 1 1 week ago
use SIMD in GetPrivateRefCountEntry() 6101 Needs review 19 10/10 +87−16 Nathan Bossart (bossartn) 1 5 days ago
pgstattuple: Use streaming read API in pgstatindex functions 6125 Needs review Extensions 19 10/10 +48−9 Xuneng Zhou (dylanzhou) Shinya Kato (shinyakato) 1 1 week ago
Don't synchronously wait for already-in-progress IO in read stream 6127 Needs review 8/10 +947−160 Andres Freund (andresfreund) 1 1 month ago
pg_stat_statements: faster search by queryid 6136 Needs review 10/10 +859−217 Karina Litskevich (karinalitskevich) 1 1 week ago
postgres_fdw: Use COPY to speed up batch inserts 6137 Needs review 10/10 +350−12 Matheus Alcantara (matheus.alcantara) 1 18 hours ago
Optimization of the is_normalized() function. 6152 Needs review Performance 19 9/10 +6626−8086 Alexander Borisov (lexborisov) 1 1 week ago
Use log_newpage_range in HASH index build 6158 Needs review stable 2/10 +58−44 Kirill Reshke (reshke) 1 6 days ago
Use BumpContext contexts for TupleHashTables' tablecxt 6168 Needs review 10/10 +90−82 Tom Lane (tgl) 1 1 hour ago
Batching in executor, part 1: add batch variant of table AM scan API 6176 Waiting on Author Help - Benchmarks Performance 19 10/10 +2669−28 Amit Langote (amitlan) 1 15 hours ago
Procedural Languages
declarative session variables, LET command 1608 Needs review Needs rebase! 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), Jim Jones (jimus), newtglobal postgresql_contributors (newtpostgrescontributors) 38 2 weeks ago
new plpgsql.extra_errors check - strict_expr_check 5044 Ready for Committer 10/10 +172−18 Pavel Stehule (okbobcz) Gilles Darold (darold), Kirk Wolak (kirkw), newtglobal postgresql_contributors (newtpostgrescontributors) 9 2 months ago
When deleting the plpgsql function, release the CachedPlan of the function 5975 Needs review PL/pgSQL 19 9/10 +118−2 Man Zeng (zengman) 2 1 month ago
Disallow BEGIN ATOMIC SQL functions depending on temp relations 6074 Needs review 19 10/10 +340−46 Jim Jones (jimus) Tom Lane (tgl) 2 2 weeks ago
Refactoring
Refactor SLRU to always use long file names 5250 Ready for Committer 10/10 +103−85 Aleksander Alekseev (a.alekseev) Rustam ALLAKOV (rustam.allakov) 6 2 months ago
Beautify read stream "per buffer data" APIs 5617 Needs review 10/10 +90−16 Thomas Munro (macdice) 3 1 week ago
Make numeric type accessible to third-party code. 5623 Needs review stable 9/10 +290−285 Ed Behn (edbehn) Jelte Fennema-Nio (jeltef) 3 1 month ago
Improve logicalrep_worker_launch() logic 5734 Needs review 10/10 +42−36 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 3 5 months ago
Refactor bytea_sortsupport(), take two 5889 Waiting on Author 19 10/10 +207−41 Aleksander Alekseev (a.alekseev) 2 12 hours ago
Treat semaphores similar to other shared memory structures 5997 Needs review Refactoring Only 10/10 +11−31 Ashutosh Bapat (ashutoshbapat) 2 2 months 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 2 months ago
List TAP test files in makefiles 6011 Needs review 10/10 +405−8 Peter Eisentraut (petere) Nathan Bossart (bossartn) 2 yesterday
ternary reloption type 6021 Needs review 19 10/10 +314−130 Nikolay Shaplov (nataraj) Álvaro Herrera (alvherre) 2 1 month ago
Get rid of pgstat_count_backend_io_op*() functions 6025 Needs review Performance 19 10/10 +31−57 Bertrand Drouvot (bertranddrouvot.pg) 1 1 month 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 1 month 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) Peter Eisentraut (petere) 1 1 month ago
Reorganize GUC structs 6105 Ready for Committer Multithreading Needs rebase! Peter Eisentraut (petere) 1 12 hours ago
refactor CreateStatsStmt 6106 Needs review 19 10/10 +18−57 Jian He (stayreal) Álvaro Herrera (alvherre) 1 1 week ago
Preferred use of macro GetPGProcByNumber 6108 Needs review Refactoring Only 19 9/10 +9−9 Maksim Melnikov (manaldush) 1 1 month ago
Little refactoring of portalcmds.c 6113 Needs review Refactoring Only 10/10 +16−24 Aleksander Alekseev (a.alekseev) 1 2 days ago
Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions 6122 Needs review Testing 19 Needs rebase! B Sadhu Prasad Patro (sadhuprasad) 1 1 week ago
Consistently use the XLogRecPtrIsInvalid() macro 6169 Needs review Refactoring Only 19 10/10 +111−111 Bertrand Drouvot (bertranddrouvot.pg) 1 4 hours ago
Unused variable in perl test 6170 Needs review Testing 19 10/10 +0−1 Daniil Davydov (dddaniil) 1 5 days ago
C11: should we use char32_t for unicode code points? 6173 Needs review 19 10/10 +284−244 Jeff Davis (jdavis) 1 1 hour ago
Remove remaining dependencies on setlocale() 6174 Needs review 19 9/10 +238−61 Jeff Davis (jdavis) 1 21 hours ago
Replication & Recovery
Return pg_control from pg_backup_stop(). 4997 Needs review 19 9/10 +178−28 David Steele (dsteele) 8 2 months ago
Synchronization of sequences to subscriber 5111 Needs review Logical Replication 10/10 +1585−188 vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Hayato Kuroda (ha-kun), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) 7 5 hours ago
Enable logical decoding when wal_level = 'replica' without a server restart 5479 Needs review 10/10 +1602−130 Masahiko Sawada (masahikosawada) Dilip Kumar (dilip.kumar), Hayato Kuroda (ha-kun) 5 2 hours ago
Fix slot synchronization with two_phase decoding enabled 5664 Needs review Bugfix Backport 17 Needs rebase! Zhijie Hou (houzj) 3 4 months ago
Extending FK check skipping on replicas to ADD FK and TRUNCATE 5774 Needs review Needs rebase! Hannu Krosing (hannukrosing) 2 3 months ago
Make wal_receiver_timeout configurable per subscription 5781 Needs review 10/10 +244−101 Fujii Masao (masaofujii) 3 6 days ago
Unnecessary delay in streaming replication due to replay lag 5908 Ready for Committer Good First Review Logical Replication Physical Replication stable 10/10 +400−9 Sunil S (sunils26) Huansong Fu (huansong) 2 2 days ago
Implement batching for walsender notifications during logical cascade replication 6019 Needs review Performance Logical Replication 19 10/10 +167−2 Alexey Makhmutov (lerm) 2 3 days ago
Support existing publications in pg_createsubscriber. 6028 Needs review 19 9/10 +237−16 Shubham Khanna (skhanna) Peter Smith (smithpb2250) 1 1 week ago
Timeline switching with partial WAL records can break replica recovery 6038 Needs review Bugfix 18 9/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 2 months ago
Add stats related to slot sync skip 6082 Needs review 10/10 +394−23 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
Issue with synced logical replication slot during switchover 6132 Needs review Bugfix Logical Replication My First Patch 19 10/10 +23−8 Fabrice Chapuis (fabricec) Alexander Kukushkin (cyberdem0n) 1 yesterday
Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array 6141 Ready for Committer Performance Logical Replication Refactoring Only 19 9/10 +0−0 Xuneng Zhou (dylanzhou) Kirill Reshke (reshke) 1 9 hours ago
pg_recvlogical: Prevent flushed data from being re-sent after restarting replication 6147 Needs review Logical Replication 9/10 +18−1 Fujii Masao (masaofujii) 1 1 month ago
Add archive_mode to prevent unarchived WAL on permanent primary failure 6177 Needs review Physical Replication 19 10/10 +645−8 Andrey Borodin (x4m) 1 2 days 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 1 month ago
Server Features
Sequence Access Methods, round two 4677 Needs review Needs rebase! Michael Paquier (michael-kun) 10 3 weeks ago
COPY ON_ERROR 'NULL' 4810 Needs review 10/10 +247−36 jian he (universality) Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), Jim Jones (jimus) 8 2 months ago
on_error table, saving error info to a table 4817 Needs review 9/10 +537−15 jian he (hellothere) Nishant Sharma (nishant-at-edb) 8 yesterday
KNN-btree 4871 Waiting on Author Needs rebase! Nikita Glukhov (n.glukhov), Anton Melnikov (antonmel) 8 11 months ago
Use WALReadFromBuffers in more places 4952 Needs review 10/10 +70−30 Bharath Rupireddy (bharathrupireddy) 5 1 month ago
VACUUM FULL / CLUSTER CONCURRENTLY 5117 Needs review 18 10/10 +2481−543 Antonin Houska (a.houska) Álvaro Herrera (alvherre), Mihail Nikalayeu (mihailnikalayeu) 8 2 weeks ago
Make MultiXactOffset 64-bit type 5205 Needs review 18 10/10 +1108−311 Maxim Orlov (m.orlov) Heikki Linnakangas (heikki) 6 yesterday
Changing shared_buffers without restart 5319 Needs review Needs rebase! Dmitry Dolgov (erthalion) Vladlen Popolitov (vladlenpopolitov) 6 1 week ago
Support enabling checksums online 5323 Needs review Needs rebase! Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) Tomas Vondra (fuzzycz) 6 3 weeks ago
using index to speedup add not null constraints to a table 5444 Needs review 18 10/10 +636−6 Jian He (stayreal) Tanzeel Khan (tanzeelk) Álvaro Herrera (alvherre) 4 1 week ago
SQL/JSON json_table PLAN clause 5478 Needs review 18 10/10 +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) 5 6 months ago
Extended Statistics set/restore/clear functions 5517 Waiting on Author 10/10 +3851−79 Corey Huinker (coreyh) 4 6 days ago
add function argument name to substring and substr 5524 Waiting on Author 10/10 +138−29 Jian He (stayreal) David Johnston (polobo) 3 2 weeks ago
support fast default for domain with constraints 5641 Needs review 10/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 6 months ago
domain over virtual generated column 5725 Needs review 19 Needs rebase! Jian He (stayreal) 3 5 months ago
finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it 5759 Needs review 19 10/10 +309−31 Jian He (stayreal) 3 2 weeks ago
ALTER DOMAIN ADD NOT NULL NOT VALID 5768 Needs review 19 10/10 +214−26 Jian He (stayreal) 3 1 month 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 2 weeks ago
Disallow concurrent ALTER DOMAIN and DROP DOMAIN 5773 Needs review 19 6/10 +126−0 Jian He (stayreal) 3 5 months ago
foreign key on virtual generated column 5782 Needs review 19 10/10 +315−93 Jian He (stayreal) Srinath Reddy (srinath-reddy-sadipiralla) 3 2 weeks ago
alter check constraint enforceability 5796 Needs review 19 9/10 +345−11 Jian He (stayreal) Robert Treat (xzilla) 2 2 months ago
Support tid range scan in parallel 5803 Needs review 10/10 +410−21 Cary Huang (cary) 2 2 months 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 4 weeks ago
Carefully exposing information without authentication 5845 Needs review Monitoring 19 8/10 +397−0 Greg Sabino Mullane (greg) 2 6 days ago
amcheck: support for GiST 5879 Needs review 9/10 +1026−109 Andrey Borodin (x4m) 2 6 days ago
no table rewrite when set column type to constrained domain 5907 Needs review 19 10/10 +133−10 Jian He (stayreal) 2 2 months ago
pg_waldump: support decoding of WAL inside tarfile 5955 Needs review 19 8/10 +1288−228 Amul Sul (sulamul) 2 1 week ago
implement CAST(expr AS type FORMAT 'template') 5957 Needs review 19 10/10 +881−10 Jian He (stayreal) 2 2 months ago
Import Statistics in postgres_fdw before resorting to sampling. 5959 Waiting on Author 19 10/10 +746−4 Corey Huinker (coreyh) 2 1 week ago
Improve initial slot synchronization in pg_sync_replication_slots() 5976 Needs review Logical Replication 19 9/10 +389−62 Ajin Cherian (ajinc) 2 2 days ago
ALTER COLUMN SET EXPRESSION [GENERATED|STORED] 6010 Needs review 19 Needs rebase! Jian He (stayreal) 2 2 months ago
NOT NULL NOT ENFORCED 6029 Needs review 19 10/10 +783−97 Jian He (stayreal) Álvaro Herrera (alvherre) 1 1 month ago
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency 6054 Needs review 19 8/10 +546−55 Jian He (stayreal) 1 1 month ago
CREATE TABLE LIKE INCLUDING POLICIES 6064 Needs review 19 9/10 +475−46 Jian He (stayreal) 1 1 month ago
let ALTER COLUMN SET DATA TYPE cope with trigger dependency 6089 Needs review 19 10/10 +500−157 Jian He (stayreal) 1 1 month ago
Allow virtual columns in index expressions or predicate 6094 Needs review 19 10/10 +69−46 Richard Guo (richardguo) 1 3 weeks ago
Migrate pg_commit_ts directory to the new node during an upgrade 6119 Ready for Committer 19 10/10 +140−3 Sergey Levin (lsv) Hayato Kuroda (ha-kun), Maxim Orlov (m.orlov) 1 2 weeks ago
Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive 6124 Needs review My First Patch 19 10/10 +285−10 Shayon Mukherjee (shayonj) 1 2 weeks ago
GIN pageinspect support for entry tree and non-leaf posting tree 6128 Needs review Extensions stable 3/10 +388−7 Kirill Reshke (reshke) 1 2 weeks ago
Add pg_get_policy_ddl() function to reconstruct CREATE POLICY statement 6135 Needs review My First Patch 10/10 +607−1 Akshay Joshi (akshay.joshi) 1 yesterday
Alow ALTER COLUMN TYPE when dependent generated column has SET EXPRESSION 6146 Needs review 19 9/10 +130−21 Chao Li (chaol) 1 1 week ago
Add GoAway protocol message for graceful but fast server shutdown/switchover 6156 Needs review libpq 10/10 +262−19 Jelte Fennema-Nio (jeltef) 1 5 days ago
Add pg_get_role_ddl() functions for role recreation 6166 Needs review 10/10 +554−1 Mario Gonzalez (gonzalemario), Bryan Green (lispyone) 1 5 days ago
Make pg_numa_init() cope with Docker 6171 Needs review Bugfix Backport stable 10/10 +11−4 Christoph Berg (myon) 1 yesterday
NLS: use gettext() to translate system error messages 6172 Needs review 19 10/10 +71−2 Jeff Davis (jdavis) 1 2 days ago
Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 6175 Needs review My First Patch 10/10 +266−0 Nishant Sharma (nishant-at-edb), Manni Wood (manniwoodedb) 1 20 hours ago
SQL Commands
Add SPLIT PARTITION/MERGE PARTITIONS commands 3659 Needs review 10/10 +8202−39 Dmitry Koval (d.koval) stephane tachoires (sttachoires) Alexander Korotkov (smagen) 16 yesterday
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 1 month 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 1 month ago
COPY TO json 4716 Needs review 10/10 +410−67 Joe Conway (jconway) Masahiko Sawada (masahikosawada) Joe Conway (jconway) 8 4 weeks ago
SQL Property Graph Queries (SQL/PGQ) 4904 Waiting on Author Needs rebase! Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat) Vik Fearing (xocolatl), Zhao Junwang (zhjwpku) 8 1 month ago
Add OR REPLACE option to CREATE MATERIALIZED VIEW 5099 Needs review 19 9/10 +694−98 Erik Wienhold (ewie) newtglobal postgresql_contributors (newtpostgrescontributors) 6 2 months 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 2 days ago
jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 5270 Needs review 9/10 +1201−25 Florents Tselai (florentst) David Wheeler (theory) 4 yesterday
Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) 5279 Needs review 19 9/10 +1490−59 Jim Jones (jimus) newtglobal postgresql_contributors (newtpostgrescontributors) 6 3 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 10/10 +19284−526 Paul Jungwirth (pjungwir) Peter Eisentraut (petere) 3 yesterday
Allow ON CONFLICT DO UPDATE to return EXCLUDED values 5854 Needs review 19 10/10 +741−269 Dean Rasheed (deanr) Viktor Holmberg (rutchkiwi) 3 3 weeks ago
CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 5941 Needs review 19 Needs rebase! Jian He (stayreal) 2 2 weeks 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 4 weeks ago
CREATE TABLE LIKE INCLUDING TRIGGERS 6087 Needs review 19 5/10 +628−144 Jian He (stayreal) 1 4 weeks ago
create table like including storage parameter 6088 Needs review 19 10/10 +200−1 Jian He (stayreal) Nathan Bossart (bossartn) 1 5 days ago
ON CONFLICT DO SELECT 6109 Needs review 19 10/10 +831−190 Viktor Holmberg (rutchkiwi) 1 3 weeks ago
Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement 6131 Ready for Committer Good First Review My First Patch 19 10/10 +312−0 Phil Alger (paalger) Jim Jones (jimus) 1 20 hours ago
COPY FROM with RLS 6178 Needs review 19 9/10 +238−14 Jian He (stayreal) 1 yesterday
System Administration
log_min_messages per backend type 5447 Needs review GUC 19 9/10 +364−43 Euler Taveira (eulerto) 5 3 weeks ago
Include extension path on pg_available_extensions 6067 Needs review Extensions 10/10 +142−36 Matheus Alcantara (matheus.alcantara) 1 7 hours ago
pg_createsubscriber --dry-run logging concerns 6129 Needs review stable 10/10 +110−29 Peter Smith (smithpb2250) Álvaro Herrera (alvherre) 1 2 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) Andrew Dunstan (adunstan) 5 3 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 3 months ago
Align tests for stored and virtual generated columns 5981 Waiting on Author Needs rebase! Yugo Nagata (yugo.nagata) Paul Jungwirth (pjungwir), mutaamba maasha (mutaambam) Peter Eisentraut (petere) 2 4 weeks ago
CI: Add task that runs pgindent 6148 Needs review CI 9/11 +40−2 Jelte Fennema-Nio (jeltef) 1 6 days ago
ci: Improve OpenBSD core dump backtrace handling 6160 Needs review CI 10/10 +25−5 Nazir Bilal Yavuz (nbyavuz) 1 5 days ago
Improve docs syntax checking and enable it in the meson build 6161 Needs review CI Testing 10/10 +153−15 Nazir Bilal Yavuz (nbyavuz) 1 4 hours ago
ci: Skip minfree file in the cores_backtrace.sh 6162 Needs review CI 10/10 +2−1 Christoph Berg (myon), Nazir Bilal Yavuz (nbyavuz) 1 1 week ago
ci: Upgrade Debian CI image from Bookworm to Trixie 6163 Needs review CI 10/10 +17−22 Nazir Bilal Yavuz (nbyavuz) 1 2 weeks ago
ci: Upgrade macOS CI image from Sonoma to Sequoia 6164 Needs review CI Needs rebase! Nazir Bilal Yavuz (nbyavuz) 1 2 weeks ago
ci: Update Windows CI Task Names: Server 2022 + VS 2022 Upgrade 6165 Needs review CI 9/10 +80−33 Nazir Bilal Yavuz (nbyavuz) 1 4 weeks ago

Closed patches

Patch ID Status Tags Ver CI status Stats Author Reviewers Committer Num cfs Latest mail
Bug Fixes
psql client does not handle WSAEWOULDBLOCK on Windows 5154 Committed 10/10 +15−12 Tom Lane (tgl), Umar Hayat (pgwizard) Tom Lane (tgl) 6 3 weeks ago
Improve ACL checks in pg_prewarm for indexes 5583 Committed Needs rebase! Ayush Vatsa (developerayuva) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 1 week ago
Accessing an invalid pointer in BufferManagerRelation structure 5646 Committed 18 10/10 +44−40 Daniil Davydov (dddaniil) Stepan Neretin (snpgg), Dmitrii Bondar (difesu) Álvaro Herrera (alvherre) 3 1 week ago
GIN tries to form a tuple with a partial compressedList during insertion 5890 Committed 10/10 +0−0 Arseniy Mukhin (amukhin) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 2 3 weeks ago
pg_restore --no-policies should not restore policies' comment 5891 Committed Bugfix Backport 18 10/10 +1−6 Jian He (stayreal) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 1 week ago
GetNamedLWLockTranche crashes on Windows in normal backend 5995 Moved to different CF 10/10 +244−0 Sami Imseih (simseih) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 month ago
Display is_prev_bucket_same_wrt of xl_hash_squeeze_page 6048 Moved to different CF Bugfix Backport Needs rebase! Kirill Reshke (reshke) Michael Paquier (michael-kun) 2 1 month ago
Unexpected changes of CurrentResourceOwner and CurrentMemoryContext 6051 Moved to different CF Bugfix stable 10/10 +15−0 Antonin Houska (a.houska) Mihail Nikalayeu (mihailnikalayeu) Álvaro Herrera (alvherre) 2 1 month ago
Fix missing EvalPlanQual recheck for TID scans 6057 Moved to different CF Bugfix Backport My First Patch 10/10 +84−25 Sophie Alpert (sophiebits) David Rowley (davidrowley) 2 1 month ago
fix re-initialization of LWLock-related shared memory 6065 Moved to different CF 19 9/10 +19−1 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 month ago
pgstattuple "unexpected zero page" for gist and hash indexes 6077 Committed 19 10/10 +16−6 Nitin Motiani (nitinmotiani) Dilip Kumar (dilip.kumar) Michael Paquier (michael-kun) 1 3 weeks ago
Avoiding roundoff error in pg_sleep() 6080 Moved to different CF 10/10 +20−9 Tom Lane (tgl) Tom Lane (tgl) 2 1 month ago
Infinite loop in pgbench when running COPY command 6096 Committed Bugfix stable 10/10 +24−0 Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) 1 3 weeks ago
sql/json query function JsonBehavior default expression's collation may differ from returning type's collation 6100 Committed Bugfix Backport stable 10/10 +113−14 Jian He (stayreal) Amit Langote (amitlan) 1 2 weeks ago
ecpg: check return value of replace_variables() 6110 Committed Bugfix 19 6/10 +7−1 Aleksander Alekseev (a.alekseev) Daniel Gustafsson (d_gustafsson) 1 2 weeks ago
Fix incorrect fprintf usage in log_error FRONTEND path 6126 Committed Bugfix Good First Review 19 10/10 +15−4 Bryan Green (lispyone) Tom Lane (tgl) 1 2 weeks ago
Fix lag columns in pg_stat_replication not advancing when replay LSN stalls 6138 Committed Bugfix Backport 10/10 +13−0 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 6 days ago
Invalid primary_slot_name triggers warnings in all processes on reload 6139 Committed Bugfix Backport GUC 9/10 +58−2 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 1 week ago
BRIN: Prevent the heapblk overflow during index summarization on very large tables resulting in an infinite loop 6143 Committed Bugfix Good First Review Backport stable 10/10 +10−4 Sunil S (sunils26) David Rowley (davidrowley) 1 1 week ago
Fix race condition in SSI when reading PredXact->SxactGlobalXmin 6145 Withdrawn Bugfix 9/10 +15−13 Josh Curtis (joshcurtis) Mihail Nikalayeu (mihailnikalayeu) 1 1 week ago
Clients
display current search_path in psql prompt 5808 Committed 10/10 +21−0 Florents Tselai (florentst) Nathan Bossart (bossartn), Jim Jones (jimus) Nathan Bossart (bossartn) 3 yesterday
Making pg_rewind faster 5902 Committed Performance 19 10/10 +215−13 Justin Kwan (justinpkwan.outlook.com), John Hsu (johnhsu) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 yesterday
psql: Count all table footer lines in pager setup 5949 Committed psql stable 10/10 +382−84 Erik Wienhold (ewie) Tom Lane (tgl) Tom Lane (tgl) 2 2 weeks ago
Tab completion for large objects 5963 Committed 10/10 +12−5 Dagfinn Ilmari Mannsåker (ilmari) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 5 days ago
Code Comments
Fix incorrect comment in pg_get_shmem_allocations_numa() 5927 Committed 19 10/10 +6−9 Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 2 1 week ago
Fix inconsistencies with code and beautify xlog structures description and fin hash_xlog.h 6034 Committed Comments Only stable Needs rebase! Kirill Reshke (reshke) Michael Paquier (michael-kun) 1 1 month ago
Update parser README to include parse_jsontable.c 6036 Committed Comments Only 19 Needs rebase! Karthik S (karthikselvaam.gmail.com) Michael Paquier (michael-kun) 1 1 month ago
fix obsolete references to postgres.h in comments 6068 Moved to different CF 19 10/10 +5−5 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 month ago
Documentation
fix shmem_startup_hook documentation 6042 Moved to different CF 16 10/10 +22−10 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 month ago
Fix CancelRequest documentation for protocol 3.2 6123 Committed Docs Only 18 10/10 +0−0 Jelte Fennema-Nio (jeltef) Magnus Hagander (mha) 1 2 weeks ago
Extend documentation for pg_stat_replication.backend_xmin 6133 Committed Docs Only 19 9/10 +4−0 Renzo Dani (renzo.dani) Fujii Masao (masaofujii) 1 1 week ago
Miscellaneous
Change the names generated for index partitions 5832 Moved to different CF 19 Needs rebase! Tom Lane (tgl) 4 1 month ago
update-po for PGXS does not work 5922 Committed Bugfix Good First Review 10/10 +5−0 Álvaro Herrera (alvherre), Ryo Matsumura (ryo) Bryan Green (lispyone) Álvaro Herrera (alvherre) 2 1 week ago
Enhance statistics reset functions to return reset timestamp 5956 Withdrawn 19 9/10 +307−239 Shinya Kato (shinyakato) 2 yesterday
Avoid overwiriting cache entry (src/backend/utils/cache/relcache.c) 6008 Committed 19 10/10 +5−6 Ranier Vilela (raniervilela) Álvaro Herrera (alvherre) 2 9 hours ago
Add error_on_null() to produce an error if the input is null 6017 Committed 9/10 +74−0 Joel Jacobson (joeljacobson) Vik Fearing (xocolatl) Michael Paquier (michael-kun) 2 1 week ago
revert some recent changes to RequestNamedLWLockTranche() 6032 Moved to different CF 19 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 month ago
PgStat_HashKey padding issue when passed by value 6033 Moved to different CF Bugfix 10/10 +19−13 Michael Paquier (michael-kun) Sami Imseih (simseih) Michael Paquier (michael-kun) 2 1 month ago
Free memory allocated by waitonlock_error_callback() 6069 Withdrawn 19 10/10 +2−0 Aleksander Alekseev (a.alekseev) 1 6 days ago
a couple of small patches for simd.h 6076 Committed 19 10/10 +10−27 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 3 weeks ago
disallow big-endian on aarch64 6098 Withdrawn 19 Not processed Nathan Bossart (bossartn) 1 3 weeks ago
track ABI breaks in stable branches 6140 Committed stable 10/10 +24−0 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 22 minutes ago
Fix POSIX compliance in pgwin32_unsetenv() 6142 Committed 19 10/10 +0−0 Bryan Green (lispyone) Michael Paquier (michael-kun) 1 1 week ago
Monitoring & Control
Improve LWLock tranche name visibility across backends 5940 Moved to different CF 19 10/10 +535−174 Sami Imseih (simseih) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 month ago
Add support for entry counting in pgstats 6052 Committed Monitoring 19 Needs rebase! Michael Paquier (michael-kun) Sami Imseih (simseih) Michael Paquier (michael-kun) 1 1 month ago
Report reorder buffer size 6053 Moved to different CF Monitoring Logical Replication 9/10 +75−11 Ashutosh Bapat (ashutoshbapat) Masahiko Sawada (masahikosawada) 2 1 month ago
Add stats_reset to pg_stat_all_tables|indexes and related views 6097 Committed Monitoring 19 10/10 +776−619 Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 1 3 weeks ago
Performance
SVE enablement for hex-encode and hex-decode 5538 Committed 19 10/10 +418−4 Chiranmoy Bhattacharya (chiranmoy), Susmitha Devanga (susmithad) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 3 weeks ago
parallel pg_restore: avoid disk seeks when jumping short distance forward 5809 Committed 19 10/10 +5−1 Dimitrios Apostolou (jimis) Tom Lane (tgl) Tom Lane (tgl) 2 1 week ago
Make few enhancements in GIN redo and GIN pg_waldump . 6083 Committed stable Needs rebase! Kirill Reshke (reshke) Michael Paquier (michael-kun) 1 2 weeks ago
Procedural Languages
plpython: Remove support for major version conflict detection 5972 Committed PL/Python 10/10 +4−61 Peter Eisentraut (petere) Euler Taveira (eulerto), Mario Gonzalez (gonzalemario) Peter Eisentraut (petere) 2 2 weeks ago
Refactoring
extensible planner state 5994 Committed Extensions 19 10/10 +0−0 Robert Haas (rhaas) Tom Lane (tgl) Robert Haas (rhaas) 2 2 weeks ago
plan shape work 5998 Committed Extensions 19 10/10 +810−653 Robert Haas (rhaas) Robert Haas (rhaas) 2 2 weeks ago
Marking shared buffer lookup table as HASH_FIXED_SIZE 6058 Moved to different CF 10/10 +1−1 Ashutosh Bapat (ashutoshbapat) Andres Freund (andresfreund) 2 1 month ago
Remove Item type 6104 Committed 9/10 +109−184 Peter Eisentraut (petere) Nathan Bossart (bossartn) Peter Eisentraut (petere) 1 2 days ago
Cleanup INFINITY related code in float.h 6107 Committed 19 10/10 +9−44 David Rowley (davidrowley) David Rowley (davidrowley) 1 3 weeks ago
Remove unused #include's 6112 Withdrawn Refactoring Only 19 10/10 +0−64 Aleksander Alekseev (a.alekseev) 1 2 weeks ago
Remove make_temptable_name_n() 6120 Committed Refactoring Only 19 10/10 +15−26 Aleksander Alekseev (a.alekseev) Nathan Bossart (bossartn) 1 1 week ago
remove partColsUpdated 6134 Committed 19 10/10 +0−27 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 week ago
fix type of infomask parameter in static inline functions 6151 Committed 19 10/10 +3−3 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 6 days ago
Replication & Recovery
Invalid pointer access in logical decoding after error 5903 Committed Logical Replication Needs rebase! vigneshwaran C (vignesh.postgres) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 2 2 weeks ago
Add memory_limit_hits to pg_stat_replication_slots 6002 Committed Logical Replication 19 10/10 +112−59 Bertrand Drouvot (bertranddrouvot.pg) Masahiko Sawada (masahikosawada) 2 3 weeks ago
Allow using replication origins in SQL level parallel sessions 6035 Withdrawn Good First Review Logical Replication 19 9/10 +30−1 Emre Hasegeli (hasegeli) 1 1 month ago
issue with synchronized_standby_slots 6153 Committed GUC Logical Replication 19 10/10 +41−43 Shlok Kyal (shlokkyal) Fujii Masao (masaofujii) Amit Kapila (amitkapila) 1 2 days ago
Security
revamp row-security tracking 5397 Withdrawn 19 9/10 +25−17 Nathan Bossart (bossartn) 5 8 months ago
Negative RelfilenumberMap cache entries from pg_filenode_relation() 6066 Withdrawn Good First Review 10/10 +31−9 Ashutosh Bapat (ashutoshbapat) 1 1 month ago
Server Features
Eager aggregation, take 3 4881 Committed 19 10/10 +0−0 Richard Guo (richardguo) Richard Guo (richardguo) 8 2 weeks ago
speedup COPY TO for partitioned table 5467 Committed 19 10/10 +200−36 Jian He (stayreal) vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), newtglobal postgresql_contributors (newtpostgrescontributors) Masahiko Sawada (masahikosawada) 5 1 week ago
Add generic routine to retrieve PG_VERSION contents (Executing pg_createsubscriber with a non-compatible control file) 6117 Committed 19 10/10 +30−84 Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 week ago
SQL Commands
GROUP BY ALL 6085 Moved to different CF 19 10/10 +300−4 David Christensen (davidchristensen) Tom Lane (tgl) Tom Lane (tgl) 2 4 weeks ago
System Administration
Add log_autoanalyze_min_duration 5797 Committed GUC 19 10/10 +120−31 Shinya Kato (shinyakato) Tatsuhito Kasahara (tatsuhito.kasahara) Peter Eisentraut (petere) 3 2 weeks ago
pg_createsubscriber - more logging to say if there are no pubs to drop 6130 Withdrawn Good First Review 10/10 +9−4 Peter Smith (smithpb2250) Masahiko Sawada (masahikosawada) 1 2 weeks ago
New patch