Commitfest 2025-03

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


Status summary: Needs review: 111. Waiting on Author: 58. Ready for Committer: 27. Committed: 105. Moved to next CF: 16. Returned with Feedback: 3. Rejected: 5. Withdrawn: 18. 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 2 days ago
"unexpected duplicate for tablespace" problem in logical replication 4720 Needs review stable 14/14 +0−0 Shenhao Wang (wangshenhao) Masahiko Sawada (masahikosawada) 7 3 days ago
Network failure may prevent promotion 4748 Needs review 7/7 +52−202 Kyotaro Horiguchi (horiguti) 7 6 days 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 1 week ago
Fix rare recovery shutdown hang 4884 Waiting on Author Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch), Martijn Wallet (mwallet) 5 3 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 3 months ago
Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state 5029 Needs review 6/7 +124−6 ChangAo Chen (chenchangao) 5 yesterday
Incorrect error message for cancellation triggered by statement_timeout & flaky test 5070 Needs review stable 6/7 +16−5 Jelte Fennema-Nio (jeltef) 5 1 month ago
inplace update: send nontransactional invalidations 5091 Needs review stable 6/7 +0−0 Noah Misch (nmisch) Noah Misch (nmisch) 5 4 months ago
Incremental Sort Cost Estimation Instability 5093 Needs review 18 6/7 +180−32 Andrei Lepikhov (lepikhov) 5 4 months ago
Prevent incorrect entries in pg_stat_activity. 5105 Waiting on Author 7/7 +19−2 Fujii Masao (masaofujii) 4 3 months ago
Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() 5124 Waiting on Author Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch) 4 2 days ago
DirtyScanshot index scan skips concurrently updated tuples 5151 Needs review stable 7/7 +146−8 Michail Nikolaev (nkey) 4 2 weeks ago
psql client does not handle WSAEWOULDBLOCK on Windows 5154 Waiting on Author 7/7 +1−1 Umar Hayat (pgwizard) 4 3 months ago
Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 5160 Needs review stable 6/7 +1567−50 Michail Nikolaev (nkey) 4 1 month ago
Fix standby may crash when switching-over in certain special cases 5199 Needs review 7/7 +2−2 pixian shi (pxshi) 4 3 months ago
ensure we have a snapshot when dropping an index concurrently 5262 Waiting on Author 18 7/7 +124−30 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 3 1 week ago
Fix incorrect Assert in gistFindCorrectParent() 5268 Waiting on Author 7/7 +2−1 Tender Wang (tndrwang) 3 4 months ago
Fix race between WAL flush and InstallXLogFileSegment() 5276 Waiting on Author 7/7 +45−0 Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) 3 4 months ago
Fix for consume_xids advancing XIDs incorrectly 5303 Waiting on Author stable 6/7 +0−0 Yushi Ogiwara (yushi) 3 3 months ago
Fix creation of empty .log files during log rotation 5365 Waiting on Author 7/7 +15−12 Arseny Kositsin (arseny114) 2 2 weeks ago
Fix bug with accessing to temporary tables of other sessions 5379 Needs review 18 7/7 +0−0 Daniil Davydov (dddaniil) Rafia Sabih (rafia.sabih) 2 2 days ago
bt_index_parent_check false alarm for indexes created concurrently 5438 Needs review 6/7 +69−39 Michail Nikolaev (nkey) 2 3 months ago
Incorrect result of bitmap heap scan. 5448 Ready for Committer stable Needs rebase! Matthias van de Meent (mmeent) 2 1 week 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 3 months ago
Fix buffer pinning logic in [SP-]Gist 5542 Needs review Needs rebase! Peter Geoghegan (pgeoghegan), Michail Nikolaev (nkey), Matthias van de Meent (mmeent) 1 6 days ago
Invalid cached plan in check_foreign_key; cascade update in check_primary_key; refint.c 5577 Needs review 7/7 +91−34 Dmitrii Bondar (difesu) Paul Jungwirth (pjungwir), Lilian Ontowhee (ontowhee) 1 yesterday
Improve ACL checks in pg_prewarm for indexes 5583 Waiting on Author 7/7 +39−3 Ayush Vatsa (developerayuva) Nathan Bossart (bossartn) 1 1 week ago
The walsender does not update its IO statistics until it exits 5596 Needs review stable 7/7 +60−20 Bertrand Drouvot (bertranddrouvot.pg) 1 4 days ago
Orphaned users in PG16 and above can only be managed by Superusers 5608 Needs review 7/7 +178−0 Ashutosh Sharma (ashu_coek) Nathan Bossart (bossartn) 1 4 days ago
Avoid infinite loop in checkpointer 5612 Needs review 7/7 +40−23 Maxim Orlov (m.orlov) 1 2 weeks ago
Corrupted FSM page is not saved after zeroing. 5615 Waiting on Author 7/7 +3−0 Anton Melnikov (antonmel) 1 4 days ago
Clients
Adding comments to help understand psql hidden queries 4764 Waiting on Author 6/7 +0−0 David Christensen (davidchristensen), Greg Sabino Mullane (greg) Tom Lane (tgl) 6 1 month ago
libpq: Fix processing of SSL records >8kB on async API 5251 Needs review stable 7/7 +13−0 Lars Kanis (larsk) Jacob Champion (jchampion) 3 1 week ago
Add Option to Check All Addresses For Matching target_session_attr 5396 Needs review 18 7/7 +306−10 Andrew Jackson (andrewjackson) 2 1 month ago
Adding support for SSLKEYLOGFILE in the frontend 5500 Needs review 18 7/7 +119−2 Abhishek Chanda (abhishekc) Jacob Champion (jchampion), Daniel Gustafsson (dege) 1 yesterday
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 hour ago
Documentation
Document NULL Concepts and Behaviors 5086 Needs review 6/7 +1279−160 David Johnston (polobo) 5 2 weeks ago
Doc: Move and modify standalone hot backups section 5087 Waiting on Author 7/7 +24−23 David Johnston (polobo) Marlene Reiterer (marlene.rte) 5 1 week ago
explain pgstatindex fragmentation 5381 Ready for Committer 18 7/7 +9−0 Frédéric Yhuel (yhuelf) Laurenz Albe (laurenz), Bertrand Drouvot (bertranddrouvot), Benoit Lobréau (benoitl), Ahmed Ashour (ahmedashour) 2 1 month ago
doc: Mention clock synchronization recommendation for hot_standby_feedback 5425 Ready for Committer stable 5/7 +7−0 Jakub Wartak (jakub.wartak.tomtom) 2 4 days ago
Windows meson build 5522 Ready for Committer 7/7 +0−0 Kohei Harikae (koheiharikae) Vladlen Popolitov (vladlenpopolitov) 1 1 month ago
Document how commit handles aborted transactions 5546 Ready for Committer 7/7 +48−3 David Johnston (polobo) Ahmed Ashour (ahmedashour) 1 1 month ago
Document custom settings more consistently 5548 Ready for Committer 6/7 +0−0 David Johnston (polobo) Mingli Zhang (zml) 1 1 month ago
Miscellaneous
Support a wildcard in backtrace_functions 4735 Needs review 6/7 +161−11 Jelte Fennema-Nio (jeltef) Daniel Gustafsson (d_gustafsson), Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson) 7 1 week ago
Avoid orphaned objects dependencies, take 3 4942 Needs review 18 6/7 +998−22 Bertrand Drouvot (bertranddrouvot.pg) 5 1 month ago
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
Truncate logs by max_log_size 5272 Ready for Committer 7/7 +112−2 Kirill Gavrilov (diphantxm) Jim Jones (jimus) 3 1 month ago
System views for versions reporting 5318 Needs review stable 2/7 +565−1 Dmitry Dolgov (erthalion) 3 4 days ago
postgres_fdw could deparse ArrayCoerceExpr 5409 Ready for Committer 18 7/7 +80−0 Alexander Pyhalov (a.pyhalov) Maxim Orlov (m.orlov) 2 1 month ago
Unicode 16 update 5472 Needs review 7/7 +7442−6609 Peter Eisentraut (petere), Jeff Davis (jdavis) 2 5 days ago
Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions 5493 Needs review 4/7 +465−19 Nazir Bilal Yavuz (nbyavuz) Joseph Koshakow (jkoshakow), Aidar Imamov (gipergeek) 1 55 minutes ago
Coccinelle for PostgreSQL development 5509 Needs review 18 7/7 +845−8 Mats Kindahl (matski) 1 2 weeks ago
Add a function to get the version of installed extension 5514 Waiting on Author 7/7 +0−0 Yugo Nagata (yugo.nagata) 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 week ago
Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup 5570 Needs review 18 Needs rebase! Jelte Fennema-Nio (jeltef) 1 1 week ago
Fix MINGW build on ARM64 on Windows 5610 Needs review 7/7 +5−5 Lars Kanis (larskanis) 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 2 weeks ago
Amcheck verification of GiST and GIN 3733 Needs review 6/7 +1495−215 Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) José Villanova (azlev), Mark Dilger (mark.dilger) 15 19 hours ago
Logging parallel worker draught 4291 Ready for Committer 18 7/7 +93−0 Benoit Lobréau (benoitl) Sami Imseih (simseih) 10 1 month ago
Set log_lock_waits=on by default 4718 Ready for Committer 7/7 +0−0 Laurenz Albe (laurenz) Michael Banck (mbanck), Nathan Bossart (bossartn) 7 6 months ago
Add local address to log_line_prefix 4907 Waiting on Author 7/7 +24−0 Greg Sabino Mullane (greg) David Steele (dsteele), Cary Huang (cary), Jim Jones (jimus) 5 yesterday
relfilenode statistics 5007 Waiting on Author 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 5 2 weeks ago
Vacuum statistics 5012 Needs review 18 6/7 +2972−24 Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) Ilia Evdokimov (ilidock95) 5 3 days ago
Logging plan of the currently running query 5330 Needs review 18 7/7 +557−42 Atsushi Torikoshi (atsushitorikoshi) Akshat Jaimini (akshatj) 3 6 days ago
Enhance memory context statistics reporting for all PostgreSQL processes. 5355 Needs review 18 7/7 +1226−40 Rahila Syed (rahila) Daniel Gustafsson (d_gustafsson), Atsushi Torikoshi (atsushitorikoshi) 3 2 days ago
Sampling in pg_stat_statements 5390 Ready for Committer 18 7/7 +291−8 Ilia Evdokimov (ilidock95) Andrey Borodin (x4m), Sami Imseih (simseih), Alena Rybakina (alenka) 2 6 days ago
Non-text mode for pg_dumpall 5495 Needs review 18 Needs rebase! Mahendra Singh Thalor (mahithalor) 1 14 hours ago
pg_stat_statements: improve loading and saving routines for the dump file. 5512 Needs review 6/7 +10−4 Mikhail Litsarev (mikhail.litsarev) 1 2 months ago
Draft for basic NUMA observability 5558 Ready for Committer 18 7/7 +1168−144 Jakub Wartak (jakub.wartak.tomtom) 1 21 hours ago
Change log level for notifying hot standby is waiting non-overflowed snapshot 5567 Needs review 18 7/7 +12−1 Atsushi Torikoshi (atsushitorikoshi) Fujii Masao (masaofujii) 1 20 hours ago
Add function - pg_accept_connections_start_time() 5576 Waiting on Author 18 7/7 +52−0 Robins Tharakan (robins) Fujii Masao (masaofujii) 1 3 weeks 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 Needs review 18 Needs rebase! James Hunter (hunjmes) 1 3 weeks ago
Metadata and record block access stats for indexes 5614 Waiting on Author 18 Needs rebase! Mircea Cadariu (mcadariu) 1 3 weeks ago
Improve monitoring of shared memory allocations 5620 Needs review 18 7/7 +294−80 Rahila Syed (rahila) 1 22 minutes ago
Performance
Reducing planning time when tables have many partitions 3701 Needs review 7/7 +1246−212 Yuya Watari (watari) Tom Lane (tgl), Thom Brown (thom), Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), newtglobal postgresql_contributors (newtpostgrescontributors) 15 yesterday
Index Prefetching 4351 Waiting on Author Needs rebase! Tomas Vondra (fuzzycz) 10 4 months ago
Statistics Import and Export 4538 Needs review 6/7 +784−302 Corey Huinker (coreyh) Bharath Rupireddy (bharathrupireddy) 9 2 days ago
Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 4564 Needs review 6/7 +357−77 Ashutosh Bapat (ashutoshbapat) 8 5 hours ago
Teach predtest about IS [NOT] <boolean> proofs 4690 Needs review 7/7 +1882−129 James Coleman (jcole1989) Tom Lane (tgl) 7 11 months ago
Parallel CREATE INDEX for GIN indexes 4966 Waiting on Author 6/7 +531−260 Tomas Vondra (fuzzycz) Matthias van de Meent (mmeent), Andy Fan (andy2) 5 1 week ago
[CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots 4971 Needs review 6/7 +3848−896 Michail Nikolaev (nkey) Matthias van de Meent (mmeent) 5 2 weeks ago
nbtree skip scan 5081 Needs review 7/7 +3767−531 Peter Geoghegan (pgeoghegan) Aleksander Alekseev (a.alekseev), Masahiro Ikeda (masahiro.ikeda) 5 13 hours ago
Improved crc32c performance with AVX-512 algorithm. 5100 Waiting on Author 18 Needs rebase! Paul Amonson (pamonson), Raghuveer Devulapalli (rdevulap) Nathan Bossart (bossartn) 4 1 month ago
MergeJoin beats HashJoin in the case of multiple hash clauses 5114 Needs review Needs rebase! Andrei Lepikhov (lepikhov) 4 2 weeks ago
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 3 months ago
Asynchronous MergeAppend Execution 5129 Waiting on Author Needs rebase! Alexander Pyhalov (a.pyhalov) 4 7 months ago
Use read streams in autoprewarm 5162 Ready for Committer 7/7 +127−5 Nazir Bilal Yavuz (nbyavuz) 4 3 months ago
AIO 5227 Ready for Committer 7/7 +6794−371 Andres Freund (andresfreund) Noah Misch (nmisch) 4 8 hours ago
Allow SQL functions use CachedPlan machinery 5246 Waiting on Author 18 7/7 +999−184 Alexander Pyhalov (a.pyhalov) Tom Lane (tgl), Pavel Stehule (okbobcz) 3 1 week ago
Replace IN VALUES with ANY in WHERE clauses during optimization 5283 Needs review 5/7 +804−60 Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) newtglobal postgresql_contributors (newtpostgrescontributors) 3 2 weeks ago
Limiting overshoot in nbtree SAOP parallel index scans 5299 Waiting on Author Needs rebase! Matthias van de Meent (mmeent) 3 5 months ago
Add sortsupport for range types and btree_gist 5325 Ready for Committer 6/7 +888−8 Bernd Helmle (psoo), Christoph Heiss (christoph.heiss) Andrey Borodin (x4m), jian he (hellothere) 3 2 weeks ago
Parallel heap vacuum 5326 Needs review 7/7 +1581−331 Masahiko Sawada (masahikosawada) Hayato Kuroda (ha-kun) 3 4 hours 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 1 month ago
Let an Append to consider a tuple fraction when choosing fractional subpaths 5361 Needs review 18 Needs rebase! Andrei Lepikhov (lepikhov), Nikita Malakhov (nmalakh) 2 2 weeks ago
Adding compression of temporary files 5382 Waiting on Author Needs rebase! Filip Januš (fjanus) 2 3 hours ago
[PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause 5422 Needs review 18 7/7 +0−0 Ravi Revathy (revathyraavi) 2 1 week ago
Eliminating SPI / SQL from some RI trigger functions 5450 Needs review 19 Needs rebase! Amit Langote (amitlan) 2 3 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 4 months ago
Speed up ICU case conversions 5474 Waiting on Author 2/7 +86−41 Andreas Karlsson (kandreas) 2 1 week ago
Exists pull-up application with JoinExpr 5487 Waiting on Author 2/7 +550−62 Alena Rybakina (alenka) 1 1 month ago
Allow to use an index for ILIKE in more cases 5505 Waiting on Author 18 Needs rebase! Yugo Nagata (yugo.nagata) 1 2 months ago
Get rid of WALBufMappingLock 5511 Needs review 7/7 +189−49 Alexander Korotkov (smagen), Yura Sokolov (funny_falcon) Alexander Korotkov (smagen), Yura Sokolov (funny_falcon), Pavel Borisov (pborisov) 1 1 week ago
SVE enablement for pop-count 5520 Needs review 18 7/7 +714−17 Chiranmoy Bhattacharya (chiranmoy), Susmitha Devanga (susmithad) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 yesterday
SVE enablement for hex-encode and hex-decode 5538 Needs review 18 6/7 +466−6 Chiranmoy Bhattacharya (chiranmoy), Susmitha Devanga (susmithad) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 month ago
Improve CRC32C performance on SSE4.2 5545 Needs review 7/7 +374−44 Raghuveer Devulapalli (rdevulap) John Naylor (john.naylor) 1 yesterday
starjoin join order planning 5553 Needs review 1/7 +288−2 Tomas Vondra (fuzzycz) 1 1 month ago
Expanding HOT updates for expression and partial indexes 5556 Needs review 19 7/7 +1639−105 Greg Burd (gregburd) 1 2 days ago
Reduce TupleHashEntryData struct size by half 5561 Needs review 18 6/7 +72−73 Jeff Davis (jdavis) 1 3 days ago
Use Bump allocator for HashAgg 5562 Waiting on Author 18 Needs rebase! Jeff Davis (jdavis) 1 1 month ago
sinvaladt.c: remove msgnumLock 5573 Needs review 18 7/7 +36−44 Yura Sokolov (funny_falcon) 1 2 days ago
Improvement of var_eq_non_const() 5588 Needs review 18 7/7 +29−14 Fedor Sigaev (sigaev) 1 6 days ago
SIMD optimization for list_sort 5607 Needs review 3/7 +1176−7 Rakshit R (rakshtr) 1 3 weeks ago
Read stream scalability improvements and AIO-compatibility 5619 Waiting on Author Needs rebase! Thomas Munro (macdice) 1 1 week ago
Compress big WAL records 5621 Waiting on Author Needs rebase! Andrey Borodin (x4m) 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 3 weeks ago
Procedural Languages
declarative session variables, LET command 1608 Needs review 6/7 +9964−65 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) 35 1 week ago
new plpgsql.extra_errors check - strict_expr_check 5044 Needs review 6/7 +177−18 Pavel Stehule (okbobcz) Gilles Darold (darold), newtglobal postgresql_contributors (newtpostgrescontributors) 5 1 month ago
Refactoring
Revise get_cheapest_parallel_safe_total_inner 4285 Waiting on Author 7/7 +11−4 Richard Guo (richardguo) wenhui qiu (wenhuiqiu) 10 6 months ago
Retiring is_pushed_down 4458 Waiting on Author Needs rebase! Richard Guo (richardguo) Tom Lane (tgl) 9 2 months ago
New [relation] options engine 4688 Needs review Needs rebase! Nikolay Shaplov (nataraj) 7 1 week ago
Use XLOG_CONTROL_FILE macro everywhere 4941 Needs review 18 7/7 +272−213 Anton Melnikov (antonmel) Daniel Gustafsson (d_gustafsson) 5 7 hours 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 2 days ago
Make ECPG locale usage thread-safe 5166 Needs review Needs rebase! Thomas Munro (macdice) Peter Eisentraut (petere) 4 1 month ago
Thread-safe nl_langinfo(), localeconv(), check_locale() 5170 Ready for Committer 7/7 +71−52 Thomas Munro (macdice) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 3 hours ago
Refactor SLRU to always use long file names 5250 Needs review 7/7 +104−86 Aleksander Alekseev (a.alekseev) 3 1 month ago
Collation and ctype method tables and extension hooks 5301 Needs review 7/7 +805−530 Jeff Davis (jdavis) 3 2 months ago
Adopt <inttypes.h> macros in format strings. 5429 Needs review Needs rebase! Thomas Munro (macdice) Peter Eisentraut (petere) 2 1 week ago
Don't dirty pages while they are getting flushed out 5483 Waiting on Author Needs rebase! Andres Freund (andresfreund) 2 4 months ago
Elimination of the repetitive code at the SLRU bootstrap functions 5575 Ready for Committer 18 6/7 +78−255 Evgeny Voropaev (evoro) Álvaro Herrera (alvherre), Aleksander Alekseev (a.alekseev), Andrey Borodin (x4mmm) 1 1 week ago
Beautify read stream "per buffer data" APIs 5617 Needs review 6/7 +90−16 Thomas Munro (macdice) 1 1 month ago
Make numeric type accessible to third-party code. 5623 Needs review stable 7/7 +0−0 Ed Behn (edbehn) 1 3 weeks ago
Replication & Recovery
CREATE SUBSCRIPTION ... SERVER 4529 Waiting on Author 7/7 +587−35 Jeff Davis (jdavis) vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) 9 3 days ago
Return pg_control from pg_backup_stop(). 4997 Needs review 18 7/7 +181−30 David Steele (dsteele) 5 2 months ago
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 3 weeks 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 2 weeks ago
Enable logical decoding when wal_level = 'replica' without a server restart 5479 Waiting on Author Needs rebase! Masahiko Sawada (masahikosawada) 2 1 month ago
Enhance 'pg_createsubscriber' to retrieve databases 5566 Needs review 7/7 +351−21 Shubham Khanna (khannashubham) Hayato Kuroda (ha-kun), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) 1 2 hours ago
Logical replication timeout 5601 Needs review 7/7 +58−33 1 3 weeks 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 2 days ago
Security
Make query cancellation keys longer 4870 Needs review 6/7 +451−60 Heikki Linnakangas (heikki), Jelte Fennema-Nio (jeltef) 4 1 month ago
Extend ALTER DEFAULT PRIVILEGES for large objects 4945 Ready for Committer 7/7 +215−11 Yugo Nagata (yugo.nagata) Laurenz Albe (laurenz) 5 2 months ago
Serverside SNI for SSL connections 4984 Waiting on Author 6/7 +937−50 Daniel Gustafsson (d_gustafsson) Jacob Champion (jchampion) 5 3 weeks ago
Extension security improvement: Add support for extensions with an owned schema 5018 Needs review 18 7/7 +326−62 Jelte Fennema-Nio (jeltef) 5 5 months ago
revamp row-security tracking 5397 Waiting on Author 18 6/7 +25−17 Nathan Bossart (bossartn) 2 1 month ago
Modern SHA2- based password hashes for pgcrypto 5481 Needs review 18 7/7 +1164−2 Bernd Helmle (psoo) 2 2 weeks ago
Server Features
COPY ON_ERROR 'NULL' 4810 Needs review 7/7 +198−25 jian he (universality) Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Jim Jones (jimus) 6 3 days ago
KNN-btree 4871 Waiting on Author Needs rebase! Nikita Glukhov (n.glukhov), Anton Melnikov (antonmel) 6 4 months ago
Eager aggregation, take 3 4881 Needs review 19 2/7 +3654−159 Richard Guo (richardguo) 5 2 months ago
CREATE DATABASE ... STRATEGY=FILE_CLONE 4886 Needs review 7/7 +170−3 Thomas Munro (macdice), Nazir Bilal Yavuz (nbyavuz) 5 2 days ago
VACUUM FULL / CLUSTER CONCURRENTLY 5117 Needs review 18 6/7 +6217−537 Antonin Houska (a.houska) 4 yesterday
Index AM API cleanup 5195 Ready for Committer 7/7 +28061−353 Mark Dilger (mark.dilger) Peter Eisentraut (petere), Andrew Dunstan (adunstan), Alexandra Wang (l-wang) Peter Eisentraut (petere) 4 1 week ago
Make MultiXactOffset 64-bit type 5205 Needs review 18 7/7 +633−304 Maxim Orlov (m.orlov) Heikki Linnakangas (heikki) 4 yesterday
NOT ENFORCED constraint feature 5285 Needs review 18 6/7 +1013−286 Amul Sul (sulamul) Peter Eisentraut (petere), Alexandra Wang (alexandrawang) 3 1 hour ago
Changing shared_buffers without restart 5319 Waiting on Author Needs rebase! Dmitry Dolgov (erthalion) Vladlen Popolitov (vladlenpopolitov) 3 1 week ago
Support enabling checksums online 5323 Waiting on Author Needs rebase! Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) Tomas Vondra (fuzzycz) 3 1 week ago
speedup COPY TO for partitioned table 5467 Needs review 18 7/7 +114−10 Jian He (stayreal) vigneshwaran C (vignesh.postgres), newtglobal postgresql_contributors (newtpostgrescontributors) 2 8 hours ago
Proposal: Progressive explain 5473 Needs review 7/7 +1706−59 Rafael Castro (rafaelthca) Robert Haas (rhaas) 2 9 hours ago
SQL/JSON json_table PLAN clause 5478 Needs review 18 6/7 +2413−332 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) 2 1 week ago
Extended Statistics set/restore/clear functions 5517 Waiting on Author Needs rebase! Corey Huinker (coreyh) 1 3 weeks ago
add function argument name to substring and substr 5524 Waiting on Author 7/7 +118−7 Jian He (stayreal) David Johnston (polobo) 1 1 week ago
COPY materialized view TO 5533 Needs review 7/7 +7−5 Jian He (stayreal) newtglobal postgresql_contributors (newtpostgrescontributors) 1 yesterday
Cross-type index comparison support in contrib/btree_gin 5535 Needs review 7/7 +2548−116 Tom Lane (tgl) 1 10 hours ago
support virtual generated column not null constraint 5578 Ready for Committer 7/7 +384−123 Jian He (stayreal) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 4 days ago
Warn, and disallow, clear text passwords via SQL 5597 Needs review 7/7 +143−4 Greg Sabino Mullane (greg) Guillaume Lelarge (gleu) 1 1 week ago
Remove extra Sort node above a btree-compatible Index Scan 5606 Needs review 19 Not processed Alexandra Wang (alexandrawang) 1 3 weeks ago
making EXPLAIN extensible 5613 Needs review 7/7 +8−0 Robert Haas (rhaas) 1 1 hour 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 week 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 week ago
Add XMLCanonicalize function 4237 Ready for Committer 18 7/7 +398−0 Jim Jones (jimus) Pavel Stehule (okbobcz), Oliver Ford (ojford), newtglobal postgresql_contributors (newtpostgrescontributors) 10 1 week ago
Incremental View Maintenance (IVM), take 2 4337 Waiting on Author Needs rebase! Yugo Nagata (yugo.nagata) 10 7 months ago
Implement row pattern recognition feature 4460 Needs review 18 7/7 +4207−35 Tatsuo Ishii (ishii) Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033) 9 2 weeks ago
Make COPY format extendable: Extract COPY TO format implementations 4681 Waiting on Author 6/7 +1376−147 Kouhei Sutou (kou) Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn), Zhao Junwang (zhjwpku), Yong Li (yoli) 7 yesterday
SQL Property Graph Queries (SQL/PGQ) 4904 Waiting on Author Needs rebase! Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat) Vik Fearing (xocolatl), Zhao Junwang (zhjwpku) 5 2 weeks ago
CREATE OR REPLACE MATERIALIZED VIEW 5099 Needs review 18 7/7 +749−96 Erik Wienhold (ewie) newtglobal postgresql_contributors (newtpostgrescontributors) 4 2 weeks ago
Add XMLCast (SQL/XML X025) 5110 Needs review 18 6/7 +2201−9 Jim Jones (jimus) Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) 4 2 weeks ago
Introduce the ability to enable/disable indexes using ALTER INDEX 5274 Needs review 18 7/7 +953−10 Shayon Mukherjee (shayonj) Sami Imseih (simseih), newtglobal postgresql_contributors (newtpostgrescontributors) 3 1 week ago
general purpose array_sort 5277 Needs review 18 7/7 +409−1 Zhao Junwang (zhjwpku) 3 1 week ago
Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) 5279 Needs review 18 7/7 +738−32 Jim Jones (jimus) newtglobal postgresql_contributors (newtpostgrescontributors) 3 1 month ago
INSERT ... ON CONFLICT DO SELECT [FOR ...] 5413 Needs review 7/7 +571−105 Andreas Karlsson (kandreas), Marko Tiikkaja (johto) 2 2 weeks ago
Add XMLDocument (SQL/XML X030) 5431 Ready for Committer 18 7/7 +258−1 Jim Jones (jimus) Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) 2 1 month ago
Add XMLNamespaces option to XMLElement 5456 Ready for Committer 18 7/7 +1200−34 Pavel Stehule (okbobcz), Jim Jones (jimus) Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) 2 2 weeks ago
explain plans for foreign servers 5525 Waiting on Author Needs rebase! dinesh salve (dinesh-salve) 1 3 weeks ago
Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 5554 Needs review 18 7/7 +0−0 Rushabh Lathia (rlathia) Álvaro Herrera (alvherre) 1 2 hours ago
System Administration
Reduce the log spam by excluding certain SQLSTATEs 4964 Ready for Committer 18 7/7 +218−0 Laurenz Albe (laurenz) Jim Jones (jimus) 5 1 week ago
pg_upgrade: Support for upgrading to checksums enabled 5206 Needs review Needs rebase! Peter Eisentraut (petere) Nathan Bossart (bossartn), Ilya Kosmodemiansky (hydrobiont) 4 2 weeks ago
New predefined role pg_manage_extensions 5357 Ready for Committer 2/7 +22−5 Michael Banck (mbanck) Laurenz Albe (laurenz) 3 2 weeks ago
log_min_messages per backend type 5447 Needs review 18 2/7 +352−25 Euler Taveira (eulerto) 2 3 weeks ago
Improve verification of recovery_target_timeline GUC. 5519 Needs review 18 7/7 +72−2 David Steele (dsteele) 1 1 month 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 2 weeks ago
Testing
Test to dump and restore objects left behind by regression 4956 Needs review 7/7 +286−2 Ashutosh Bapat (ashutoshbapat) Michael Paquier (michael-kun), vigneshwaran C (vignesh.postgres) 5 12 minutes ago
Allow CI to only run the compiler warnings task 5249 Needs review 18 7/10 +14−13 Bertrand Drouvot (bertranddrouvot.pg) 3 2 weeks ago
Add 'make check-tests' behavior to the meson based builds 5405 Ready for Committer 7/7 +16−6 Nazir Bilal Yavuz (nbyavuz) Ashutosh Bapat (ashutoshbapat), Jian He (stayreal) 2 6 days ago
Fix 035_standby_logical_decoding.pl race conditions 5568 Needs review 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 1 2 hours 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 week ago

Closed patches

Patch ID Status Ver CI status Stats Author Reviewers Committer Num cfs Latest mail
Bug Fixes
Fix BackgroundPsql to report error on query timeout rather than calling die 4959 Moved to next CF 18 7/7 +17−16 Daniel Gustafsson (d_gustafsson) Heikki Linnakangas (heikki) 6 1 month 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 yesterday
Fix RelationTruncate() corruption 5242 Committed Not processed Robert Haas (rhaas), Thomas Munro (macdice) Thomas Munro (macdice) 3 1 month ago
Fix logging for invalid recovery timeline 5468 Committed stable 7/7 +3−3 David Steele (dsteele) Michael Paquier (michael-kun) 2 1 month 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 2 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 2 months ago
ecpg command does not warn COPY ... FROM STDIN; 5497 Committed stable Not processed Ryo Kanbayashi (ryokanbayashi) Fujii Masao (masaofujii) 1 2 months ago
Avoid possible null pointer dereference 5506 Withdrawn 17 Not processed Ranier Vilela (raniervilela) Ilia Evdokimov (ilidock95) 1 1 month 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 1 month ago
Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData 5532 Moved to next CF stable 7/7 +388−190 Michael Paquier (michael-kun) Noah Misch (nmisch) 2 1 month ago
Prevent COPY FREEZE on Foreign tables 5544 Committed 18 Not processed Sami Imseih (simseih) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 month 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 1 month ago
fix for bug #18815 5582 Committed stable 7/7 +35−21 Tom Lane (tgl) Tom Lane (tgl) 1 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 1 month ago
Missing [NO] INDENT flag in XMLSerialize backward parsing 5587 Committed 16 7/7 +0−0 Jim Jones (jimus) Michael Paquier (michael-kun) 1 1 month ago
Fix race condition between role grants and DROP ROLE 5589 Committed stable Needs rebase! Tom Lane (tgl) Tom Lane (tgl) 1 3 weeks ago
Not-terribly-safe checks for CRC intrinsic support 5653 Committed 34/35 +0−0 Tom Lane (tgl) Tom Lane (tgl) 1 1 week 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 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 22 hours ago
Add Pipelining support to psql 5407 Committed 18 Needs rebase! Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 1 week ago
Tab completion for ALTER USER RESET 5414 Committed 18 7/7 +28−0 Robins Tharakan (robins) Tomas Vondra (fuzzycz) 2 1 month 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 3 days 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 week 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 week 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 1 month 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 4 days 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 1 month ago
Documentation
Doc: Improve hostssl related descriptions and option presentation 5088 Withdrawn Needs rebase! David Johnston (polobo) 5 2 weeks 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 1 month ago
Use "protocol options" name instead of "protocol extensions" everywhere 5341 Rejected 7/7 +4−4 Jelte Fennema-Nio (jeltef) 3 2 weeks 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 4 days ago
DOCS for generated column replication 5502 Rejected 7/7 +146−0 Peter Smith (smithpb2250) 1 2 weeks ago
split func.sgml to separated individual sgml files 5515 Moved to next CF 6/7 +44−1 Jian He (stayreal) 2 1 week ago
TOAST is acronym so should be uppercase 5530 Moved to next CF 7/7 +13−13 Peter Smith (smithpb2250) 2 1 week 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 3 weeks ago
Doc: Create table improvements 5547 Moved to next CF 7/7 +22−5 David Johnston (polobo) Laurenz Albe (laurenz) 2 3 weeks ago
Document hostssl related concepts better 5549 Withdrawn Needs rebase! David Johnston (polobo) 1 2 weeks ago
DOCS - Generated Column Logical Replication Examples 5590 Withdrawn 18 7/7 +146−0 Peter Smith (smithpb2250) 1 2 weeks 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 yesterday
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 yesterday
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 3 weeks ago
Miscellaneous
gamma() and lgamma() functions 5098 Committed 18 7/7 +212−0 Dean Rasheed (deanr) Alexandra Wang (alexandrawang) Dean Rasheed (deanr) 5 yesterday
Allow casting between bytea and integer types 5176 Committed 7/7 +274−0 Aleksander Alekseev (a.alekseev) Joel Jacobson (joeljacobson) Dean Rasheed (deanr) 4 3 weeks 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 yesterday
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 3 days ago
Tweak access BufferDescriptors array codes in BufferGetLSNAtomic() 5373 Committed 7/7 +2−0 Tender Wang (tndrwang) Xuneng Zhou (egoa) Richard Guo (richardguo) 2 1 month 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 20 hours ago
read stream on amcheck 5488 Committed 7/7 +79−24 Matheus Alcantara (matheus.alcantara) Melanie Plageman (melanieplageman) 1 14 hours 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 2 months ago
Optimizing FastPathTransferRelationLocks() 5494 Committed 7/7 +16−12 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 1 week 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 2 weeks ago
convert libpgport's pqsignal() to a void function 5507 Committed 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 2 months ago
Remove unused helpers that don't compile anymore 5510 Committed Not processed Jacob Brazeal (polkerty) Tom Lane (tgl) 1 2 months 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 week ago
pg_upgrade check for Unicode update 5563 Withdrawn 18 7/7 +7442−6609 Jeff Davis (jdavis) Nathan Bossart (bossartn) 1 5 days ago
describe special values in GUC descriptions more consistently 5564 Committed 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 3 weeks 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 week ago
noreturn attribute for MSVC, C11 5571 Committed Needs rebase! Peter Eisentraut (petere) Peter Eisentraut (petere) 1 2 weeks ago
Increase maximum allowed io_combine_limit to 1MB 5618 Committed Needs rebase! Thomas Munro (macdice) Thomas Munro (macdice) 1 1 week 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 5 days 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 week 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 1 month 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 2 weeks ago
Enhance file_fdw to report processed and skipped tuples in COPY progress 5282 Withdrawn Needs rebase! Fujii Masao (masaofujii) 3 2 weeks 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 4 days 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 2 weeks ago
track vacuum/analyze cumulative time per relation 5485 Committed Not processed Sami Imseih (simseih) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 month 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 week ago
improve DEBUG1 logging of parallel workers for CREATE INDEX 5490 Withdrawn Not processed Sami Imseih (simseih) 1 1 month ago
per backend WAL statistics 5492 Committed 18 7/7 +183−26 Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 1 2 weeks ago
Add storage I/O tracking to EXPLAIN BUFFERS 5526 Moved to next CF 18 7/7 +296−42 Atsushi Torikoshi (atsushitorikoshi) Jelte Fennema-Nio (jeltef) 2 3 days 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 1 month 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 1 month ago
allow extensions to set a plan identifier 5593 Committed 18 7/7 +95−0 Sami Imseih (simseih) Michael Paquier (michael-kun) 1 2 days ago
Performance
AcquireExecutorLocks() and run-time pruning 3478 Committed Needs rebase! Amit Langote (amitlan) Tom Lane (tgl) Amit Langote (amitlan) 17 1 month 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 2 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 1 month ago
Remove self join on a unique column 5043 Committed 7/7 +53−28 Andrei Lepikhov (lepikhov) Dean Rasheed (deanr) Alexander Korotkov (smagen) 5 6 days ago
Streaming Vacuum 5089 Committed Not processed Thomas Munro (macdice), Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 5 1 month ago
Improve statistics estimation considering GROUP-BY as a 'uniqueiser' 5269 Committed 18 2/7 +37−0 Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 3 1 month 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 3 weeks 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 4 days ago
Using Expanded Objects other than Arrays from plpgsql 5364 Committed Not processed Tom Lane (tgl) Tom Lane (tgl) 2 1 month ago
Eagerly scan all-visible pages to amortize aggressive vacuum 5366 Committed Not processed Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 2 1 month ago
optimize file transfer in pg_upgrade 5369 Committed 18 7/7 +642−80 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 2 days ago
handle batch explosion in hash joins 5482 Committed 2/7 +5635−0 Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 2 1 month ago
quick and dirty fix: Quadratic planning time for ordered paths over partitioned tables 5516 Rejected 18 Not processed 1 2 months ago
SVE popcount support 5521 Withdrawn Not processed 1 yesterday
Optimization for lower(), upper(), casefold() functions. 5574 Committed Needs rebase! Alexander Borisov (lexborisov) Jeff Davis (jdavis) Jeff Davis (jdavis) 1 1 week ago
Avoid O(N^2) script parsing cost in pgbench 5599 Committed 7/7 +98−66 Tom Lane (tgl) Tom Lane (tgl) 1 1 month ago
Procedural Languages
Use Python "Limited API" in PL/Python 5416 Committed 7/7 +0−0 Peter Eisentraut (petere) Peter Eisentraut (petere) 2 1 week 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 3 weeks ago
Refactoring
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 3 days ago
Refactor bytea_sortsupport() 5288 Returned with feedback Not processed Aleksander Alekseev (a.alekseev) 3 3 months ago
Getting rid of CaseTestExpr 5531 Withdrawn Not processed Tom Lane (tgl) 1 1 month ago
ctype method table 5559 Withdrawn 18 Not processed Jeff Davis (jdavis) 1 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 1 month 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 3 weeks ago
moving some code out of explain.c 5584 Committed 7/7 +0−0 Robert Haas (rhaas) Robert Haas (rhaas) 1 3 weeks ago
Replication & Recovery
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 1 month ago
Synchronization of sequences to subscriber 5111 Moved to next CF 7/7 +2963−730 vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Peter Smith (smithpb2250) 5 3 days ago
Skip logical decoding of already-aborted transactions. 5338 Committed Not processed Masahiko Sawada (masahikosawada) vigneshwaran C (vignesh.postgres) Masahiko Sawada (masahikosawada) 3 1 week ago
Conflict detection for update_deleted in logical replication 5378 Moved to next CF 7/7 +2142−171 Hou Zhijie (houzj) Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres) Amit Kapila (amitkapila) 3 2 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 1 month 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 6 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 1 month ago
Don't ignore recovery conflict interrupt on blocked writing 5504 Withdrawn Needs rebase! Anthonin Bonnefoy (bonnefoa) 1 2 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 2 days 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 1 week ago
Filter irrelevant change before reassemble transactions during logical decoding 5585 Moved to next CF 7/7 +764−71 Jie Li (adger), Ajin Cherian (ajinc), Hou Zhijie (houzj) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Hou Zhijie (houzj) Amit Kapila (amitkapila) 2 1 week 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 days ago
Filter irrelevant change before reassemble transactions during logical decoding 5592 Withdrawn 7/7 +0−0 Jie Li (adger), Ajin Cherian (ajinc), Hou Zhijie (houzj) Amit Kapila (amitkapila) 1 1 week 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 yesterday
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 1 month ago
Server Features
Sequence Access Methods, round two 4677 Moved to next CF 7/7 +2753−795 Michael Paquier (michael-kun) 8 3 hours 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 1 month ago
on_error table, saving error info to a table 4817 Moved to next CF Needs rebase! jian he (hellothere) Nishant Sharma (nishant-at-edb) 7 3 months 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 5 days ago
CREATE INDEX CONCURRENTLY for partitioned tables 5004 Moved to next CF 2/7 +520−78 Justin Pryzby (justinpryzby), Ilya Gladyshev (qoops) 6 5 months 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 2 weeks ago
using index to speedup add not null constraints to a table 5444 Moved to next CF 18 0/10 +498−12 Jian He (stayreal) 3 1 month ago
refactor AlterDomainAddConstraint (alter domain add constraint) 5455 Moved to next CF 18 7/7 +79−8 Jian He (stayreal) Peter Eisentraut (petere) 3 2 weeks ago
WAL-logging facility for pgstats kinds 5466 Withdrawn 18 Not processed Michael Paquier (michael-kun) 2 1 month ago
SCRAM pass-through authentication for dblink connections 5534 Committed 7/7 +503−9 Matheus Alcantara (matheus.alcantara) Peter Eisentraut (petere) 1 yesterday
SQL Commands
SQL:2011 application time 4308 Committed Needs rebase! Paul Jungwirth (pjungwir) Peter Eisentraut (petere) Peter Eisentraut (petere) 10 1 week ago
Virtual generated columns 4972 Committed Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 5 1 month ago
Support POSITION with nondeterministic collations 5209 Committed 7/7 +247−48 Peter Eisentraut (petere) Peter Eisentraut (petere) 4 1 month 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 21 hours ago
Add IGNORE NULLS to Window functions 5230 Moved to next CF 18 7/7 +773−28 Oliver Ford (ojford) Krasiyan Andreev (krasiyan) 4 2 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 3 weeks ago
Allow subfield references without parentheses 5449 Returned with feedback Not processed Peter Eisentraut (petere) 2 3 months ago
NOT VALID foreign key constraints on partitioned tables 5503 Committed 18 0/1 +0−0 Amul Sul (sulamul) Álvaro Herrera (alvherre) 1 2 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 2 days 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 1 month ago
System Administration
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 1 month 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 week 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 3 days 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 4 days 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 1 month ago
Add NetBSD and OpenBSD OSes to Postgres CI 5360 Committed Needs rebase! Nazir Bilal Yavuz (nbyavuz) Andres Freund (andresfreund) 3 3 weeks ago
Disable installcheck for tap and regress tests for injection_points module 5410 Withdrawn 18 2/7 +77−0 Michail Nikolaev (nkey) 2 1 month 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 21 hours ago
tests for pg_stat_progress_copy.tuples_skipped 5536 Committed stable 7/7 +17−4 Jian He (stayreal) Fujii Masao (masaofujii) 1 3 weeks 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 3 weeks ago
Injection points for HashAgg 5560 Committed 18 Needs rebase! Jeff Davis (jdavis) Jeff Davis (jdavis) 1 1 month 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 4 days ago