Commitfest 2024-09

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


Status summary: Committed: 90. Moved to next CF: 206. Withdrawn: 15. Rejected: 5. Returned with Feedback: 50. Total: 366.

Closed patches

Patch ID Status Ver CI status Stats Author Reviewers Committer Num cfs Latest mail
Bug Fixes
pg_rewind WAL deletion pitfall 3874 Moved to next CF Not processed Alexander Kukushkin (cyberdem0n), Polina Bungina (hughcapet) Kyotaro Horiguchi (horiguti), Atsushi Torikoshi (atsushitorikoshi), moro dream (morod) Álvaro Herrera (alvherre) 12 4 months ago
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
Recheck foreign key if a referenced collation was nondeterministic 4908 Moved to next CF 18 Not processed Paul Jungwirth (pjungwir) Peter Eisentraut (petere), Jian He (stayreal) Peter Eisentraut (petere) 3 4 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
pg_parse_json: don't leak token copies on failure 4975 Moved to next CF Not processed Jacob Champion (jchampion) Andrew Dunstan (adunstan) Andrew Dunstan (adunstan) 3 4 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 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
Fix race conditions with concurrent drops of shared pgstats entries 5045 Moved to next CF stable Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 5 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
Set query_id for queries contained in utility statement 5150 Moved to next CF Not processed Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 4 months 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
Backport of LLVM memory manager to fix ARM relocation bug 5220 Moved to next CF stable Not processed Thomas Munro (macdice), Anthonin Bonnefoy (bonnefoa) Anthonin Bonnefoy (bonnefoa) Thomas Munro (macdice) 2 5 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
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
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
Add LSN <-> time conversion facility 4754 Moved to next CF Not processed Melanie Plageman (melanieplageman) Daniel Gustafsson (d_gustafsson), Andrey Borodin (x4m) 5 8 months 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
GUC names in messages 5011 Moved to next CF 18 Not processed Peter Smith (smithpb2250) Michael Paquier (michael-kun) 3 6 months 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
Improvements for pg_wal_replay_wait() 5167 Moved to next CF 18 Not processed Alexander Korotkov (smagen) Alexander Korotkov (smagen) 2 6 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
Add contrib/pg_logicalsnapinspect 5197 Moved to next CF 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 2 6 months ago
remove adaptive spins_per_delay code 5210 Moved to next CF 18 Not processed Nathan Bossart (bossartn) 2 7 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 3 weeks 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 1 month 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
Separate memory contexts for relcache and catcache 4554 Moved to next CF Not processed Melih Mutlu (melihmutlu) Atsushi Torikoshi (atsushitorikoshi) 6 4 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
Parallel workers stats in pg_stat_database 5212 Moved to next CF 18 Not processed Benoit Lobréau (benoitl) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 5 months 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
Replace a large number of OR clauses with ANY expression 4450 Moved to next CF 17 Not processed Andrei Lepikhov (lepikhov), Alena Rybakina (alenka) Nikolay Shaplov (nataraj), Ranier Vilela (raniervilela) Alexander Korotkov (smagen) 7 4 months 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
Reordering DISTINCT keys to match input path's pathkeys 4787 Moved to next CF Not processed Richard Guo (richardguo) Richard Guo (richardguo) 4 4 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
prefetching for nestloop / indexscan 5208 Moved to next CF Not processed Tomas Vondra (fuzzycz) 2 4 months ago
Avoiding superfluous buffer locking during nbtree backwards scans 5222 Moved to next CF Not processed Matthias van de Meent (mmeent) Peter Geoghegan (pgeoghegan) 2 5 months 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
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
ECPG cleanup and fix for clang compile-time problem 4939 Moved to next CF Not processed Tom Lane (tgl) John Naylor (john.naylor) Tom Lane (tgl) 3 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
AIX support, revert the changes from 0b16bb8776bb8 5003 Moved to next CF Not processed Sriram RK (sriramrk) 3 4 months ago
Relcache refactoring 5022 Moved to next CF Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 3 5 months ago
SendProcSignal(), SetLatch() → SendInterrupt() 5118 Moved to next CF Not processed Heikki Linnakangas (heikki), Thomas Munro (macdice) 3 2 months ago
Converting tab-complete.c's else-if chain to a switch 5123 Moved to next CF Not processed Tom Lane (tgl) Tom Lane (tgl) 2 6 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
Refactor postmaster child handling 5185 Moved to next CF Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 2 5 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
Replication & Recovery
Switching XLog source from archive to streaming when primary available 3663 Moved to next CF Not processed Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) Nathan Bossart (bossartn) 13 7 months ago
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
Detection and resolution of logical replication conflict 5021 Moved to next CF 18 Not processed Zhijie Hou (houzj), shveta malik (shvetam), Nisha Moond (nishamoond) Masahiko Sawada (masahikosawada), Michail Nikolaev (nkey), Hayato Kuroda (ha-kun) Amit Kapila (amitkapila) 3 5 months ago
Allow logical decoding to output generated columns 5068 Moved to next CF 18 Not processed Peter Smith (smithpb2250), Shubham Khanna (skhanna), Shlok Kyal (shlokkyal) Masahiko Sawada (masahikosawada), Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb) 3 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
Collect statistics about conflicts in logical replication 5211 Moved to next CF 18 Not processed Zhijie Hou (houzj) Hayato Kuroda (ha-kun), Peter Smith (smithpb), shveta malik (shvetam) Amit Kapila (amitkapila) 2 7 months 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
Avoid mixing custom and OpenSSL BIO functions 4835 Moved to next CF Not processed David Benjamin (dbenjamin) Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 4 4 months ago
Make query cancellation keys longer 4870 Moved to next CF 7/7 +786−161 Heikki Linnakangas (heikki), Jelte Fennema-Nio (jeltef) Heikki Linnakangas (heikki) 4 1 week 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
Add support to TLS 1.3 cipher suites and curves lists in Postgres 5025 Moved to next CF Not processed Erica Zhang (zerica) Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) Daniel Gustafsson (d_gustafsson) 3 5 months ago
Blast-RADIUS mitigation 5158 Moved to next CF Not processed Thomas Munro (macdice) Heikki Linnakangas (heikki) 3 8 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
Identify huge pages accessibility using madvise 4937 Moved to next CF stable Not processed Dmitry Dolgov (erthalion) Gabriele Bartolini (gbartolini), Niccolo Fei (nfei) 3 5 months 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
Add min/max aggregate functions to BYTEA 5138 Moved to next CF 18 Not processed Aleksander Alekseev (a.alekseev), Marat Bukharov (maratik) Andrey Borodin (x4m) Tom Lane (tgl) 2 6 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
not-null constraints 5224 Moved to next CF Not processed Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 2 5 months ago
SQL Commands
Add XMLCanonicalize function 4237 Moved to next CF 18 7/7 +398−0 Jim Jones (jimus) Pavel Stehule (okbobcz), Oliver Ford (ojford), newtglobal postgresql_contributors (newtpostgrescontributors) 11 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
add COPY option REJECT_LIMIT 4797 Moved to next CF Not processed Atsushi Torikoshi (atsushitorikoshi) Fujii Masao (masaofujii), Kirill Reshke (reshke) Fujii Masao (masaofujii) 4 6 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
Support LIKE with nondeterministic collations 4965 Moved to next CF Not processed Peter Eisentraut (petere) Paul Jungwirth (pjungwir) Peter Eisentraut (petere) 3 4 months 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
System Administration
warn if GUC set to an invalid shared library 3482 Moved to next CF Not processed Justin Pryzby (justinpryzby) Christoph Berg (myon), cary huang (caryh), Maciek Sakrejda (msakrejda), Cary Huang (cary) 14 5 months ago
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
Enable data checksums by default with initdb 5178 Moved to next CF Not processed Greg Sabino Mullane (greg) Peter Eisentraut (petere), Nathan Bossart (bossartn) Peter Eisentraut (petere) 2 5 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
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
Make PG_TEST_EXTRA env variable override its Meson configure option 5134 Moved to next CF Not processed Jacob Champion (jchampion), Nazir Bilal Yavuz (nbyavuz) Ashutosh Bapat (ashutoshbapat) Heikki Linnakangas (heikki) 2 5 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