Commitfest PG19-4 (2026-01-01 – 2026-01-31)

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


Status summary: Needs review: 211. Waiting on Author: 29. Ready for Committer: 29. Committed: 74. Moved to next CF: 19. Rejected: 1. Withdrawn: 9. Total: 372.

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 Bugfix Logical Replication 10/10 +110−6 ChangAo Chen (chenchangao) harinath kanchu (harinath001), Lilian Ontowhee (ontowhee), haiyang li (ocean-li) 8 1 month 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) 7 2 months ago
Fix bug with accessing to temporary tables of other sessions 5379 Needs review Bugfix Backport 18 Needs rebase! Daniil Davydov (dddaniil) Rafia Sabih (rafia.sabih), Jim Jones (jimus) 6 2 months ago
Fix buffer pinning logic/visibility bugs in [SP-]Gist Index-Only Scans 5542 Needs review Needs rebase! Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Matthias van de Meent (mmeent), Mihail Nikalayeu (mihailnikalayeu) 4 3 weeks ago
UPDATE with invalid domain constraint 6031 Needs review Bugfix Backport stable 0/10 +114−0 Jian He (stayreal) 2 4 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) 2 2 months ago
let ALTER TABLE DROP COLUMN drop whole-row referenced object 6055 Needs review Bugfix Backport stable 10/10 +646−5 Jian He (stayreal) 2 3 weeks ago
meson: Fix libpq search order 6056 Needs review Needs rebase! Thomas Munro (macdice) Mario Gonzalez (gonzalemario) 2 2 months ago
Preserve index stats during ALTER TABLE ... TYPE ... 6118 Needs review Bugfix 19 10/10 +576−4 Bertrand Drouvot (bertranddrouvot.pg) 2 2 months ago
avoid call ATPostAlterTypeCleanup twice 6121 Needs review Bugfix Backport stable 10/10 +88−0 Jian He (stayreal) 2 2 months ago
Fix orphaned backend processes on Windows using Job Objects 6201 Needs review Bugfix 19 10/10 +366−0 Bryan Green (lispyone) 1 1 month ago
Windows relation extension failure at 2GB and 4GB 6204 Needs review Bugfix 19 10/10 +298−8 Bryan Green (lispyone) 1 1 month ago
Fix socket handle inheritance on Windows 6207 Needs review Bugfix 10/10 +154−2 Bryan Green (lispyone) 1 2 months ago
Avoid overflow (src/backend/utils/adt/formatting.c) 6209 Needs review Bugfix 19 10/10 +5−2 Ranier Vilela (raniervilela) 1 2 months ago
001_password.pl fails with --without-readline 6238 Needs review Bugfix Testing 19 10/10 +58−27 Oleg Tselebrovskiy (oleg.tselebrovskiy.pgpro) Soumya S Murali (soumyamurali) Tom Lane (tgl) 1 2 hours ago
Visibility bug in tuple lock 6253 Needs review Bugfix 19 Needs rebase! David Geier (geidav) Heikki Linnakangas (heikki) 1 4 weeks ago
Fix crash during recovery when redo segment is missing 6279 Needs review Bugfix Backport Needs rebase! Nitin Jadhav (nitinjadhav11) 1 1 month ago
Incorrect historic snapshot may be serialized to disk during fast-forwarding 6304 Needs review Bugfix 9/10 +12−9 ChangAo Chen (chenchangao), haiyang li (ocean-li) 1 2 weeks ago
Assert when executing query on partitioned table 6353 Needs review Bugfix 19 10/10 +4−7 Dmitry Koval (d.koval) 1 2 weeks ago
Clients
Improve tab completion for various SET/RESET forms 5810 Needs review 19 10/10 +74−11 Dagfinn Ilmari Mannsåker (ilmari) Shinya Kato (shinyakato) 3 2 months ago
Add prompt option to display read-only and read/write states in psql 5872 Needs review psql Good First Review 19 10/10 +66−0 Jim Jones (jimus) Fujii Masao (masaofujii), Nathan Bossart (bossartn), Srinath Reddy (srinath-reddy-sadipiralla) 4 2 months ago
TAB completion for ALTER TABLE ... ALTER CONSTRAINT ... ENFORCED 5968 Needs review psql stable 9/10 +16−0 Kirill Reshke (reshke) Roman Khapov (rkhapov) 2 2 weeks ago
libpq: Bump protocol version to version 3.2 at least until the first/second beta (aka protocol grease) 6157 Needs review libpq 10/10 +159−41 Jelte Fennema-Nio (jeltef) Jacob Champion (jchampion) Jacob Champion (jchampion) 2 2 days ago
psql: add \dcs to list all constraints 6220 Needs review psql 19 0/10 +745−3 Tatsuro Yamada (tatsuro_yamada) Jim Jones (jimus) 1 15 hours ago
Adds two new modifiers for \dt[Oo] and \di[Oo]. This helps inspect large deployments where relation size is important. 6258 Needs review psql My First Patch 19 10/10 +25−3 M.Atıf CEYLAN (ceylani) Mahmoud Ayman (mahmoudayman) 1 1 week ago
Proposal to allow setting cursor options on Portals 6292 Needs review libpq 2/10 +399−6 Dave Cramer (dcramer) Jelte Fennema-Nio (jeltef) 1 yesterday
Support named (destination) portals in extended proto for psql meta commands. 6321 Needs review stable 10/10 +158−16 Kirill Reshke (reshke) Sami Imseih (simseih) 1 1 week ago
Code Comments
Add comments about fire_triggers argument in ri_triggers.c 5679 Needs review 10/10 +7−1 Yugo Nagata (yugo.nagata) 4 1 month ago
Change comment in `contrib/amcheck` regression suite 6287 Needs review Help - Bikeshedding 10/10 +33−8 Kirill Reshke (reshke) 1 2 days ago
Fix typo 586/686 in atomics/arch-x86.h 6295 Needs review 19 10/10 +1−1 Jakub Wartak (jakub.wartak.tomtom) 1 3 weeks ago
Add a berief general comment on BTScanInsertData's nextkey and backward 6363 Needs review 10/10 +3−2 Yugo Nagata (yugo.nagata) 1 1 month ago
Documentation
refactor func-matching.sgml, make regexp* function more readable 6144 Needs review Docs Only 19 10/10 +114−76 Jian He (stayreal) 2 3 months ago
Add a warning on stats manipulation functions 6155 Needs review Docs Only 19 10/10 +6−0 Yugo Nagata (yugo.nagata) 2 2 months ago
doc: Clarify ANALYZE VERBOSE output 6259 Needs review Docs Only stable 10/10 +2−1 Shinya Kato (shinyakato) 1 2 months ago
Clarify the scope and intended use of pg_dumpall 6282 Needs review Docs Only 19 10/10 +13−4 Laurenz Albe (laurenz) 1 1 month ago
Add Restart Policy to Systemd Unit File 6344 Needs review 10/10 +1−0 Andrew Jackson (andrewjackson) 1 1 month ago
Miscellaneous
pgbench - adding pl/pgsql versions of tests 4105 Needs review 19 10/10 +247−14 Hannu Krosing (hannukrosing) Fabien Coelho (calvin), Yugo Nagata (yugo.nagata), Robert Treat (xzilla) 8 5 days ago
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) 11 9 months ago
Avoid orphaned objects dependencies, take 3 4942 Needs review 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 9 2 months ago
Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup 5570 Needs review Multithreading AIO 10/10 +448−37 Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 5 2 months ago
pgindent: improve formatting of multiline comments 5831 Needs review 19 10/10 +5−5 Aleksander Alekseev (a.alekseev) Nathan Bossart (bossartn) 4 4 weeks ago
Use enum type replacing #define for exec state of hashjoin and mergejoin 6027 Needs review 10/10 +36−27 Tender Wang (tndrwang) 2 2 months ago
Improving the names generated for indexes on expressions 6059 Needs review 10/10 +265−159 Tom Lane (tgl) 2 2 months ago
O_CLOEXEC not honored on Windows - handle inheritance chain 6197 Needs review 19 Needs rebase! Bryan Green (lispyone) 2 3 weeks ago
Refactor how we form HeapTuples for CatalogTuple(Insert|Update) 6221 Needs review Refactoring Only 19 10/10 +3194−3144 Greg Burd (gregburd) 1 6 hours ago
enhance wraparound warnings 6222 Needs review 19 10/10 +100−18 Nathan Bossart (bossartn) 1 1 month ago
parallel pgbench -i 6242 Needs review Performance 7/10 +420−35 Mircea Cadariu (mcadariu) 1 1 month ago
Use ROLERECURSE_PRIVS in is_admin_of_role() 6251 Needs review Good First Review 10/10 +16−1 ChangAo Chen (chenchangao) 1 3 weeks ago
Support getrandom() for pg_strong_random() source 6283 Needs review 19 9/10 +259−35 Masahiko Sawada (masahikosawada) 1 1 week ago
Adding TRIM_SPACE option to COPY 6289 Needs review 19 10/10 +67−3 Tatsuya Kawata (croissant) 1 1 month ago
Make copyObject work in C++ 6291 Needs review Extensions Needs rebase! Jelte Fennema-Nio (jeltef) Akshat Jaimini (akshatj) Peter Eisentraut (petere) 1 2 days ago
Safer and easier to use hash table initialization macro 6301 Needs review Refactoring Only 0/10 +917−1402 Bertrand Drouvot (bdrouvot), Jelte Fennema-Nio (jeltef) 1 2 days ago
change default default_toast_compression to lz4 6312 Needs review Performance GUC 10/10 +33−4 Euler Taveira (eulerto) Peter Eisentraut (petere) 1 1 month ago
Enable partitionwise join for partition keys wrapped by RelabelType 6315 Needs review 10/10 +53−2 Matheus Alcantara (matheus.alcantara) 1 yesterday
Add sanity check for duplicate enum values in GUC definitions 6316 Needs review GUC 19 10/10 +75−0 Chao Li (chaol) 1 4 weeks ago
Propagate XLogFindNextRecord error to callers 6320 Needs review 19 10/10 +47−16 Anthonin Bonnefoy (bonnefoa) 1 1 month ago
Message in pg_terminate_backend 6331 Needs review Good First Review 19 Needs rebase! Roman Khapov (rkhapov) 1 3 weeks ago
Add --extra-dependencies and immediate data dumping for pg_dump/pg_upgrade 6340 Needs review 19 10/10 +220−6 Jeevan Chalke (jeevan.chalke) 1 3 weeks ago
Add "format" target to make and ninja to run pgindent and pgperltidy 6366 Needs review Devtools 10/10 +315−28 Jelte Fennema-Nio (jeltef) 1 1 week ago
Generate pkg-config for server module development 6367 Needs review 10/10 +27−13 Anders Åstrand (anders_a) 1 1 week ago
Monitoring & Control
relfilenode statistics 5007 Needs review 18 10/10 +690−84 Bertrand Drouvot (bertranddrouvot.pg) 9 3 days ago
Logging plan of the currently running query 5330 Needs review Monitoring 18 10/10 +645−34 Atsushi Torikoshi (atsushitorikoshi) Hironobu Suzuki (suzuki_hironobu), Akshat Jaimini (akshatj), Sadeq Dousti (msdousti) 7 1 month 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) 5 2 months ago
Leaf and internal block access stats for indexes 5614 Needs review Monitoring My First Patch Help - User Testing 19 10/10 +202−3 Mircea Cadariu (mcadariu) Frédéric Yhuel (yhuelf) 5 1 month ago
Support for basic ALTER TABLE progress reporting. 5873 Needs review Monitoring 10/10 +83−6 Jiří Kavalík (jkavalik) Jian He (stayreal) 3 5 months ago
Report bytes and transactions actually sent downtream 5877 Needs review Monitoring Logical Replication 10/10 +452−190 Ashutosh Bapat (ashutoshbapat) 4 4 days ago
Enhancing Memory Context Statistics Reporting 5938 Needs review Monitoring 19 0/10 +1495−21 Rahila Syed (rahila) Atsushi Torikoshi (atsushitorikoshi) 3 2 days ago
Adding locks statistics 5942 Needs review 19 10/10 +553−4 Bertrand Drouvot (bertranddrouvot.pg) 3 5 months ago
Adding per backend commit and rollback counters 5947 Needs review 19 10/10 +296−2 Bertrand Drouvot (bertranddrouvot.pg) 3 4 months ago
Per backend relation statistics tracking 5958 Needs review 19 9/10 +261−2 Bertrand Drouvot (bertranddrouvot.pg) 3 4 months ago
Add last_executed timestamp to pg_stat_statements 6308 Needs review Extensions Good First Review Monitoring 19 10/10 +286−4 Pavlo Golub (pasha_golub) 1 1 month ago
pg_stat_statements: Fix nested tracking for implicitly closed cursors 6342 Needs review 10/10 +309−26 Sami Imseih (simseih) 1 2 hours ago
Performance
[CREATE|RE] INDEX CONCURRENTLY with single heap scan 4971 Needs review Performance 19 10/10 +2867−479 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Matthias van de Meent (mmeent) 8 yesterday
Asynchronous MergeAppend Execution 5129 Needs review 10/10 +1441−710 Alexander Pyhalov (a.pyhalov) Matheus Alcantara (matheus.alcantara) 7 2 weeks ago
Parallel heap vacuum 5326 Needs review Needs rebase! Masahiko Sawada (masahikosawada) Hayato Kuroda (ha-kun) 7 3 months 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) 5 3 months ago
Expanding HOT updates for expression and partial indexes 5556 Needs review Performance 19 10/10 +2380−511 Greg Burd (gregburd) 4 3 days ago
Reduce timing overhead of EXPLAIN ANALYZE using rdtsc 5622 Needs review 8/10 +470−44 Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) 4 5 days ago
Create DATA dump objects for partitioned tables too 5692 Needs review 10/10 +223−41 Tom Lane (tgl) 4 9 months ago
Accounting for metapages in genericcostestimate() 5727 Needs review 10/10 +55−13 Tom Lane (tgl) 4 8 months ago
Parallel processing of indexes in autovacuum 5755 Needs review 18 Needs rebase! Maxim Orlov (m.orlov), Daniil Davydov (dddaniil) Masahiko Sawada (masahikosawada), Sami Imseih (simseih) 4 4 hours ago
Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume 5841 Needs review 19 10/10 +914−840 Melanie Plageman (melanieplageman) Kirill Reshke (reshke) 4 13 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) 3 6 months ago
Automatically sizing the IO worker pool 5913 Needs review 19 Needs rebase! Thomas Munro (macdice) 2 5 months ago
Eagerly evict bulkwrite strategy ring 5919 Needs review 19 Needs rebase! Melanie Plageman (melanieplageman) 4 3 days ago
Speed up COPY FROM text/CSV parsing using SIMD 5952 Needs review 19 9/10 +210−2 Shinya Kato (shinyakato) Nathan Bossart (bossartn), Ayoub Kazar (kaz) Nathan Bossart (bossartn) 2 3 days ago
Stack-based tracking of per-node WAL/buffer usage 6023 Needs review 19 10/10 +739−353 Lukas Fittl (lfittl) 3 yesterday
Improve read_local_xlog_page_guts by replacing polling with latch-based waiting 6024 Needs review Performance Logical Replication 19 0/10 +59−11 Xuneng Zhou (dylanzhou) 2 1 month ago
Checkpointer write combining 6043 Needs review Needs rebase! Melanie Plageman (melanieplageman) 2 2 days ago
pg_stat_statements: faster search by queryid 6136 Needs review 10/10 +859−217 Karina Litskevich (karinalitskevich) Sami Imseih (simseih) 2 3 months ago
postgres_fdw: Use COPY to speed up batch inserts 6137 Needs review 10/10 +303−3 Matheus Alcantara (matheus.alcantara) 2 1 week ago
Optimization of the is_normalized() function. 6152 Needs review Performance 19 10/10 +6626−8086 Alexander Borisov (lexborisov) 2 2 months ago
Optimize shared LWLock acquisition for high-core-count systems 6191 Needs review Performance Multithreading 19 10/10 +88−16 Zhiguo Zhou (zhiguozhou) 2 5 months ago
Lock-free XLog Reservation from WAL 6192 Needs review Performance Multithreading 19 10/10 +532−57 Yura Sokolov (funny_falcon), Zhiguo Zhou (zhiguozhou) 2 2 months ago
Increase NUM_XLOGINSERT_LOCKS 6193 Needs review Multithreading Performance 19 10/10 +34−21 Yura Sokolov (funny_falcon) 2 11 months ago
Write Notifications Through WAL 6205 Needs review Performance Needs rebase! Rishu Bagga (rishub) 1 1 month ago
Reduce unnecessary locking of pruned partitions when reusing cached plans 6216 Needs review Performance 19 10/10 +963−85 Amit Langote (amitlan) 1 1 month ago
Bypassing cursors in postgres_fdw to enable parallel plans 6233 Needs review postgres_fdw Performance 19 Needs rebase! Rafia Sabih (rafia.sabih) 1 1 month ago
Better Performance for PostgreSQL with large INSERTs 6266 Needs review Performance GUC 19 10/10 +24−14 Filip Januš (fjanus) 1 1 month ago
Add a greedy join search algorithm to handle large join problems 6274 Needs review 1/10 +1868−4 Chengpeng Yan (chengpeng.yan) 1 1 week ago
New grouping strategy - Index Aggregate 6299 Needs review Performance stable 8/10 +4370−832 Sergey Solovev (ashblade) 1 1 week ago
Expose checkpoint timestamp and duration in pg_stat_checkpointer 6307 Needs review Extensions 19 Needs rebase! Soumya S Murali (soumyamurali) 1 1 month ago
CRC32C optimizations using SVE2 on ARM. 6329 Needs review Performance 19 Needs rebase! Susmitha Devanga (susmithad) 1 1 week ago
Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations 6334 Needs review 19 9/10 +46−18 Andreas Karlsson (kandreas) 1 2 days ago
Reuse data from readRecordBuf in XLogDecodeNextRecord 6343 Needs review AIO Performance My First Patch 19 2/10 +97−68 Sonya Valchuk (pyos) 1 1 month ago
Streamify more code paths 6346 Needs review Extensions AIO 19 10/10 +300−46 Xuneng Zhou (dylanzhou) 1 2 weeks ago
Improve performance of tuple deformation 6352 Needs review 1/10 +700−635 David Rowley (davidrowley) 1 2 weeks ago
Hash-based MCV matching for large IN-lists 6356 Needs review Performance stable 10/10 +1062−1 Ilia Evdokimov (ilidock95) 1 2 days ago
Procedural Languages
declarative session variables, LET command 1608 Needs review 10/10 +2950−37 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) 39 1 week ago
Refactoring
SendProcSignal(), SetLatch() → SendInterrupt() 5118 Needs review Needs rebase! Heikki Linnakangas (heikki), Thomas Munro (macdice) 4 5 months ago
Don't dirty pages while they are getting flushed out 5483 Needs review Needs rebase! Andres Freund (andresfreund) 4 14 hours ago
Beautify read stream "per buffer data" APIs 5617 Needs review 10/10 +90−16 Thomas Munro (macdice) 4 2 months ago
Make numeric type accessible to third-party code. 5623 Needs review stable 9/10 +290−285 Ed Behn (edbehn) Jelte Fennema-Nio (jeltef) 4 1 week ago
ternary reloption type 6021 Needs review 19 10/10 +202−43 Nikolay Shaplov (nataraj) Álvaro Herrera (alvherre) 3 4 hours ago
Get rid of pgstat_count_backend_io_op*() functions 6025 Needs review Performance 19 10/10 +31−57 Bertrand Drouvot (bertranddrouvot.pg) 2 3 months ago
refactor CreateStatsStmt 6106 Needs review 19 10/10 +149−101 Jian He (stayreal) Álvaro Herrera (alvherre) 2 2 months ago
Little refactoring of portalcmds.c 6113 Needs review Refactoring Only 9/10 +16−24 Aleksander Alekseev (a.alekseev) 2 2 months ago
quoteOneName() inconsistency with quote_all_identifiers — replacement API proposed: appendStringInfoIdentifier 6240 Needs review Refactoring Only 19 Needs rebase! Chao Li (chaol) 1 1 month ago
Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) 6245 Needs review Performance My First Patch 19 7/10 +598−33 Boris Mironov (bmironov) 1 1 month ago
Minor refactor of ExecScanExtended() 6255 Needs review Refactoring Only Good First Review 10/10 +6−9 ChangAo Chen (chenchangao) 1 2 months ago
Cleanup shadows variable warnings 6262 Needs review Refactoring Only 19 10/10 +658−667 Chao Li (chaol) 1 1 month ago
Remove unused function parameters, part 1: contrib 6263 Needs review 19 10/10 +50−80 Bertrand Drouvot (bertranddrouvot.pg) 1 1 month ago
Remove unused function parameters, part 2: replication 6264 Needs review 19 10/10 +44−44 Bertrand Drouvot (bertranddrouvot.pg) 1 1 month ago
<stdatomic.h> 6268 Needs review Needs rebase! Thomas Munro (macdice) 1 1 month ago
Safer hash table initialization macro 6276 Needs review 19 0/10 +917−1402 Bertrand Drouvot (bertranddrouvot.pg) 1 2 days ago
refactor ExecInitPartitionInfo 6280 Needs review stable 10/10 +13−23 Jian He (stayreal) 1 1 month ago
Give StartReadBuffers() a more robust interface. 6297 Needs review AIO 19 10/10 +0−0 Thomas Munro (macdice) Xuneng Zhou (dylanzhou) 1 3 months ago
refactor handling optional argument in system functions 6303 Needs review Refactoring Only 19 9/10 +56−159 Mark Wong (markwkm) 1 1 month ago
Refactor query normalization into core query jumbling 6326 Needs review 19 10/10 +280−271 Sami Imseih (simseih) 1 1 week ago
Refactor PROCLOCK hash table into partitioned list allocator 6358 Needs review 10/10 +325−310 Andrey Borodin (x4m) 1 1 week ago
Replication & Recovery
CREATE SUBSCRIPTION ... SERVER 4529 Needs review 10/10 +810−155 Jeff Davis (jdavis) vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) 11 5 days ago
Return pg_control from pg_backup_stop(). 4997 Needs review 19 10/10 +178−28 David Steele (dsteele) 9 5 months ago
Extending FK check skipping on replicas to ADD FK and TRUNCATE 5774 Needs review Performance Help - Stuck Rebasing Logical Replication 19 10/10 +96−3 Hannu Krosing (hannukrosing) 3 5 days ago
Make wal_receiver_timeout configurable per subscription 5781 Needs review 10/10 +244−101 Fujii Masao (masaofujii) 4 2 months 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) 2 1 week ago
Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array 6141 Needs review Performance Logical Replication Refactoring Only 19 10/10 +307−69 Xuneng Zhou (dylanzhou) Kirill Reshke (reshke) 2 18 hours ago
Add archive_mode to prevent unarchived WAL on permanent primary failure 6177 Needs review Physical Replication 19 9/10 +805−43 Andrey Borodin (x4m) 2 2 months ago
Optimize SnapBuild by maintaining committed.xip in sorted order 6187 Needs review Performance Logical Replication 19 10/10 +151−25 Xuneng Zhou (dylanzhou) 2 1 month ago
Introduce a new GUC to allow logical walsender to shutdown immediately without waiting for a response from the client. 6234 Needs review Backport GUC Logical Replication 2/10 +235−0 Andrey Silitskiy (andrey-silitskiy) Fujii Masao (masaofujii) 1 yesterday
Proposal: Conflict log history table for Logical Replication 6252 Needs review Logical Replication 19 6/10 +1758−150 Dilip Kumar (dilip.kumar) 1 19 hours ago
Add WALRCV_CONNECTING state to walreceiver 6311 Needs review Monitoring 19 Needs rebase! Xuneng Zhou (dylanzhou) 1 5 days ago
add new parameter to pg_replication_origin_session_setup 6337 Needs review Backport Logical Replication Needs rebase! Zhijie Hou (houzj) 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) 9 4 months ago
Don't use the deprecated and insecure PQcancel in our frontend tools anymore 6314 Needs review psql Security 0/1 +420−329 Jelte Fennema-Nio (jeltef) 1 1 month ago
Server Features
Sequence Access Methods, round two 4677 Needs review Needs rebase! Michael Paquier (michael-kun) 11 1 week ago
Changing shared_buffers without restart 5319 Needs review Needs rebase! Dmitry Dolgov (erthalion) Vladlen Popolitov (vladlenpopolitov) 7 2 months ago
using index to speedup add not null constraints to a table 5444 Needs review 18 10/10 +606−6 Jian He (stayreal) Tanzeel Khan (tanzeelk) Álvaro Herrera (alvherre) 5 21 hours ago
Extended Statistics set/restore/clear functions 5517 Needs review 10/10 +2684−1 Corey Huinker (coreyh) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 5 2 hours ago
support fast default for domain with constraints 5641 Needs review Needs rebase! Jian He (stayreal) 4 4 months ago
support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint 5645 Needs review 10/10 +54−27 Jian He (stayreal) 4 10 hours ago
support create index on virtual generated column. 5667 Needs review 10/10 +1114−80 Jian He (stayreal) 4 1 week ago
Allow to collect statistics on virtual generated columns 5714 Needs review 19 10/10 +167−28 Yugo Nagata (yugo.nagata) 4 4 months ago
virtual generated column as partition key 5720 Needs review 19 0/1 +704−64 Jian He (stayreal) 4 1 week ago
finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it 5759 Needs review 19 10/10 +337−31 Jian He (stayreal) Vaibhav Dalvi (vaibhavdalvi) 4 3 days ago
ALTER DOMAIN ADD NOT NULL NOT VALID 5768 Needs review 19 10/10 +214−26 Jian He (stayreal) 4 3 months 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) 3 3 months ago
foreign key on virtual generated column 5782 Needs review 19 10/10 +315−93 Jian He (stayreal) Srinath Reddy (srinath-reddy-sadipiralla) 4 2 months ago
Support for 8-byte TOAST values (aka the TOAST infinite loop problem) 5830 Needs review 19 10/10 +1480−371 Michael Paquier (michael-kun) Tom Lane (tgl), Nikhil Kumar Veldanda (nikhilkumarv) 4 1 week ago
no table rewrite when set column type to constrained domain 5907 Needs review 19 10/10 +183−10 Jian He (stayreal) 3 4 months ago
pg_waldump: support decoding of WAL inside tarfile 5955 Needs review 19 10/10 +1310−205 Amul Sul (sulamul) 3 5 hours ago
implement CAST(expr AS type FORMAT 'template') 5957 Needs review 19 2/10 +881−10 Jian He (stayreal) 3 5 months ago
Import Statistics in postgres_fdw before resorting to sampling. 5959 Needs review 19 9/10 +983−20 Corey Huinker (coreyh) 3 9 hours ago
ALTER COLUMN SET EXPRESSION [GENERATED|STORED] 6010 Needs review 19 10/10 +633−13 Jian He (stayreal) 3 1 week ago
NOT NULL NOT ENFORCED 6029 Needs review 19 10/10 +783−97 Jian He (stayreal) Haritabh Gupta (haritabhgupta), Kuba Knysiak (xsni12) Álvaro Herrera (alvherre) 2 1 week ago
let ALTER COLUMN SET DATA TYPE cope with POLICY dependency 6054 Needs review 19 9/10 +705−61 Jian He (stayreal) 2 4 months ago
CREATE TABLE LIKE INCLUDING POLICIES 6064 Needs review 19 10/10 +672−55 Jian He (stayreal) 2 4 months ago
let ALTER COLUMN SET DATA TYPE cope with trigger dependency 6089 Needs review 19 10/10 +380−44 Jian He (stayreal) 2 3 months ago
Alow ALTER COLUMN TYPE when dependent generated column has SET EXPRESSION 6146 Needs review 19 Needs rebase! Chao Li (chaol) 2 2 months ago
Add GoAway protocol message for graceful but fast server shutdown/switchover 6156 Needs review libpq 2/10 +329−13 Jelte Fennema-Nio (jeltef) 2 1 week ago
Add pg_get_role_ddl() functions for role recreation 6166 Needs review 9/10 +551−1 Mario Gonzalez (gonzalemario), Bryan Green (lispyone) Japin Li (japin) 2 11 hours ago
NLS: use gettext() to translate system error messages 6172 Needs review 19 10/10 +71−2 Jeff Davis (jdavis) 2 1 week ago
Add pg_get_type_ddl() to retrieve the CREATE TYPE statement 6185 Needs review 10/10 +1019−0 Phil Alger (paalger) 2 2 months ago
pg_get_domain_ddl: DDL reconstruction function for CREATE DOMAIN statement 6212 Needs review Good First Review 19 Needs rebase! Florin Irion (irionr), Tim Waizenegger (tim.waizenegger.edb) Haritabh Gupta (haritabhgupta), Kuba Knysiak (xsni12) 1 1 month ago
Add pg_get_database_ddl() function to reconstruct CREATE DATABASE statement 6215 Needs review 10/10 +642−0 Akshay Joshi (akshay.joshi) Japin Li (japin) 1 18 hours ago
Give Plugins control at the end of CHECKPOINT to store their state 6224 Needs review Extensions 19 9/10 +215−0 Andrei Lepikhov (lepikhov), Asif Rehman (asifrana) 1 2 months ago
IS JSON predicate support for domain base type as JSON/JSONB/BYTEA/TEXT 6237 Needs review 19 10/10 +356−9 Jian He (stayreal) 1 1 month ago
extend JSON_TABLE top level path expression 6260 Needs review 19 10/10 +238−105 Jian He (stayreal) 1 1 month ago
UPDATE run check constraints for affected columns only 6270 Needs review 19 10/10 +131−11 Jian He (stayreal) 1 1 month ago
Qual push down to table AM 6271 Needs review 10/10 +27−15 Julien Tachoires (julmon) Miłosz Bieniek (moozzi) 1 1 month ago
PoC: Simplify recovery after dropping a table by LOGGING the restore LSN 6272 Needs review GUC My First Patch 19 Needs rebase! Dmitry Lebedev (dmitrylebedev) 1 1 month ago
explain plans for foreign scans 6285 Needs review 19 10/10 +964−9 dinesh salve (dinesh-salve) Sami Imseih (simseih) 1 1 week ago
SQL-level pg_datum_image_equal 6309 Needs review Needs rebase! Matthias van de Meent (mmeent) 1 3 weeks ago
json_table function PLAN clause 6332 Needs review Help - User Testing 19 10/10 +2312−168 Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Nikita Malakhov (nmalakh) 1 3 weeks ago
File locks for data directory lockfile in the context of Linux namespaces 6335 Needs review stable Needs rebase! Dmitry Dolgov (erthalion) 1 4 weeks ago
Storage layer hooks to enable data transformation in extensions 6351 Needs review Extensions My First Patch 10/10 +1718−3 Henson Choi (assam258.gmail.com) 1 2 weeks ago
Remove Int8GetDatum, DatumGetUInt8 and UInt8GetDatum funcitons 6354 Needs review 19 10/10 +9−38 Aleksander Alekseev (a.alekseev), Kirill Reshke (reshke) 1 1 week ago
Remove support for standard_conforming_strings = off 6359 Needs review 9/10 +155−661 Tom Lane (tgl) 1 1 week ago
SQL Commands
Implement row pattern recognition feature 4460 Needs review 19 10/10 +9704−60 Tatsuo Ishii (ishii), Henson Choi (assam258.gmail.com) Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033), Henson Choi (assam258.gmail.com) 13 21 hours ago
Make COPY format extendable: Extract COPY TO format implementations 4681 Needs review Needs rebase! Kouhei Sutou (kou) Masahiko Sawada (masahikosawada), Zhao Junwang (zhjwpku), Yong Li (yoli) 9 1 month ago
COPY TO json 4716 Needs review Needs rebase! Joe Conway (jconway) Masahiko Sawada (masahikosawada) Joe Conway (jconway) 9 1 month ago
SQL Property Graph Queries (SQL/PGQ) 4904 Needs review 10/10 +14822−211 Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat) Vik Fearing (xocolatl), Zhao Junwang (zhjwpku), Hannu Krosing (hannukrosing), Henson Choi (assam258.gmail.com) 9 3 days ago
Add OR REPLACE option to CREATE MATERIALIZED VIEW 5099 Needs review 19 10/10 +694−98 Erik Wienhold (ewie) Paul Jungwirth (pjungwir), newtglobal postgresql_contributors (newtpostgrescontributors) 7 5 months ago
Add XMLCast (SQL/XML X025) 5110 Needs review 19 10/10 +2474−13 Jim Jones (jimus) Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) 9 6 hours ago
Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) 5279 Needs review 19 10/10 +1490−59 Jim Jones (jimus) newtglobal postgresql_contributors (newtpostgrescontributors) 7 2 months ago
SQL:2011 Application Time Update & Delete 5836 Needs review 19 10/10 +157−14 Paul Jungwirth (pjungwir) Peter Eisentraut (petere) 4 6 days ago
Allow ON CONFLICT DO UPDATE to return EXCLUDED values 5854 Needs review 19 10/10 +741−269 Dean Rasheed (deanr) Viktor Holmberg (rutchkiwi) 4 3 months ago
CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 5941 Needs review 19 10/10 +2960−509 Jian He (stayreal) Peter Eisentraut (petere) 3 2 days ago
CREATE SCHEMA ... CREATE DOMAIN support 5985 Needs review 19 10/10 +883−149 Jian He (stayreal) 3 4 weeks ago
create table like including storage parameter 6088 Needs review 19 10/10 +201−9 Jian He (stayreal) Nathan Bossart (bossartn) 2 4 weeks ago
ON CONFLICT DO SELECT 6109 Needs review 19 10/10 +1829−304 Viktor Holmberg (rutchkiwi) Dean Rasheed (deanr) 2 3 days ago
COPY FROM with RLS 6178 Needs review 19 10/10 +238−14 Jian He (stayreal) 2 2 months ago
ago(interval) → timestamptz 6202 Needs review 19 10/10 +25−0 Florents Tselai (florentst) 1 2 months ago
implement GRANT/REVOKE ... GRANTED BY 6218 Needs review 19 10/10 +68−28 Nathan Bossart (bossartn) Adam Brusselback (tostino) 1 2 months ago
Add support for partial incremental materialized view refresh using REFRESH ... WHERE 6305 Needs review My First Patch 19 10/10 +1477−74 Adam Brusselback (tostino) Dharin Shah (dharins0) 1 yesterday
Cleaning up PREPARE query strings? 6341 Needs review 10/10 +72−25 Julien Rouhaud (rjuju) Sami Imseih (simseih) 1 yesterday
Create unique GiST index 6368 Needs review Bugfix 19 10/10 +447−17 Paul Jungwirth (pjungwir) 1 2 weeks ago
System Administration
Adding pg_dump flag for parallel export to pipes 5893 Needs review Performance stable 1/10 +478−72 Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) Dilip Kumar (dilip.kumar) 2 3 days ago
Change initdb default to the builtin collation provider 6198 Needs review 19 7/10 +28−3 Jeff Davis (jdavis) 2 2 months ago
Testing
RFC: adding pytest as a supported test framework 6045 Needs review Testing Help - User Testing Help - Bikeshedding 10/10 +3747−249 Jacob Champion (jchampion), Jelte Fennema-Nio (jeltef) Jelte Fennema-Nio (jeltef) 2 6 days ago
CI: Add task that runs pgindent 6148 Needs review CI 10/11 +40−2 Jelte Fennema-Nio (jeltef) 2 2 months ago
Support for EXTRA_REGRESS_OPTS and TEMP_CONFIG for meson tests 6361 Needs review 10/10 +9−0 Andreas Karlsson (kandreas) 1 3 days ago