Commitfest 2025-03

Shortcuts
Text Status Target version Author (type to search) Reviewer (type to search)
Clear


Status summary: Needs review: 27. Waiting on Author: 28. Ready for Committer: 5. Committed: 154. Moved to next CF: 92. Returned with Feedback: 9. Rejected: 6. Withdrawn: 22. Total: 343.

Active patches

Patch ID Status 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 Needs rebase! Kyotaro Horiguchi (horiguti) Hayato Kuroda (ha-kun), Yasir Shah (yasir.hussain.shah.gmail.com) 8 1 month ago
"unexpected duplicate for tablespace" problem in logical replication 4720 Needs review stable 6/7 +0−0 Shenhao Wang (wangshenhao) Masahiko Sawada (masahikosawada) 7 1 month ago
data loss bug in initial sync of logical replication 4766 Needs review 7/7 +134−15 Tomas Vondra (fuzzycz) Nitin Motiani (nitinmotiani), work nsandeepkumar (nsandeepk) 6 2 weeks ago
Fix rare recovery shutdown hang 4884 Waiting on Author Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch), Martijn Wallet (mwallet) 5 4 months ago
WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts 4986 Waiting on Author 6/7 +6−2 Matthias van de Meent (mmeent) Akshat Jaimini (akshatj) 5 4 months ago
Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state 5029 Needs review 7/7 +121−6 ChangAo Chen (chenchangao) 5 3 weeks ago
inplace update: send nontransactional invalidations 5091 Needs review stable 6/7 +0−0 Noah Misch (nmisch) Noah Misch (nmisch) 5 5 months ago
Incremental Sort Cost Estimation Instability 5093 Needs review 18 6/7 +180−32 Andrei Lepikhov (lepikhov) 5 5 months ago
Prevent incorrect entries in pg_stat_activity. 5105 Waiting on Author 6/7 +19−2 Fujii Masao (masaofujii) 4 4 months ago
Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() 5124 Waiting on Author Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch) 4 1 month ago
psql client does not handle WSAEWOULDBLOCK on Windows 5154 Waiting on Author 7/7 +1−1 Umar Hayat (pgwizard) 4 4 months ago
Fix standby may crash when switching-over in certain special cases 5199 Needs review 7/7 +2−2 pixian shi (pxshi) 4 4 months ago
Fix race between WAL flush and InstallXLogFileSegment() 5276 Waiting on Author Needs rebase! Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) 3 5 months ago
Fix for consume_xids advancing XIDs incorrectly 5303 Waiting on Author stable 6/7 +0−0 Yushi Ogiwara (yushi) 3 4 months ago
Fix creation of empty .log files during log rotation 5365 Waiting on Author 6/7 +15−12 Arseny Kositsin (arseny114) 2 1 month ago
Bug: mdunlinkfiletag unlinks mainfork seg.0 instead of indicated fork+segment 5454 Needs review 7/7 +10−7 Matthias van de Meent (mmeent) 2 4 months ago
Clients
Adding comments to help understand psql hidden queries 4764 Waiting on Author Needs rebase! David Christensen (davidchristensen), Greg Sabino Mullane (greg) Tom Lane (tgl) 6 4 weeks ago
psql \dh: List High-Level (Root) Tables and Indexes 5594 Needs review stable 7/7 +174−7 Sadeq Dousti (msdousti) Greg Sabino Mullane (greg), Sergey Dudoladov (sdudoladov) 1 1 month ago
Documentation
Windows meson build 5522 Ready for Committer 14/14 +0−0 Kohei Harikae (koheiharikae) Vladlen Popolitov (vladlenpopolitov) 1 2 months ago
Miscellaneous
Expand applicability of aggregate's sortop optimization 4980 Needs review 7/7 +352−47 Matthias van de Meent (mmeent) Andrei Lepikhov (lepikhov) 5 3 weeks ago
postgres_fdw could deparse ArrayCoerceExpr 5409 Ready for Committer 18 7/7 +80−0 Alexander Pyhalov (a.pyhalov) Maxim Orlov (m.orlov) 2 2 months ago
Coccinelle for PostgreSQL development 5509 Needs review 18 6/7 +845−8 Mats Kindahl (matski) 1 1 month ago
Waiting for LSN replay with WAIT FOR command 5550 Waiting on Author Needs rebase! Alexander Korotkov (smagen) Yura Sokolov (funny_falcon) 1 1 month ago
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) 16 1 month ago
Logging parallel worker draught 4291 Ready for Committer 19 7/7 +93−0 Benoit Lobréau (benoitl) Sami Imseih (simseih) 10 3 weeks ago
Add function - pg_accept_connections_start_time() 5576 Waiting on Author 18 7/7 +52−0 Robins Tharakan (robins) Fujii Masao (masaofujii) 1 1 month ago
Track and display estimated "work_mem" as well as limit, via EXPLAIN (work_mem on); add hook to override work_mem limits; add extension to override using "workmem.query_work_mem" GUC 5595 Waiting on Author 18 Needs rebase! James Hunter (hunjmes) 1 3 weeks ago
Metadata and record block access stats for indexes 5614 Needs review 18 Needs rebase! Mircea Cadariu (mcadariu) 1 2 months ago
Performance
Allow partition-wise join when whole row var is needed 5128 Waiting on Author 18 Needs rebase! Ashutosh Bapat (ashutoshbapat), Alexander Pyhalov (a.pyhalov) 4 4 months ago
Asynchronous MergeAppend Execution 5129 Waiting on Author Needs rebase! Alexander Pyhalov (a.pyhalov) 4 8 months ago
Limiting overshoot in nbtree SAOP parallel index scans 5299 Waiting on Author Needs rebase! Matthias van de Meent (mmeent) 3 6 months ago
Showing applied extended statistics in explain Part2 5359 Waiting on Author 18 Needs rebase! Tatsuro Yamada (tatsuro_yamada) Tomas Vondra (fuzzycz), Andrei Lepikhov (lepikhov), Masahiro Ikeda (masahiro.ikeda), Ilia Evdokimov (ilidock95) Tomas Vondra (fuzzycz) 3 2 months ago
Function scan FDW pushdown 5470 Needs review 18 6/7 +1046−105 Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) Ashutosh Bapat (ashutoshbapat) 2 5 months ago
starjoin join order planning 5553 Needs review 1/7 +288−2 Tomas Vondra (fuzzycz) 1 2 months ago
sinvaladt.c: remove msgnumLock 5573 Needs review 18 7/7 +36−44 Yura Sokolov (funny_falcon) 1 1 month ago
Improvement of var_eq_non_const() 5588 Needs review 18 7/7 +29−14 Fedor Sigaev (sigaev) 1 1 month ago
SIMD optimization for list_sort 5607 Needs review 3/7 +1176−7 Rakshit R (rakshtr) 1 1 month ago
Reduce timing overhead of EXPLAIN ANALYZE using rdtsc 5622 Waiting on Author Needs rebase! Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) 1 1 month ago
Refactoring
New [relation] options engine 4688 Waiting on Author Needs rebase! Nikolay Shaplov (nataraj) 7 1 month ago
Remove duplicated smgrclose call 5149 Needs review 18 7/7 +0−6 Steven Niu (niushiji) Cary Huang (cary), Kirill Reshke (reshke), Zhao Junwang (zhjwpku) 4 1 month ago
Beautify read stream "per buffer data" APIs 5617 Needs review 0/1 +90−16 Thomas Munro (macdice) 1 2 months ago
Make numeric type accessible to third-party code. 5623 Needs review stable 13/14 +0−0 Ed Behn (edbehn) 1 1 month ago
Replication & Recovery
Expose the acquired_by parameter to the pg_replication_origin_session_setup function 5189 Ready for Committer 18 7/7 +19−4 Doruk Yılmaz (dorukyilmaz) Euler Taveira (eulerto) 4 1 month ago
Log LSN before table is dropped 5386 Waiting on Author 6/7 +8−0 Andrey Borodin (x4m), Nikolay Samokhvalov (nikolay), Kirk Wolak (kirkw) Jim Jones (jimus) 2 1 month ago
Logical replication timeout 5601 Needs review 7/7 +58−33 Marc Rechté (rechtem) 1 1 month ago
SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica 5611 Needs review 7/7 +215−139 Mikhail Litsarev (mikhail.litsarev) 1 3 weeks ago
Server Features
KNN-btree 4871 Waiting on Author Needs rebase! Nikita Glukhov (n.glukhov), Anton Melnikov (antonmel) 6 5 months ago
VACUUM FULL / CLUSTER CONCURRENTLY 5117 Needs review 18 7/7 +1259−207 Antonin Houska (a.houska) 4 3 weeks ago
Warn, and disallow, clear text passwords via SQL 5597 Needs review 6/7 +143−4 Greg Sabino Mullane (greg) Guillaume Lelarge (gleu) 1 1 month ago
Remove extra Sort node above a btree-compatible Index Scan 5606 Needs review 19 Not processed Alexandra Wang (alexandrawang) 1 2 months ago
Extensible storage manager API 5616 Waiting on Author Needs rebase! Andreas Karlsson (kandreas), Anastasia Lubennikova (lubennikovaav), Matthias van de Meent (mmeent), Tristan Partin (tristan957) 1 1 month ago
SQL Commands
Add SPLIT PARTITION/MERGE PARTITIONS commands 3659 Needs review 18 7/7 +7090−39 Dmitry Koval (d.koval) stephane tachoires (sttachoires) Alexander Korotkov (smagen) 13 1 month ago
Make COPY format extendable: Extract COPY TO format implementations 4681 Waiting on Author Needs rebase! Kouhei Sutou (kou) Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn), Zhao Junwang (zhjwpku), Yong Li (yoli) 7 3 weeks ago
CREATE OR REPLACE MATERIALIZED VIEW 5099 Needs review 18 7/7 +749−96 Erik Wienhold (ewie) newtglobal postgresql_contributors (newtpostgrescontributors) 4 3 weeks ago
INSERT ... ON CONFLICT DO SELECT [FOR ...] 5413 Waiting on Author 7/7 +831−190 Andreas Karlsson (kandreas), Marko Tiikkaja (johto) Dean Rasheed (deanr) 2 4 weeks ago
explain plans for foreign servers 5525 Waiting on Author Needs rebase! dinesh salve (dinesh-salve) 1 1 month ago
System Administration
New predefined role pg_manage_extensions 5357 Ready for Committer 2/7 +22−5 Michael Banck (mbanck) Laurenz Albe (laurenz) 3 3 weeks ago
Enable fine-grained control over what gets logged on connection attempt (reduces log size) 5609 Waiting on Author 18 Needs rebase! Sergey Dudoladov (sdudoladov) 1 1 month ago
Testing
Test to dump and restore objects left behind by regression 4956 Needs review 7/7 +51−26 Ashutosh Bapat (ashutoshbapat) Michael Paquier (michael-kun), vigneshwaran C (vignesh.postgres) 5 3 weeks ago
Add support for EXTRA_REGRESS_OPTS for meson test 5602 Waiting on Author 7/7 +7−1 Andreas Karlsson (kandreas) Rustam ALLAKOV (rustam.allakov) 1 1 month ago

Closed patches

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