Commitfest 2024-11

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


Status summary: Committed: 78. Moved to next CF: 236. Withdrawn: 11. Rejected: 2. Returned with Feedback: 9. Total: 336.

Closed 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 Moved to next CF Needs rebase! Kyotaro Horiguchi (horiguti) Hayato Kuroda (ha-kun), Yasir Shah (yasir.hussain.shah.gmail.com) 8 3 weeks ago
"unexpected duplicate for tablespace" problem in logical replication 4720 Moved to next CF stable 6/7 +0−0 Shenhao Wang (wangshenhao) Masahiko Sawada (masahikosawada) 7 3 weeks ago
Network failure may prevent promotion 4748 Moved to next CF 7/7 +52−202 Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki) 7 1 week ago
data loss bug in initial sync of logical replication 4766 Moved to next CF 7/7 +134−15 Tomas Vondra (fuzzycz) Nitin Motiani (nitinmotiani), work nsandeepkumar (nsandeepk) 6 1 week ago
Fix rare recovery shutdown hang 4884 Moved to next CF Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch), Martijn Wallet (mwallet) 5 4 months ago
Run deferred triggers in the correct security context 4888 Moved to next CF 18 Not processed Laurenz Albe (laurenz) Pavel Stehule (okbobcz) Tom Lane (tgl) 4 2 months ago
apply_scanjoin_target_to_paths and partitionwise join 4929 Moved to next CF stable Not processed Ashutosh Bapat (ashutoshbapat) 4 3 months ago
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
WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts 4986 Moved to next CF 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 Moved to next CF 7/7 +121−6 ChangAo Chen (chenchangao) 5 1 week ago
Remove dependence on integer wrapping 5031 Moved to next CF 18 Not processed Nathan Bossart (bossartn), Joseph Koshakow (jkoshakow), Matthew Kim (friendlymatthew) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 4 months ago
windows compilation fails when gssapi & openssl are enabled 5060 Moved to next CF 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 2 weeks ago
Incorrect error message for cancellation triggered by statement_timeout & flaky test 5070 Moved to next CF stable 7/7 +16−5 Jelte Fennema-Nio (jeltef) 6 1 month ago
inplace update: send nontransactional invalidations 5091 Moved to next CF stable 6/7 +0−0 Noah Misch (nmisch) Noah Misch (nmisch) 5 5 months ago
Incremental Sort Cost Estimation Instability 5093 Moved to next CF 18 6/7 +180−32 Andrei Lepikhov (lepikhov) 5 5 months ago
Prevent incorrect entries in pg_stat_activity. 5105 Moved to next CF 6/7 +19−2 Fujii Masao (masaofujii) 4 4 months ago
Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() 5124 Moved to next CF Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch) 4 3 weeks ago
DirtyScanshot index scan skips concurrently updated tuples 5151 Moved to next CF stable 7/7 +146−8 Michail Nikolaev (nkey) 4 1 month ago
psql client does not handle WSAEWOULDBLOCK on Windows 5154 Moved to next CF 7/7 +1−1 Umar Hayat (pgwizard) 4 4 months ago
Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 5160 Moved to next CF stable 6/7 +1567−50 Michail Nikolaev (nkey) 4 1 month ago
Fix standby may crash when switching-over in certain special cases 5199 Moved to next CF 7/7 +2−2 pixian shi (pxshi) 4 3 months ago
Fix RelationTruncate() corruption 5242 Moved to next CF Not processed Robert Haas (rhaas), Thomas Munro (macdice) Thomas Munro (macdice) 3 1 week ago
ensure we have a snapshot when dropping an index concurrently 5262 Moved to next CF 18 6/7 +35−5 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 4 days ago
Fix incorrect Assert in gistFindCorrectParent() 5268 Moved to next CF 6/7 +2−1 Tender Wang (tndrwang) Heikki Linnakangas (heikki) 3 1 week ago
Fix race between WAL flush and InstallXLogFileSegment() 5276 Moved to next CF Needs rebase! Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) 3 5 months ago
Fix for consume_xids advancing XIDs incorrectly 5303 Moved to next CF stable 6/7 +0−0 Yushi Ogiwara (yushi) 3 4 months ago
Clients
functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) 3256 Moved to next CF Not processed Justin Pryzby (justinpryzby) David Christensen (davidchristensen) 16 10 months ago
psql: Rethinking of \du command 4738 Moved to next CF 7/7 +72−126 Pavel Luzanov (p.luzanov@postgrespro.ru) David Johnston (polobo), Wen Yi (wenyi) 7 3 days ago
Adding comments to help understand psql hidden queries 4764 Moved to next CF Needs rebase! David Christensen (davidchristensen), Greg Sabino Mullane (greg) Tom Lane (tgl) 6 2 weeks ago
psql meta-command conninfo+ 4814 Moved to next CF 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
psql: Add leakproof field to \dAo+ meta-command results 5102 Moved to next CF Not processed Yugo Nagata (yugo.nagata) Dean Rasheed (deanr), Erik Wienhold (ewie) Dean Rasheed (deanr) 3 3 months ago
libpq: Fix processing of SSL records >8kB on async API 5251 Moved to next CF stable 7/7 +13−0 Lars Kanis (larsk) Jacob Champion (jchampion) 4 4 weeks ago
Allow default \watch interval in psql to be configured 5353 Moved to next CF 6/7 +141−2 Daniel Gustafsson (d_gustafsson) Ashutosh Bapat (ashutoshbapat), Masahiro Ikeda (masahiro.ikeda) Daniel Gustafsson (d_gustafsson) 3 2 weeks ago
Add support for database service to psql prompt 5356 Moved to next CF Not processed Michael Banck (mbanck) Greg Sabino Mullane (greg) Michael Paquier (michael-kun) 2 3 months ago
Documentation
Convert internals documentation to Markdown 4918 Moved to next CF 18 Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) 4 4 months ago
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/7 +139−139 David Johnston (polobo) Marlene Reiterer (marlene.rte) 6 yesterday
Doc: Improve hostssl related descriptions and option presentation 5088 Moved to next CF Needs rebase! David Johnston (polobo) 5 1 month ago
Clarify the behavior of AT TIME ZONE 5146 Moved to next CF 7/8 +0−0 Aleksander Alekseev (a.alekseev) Laurenz Albe (laurenz) Bruce Momjian (bmomjian) 4 1 month ago
doc: Meson is not experimental on Windows 5156 Moved to next CF Not processed Aleksander Alekseev (a.alekseev) Peter Eisentraut (petere) Peter Eisentraut (petere) 3 2 months ago
C-Language Functions docs on how to call internal functions 5255 Moved to next CF Not processed Florents Tselai (florentst) Pavel Stehule (okbobcz) Tom Lane (tgl) 2 2 months ago
Streaming Replication vs Logical 5296 Moved to next CF 6/7 +31−22 Paul Jungwirth (pjungwir) Robert Treat (xzilla) 3 1 month ago
Recommend --no-psqlrc when restoring a pg_dump script 5306 Moved to next CF stable Not processed Shinya Kato (shinyakato) Robert Treat (xzilla) Tom Lane (tgl) 2 2 months ago
doc: virtual envs with Pl/Python 5308 Moved to next CF Not processed Florents Tselai (florentst) 2 5 months ago
Clarify old WAL files cannot be removed until they are summarized 5310 Moved to next CF Not processed Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 4 months ago
Document how to run only specific regress tests 5333 Moved to next CF Not processed Paul Jungwirth (pjungwir) 2 5 months ago
Use "protocol options" name instead of "protocol extensions" everywhere 5341 Moved to next CF 7/7 +4−4 Jelte Fennema-Nio (jeltef) 3 1 month ago
Miscellaneous
Unlinking Parallel Hash Join inner batch files sooner 4314 Moved to next CF Not processed Thomas Munro (macdice) 9 6 months ago
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 4 weeks ago
date_trunc function in interval version 4761 Moved to next CF Not processed Przemysław Sztoch (psztoch) 5 10 months ago
Add trim_trailing_whitespace to editorconfig file 4829 Moved to next CF Not processed Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) Peter Eisentraut (petere) 5 2 months ago
Avoid orphaned objects dependencies, take 3 4942 Moved to next CF 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 6 2 months ago
Expand applicability of aggregate's sortop optimization 4980 Moved to next CF 7/7 +352−47 Matthias van de Meent (mmeent) Andrei Lepikhov (lepikhov) 5 1 week ago
better error message when --single is not the first arg to postgres executable 5052 Moved to next CF 18 Not processed Nathan Bossart (bossartn), Greg Sabino Mullane (greg) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 4 months ago
gamma() and lgamma() functions 5098 Moved to next CF 18 7/7 +212−0 Dean Rasheed (deanr) Alexandra Wang (alexandrawang) Dean Rasheed (deanr) 5 3 weeks ago
Casts from jsonb to other types should cope with json null 5152 Moved to next CF Not processed Tom Lane (tgl) Tom Lane (tgl) 3 2 months ago
Prohibit to use EphemeralNamedRelation in materialized views 5153 Moved to next CF Not processed Yugo Nagata (yugo.nagata) Tom Lane (tgl) Tom Lane (tgl) 3 3 months ago
Allow casting between bytea and integer types 5176 Moved to next CF 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 Moved to next CF 7/7 +61−0 Nishant Sharma (nishant-at-edb) 4 2 weeks ago
Truncate logs by max_log_size 5272 Moved to next CF 7/7 +112−2 Kirill Gavrilov (diphantxm) Fujii Masao (masaofujii), Jim Jones (jimus) 4 2 weeks ago
Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c 5291 Moved to next CF 6/7 +2−3 Tender Wang (tndrwang) Alexander Korotkov (smagen) 3 3 weeks ago
System views for versions reporting 5318 Moved to next CF stable Needs rebase! Dmitry Dolgov (erthalion) 4 2 weeks ago
Monitoring & Control
pg_stat_statements and "IN" conditions 2837 Moved to next CF 6/7 +945−23 Dmitry Dolgov (erthalion) Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih) Álvaro Herrera (alvherre) 22 3 weeks ago
Amcheck verification of GiST and GIN 3733 Moved to next CF 6/7 +1508−215 Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) José Villanova (azlev), Mark Dilger (mark.dilger) Tomas Vondra (fuzzycz) 15 2 weeks ago
Logging parallel worker draught 4291 Moved to next CF 19 7/7 +93−0 Benoit Lobréau (benoitl) Sami Imseih (simseih) 10 1 week ago
Add last_commit_lsn to pg_stat_database 4355 Moved to next CF Not processed James Coleman (jcole1989) Wen Yi (wenyi) 9 10 months ago
Set log_lock_waits=on by default 4718 Moved to next CF 7/7 +6−5 Laurenz Albe (laurenz) Michael Banck (mbanck), Nathan Bossart (bossartn) 8 1 week ago
Add local address to log_line_prefix 4907 Moved to next CF 7/7 +24−0 Greg Sabino Mullane (greg) David Steele (dsteele), Cary Huang (cary), Jim Jones (jimus) Tom Lane (tgl) 5 1 week ago
Show WAL stats on pg_stat_io 4950 Moved to next CF Not processed Nazir Bilal Yavuz (nbyavuz) Akshat Jaimini (akshatj) Michael Paquier (michael-kun) 4 2 months ago
pg_stat_activity: make slow/hanging authentication more visible 4974 Moved to next CF 18 7/7 +127−6 Jacob Champion (jchampion) Michael Paquier (michael-kun) 5 3 weeks 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 3 weeks ago
Track the amount of time waiting due to cost_delay 5027 Moved to next CF 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Nathan Bossart (bossartn), Masahiro Ikeda (masahiro.ikeda) Nathan Bossart (bossartn) 5 2 months ago
Add pg_ownerships and pg_privileges system views 5033 Moved to next CF Not processed Joel Jacobson (joeljacobson) 4 4 months ago
Improve EXPLAIN output for multicolumn B-Tree Index 5063 Moved to next CF 18 Not processed Masahiro Ikeda (masahiro.ikeda) 4 6 months ago
add log_transaction GUC setting 5131 Moved to next CF 18 Not processed Sergey Solovev (ashblade) 3 4 months ago
Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) 5183 Moved to next CF 7/7 +306−49 Peter Geoghegan (pgeoghegan) Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (alenka) Peter Geoghegan (pgeoghegan) 4 1 month ago
per backend I/O statistics 5232 Moved to next CF 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 2 months ago
Trim the heap free memory 5252 Moved to next CF 18 Not processed Shawn Wang (shawnwang) 2 2 months ago
Make pg_stat_io view count IOs as bytes instead of blocks 5256 Moved to next CF 18 Not processed Nazir Bilal Yavuz (nbyavuz) Michael Paquier (michael-kun), Andrew Dunstan (adunstan) Michael Paquier (michael-kun) 2 2 months ago
Enhance file_fdw to report processed and skipped tuples in COPY progress 5282 Moved to next CF Needs rebase! Fujii Masao (masaofujii) 3 1 month ago
Add “FOR UPDATE NOWAIT” lock details to the log. 5294 Moved to next CF 7/7 +4−2 Yuki Seino (seinoyu) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 3 3 weeks ago
Logging plan of the currently running query 5330 Moved to next CF 18 Needs rebase! Atsushi Torikoshi (atsushitorikoshi) Akshat Jaimini (akshatj), Sadeq Dousti (msdousti) 4 1 week ago
Count and log pages set all frozen by vacuum 5346 Moved to next CF Not processed Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 2 3 months ago
Enhance memory context statistics reporting for all PostgreSQL processes. 5355 Moved to next CF 18 6/7 +1383−45 Rahila Syed (rahila) Daniel Gustafsson (d_gustafsson), Atsushi Torikoshi (atsushitorikoshi) Daniel Gustafsson (d_gustafsson) 3 1 week ago
Performance
In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal) 3461 Moved to next CF Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom) 16 3 months ago
AcquireExecutorLocks() and run-time pruning 3478 Moved to next CF Needs rebase! Amit Langote (amitlan) Tom Lane (tgl) Amit Langote (amitlan) 17 1 month ago
nbtree performance improvements through specialization on key shape 3672 Moved to next CF Not processed Matthias van de Meent (mmeent) 14 5 months ago
Reducing planning time when tables have many partitions 3701 Moved to next CF 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 1 week ago
ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables 3705 Moved to next CF Not processed Justin Pryzby (justinpryzby) Bertrand Drouvot (bertranddrouvot.pg) 13 4 months ago
Cross-database SERIALIZABLE safe snapshots 4240 Moved to next CF Not processed Thomas Munro (macdice) Heikki Linnakangas (heikki) 9 1 year ago
Avoid unnecessary PlaceHolderVars for simple Vars 4319 Moved to next CF Not processed Richard Guo (richardguo) James Coleman (jcole1989) Richard Guo (richardguo) 9 4 months ago
Index Prefetching 4351 Moved to next CF Needs rebase! Tomas Vondra (fuzzycz) 11 1 week ago
Extract numeric field in JSONB more effectively 4476 Moved to next CF Not processed Andy Fan (andyf) Chapman Flack (chap) 8 4 months ago
Statistics Import and Export 4538 Moved to next CF 7/7 +267−64 Corey Huinker (coreyh) Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) Jeff Davis (jdavis) 9 1 week ago
Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 4564 Moved to next CF 7/7 +389−77 Ashutosh Bapat (ashutoshbapat) Amit Langote (amitlan) 8 1 week ago
CRC32C Parallel Computation Optimization on ARM 4620 Moved to next CF Needs rebase! xiang gao (xiang.gao) Nathan Bossart (bossartn), John Naylor (john.naylor) 8 2 weeks ago
Special-case executor expression steps for common combinations 4627 Moved to next CF 7/7 +194−39 Andres Freund (andresfreund), Daniel Gustafsson (d_gustafsson) Andreas Karlsson (kandreas) Daniel Gustafsson (d_gustafsson) 8 1 month ago
nbtree: implement dynamic prefix truncation 4635 Moved to next CF Not processed Matthias van de Meent (mmeent) 7 5 months ago
nbtree: downlink right separator/HIKEY optimization 4638 Moved to next CF Not processed Matthias van de Meent (mmeent) 7 1 year 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
shared detoast datum 4759 Moved to next CF Not processed Andy Fan (andy2) 6 9 months ago
Add a attopt to disable MCV when estimating for Var = Const 4909 Moved to next CF Not processed Andy Fan (andy2) 4 11 months ago
Parallel CREATE INDEX for GIN indexes 4966 Moved to next CF 7/7 +531−260 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 7/7 +3891−897 Michail Nikolaev (nkey) Matthias van de Meent (mmeent) 5 1 week ago
Parallel CREATE INDEX for GiST indexes 5026 Moved to next CF Not processed Tomas Vondra (fuzzycz) Andreas Karlsson (kandreas) 4 5 months ago
Sort functions with specialized comparators 5036 Moved to next CF 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 Moved to next CF 7/7 +53−28 Andrei Lepikhov (lepikhov) Dean Rasheed (deanr) Alexander Korotkov (smagen) 5 1 week ago
nbtree skip scan 5081 Moved to next CF 7/7 +3840−565 Peter Geoghegan (pgeoghegan) Aleksander Alekseev (a.alekseev), Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (a.rybakina) Peter Geoghegan (pgeoghegan) 5 1 week ago
Streaming Vacuum 5089 Moved to next CF Not processed Thomas Munro (macdice), Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 5 1 month ago
Make tuple deformation faster 5097 Moved to next CF Not processed David Rowley (davidrowley) David Rowley (davidrowley) 4 3 months ago
Improved crc32c performance with AVX-512 algorithm. 5100 Moved to next CF 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 Moved to next CF Needs rebase! Andrei Lepikhov (lepikhov) 4 1 month ago
Allow partition-wise join when whole row var is needed 5128 Moved to next CF 18 Needs rebase! Ashutosh Bapat (ashutoshbapat), Alexander Pyhalov (a.pyhalov) 4 4 months ago
Asynchronous MergeAppend Execution 5129 Moved to next CF Needs rebase! Alexander Pyhalov (a.pyhalov) 4 7 months ago
Use read streams in autoprewarm 5162 Moved to next CF 7/8 +178−76 Nazir Bilal Yavuz (nbyavuz) Daniel Gustafsson (d_gustafsson) Melanie Plageman (melanieplageman) 4 1 week ago
AIO 5227 Moved to next CF 7/7 +5611−79 Andres Freund (andresfreund) Noah Misch (nmisch) Andres Freund (andresfreund) 4 1 week ago
Add ExprState hashing for GROUP BY and hashed SubPlans 5229 Moved to next CF Not processed David Rowley (davidrowley) David Rowley (davidrowley) 3 4 months ago
Consider the number of columns in the sort cost model 5231 Moved to next CF 18 Not processed Andrei Lepikhov (lepikhov) Kirill Reshke (reshke), Alena Rybakina (alenka) 2 4 months ago
Allow SQL functions use CachedPlan machinery 5246 Moved to next CF 18 7/7 +2109−972 Alexander Pyhalov (a.pyhalov) Tom Lane (tgl), Pavel Stehule (okbobcz) Tom Lane (tgl) 3 1 week ago
Improve statistics estimation considering GROUP-BY as a 'uniqueiser' 5269 Moved to next CF 18 2/7 +37−0 Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 3 1 month ago
Replace IN VALUES with ANY in WHERE clauses during optimization 5283 Moved to next CF 18 Needs rebase! Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) newtglobal postgresql_contributors (newtpostgrescontributors) Alexander Korotkov (smagen) 3 1 week ago
Limiting overshoot in nbtree SAOP parallel index scans 5299 Moved to next CF Needs rebase! Matthias van de Meent (mmeent) 3 5 months ago
Trigger more frequent autovacuums for insert-heavy tables 5320 Moved to next CF 7/7 +37−16 Melanie Plageman (melanieplageman) Nathan Bossart (bossartn) Melanie Plageman (melanieplageman) 3 1 month ago
use a non-locking initial test in TAS_SPIN on AArch64 5321 Moved to next CF 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 3 months ago
Add sortsupport for range types and btree_gist 5325 Moved to next CF 7/7 +870−8 Bernd Helmle (psoo), Christoph Heiss (christoph.heiss) Andrey Borodin (x4m), jian he (hellothere) Heikki Linnakangas (heikki) 3 1 week ago
Parallel heap vacuum 5326 Moved to next CF 7/7 +1617−380 Masahiko Sawada (masahikosawada) Hayato Kuroda (ha-kun) 3 1 week ago
Use read_stream in index vacuum 5327 Moved to next CF 7/7 +167−25 Andrey Borodin (x4m) Melanie Plageman (melanieplageman), Kirill Reshke (reshke), Rahila Syed (rahila), Zhao Junwang (zhjwpku) Melanie Plageman (melanieplageman) 3 3 weeks ago
Additional function inlining for slow_deform_heap_tuple 5347 Moved to next CF Not processed David Rowley (davidrowley) David Rowley (davidrowley) 2 5 months ago
Shave a few cycles off our ilog10 implementation 5358 Moved to next CF 18 Not processed David Fetter (dfetter) Heikki Linnakangas (heikki), David Rowley (davidrowley) 2 3 months ago
Showing applied extended statistics in explain Part2 5359 Moved to next CF 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
Procedural Languages
declarative session variables, LET command 1608 Moved to next CF 6/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 1 week 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 1 month ago
Refactoring
SetLatches() 3998 Moved to next CF Not processed Thomas Munro (macdice) 12 5 months ago
Revise get_cheapest_parallel_safe_total_inner 4285 Moved to next CF 7/7 +11−4 Richard Guo (richardguo) wenhui qiu (wenhuiqiu) 11 6 months ago
Retiring is_pushed_down 4458 Moved to next CF Needs rebase! Richard Guo (richardguo) Tom Lane (tgl) 10 3 months ago
New [relation] options engine 4688 Moved to next CF Needs rebase! Nikolay Shaplov (nataraj) 7 4 weeks ago
Change prefetch and read strategies to use range in pg_prewarm 4763 Moved to next CF Not processed Cédric Villemain (c2main) Nazir Bilal Yavuz (nbyavuz) 5 1 year ago
BitmapHeapScan table AM violation removal (and use streaming read API) 4874 Moved to next CF 7/7 +826−911 Melanie Plageman (melanieplageman) Heikki Linnakangas (heikki), Andres Freund (andresfreund), Tomas Vondra (fuzzycz) Melanie Plageman (melanieplageman) 6 1 week ago
Use <stdint.h> for int64_t and other exact-width integer types 4938 Moved to next CF Not processed Thomas Munro (macdice) Peter Eisentraut (petere) Thomas Munro (macdice) 4 4 months ago
Use XLOG_CONTROL_FILE macro everywhere 4941 Moved to next CF 18 7/7 +30−9 Anton Melnikov (antonmel) Daniel Gustafsson (d_gustafsson) Fujii Masao (masaofujii) 5 1 week ago
SendProcSignal(), SetLatch() → SendInterrupt() 5118 Moved to next CF Not processed Heikki Linnakangas (heikki), Thomas Munro (macdice) 3 2 months ago
Remove duplicated smgrclose call 5149 Moved to next CF 18 7/7 +0−6 Steven Niu (niushiji) Cary Huang (cary), Kirill Reshke (reshke), Zhao Junwang (zhjwpku) 4 3 weeks ago
Fix a few issues in collation cache 5164 Moved to next CF 18 Not processed Jeff Davis (jdavis) 3 4 months ago
Make ECPG locale usage thread-safe 5166 Moved to next CF Needs rebase! Thomas Munro (macdice) Peter Eisentraut (petere) 5 2 weeks ago
Thread-safe nl_langinfo(), localeconv(), check_locale() 5170 Moved to next CF 7/7 +71−52 Thomas Munro (macdice) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 1 week ago
Call rm_redo in a temporary memory context 5174 Moved to next CF Not processed Heikki Linnakangas (heikki) 3 6 months ago
Use function smgrclose() to replace the loop 5196 Moved to next CF 18 Not processed Steven Niu (niushiji) 3 5 months ago
Vectored IO in XLogWrite() 5225 Moved to next CF Not processed Melih Mutlu (melihmutlu) 3 4 months ago
JIT: The nullness of casetest.value can be determined at the JIT compile time. 5236 Moved to next CF 18 Not processed Xing Guo (higuoxing) Tom Lane (tgl) Tom Lane (tgl) 2 2 months ago
Refactor SLRU to always use long file names 5250 Moved to next CF 6/7 +103−85 Aleksander Alekseev (a.alekseev) Rustam ALLAKOV (rustam.allakov) 4 1 week ago
Refactor bytea_sortsupport() 5288 Moved to next CF Not processed Aleksander Alekseev (a.alekseev) 3 4 months ago
Move clause_sides_match_join() into pathnode.h 5289 Moved to next CF Not processed James Hunter (hunjmes) David Rowley (davidrowley) 2 6 months ago
Collation and ctype method tables and extension hooks 5301 Moved to next CF Needs rebase! Jeff Davis (jdavis) 4 2 months ago
simplify regular expression locale global variables 5313 Moved to next CF Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 2 4 months ago
Replication & Recovery
CREATE SUBSCRIPTION ... SERVER 4529 Moved to next CF 6/7 +587−35 Jeff Davis (jdavis) vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) 10 1 week ago
Introduce XID age and inactive timeout based replication slot invalidation 4770 Moved to next CF 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
CSN snapshots in hot standby 4912 Moved to next CF 18 Not processed Heikki Linnakangas (heikki) 4 4 months ago
Return pg_control from pg_backup_stop(). 4997 Moved to next CF 18 7/7 +181−30 David Steele (dsteele) 6 2 months ago
Synchronization of sequences to subscriber 5111 Moved to next CF 7/7 +2977−740 vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Peter Smith (smithpb2250) 5 2 hours ago
Recovery of .partial WAL segments 5148 Moved to next CF Not processed Stefan Fercot (stefan.fercot) 3 5 months ago
Expose the acquired_by parameter to the pg_replication_origin_session_setup function 5189 Moved to next CF 18 7/7 +19−4 Doruk Yılmaz (dorukyilmaz) Euler Taveira (eulerto) 4 1 month ago
Syncrep and improving latency due to WAL throttling 5309 Moved to next CF 18 Not processed Tomas Vondra (fuzzycz), Jakub Wartak (jakub.wartak.tomtom) Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) 2 5 months ago
Skip logical decoding of already-aborted transactions. 5338 Moved to next CF Not processed Masahiko Sawada (masahikosawada) vigneshwaran C (vignesh.postgres) Masahiko Sawada (masahikosawada) 3 4 weeks ago
Security
add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl 4390 Moved to next CF 7/7 +255−32 Cary Huang (cary) Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) 10 1 month ago
Client authentication via OAuth 2.0 4412 Moved to next CF 7/7 +0−0 Jacob Champion (jchampion) Peter Eisentraut (petere), Daniel Gustafsson (d_gustafsson), Antonin Houska (a.houska) Daniel Gustafsson (d_gustafsson) 10 18 hours ago
add multiple client certificate selection feature 4924 Moved to next CF Not processed Cary Huang (cary) 4 1 year ago
Extend ALTER DEFAULT PRIVILEGES for large objects 4945 Moved to next CF 7/7 +20−0 Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii), Laurenz Albe (laurenz) Fujii Masao (masaofujii) 5 1 week 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 7/7 +326−62 Jelte Fennema-Nio (jeltef) 6 6 months ago
Blast-RADIUS mitigation 5158 Moved to next CF Not processed Thomas Munro (macdice) Heikki Linnakangas (heikki) 3 8 months ago
deprecate md5 passwords 5295 Moved to next CF 18 Not processed Nathan Bossart (bossartn) Greg Sabino Mullane (greg) Nathan Bossart (bossartn) 2 4 months ago
Provide means to disable legacy crypt() and gen_salt() functions in pgcrypto 5332 Moved to next CF 18 Not processed Joe Conway (jconway) 2 2 months ago
Server Features
BCP 47 locale names for Windows 3772 Moved to next CF Not processed Thomas Munro (macdice) 8 8 months ago
Post-special Page Storage TDE support (aka Reserved Page Size) 3986 Moved to next CF Not processed David Christensen (davidchristensen) 12 3 months ago
UUID v7 4388 Moved to next CF 17 Not processed Andrey Borodin (x4m) Masahiko Sawada (masahikosawada), Aleksander Alekseev (a.alekseev), Chris Travers (einhverfr), Nikolay Samokhvalov (nikolay), Przemysław Sztoch (psztoch), Kirk Wolak (kirkw) Masahiko Sawada (masahikosawada) 9 2 months ago
Sequence Access Methods, round two 4677 Moved to next CF Needs rebase! Michael Paquier (michael-kun) 8 2 weeks ago
Add the page header to each SLRU page. 4709 Moved to next CF Not processed Rishu Bagga (rishubagga), Yong Li (yoli) Thomas Munro (macdice), Shawn Debnath (sd) 6 5 months ago
Add new protocol message to change GUCs to be able to change protocol extension parameters 4736 Moved to next CF 18 Needs rebase! Jelte Fennema-Nio (jeltef) Robert Haas (rhaas) 7 1 month ago
Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM 4777 Moved to next CF Not processed Bharath Rupireddy (bharathrupireddy) Jeff Davis (jdavis) 5 5 months ago
COPY ON_ERROR 'NULL' 4810 Moved to next CF 6/7 +277−52 jian he (universality) Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Jim Jones (jimus) 7 1 week 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
KNN-btree 4871 Moved to next CF Needs rebase! Nikita Glukhov (n.glukhov), Anton Melnikov (antonmel) 6 4 months ago
CREATE DATABASE ... STRICT_UNICODE 4876 Moved to next CF Not processed Jeff Davis (jdavis) 5 4 months ago
Eager aggregation, take 3 4881 Moved to next CF 19 Needs rebase! Richard Guo (richardguo) 6 2 months ago
CREATE DATABASE ... STRATEGY=FILE_CLONE 4886 Moved to next CF 2/7 +170−3 Thomas Munro (macdice), Nazir Bilal Yavuz (nbyavuz) Thomas Munro (macdice) 5 1 week ago
Add extension_destdir GUC 4913 Moved to next CF 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 3 weeks ago
Use WALReadFromBuffers in more places 4952 Moved to next CF Not processed Bharath Rupireddy (bharathrupireddy) 4 6 months 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
New function rand_array() to contrib/tablefunc 5061 Moved to next CF Not processed Andy Fan (andy2) Dean Rasheed (deanr), Aleksander Alekseev (a.alekseev), Jim Jones (jimus) 4 5 months ago
VACUUM FULL / CLUSTER CONCURRENTLY 5117 Moved to next CF 18 7/7 +1259−207 Antonin Houska (a.houska) 4 1 week ago
REINDEX not updating partition progress 5122 Moved to next CF stable Not processed Ilya Gladyshev (qoops) 3 8 months ago
Index AM API cleanup 5195 Moved to next CF 6/7 +399−334 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 Moved to next CF 18 6/7 +102−0 Maxim Orlov (m.orlov) Heikki Linnakangas (heikki) 5 8 hours ago
removes attndims and typndims entirely 5263 Moved to next CF 18 Not processed Jian He (stayreal) 2 2 months ago
Add column name to error description 5266 Moved to next CF 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 Moved to next CF 18 7/7 +1048−286 Amul Sul (sulamul) Peter Eisentraut (petere), Alexandra Wang (alexandrawang) Peter Eisentraut (petere) 3 1 week ago
New "single" COPY format 5300 Moved to next CF Not processed Joel Jacobson (joeljacobson) Masahiko Sawada (masahikosawada), newtglobal postgresql_contributors (newtpostgrescontributors) 2 3 months ago
Changing shared_buffers without restart 5319 Moved to next CF Needs rebase! Dmitry Dolgov (erthalion) Vladlen Popolitov (vladlenpopolitov) 4 2 days ago
Support enabling checksums online 5323 Moved to next CF Needs rebase! Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) Tomas Vondra (fuzzycz) 4 1 week ago
Increase 2Gb limit of memory GUC variables in 64-bit Windows 5343 Moved to next CF 18 Not processed Vladlen Popolitov (vladlenpopolitov) Tom Lane (tgl) Tom Lane (tgl) 2 2 months ago
SQL Commands
Add SPLIT PARTITION/MERGE PARTITIONS commands 3659 Moved to next CF 18 7/7 +7090−39 Dmitry Koval (d.koval) stephane tachoires (sttachoires) Alexander Korotkov (smagen) 13 4 weeks ago
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 1 week ago
SQL:2011 application time 4308 Moved to next CF Needs rebase! Paul Jungwirth (pjungwir) Peter Eisentraut (petere) Peter Eisentraut (petere) 10 3 weeks ago
Incremental View Maintenance (IVM), take 2 4337 Moved to next CF Needs rebase! Yugo Nagata (yugo.nagata) 11 7 months ago
Implement row pattern recognition feature 4460 Moved to next CF 19 6/7 +4207−35 Tatsuo Ishii (ishii) Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033) 10 1 month ago
Make COPY format extendable: Extract COPY TO format implementations 4681 Moved to next CF Needs rebase! Kouhei Sutou (kou) Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn), Zhao Junwang (zhjwpku), Yong Li (yoli) 7 1 week ago
COPY TO json 4716 Moved to next CF 6/7 +378−53 Joe Conway (jconway) Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn) Joe Conway (jconway) 7 1 month ago
RETURNING OLD/NEW values 4723 Moved to next CF 18 Not processed Dean Rasheed (deanr) Dean Rasheed (deanr) 6 2 months 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 1 week ago
Virtual generated columns 4972 Moved to next CF Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 5 1 month ago
CREATE OR REPLACE MATERIALIZED VIEW 5099 Moved to next CF 18 7/7 +749−96 Erik Wienhold (ewie) newtglobal postgresql_contributors (newtpostgrescontributors) 4 1 week 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 Moved to next CF 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 6/7 +1567−202 Alexandra Wang (alexandrawang) Peter Eisentraut (petere), Vik Fearing (xocolatl) 5 2 weeks ago
Add roman support for to_number function 5221 Moved to next CF 18 Not processed Hunaid Sohail (hunaid) Maciek Sakrejda (msakrejda-pga) Tom Lane (tgl) 3 2 months 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 Moved to next CF 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 +1585−26 Shayon Mukherjee (shayonj) Sami Imseih (simseih), newtglobal postgresql_contributors (newtpostgrescontributors) 4 1 week ago
general purpose array_sort 5277 Moved to next CF 18 7/7 +425−0 Zhao Junwang (zhjwpku) Tom Lane (tgl) Tom Lane (tgl) 3 2 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 1 month ago
Support regular expressions with nondeterministic collations 5334 Moved to next CF Not processed Peter Eisentraut (petere) 2 3 months ago
System Administration
allow changing autovacuum_max_workers without restarting 4921 Moved to next CF 18 Not processed Nathan Bossart (bossartn) Yogesh Sharma (sharmay) Nathan Bossart (bossartn) 4 3 months ago
Reduce the log spam by excluding certain SQLSTATEs 4964 Moved to next CF 18 7/7 +218−0 Laurenz Albe (laurenz) Jim Jones (jimus) 5 1 week ago
New GUC autovacuum_max_threshold 5046 Moved to next CF 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
Track collation and ctype versions separately 5141 Moved to next CF 18 Not processed Jeff Davis (jdavis) 3 8 months ago
pg_upgrade: Support for upgrading to checksums enabled 5206 Moved to next CF Needs rebase! Peter Eisentraut (petere) Nathan Bossart (bossartn), Ilya Kosmodemiansky (hydrobiont) 4 1 week ago
database-specific role memberships 5284 Moved to next CF Not processed Denis Laxalde (dlax), Kenaniah Cerny (kenaniah) 2 6 months ago
New predefined role pg_manage_extensions 5357 Moved to next CF 2/7 +22−5 Michael Banck (mbanck) Laurenz Albe (laurenz) 3 1 week ago
Testing
CI and test improvements 3709 Moved to next CF Not processed Justin Pryzby (justinpryzby) 14 4 months ago
Test to dump and restore objects left behind by regression 4956 Moved to next CF 7/7 +51−26 Ashutosh Bapat (ashutoshbapat) Michael Paquier (michael-kun), vigneshwaran C (vignesh.postgres) 5 1 week ago
Convert sepgsql tests to TAP 4992 Moved to next CF Not processed Peter Eisentraut (petere) Andreas Karlsson (kandreas) Peter Eisentraut (petere) 4 2 months ago
CREATE SUBSCRIPTION - add missing test case 5190 Moved to next CF 6/7 +14−0 Peter Smith (smithpb2250) vigneshwaran C (vignesh.postgres) Heikki Linnakangas (heikki) 4 2 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 Moved to next CF 18 Not processed Aleksander Alekseev (a.alekseev) Jacob Champion (jchampion), keisuke kuroda (keisuke.kuroda.3862) Michael Paquier (michael-kun) 3 2 months ago
Add NetBSD and OpenBSD OSes to Postgres CI 5360 Moved to next CF Needs rebase! Nazir Bilal Yavuz (nbyavuz) Andres Freund (andresfreund) 3 1 week ago