Commitfest 2025-01

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


Status summary: Needs review: 28. Waiting on Author: 12. Ready for Committer: 4. Committed: 82. Moved to next CF: 208. Returned with Feedback: 6. Rejected: 4. Withdrawn: 14. Total: 358.

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 2 months 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 2 months ago
Network failure may prevent promotion 4748 Moved to next CF 7/7 +52−202 Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki) 7 2 months 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 2 months ago
Fix rare recovery shutdown hang 4884 Moved to next CF Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch), Martijn Wallet (mwallet) 5 6 months ago
Fix BackgroundPsql to report error on query timeout rather than calling die 4959 Moved to next CF 18 6/7 +17−16 Daniel Gustafsson (d_gustafsson) Heikki Linnakangas (heikki) 6 3 months 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 6 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 2 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 months ago
Incorrect error message for cancellation triggered by statement_timeout & flaky test 5070 Moved to next CF stable 6/7 +16−5 Jelte Fennema-Nio (jeltef) 6 3 months ago
inplace update: send nontransactional invalidations 5091 Moved to next CF stable 6/7 +3−0 Noah Misch (nmisch) Noah Misch (nmisch) 6 1 month ago
Incremental Sort Cost Estimation Instability 5093 Moved to next CF 18 6/7 +180−32 Andrei Lepikhov (lepikhov) 5 1 week ago
Prevent incorrect entries in pg_stat_activity. 5105 Moved to next CF 6/7 +19−2 Fujii Masao (masaofujii) 4 6 months ago
Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() 5124 Moved to next CF Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch) 4 2 months ago
DirtyScanshot index scan skips concurrently updated tuples 5151 Moved to next CF stable Needs rebase! Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Luan Silva (luansilva) 5 5 days ago
psql client does not handle WSAEWOULDBLOCK on Windows 5154 Moved to next CF 7/7 +1−1 Umar Hayat (pgwizard) 4 6 months ago
Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 5160 Moved to next CF stable 7/7 +1567−50 Michail Nikolaev (nkey) 5 4 weeks 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 5 months ago
Fix RelationTruncate() corruption 5242 Moved to next CF Not processed Robert Haas (rhaas), Thomas Munro (macdice) Thomas Munro (macdice) 3 2 months ago
ensure we have a snapshot when dropping an index concurrently 5262 Moved to next CF stable Needs rebase! Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 2 weeks ago
Fix incorrect Assert in gistFindCorrectParent() 5268 Moved to next CF 6/7 +2−1 Tender Wang (tndrwang) Heikki Linnakangas (heikki) 3 2 months ago
Fix race between WAL flush and InstallXLogFileSegment() 5276 Moved to next CF Needs rebase! Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) 3 7 months ago
Fix for consume_xids advancing XIDs incorrectly 5303 Moved to next CF stable 6/7 +0−0 Yushi Ogiwara (yushi) 3 6 months ago
Fix creation of empty .log files during log rotation 5365 Moved to next CF 6/7 +15−12 Arseny Kositsin (arseny114) 2 3 months ago
Fix bug with accessing to temporary tables of other sessions 5379 Moved to next CF 18 6/7 +55−23 Daniil Davydov (dddaniil) Rafia Sabih (rafia.sabih) 3 2 months ago
bt_index_parent_check false alarm for indexes created concurrently 5438 Moved to next CF 5/7 +70−40 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) 3 1 week ago
Incorrect result of bitmap heap scan. 5448 Moved to next CF stable 7/7 +127−132 Matthias van de Meent (mmeent) Andres Freund (andresfreund) 2 2 months ago
Fix logging for invalid recovery timeline 5468 Moved to next CF stable 7/7 +3−3 David Steele (dsteele) Michael Paquier (michael-kun) 2 3 months ago
Clients
psql: Rethinking of \du command 4738 Moved to next CF 6/7 +72−126 Pavel Luzanov (p.luzanov@postgrespro.ru) David Johnston (polobo), Wen Yi (wenyi) 7 2 months 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 months 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 3 months ago
libpq: Fix processing of SSL records >8kB on async API 5251 Moved to next CF stable 6/7 +13−0 Lars Kanis (larsk) Jacob Champion (jchampion) 4 2 months 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 months ago
Allow PGSERVICEFILE to be specified as part of the connection string 5387 Moved to next CF 19 7/7 +176−5 Torsten Foertsch (tfoertsch123) Ryo Kanbayashi (ryokanbayashi) 2 3 hours ago
Add Option to Check All Addresses For Matching target_session_attr 5396 Moved to next CF 18 Needs rebase! Andrew Jackson (andrewjackson) 3 4 weeks ago
Add Pipelining support to psql 5407 Moved to next CF 18 Needs rebase! Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 1 month ago
Tab completion for ALTER USER RESET 5414 Moved to next CF 18 7/7 +28−0 Robins Tharakan (robins) Tomas Vondra (fuzzycz) 2 3 months ago
Documentation
Document NULL Concepts and Behaviors 5086 Moved to next CF 6/7 +1279−160 David Johnston (polobo) 6 3 months ago
Doc: Move and modify standalone hot backups section 5087 Moved to next CF 6/7 +139−139 David Johnston (polobo) Marlene Reiterer (marlene.rte) 6 2 months ago
Doc: Improve hostssl related descriptions and option presentation 5088 Moved to next CF Needs rebase! David Johnston (polobo) 5 3 months 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 3 months ago
Streaming Replication vs Logical 5296 Moved to next CF 6/7 +31−22 Paul Jungwirth (pjungwir) Robert Treat (xzilla) 3 3 months ago
Document how to run only specific regress tests 5333 Moved to next CF 6/7 +12−0 Paul Jungwirth (pjungwir) Robert Treat (xzillaws) 3 7 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 3 months ago
explain pgstatindex fragmentation 5381 Moved to next CF 18 6/7 +9−0 Frédéric Yhuel (yhuelf) Laurenz Albe (laurenz), Bertrand Drouvot (bertranddrouvot), Benoit Lobréau (benoitl), Ahmed Ashour (ahmedashour) Peter Eisentraut (petere) 3 3 months ago
Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN 5418 Moved to next CF 7/7 +0−0 Masahiro Ikeda (masahiro.ikeda) Robert Treat (xzilla) Álvaro Herrera (alvherre) 2 2 months ago
doc: Mention clock synchronization recommendation for hot_standby_feedback 5425 Moved to next CF stable 5/7 +7−0 Jakub Wartak (jakub.wartak.tomtom) vigneshwaran C (vignesh.postgres) Peter Eisentraut (petere) 2 2 months ago
Miscellaneous
Support a wildcard in backtrace_functions 4735 Moved to next CF 6/7 +161−11 Jelte Fennema-Nio (jeltef) Daniel Gustafsson (d_gustafsson), Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson) 8 2 months ago
Avoid orphaned objects dependencies, take 3 4942 Moved to next CF 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 6 1 week 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 2 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 2 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 3 months 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 months ago
Truncate logs by max_log_size 5272 Moved to next CF 6/7 +112−2 Kirill Gavrilov (diphantxm) Fujii Masao (masaofujii), Jim Jones (jimus) 4 2 months 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 2 months ago
System views for versions reporting 5318 Moved to next CF stable Needs rebase! Dmitry Dolgov (erthalion) 4 2 months ago
Tweak access BufferDescriptors array codes in BufferGetLSNAtomic() 5373 Moved to next CF 7/7 +2−0 Tender Wang (tndrwang) Xuneng Zhou (egoa) Richard Guo (richardguo) 2 3 months ago
postgres_fdw could deparse ArrayCoerceExpr 5409 Moved to next CF 18 6/7 +80−0 Alexander Pyhalov (a.pyhalov) Maxim Orlov (m.orlov) 3 1 week ago
Add maintainer-defined module info into shared library 5465 Moved to next CF 18 7/7 +596−112 Andrei Lepikhov (lepikhov) Yurii Rashkovskii (yrashk) Tom Lane (tgl) 2 2 months ago
Unicode 16 update 5472 Moved to next CF 7/7 +7442−6609 Peter Eisentraut (petere), Jeff Davis (jdavis) Peter Eisentraut (petere) 2 2 months 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 2 months ago
Add pg_stat_session 3405 Moved to next CF Needs rebase! Rafia Sabih (rafia.sabih), Sergey Dudoladov (sdudoladov) Bertrand Drouvot (bdrouvot), Atsushi Torikoshi (atsushitorikoshi), Andrei Zubkov (zubkov), Sadeq Dousti (msdousti) 16 3 months 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 months ago
Logging parallel worker draught 4291 Moved to next CF 19 7/7 +93−0 Benoit Lobréau (benoitl) Sami Imseih (simseih) 10 2 months ago
Set log_lock_waits=on by default 4718 Moved to next CF 6/7 +6−5 Laurenz Albe (laurenz) Michael Banck (mbanck) 8 2 months 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 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 2 months ago
relfilenode statistics 5007 Moved to next CF 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) 6 3 months ago
Vacuum statistics 5012 Moved to next CF 18 Needs rebase! Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) Ilia Evdokimov (ilidock95) 6 1 week 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 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 3 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 3 months 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 2 months ago
Logging plan of the currently running query 5330 Moved to next CF 18 6/7 +573−54 Atsushi Torikoshi (atsushitorikoshi) Akshat Jaimini (akshatj), Sadeq Dousti (msdousti) 4 1 week 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 2 months ago
Sampling in pg_stat_statements 5390 Moved to next CF 18 7/7 +291−8 Ilia Evdokimov (ilidock95) Andrey Borodin (x4m), Sami Imseih (simseih), Alena Rybakina (alenka) 2 2 months ago
Log connection establishment timings 5442 Moved to next CF 7/7 +508−25 Melanie Plageman (melanieplageman) Fujii Masao (masaofujii), Jacob Champion (jchampion), Bertrand Drouvot (bertranddrouvot.pg) Melanie Plageman (melanieplageman) 2 3 months ago
Performance
AcquireExecutorLocks() and run-time pruning 3478 Moved to next CF Needs rebase! Amit Langote (amitlan) Tom Lane (tgl) Amit Langote (amitlan) 17 3 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 2 months ago
Index Prefetching 4351 Moved to next CF 7/7 +4395−192 Tomas Vondra (fuzzycz) 11 1 month 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 3 weeks 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 2 months 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 months 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 3 months ago
Teach predtest about IS [NOT] <boolean> proofs 4690 Moved to next CF 6/7 +1882−129 James Coleman (jcole1989) Tom Lane (tgl) 8 1 year ago
Parallel CREATE INDEX for GIN indexes 4966 Moved to next CF 5/7 +7−0 Tomas Vondra (fuzzycz) Matthias van de Meent (mmeent), Andy Fan (andy2) 6 1 month ago
[CREATE|RE] INDEX CONCURRENTLY with single heap scan and short-term resetting shapshots 4971 Moved to next CF 6/7 +3953−929 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Matthias van de Meent (mmeent) 6 3 weeks 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 3 months 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 2 months 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 2 months ago
Streaming Vacuum 5089 Moved to next CF Not processed Thomas Munro (macdice), Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 5 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 4 months ago
MergeJoin beats HashJoin in the case of multiple hash clauses 5114 Moved to next CF Needs rebase! Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 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 6 months ago
Asynchronous MergeAppend Execution 5129 Moved to next CF Needs rebase! Alexander Pyhalov (a.pyhalov) 4 9 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 2 months ago
AIO 5227 Moved to next CF 7/7 +5611−79 Andres Freund (andresfreund) Noah Misch (nmisch) Andres Freund (andresfreund) 4 2 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 2 months 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 3 months 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 2 months ago
Limiting overshoot in nbtree SAOP parallel index scans 5299 Moved to next CF 6/7 +151−23 Matthias van de Meent (mmeent) 4 1 month 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 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 2 months ago
Parallel heap vacuum 5326 Moved to next CF 6/7 +1927−370 Masahiko Sawada (masahikosawada) Hayato Kuroda (ha-kun) 4 yesterday
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 2 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 4 months ago
Let an Append to consider a tuple fraction when choosing fractional subpaths 5361 Moved to next CF 18 Needs rebase! Andrei Lepikhov (lepikhov), Nikita Malakhov (nmalakh) Alexander Korotkov (smagen) 2 3 months ago
Using Expanded Objects other than Arrays from plpgsql 5364 Moved to next CF Not processed Tom Lane (tgl) Tom Lane (tgl) 2 4 months ago
Eagerly scan all-visible pages to amortize aggressive vacuum 5366 Moved to next CF Not processed Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 2 4 months ago
optimize file transfer in pg_upgrade 5369 Moved to next CF 18 7/7 +642−80 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 2 months ago
Adding compression of temporary files 5382 Moved to next CF 4/7 +3842−16 Filip Januš (fjanus) 3 1 month ago
[PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause 5422 Moved to next CF 18 7/7 +0−0 Ravi Revathy (revathyraavi) 2 2 months ago
Eliminating SPI / SQL from some RI trigger functions 5450 Moved to next CF 19 Needs rebase! Amit Langote (amitlan) 3 2 months ago
Function scan FDW pushdown 5470 Moved to next CF 18 6/7 +1046−105 Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) Ashutosh Bapat (ashutoshbapat) 2 7 months ago
Speed up ICU case conversions 5474 Moved to next CF 2/7 +86−41 Andreas Karlsson (kandreas) 2 2 months ago
handle batch explosion in hash joins 5482 Moved to next CF 2/7 +5635−0 Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 2 3 months ago
Procedural Languages
declarative session variables, LET command 1608 Moved to next CF 6/7 +7762−63 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 2 days 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 week ago
Use Python "Limited API" in PL/Python 5416 Moved to next CF 7/7 +0−0 Peter Eisentraut (petere) Peter Eisentraut (petere) 2 2 months ago
Refactoring
Revise get_cheapest_parallel_safe_total_inner 4285 Moved to next CF 6/7 +11−4 Richard Guo (richardguo) wenhui qiu (wenhuiqiu) 11 8 months ago
Retiring is_pushed_down 4458 Moved to next CF Needs rebase! Richard Guo (richardguo) Tom Lane (tgl) 10 5 months ago
New [relation] options engine 4688 Moved to next CF Needs rebase! Nikolay Shaplov (nataraj) 7 2 months 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 2 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 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 2 months ago
Make ECPG locale usage thread-safe 5166 Moved to next CF Needs rebase! Thomas Munro (macdice) Peter Eisentraut (petere) 5 2 months 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 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 2 months ago
Refactor bytea_sortsupport() 5288 Moved to next CF Not processed Aleksander Alekseev (a.alekseev) 3 6 months ago
Collation and ctype method tables and extension hooks 5301 Moved to next CF 7/7 +860−583 Jeff Davis (jdavis) 4 3 days ago
Adopt <inttypes.h> macros in format strings. 5429 Moved to next CF Needs rebase! Thomas Munro (macdice) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 2 months ago
Clarify FileTag-based unlinking 5454 Moved to next CF 6/7 +10−7 Matthias van de Meent (mmeent) 3 5 months ago
Don't dirty pages while they are getting flushed out 5483 Moved to next CF Needs rebase! Andres Freund (andresfreund) 3 2 months ago
Replication & Recovery
CREATE SUBSCRIPTION ... SERVER 4529 Moved to next CF Needs rebase! Jeff Davis (jdavis) vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) 10 2 months 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 3 months ago
Return pg_control from pg_backup_stop(). 4997 Moved to next CF 18 6/7 +181−30 David Steele (dsteele) 6 4 months ago
Synchronization of sequences to subscriber 5111 Moved to next CF 6/7 +3066−764 vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Peter Smith (smithpb2250) 5 5 days 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 3 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 2 months ago
Conflict detection for update_deleted in logical replication 5378 Moved to next CF 2/7 +2389−172 Zhijie Hou (houzj) Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres) Amit Kapila (amitkapila) 3 2 days ago
Log LSN before table is dropped 5386 Moved to next CF 6/7 +8−0 Andrey Borodin (x4m), Nikolay Samokhvalov (nikolay), Kirk Wolak (kirkw) Jim Jones (jimus) 2 3 months ago
Adding a '--two-phase' option to 'pg_createsubscriber' utility. 5433 Moved to next CF Needs rebase! Shubham Khanna (skhanna) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) Amit Kapila (amitkapila) 2 3 months ago
Separate GUC for replication origins 5441 Moved to next CF 18 7/7 +92−92 Euler Taveira (eulerto) Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres) Masahiko Sawada (masahikosawada) 2 2 months ago
Enable logical decoding when wal_level = 'replica' without a server restart 5479 Moved to next CF 6/7 +1001−115 Masahiko Sawada (masahikosawada) 3 4 days ago
Security
add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl 4390 Moved to next CF 5/7 +255−32 Cary Huang (cary) Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) 10 1 week 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 2 days 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 2 months ago
Serverside SNI for SSL connections 4984 Moved to next CF 5/7 +937−50 Daniel Gustafsson (d_gustafsson) Jacob Champion (jchampion) 6 1 month ago
Extension security improvement: Add support for extensions with an owned schema 5018 Moved to next CF 18 6/7 +326−62 Jelte Fennema-Nio (jeltef) 6 8 months ago
revamp row-security tracking 5397 Moved to next CF 19 6/7 +25−17 Nathan Bossart (bossartn) 3 3 months ago
Modern SHA2- based password hashes for pgcrypto 5481 Moved to next CF 18 7/7 +1164−2 Bernd Helmle (psoo) Álvaro Herrera (alvherre) 2 2 months ago
Server Features
Sequence Access Methods, round two 4677 Moved to next CF 6/7 +2753−795 Michael Paquier (michael-kun) 8 1 month 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 3 months ago
COPY ON_ERROR 'NULL' 4810 Moved to next CF 7/7 +277−52 jian he (universality) Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Jim Jones (jimus) 7 2 months ago
on_error table, saving error info to a table 4817 Moved to next CF 6/7 +582−13 jian he (hellothere) Nishant Sharma (nishant-at-edb) 7 2 weeks ago
KNN-btree 4871 Moved to next CF Needs rebase! Nikita Glukhov (n.glukhov), Anton Melnikov (antonmel) 6 6 months ago
Eager aggregation, take 3 4881 Moved to next CF 19 Needs rebase! Richard Guo (richardguo) 6 2 days 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 2 months 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 2 months ago
CREATE INDEX CONCURRENTLY for partitioned tables 5004 Moved to next CF 2/7 +520−78 Justin Pryzby (justinpryzby), Ilya Gladyshev (qoops) 6 7 months ago
VACUUM FULL / CLUSTER CONCURRENTLY 5117 Moved to next CF 18 6/7 +5096−494 Antonin Houska (a.houska) 5 6 days 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 2 months ago
Make MultiXactOffset 64-bit type 5205 Moved to next CF 18 0/1 +615−291 Maxim Orlov (m.orlov) Heikki Linnakangas (heikki) 5 2 weeks 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 3 months 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 2 months ago
Changing shared_buffers without restart 5319 Moved to next CF 1/7 +1749−285 Dmitry Dolgov (erthalion) Vladlen Popolitov (vladlenpopolitov) 4 5 days ago
Support enabling checksums online 5323 Moved to next CF Needs rebase! Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) Tomas Vondra (fuzzycz) 4 2 months ago
using index to speedup add not null constraints to a table 5444 Moved to next CF 18 6/7 +630−5 Jian He (stayreal) Tanzeel Khan (tanzeelk) 3 1 month ago
refactor AlterDomainAddConstraint (alter domain add constraint) 5455 Moved to next CF 18 6/7 +79−8 Jian He (stayreal) Peter Eisentraut (petere) 3 3 months ago
WAL-logging facility for pgstats kinds 5466 Moved to next CF 18 Not processed Michael Paquier (michael-kun) 2 3 months ago
speedup COPY TO for partitioned table 5467 Moved to next CF 19 5/7 +153−32 Jian He (stayreal) vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), newtglobal postgresql_contributors (newtpostgrescontributors) 3 1 week ago
Proposal: Progressive explain 5473 Moved to next CF Needs rebase! Rafael Castro (rafaelthca) Robert Haas (rhaas) 2 2 months ago
SQL/JSON json_table PLAN clause 5478 Moved to next CF 18 7/7 +2308−168 Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrew Dunstan (adunstan), Amit Langote (amitlan), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Anton Melnikov (antonmel), Nikita Malakhov (nmalakh) Amit Langote (amitlan), Vladlen Popolitov (vladlenpopolitov) 3 2 months ago
SQL Commands
Add SPLIT PARTITION/MERGE PARTITIONS commands 3659 Moved to next CF 18 6/7 +8385−41 Dmitry Koval (d.koval) stephane tachoires (sttachoires) Alexander Korotkov (smagen) 14 yesterday
Add XMLCanonicalize function 4237 Moved to next CF 19 6/7 +415−0 Jim Jones (jimus) Pavel Stehule (okbobcz), Oliver Ford (ojford), newtglobal postgresql_contributors (newtpostgrescontributors) 11 5 days ago
SQL:2011 application time 4308 Moved to next CF Needs rebase! Paul Jungwirth (pjungwir) Peter Eisentraut (petere) Peter Eisentraut (petere) 10 1 week ago
Incremental View Maintenance (IVM), take 2 4337 Moved to next CF Needs rebase! Yugo Nagata (yugo.nagata) 11 9 months ago
Implement row pattern recognition feature 4460 Moved to next CF 19 5/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), Zhao Junwang (zhjwpku), Yong Li (yoli) 7 2 months ago
COPY TO json 4716 Moved to next CF Needs rebase! Joe Conway (jconway) Masahiko Sawada (masahikosawada) Joe Conway (jconway) 7 3 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 2 months ago
Virtual generated columns 4972 Moved to next CF Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 5 3 months ago
CREATE OR REPLACE MATERIALIZED VIEW 5099 Moved to next CF 18 7/7 +749−96 Erik Wienhold (ewie) newtglobal postgresql_contributors (newtpostgrescontributors) 4 2 months ago
Add XMLCast (SQL/XML X025) 5110 Moved to next CF 19 6/7 +2276−10 Jim Jones (jimus) Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) 5 3 weeks ago
Support POSITION with nondeterministic collations 5209 Moved to next CF 7/7 +247−48 Peter Eisentraut (petere) Peter Eisentraut (petere) 4 3 months 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 1 month ago
Add IGNORE NULLS to Window functions 5230 Moved to next CF 18 7/7 +907−28 Oliver Ford (ojford) Krasiyan Andreev (krasiyan) 4 3 days 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 3 months ago
Introduce the ability to enable/disable indexes using ALTER INDEX 5274 Moved to next CF 18 6/7 +1703−26 Shayon Mukherjee (shayonj) Sami Imseih (simseih), newtglobal postgresql_contributors (newtpostgrescontributors) 4 4 days 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 months ago
Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) 5279 Moved to next CF 19 6/7 +1487−59 Jim Jones (jimus) newtglobal postgresql_contributors (newtpostgrescontributors) 4 5 days ago
INSERT ... ON CONFLICT DO SELECT [FOR ...] 5413 Moved to next CF 7/7 +831−190 Andreas Karlsson (kandreas), Marko Tiikkaja (johto) Dean Rasheed (deanr) 2 2 months ago
Add XMLDocument (SQL/XML X030) 5431 Moved to next CF 19 6/7 +258−1 Jim Jones (jimus) Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) 3 4 months ago
Allow subfield references without parentheses 5449 Moved to next CF Not processed Peter Eisentraut (petere) 2 6 months ago
Add XMLNamespaces option to XMLElement 5456 Moved to next CF 19 6/7 +1202−34 Pavel Stehule (okbobcz), Jim Jones (jimus) Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) 3 5 days ago
System Administration
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 2 months 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 4 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 2 months ago
New predefined role pg_manage_extensions 5357 Moved to next CF 2/7 +22−5 Michael Banck (mbanck) Laurenz Albe (laurenz) 3 2 months ago
log_min_messages per backend type 5447 Moved to next CF 18 2/7 +352−25 Euler Taveira (eulerto) 3 3 months ago
Testing
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 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 months ago
Allow CI to only run the compiler warnings task 5249 Moved to next CF 18 6/7 +14−13 Bertrand Drouvot (bertranddrouvot.pg) Rustam ALLAKOV (rustam.allakov) 4 1 week 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 4 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 2 months ago
Add 'make check-tests' behavior to the meson based builds 5405 Moved to next CF 6/7 +16−6 Nazir Bilal Yavuz (nbyavuz) Ashutosh Bapat (ashutoshbapat), Jian He (stayreal) 3 2 months ago
Disable installcheck for tap and regress tests for injection_points module 5410 Moved to next CF 18 2/7 +77−0 Michail Nikolaev (nkey) 2 3 months ago
Parallel tests publication and subscription might fail due to concurrent tuple update 5459 Moved to next CF 16 6/7 +4−2 Jelte Fennema-Nio (jeltef) 2 2 months ago