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
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
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 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
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
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
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
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
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: 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
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
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
Documentation
pg_restore add note about -n 5818 Needs review 10/10 +21−40 Florents Tselai (florentst) 3 4 days 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 2 months 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
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
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
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
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
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
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
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
[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
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
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
Accounting for metapages in genericcostestimate() 5727 Needs review 10/10 +55−13 Tom Lane (tgl) 3 5 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
New patch