declarative session variables, LET command 1608 Moved to different CF DDL 10/10 +3003−37 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), Jim Jones (jimus), newtglobal postgresql_contributors (newtpostgrescontributors) 40 yesterday pg_stat_statements and "IN" conditions 2837 Moved to different CF Monitoring 6/7 +945−23 Dmitry Dolgov (erthalion) Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih) Álvaro Herrera (alvherre) 22 1 year ago Add pg_stat_session 3405 Moved to different CF Monitoring Needs rebase! Rafia Sabih (rafia.sabih), Sergey Dudoladov (sdudoladov) Bertrand Drouvot (bdrouvot), Atsushi Torikoshi (atsushitorikoshi), Andrei Zubkov (zubkov), Sadeq Dousti (msdousti) 19 11 months ago AcquireExecutorLocks() and run-time pruning 3478 Moved to different CF Performance Needs rebase! Amit Langote (amitlan) Tom Lane (tgl) Amit Langote (amitlan) 17 4 months ago Add SPLIT PARTITION/MERGE PARTITIONS commands 3659 Moved to different CF SQL Commands 19 10/10 +8227−46 Dmitry Koval (d.koval) stephane tachoires (sttachoires) Alexander Korotkov (smagen) 17 2 months ago Reducing planning time when tables have many partitions 3701 Moved to different CF Performance 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 11 months ago Amcheck verification of GiST and GIN 3733 Moved to different CF Monitoring 6/7 +1508−215 Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) José Villanova (azlev), Mark Dilger (mark.dilger) Tomas Vondra (fuzzycz) 15 1 year ago Add XMLCanonicalize function 4237 Moved to different CF SQL Commands 19 10/10 +509−0 Jim Jones (jimus) Pavel Stehule (okbobcz), Oliver Ford (ojford), newtglobal postgresql_contributors (newtpostgrescontributors) 15 3 days ago Revise get_cheapest_parallel_safe_total_inner 4285 Moved to different CF Refactoring Only 10/10 +11−4 Richard Guo (richardguo) wenhui qiu (wenhuiqiu) 11 1 year ago Logging parallel worker draught 4291 Moved to different CF Monitoring 19 10/10 +95−0 Benoit Lobréau (benoitl) Sami Imseih (simseih) 13 2 months ago SQL:2011 application time 4308 Moved to different CF SQL Commands Needs rebase! Paul Jungwirth (pjungwir) Peter Eisentraut (petere) Peter Eisentraut (petere) 10 10 months ago Unlinking Parallel Hash Join inner batch files sooner 4314 Moved to different CF Needs rebase! Thomas Munro (macdice) Ben Mejia (benmejia) 11 2 months ago Avoid unnecessary PlaceHolderVars for simple Vars 4319 Committed Performance Not processed Richard Guo (richardguo) James Coleman (jcole1989) Richard Guo (richardguo) 9 1 year ago Incremental View Maintenance (IVM), take 2 4337 Moved to different CF SQL Commands Needs rebase! Yugo Nagata (yugo.nagata) Alexandre Felipe (afelipe) 16 1 month ago Index Prefetching 4351 Moved to different CF Performance 9/10 +5138−2325 Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) 14 5 hours ago UUID v7 4388 Committed 17 Not processed Andrey Borodin (x4m) Masahiko Sawada (masahikosawada), Aleksander Alekseev (a.alekseev), Chris Travers (einhverfr), Nik Samokhvalov (nikolay), Przemysław Sztoch (psztoch), Kirk Wolak (kirkw) Masahiko Sawada (masahikosawada) 9 1 year ago add not_before and not_after timestamps to sslinfo extension and pg_stat_ssl 4390 Moved to different CF Security Needs rebase! Cary Huang (cary) Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) 12 9 months ago Client authentication via OAuth 2.0 4412 Moved to different CF Security 7/7 +0−0 Jacob Champion (jchampion) Peter Eisentraut (petere), Daniel Gustafsson (d_gustafsson), Antonin Houska (a.houska) Daniel Gustafsson (d_gustafsson) 10 7 months ago Retiring is_pushed_down 4458 Moved to different CF Refactoring Only Needs rebase! Richard Guo (richardguo) Tom Lane (tgl) 10 1 year ago Implement row pattern recognition feature 4460 Moved to different CF SQL Commands 19 Needs rebase! Tatsuo Ishii (ishii), Henson Choi (assam258.gmail.com) Vik Fearing (xocolatl), Jacob Champion (jchampion), Ningwei Chen (chen-5033), Henson Choi (assam258.gmail.com) 14 yesterday CREATE SUBSCRIPTION ... SERVER 4529 Moved to different CF DDL Needs rebase! Jeff Davis (jdavis) Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) Jeff Davis (jdavis) 12 1 week ago Statistics Import and Export 4538 Moved to different CF Performance 7/7 +267−64 Corey Huinker (coreyh) Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) Jeff Davis (jdavis) 9 10 months ago Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 4564 Moved to different CF Performance 7/7 +389−77 Ashutosh Bapat (ashutoshbapat) Amit Langote (amitlan) 8 1 year ago pg_ctl start may return 0 even if the postmaster has been already started on Windows 4573 Moved to different CF Bugfix Windows 10/10 +369−153 Kyotaro Horiguchi (horiguti) Hayato Kuroda (ha-kun), Yasir Shah (yasir.hussain.shah.gmail.com) 12 2 months ago CRC32C Parallel Computation Optimization on ARM 4620 Moved to different CF Performance Needs rebase! xiang gao (xiang.gao) Nathan Bossart (bossartn), John Naylor (john.naylor) 8 1 year ago Special-case executor expression steps for common combinations 4627 Moved to different CF Performance 7/7 +194−39 Andres Freund (andresfreund), Daniel Gustafsson (d_gustafsson) Andreas Karlsson (kandreas) Daniel Gustafsson (d_gustafsson) 8 1 year ago Sequence Access Methods, round two 4677 Moved to different CF Needs rebase! Michael Paquier (michael-kun) 12 2 months ago Make COPY format extendable: Extract COPY TO format implementations 4681 Moved to different CF SQL Commands Needs rebase! Kouhei Sutou (kou) Masahiko Sawada (masahikosawada), Zhao Junwang (zhjwpku), Yong Li (yoli) 11 1 week ago New [relation] options engine 4688 Moved to different CF Refactoring Only Needs rebase! Nikolay Shaplov (nataraj) 10 2 months ago Teach predtest about IS [NOT] <boolean> proofs 4690 Moved to different CF Performance 10/10 +1882−129 James Coleman (jcole1989) Tom Lane (tgl) 8 1 year ago COPY TO json 4716 Moved to different CF SQL Commands 10/10 +620−65 Joe Conway (jconway) Masahiko Sawada (masahikosawada), Richard Yen (richyen) Andrew Dunstan (adunstan) 10 2 weeks ago Set log_lock_waits=on by default 4718 Moved to different CF GUC Monitoring 19 10/10 +4−4 Laurenz Albe (laurenz) Michael Banck (mbanck) Peter Eisentraut (petere) 9 6 months ago "unexpected duplicate for tablespace" problem in logical replication 4720 Moved to different CF Bugfix stable 10/10 +58−20 Shenhao Wang (wangshenhao) Masahiko Sawada (masahikosawada) Michael Paquier (michael-kun) 8 6 months ago RETURNING OLD/NEW values 4723 Committed SQL Commands 18 Not processed Dean Rasheed (deanr) Dean Rasheed (deanr) 6 1 year ago Support a wildcard in backtrace_functions 4735 Moved to different CF GUC Help - Bikeshedding Needs rebase! Jelte Fennema-Nio (jeltef) Daniel Gustafsson (d_gustafsson), Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson) 13 1 year ago Add new protocol message to change GUCs to be able to change protocol extension parameters 4736 Moved to different CF 18 Needs rebase! Jelte Fennema-Nio (jeltef) Robert Haas (rhaas) 7 1 year ago psql: Rethinking of \du command 4738 Moved to different CF libpq 10/10 +72−126 Pavel Luzanov (p.luzanov@postgrespro.ru) David Johnston (polobo), Wen Yi (wenyi) 8 9 months ago Network failure may prevent promotion 4748 Moved to different CF Bugfix 7/7 +52−202 Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki) 7 1 year ago Adding comments to help understand psql hidden queries 4764 Moved to different CF libpq 9/10 +217−100 David Christensen (davidchristensen), Greg Sabino Mullane (greg) Tom Lane (tgl) Tom Lane (tgl) 8 1 week ago data loss bug in initial sync of logical replication 4766 Moved to different CF Bugfix Needs rebase! Tomas Vondra (fuzzycz) Nitin Motiani (nitinmotiani), work nsandeepkumar (nsandeepk) Amit Kapila (amitkapila) 7 11 months ago Introduce XID age and inactive timeout based replication slot invalidation 4770 Moved to different 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 year ago COPY ON_ERROR 'NULL' 4810 Moved to different CF 10/10 +251−43 jian he (universality) Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), Jim Jones (jimus) Peter Eisentraut (petere) 9 2 weeks ago psql meta-command conninfo+ 4814 Moved to different CF libpq 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 year ago on_error table, saving error info to a table 4817 Moved to different CF Needs rebase! jian he (hellothere) Nishant Sharma (nishant-at-edb) 9 4 months ago Add trim_trailing_whitespace to editorconfig file 4829 Committed Not processed Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) Peter Eisentraut (petere) 5 1 year ago KNN-btree 4871 Moved to different CF Needs rebase! Nikita Glukhov (n.glukhov), Anton Melnikov (antonmel) 8 1 year ago BitmapHeapScan table AM violation removal (and use streaming read API) 4874 Moved to different CF Refactoring Only 7/7 +826−911 Melanie Plageman (melanieplageman) Heikki Linnakangas (heikki), Andres Freund (andresfreund), Tomas Vondra (fuzzycz) Melanie Plageman (melanieplageman) 6 11 months ago CREATE DATABASE ... STRICT_UNICODE 4876 Withdrawn Not processed Jeff Davis (jdavis) 5 1 year ago Eager aggregation, take 3 4881 Moved to different CF 19 10/10 +0−0 Richard Guo (richardguo) Richard Guo (richardguo) 8 5 months ago Fix rare recovery shutdown hang 4884 Moved to different CF Bugfix Needs rebase! Thomas Munro (macdice) Noah Misch (nmisch), Martijn Wallet (mwallet) 8 1 year ago CREATE DATABASE ... STRATEGY=FILE_CLONE 4886 Moved to different CF 2/7 +170−3 Thomas Munro (macdice), Nazir Bilal Yavuz (nbyavuz) Thomas Munro (macdice) 5 11 months ago Run deferred triggers in the correct security context 4888 Committed Bugfix 18 Not processed Laurenz Albe (laurenz) Pavel Stehule (okbobcz) Tom Lane (tgl) 4 1 year ago SQL Property Graph Queries (SQL/PGQ) 4904 Moved to different CF SQL Commands Needs rebase! Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat) Vik Fearing (xocolatl), Zhao Junwang (zhjwpku), Hannu Krosing (hannukrosing), Henson Choi (assam258.gmail.com) Peter Eisentraut (petere) 10 5 days ago Add local address to log_line_prefix 4907 Moved to different CF Monitoring 7/7 +24−0 Greg Sabino Mullane (greg) David Steele (dsteele), Cary Huang (cary), Jim Jones (jimus) Tom Lane (tgl) 5 11 months ago Add extension_destdir GUC 4913 Moved to different 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 1 year ago Convert internals documentation to Markdown 4918 Returned with feedback Docs Only 18 Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) 4 1 year ago allow changing autovacuum_max_workers without restarting 4921 Committed System Administration 18 Not processed Nathan Bossart (bossartn) Yogesh Sharma (sharmay) Nathan Bossart (bossartn) 4 1 year ago apply_scanjoin_target_to_paths and partitionwise join 4929 Returned with feedback Bugfix stable Not processed Ashutosh Bapat (ashutoshbapat) 4 1 year ago Use <stdint.h> for int64_t and other exact-width integer types 4938 Committed Refactoring Only Not processed Thomas Munro (macdice) Peter Eisentraut (petere) Thomas Munro (macdice) 4 1 year ago Use XLOG_CONTROL_FILE macro everywhere 4941 Moved to different CF Refactoring Only 18 7/7 +30−9 Anton Melnikov (antonmel) Daniel Gustafsson (d_gustafsson) Fujii Masao (masaofujii) 5 11 months ago Avoid orphaned objects dependencies, take 3 4942 Moved to different CF DDL 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) Yogesh Sharma (sharmay) 10 4 months ago Extend ALTER DEFAULT PRIVILEGES for large objects 4945 Moved to different CF Security 7/7 +20−0 Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii), Laurenz Albe (laurenz) Fujii Masao (masaofujii) 5 8 months ago Show WAL stats on pg_stat_io 4950 Committed Monitoring Not processed Nazir Bilal Yavuz (nbyavuz) Akshat Jaimini (akshatj) Michael Paquier (michael-kun) 4 1 year ago Use WALReadFromBuffers in more places 4952 Moved to different CF 10/10 +70−30 Bharath Rupireddy (bharathrupireddy) 5 6 months ago Test to dump and restore objects left behind by regression 4956 Moved to different CF Testing 7/7 +51−26 Ashutosh Bapat (ashutoshbapat) Michael Paquier (michael-kun), vigneshwaran C (vignesh.postgres) Álvaro Herrera (alvherre) 5 1 year ago Fix BackgroundPsql to report error on query timeout rather than calling die 4959 Moved to different CF Bugfix 18 10/10 +6−8 Daniel Gustafsson (d_gustafsson) Heikki Linnakangas (heikki), Tom Lane (tgl) Daniel Gustafsson (d_gustafsson) 7 1 month ago Reduce the log spam by excluding certain SQLSTATEs 4964 Moved to different CF System Administration 18 7/7 +218−0 Laurenz Albe (laurenz) Jim Jones (jimus) 5 1 year ago Parallel CREATE INDEX for GIN indexes 4966 Moved to different CF Performance 9/10 +7−0 Tomas Vondra (fuzzycz) Kirill Reshke (reshke), Matthias van de Meent (mmeent), Andy Fan (andy2) Tomas Vondra (fuzzycz) 6 11 months ago [CREATE|RE] INDEX CONCURRENTLY with single heap scan 4971 Moved to different CF Performance DDL 19 Needs rebase! Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Matthias van de Meent (mmeent) 9 4 days ago Virtual generated columns 4972 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 5 1 year ago pg_stat_activity: make slow/hanging authentication more visible 4974 Moved to different CF Monitoring 18 7/7 +127−6 Jacob Champion (jchampion) Michael Paquier (michael-kun) 5 1 year ago Expand applicability of aggregate's sortop optimization 4980 Moved to different CF 7/7 +352−47 Matthias van de Meent (mmeent) Andrei Lepikhov (lepikhov) 5 1 year ago Serverside SNI for SSL connections 4984 Moved to different CF Security 10/10 +9−3 Daniel Gustafsson (d_gustafsson) Jacob Champion (jchampion) Daniel Gustafsson (d_gustafsson) 8 2 weeks ago WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts 4986 Moved to different CF Bugfix DDL 9/10 +6−2 Matthias van de Meent (mmeent) Akshat Jaimini (akshatj) 8 2 months ago Convert sepgsql tests to TAP 4992 Committed Testing Not processed Peter Eisentraut (petere) Andreas Karlsson (kandreas) Peter Eisentraut (petere) 4 1 year ago Return pg_control from pg_backup_stop(). 4997 Moved to different CF 19 10/10 +199−27 David Steele (dsteele) 10 2 weeks ago CREATE INDEX CONCURRENTLY for partitioned tables 5004 Moved to different CF 2/7 +520−78 Justin Pryzby (justinpryzby), Ilya Gladyshev (qoops) 6 9 months ago relfilenode statistics 5007 Moved to different CF Monitoring 18 10/10 +691−83 Bertrand Drouvot (bertranddrouvot.pg) 10 5 days ago Vacuum statistics 5012 Moved to different CF Monitoring 19 10/10 +391−5 Andrei Lepikhov (lepikhov), Andrei Zubkov (zubkov), Alena Rybakina (alenka) Ilia Evdokimov (ilidock95) 10 6 days ago Extension security improvement: Add support for extensions with an owned schema 5018 Moved to different CF Security Extensions 10/10 +765−143 Jelte Fennema-Nio (jeltef) Sadeq Dousti (msdousti), Artem Gavrilov (artem.gavrilov) 10 2 weeks ago Parallel CREATE INDEX for GiST indexes 5026 Returned with feedback Performance Not processed Tomas Vondra (fuzzycz) Andreas Karlsson (kandreas) 4 1 year ago Track the amount of time waiting due to cost_delay 5027 Moved to different CF Monitoring 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Nathan Bossart (bossartn), Masahiro Ikeda (masahiro.ikeda) Nathan Bossart (bossartn) 5 1 year ago Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state 5029 Moved to different CF Bugfix Logical Replication 10/10 +110−6 ChangAo Chen (chenchangao) harinath kanchu (harinath001), Lilian Ontowhee (ontowhee), haiyang li (ocean-li) 10 4 months ago Remove dependence on integer wrapping 5031 Committed Bugfix 18 Not processed Nathan Bossart (bossartn), Joseph Koshakow (jkoshakow), Matthew Kim (friendlymatthew) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 1 year ago Add pg_ownerships and pg_privileges system views 5033 Withdrawn Monitoring Not processed Joel Jacobson (joeljacobson) 4 1 year ago Sort functions with specialized comparators 5036 Moved to different CF Performance 6/7 +34−48 Andrey Borodin (x4mmm), Stepan Neretin (fenixrnd.mail.ru) John Naylor (john.naylor) 5 1 year ago Remove self join on a unique column 5043 Moved to different CF Performance 7/7 +53−28 Andrei Lepikhov (lepikhov) Dean Rasheed (deanr) Alexander Korotkov (smagen) 5 11 months ago new plpgsql.extra_errors check - strict_expr_check 5044 Moved to different CF 9/10 +172−18 Pavel Stehule (okbobcz) Gilles Darold (darold), Kirk Wolak (kirkw), newtglobal postgresql_contributors (newtpostgrescontributors) 9 4 months ago New GUC autovacuum_max_threshold 5046 Moved to different CF System Administration 18 Not processed Nathan Bossart (bossartn), Frédéric Yhuel (yhuelf) Nathan Bossart (bossartn), wenhui qiu (qiuwenhuifx.163.com) Nathan Bossart (bossartn) 5 1 year ago better error message when --single is not the first arg to postgres executable 5052 Committed 18 Not processed Nathan Bossart (bossartn), Greg Sabino Mullane (greg) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 1 year ago windows compilation fails when gssapi & openssl are enabled 5060 Moved to different CF Bugfix 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 1 year ago Incorrect error message for cancellation triggered by statement_timeout & flaky test 5070 Moved to different CF Bugfix Flakyfix stable 10/10 +33−15 Jelte Fennema-Nio (jeltef) Akshat Jaimini (akshatj) 10 2 months ago nbtree skip scan 5081 Moved to different CF Performance 7/7 +3840−565 Peter Geoghegan (pgeoghegan) Aleksander Alekseev (a.alekseev), Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (a.rybakina) Peter Geoghegan (pgeoghegan) 5 1 year ago Document NULL Concepts and Behaviors 5086 Moved to different CF Docs Only 18 10/10 +1360−161 David Johnston (polobo) 9 2 months ago Doc: Move and modify standalone hot backups section 5087 Moved to different CF Docs Only 9/10 +139−139 David Johnston (polobo) Marlene Reiterer (marlene.rte) 7 11 months ago Doc: Improve hostssl related descriptions and option presentation 5088 Moved to different CF Docs Only Needs rebase! David Johnston (polobo) 5 1 year ago Streaming Vacuum 5089 Moved to different CF Performance Not processed Thomas Munro (macdice), Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 5 5 months ago inplace update: send nontransactional invalidations 5091 Moved to different CF Bugfix Backport stable 10/10 +3−0 Noah Misch (nmisch) Paul Jungwirth (pjungwir), Ian Ilyasov (ianilyasov), Surya Poondla (spoondla) Noah Misch (nmisch) 6 8 months ago Incremental Sort Cost Estimation Instability 5093 Moved to different CF Bugfix 18 Needs rebase! Andrei Lepikhov (lepikhov) 8 10 months ago Make tuple deformation faster 5097 Committed Performance Not processed David Rowley (davidrowley) David Rowley (davidrowley) 4 1 year ago gamma() and lgamma() functions 5098 Moved to different CF 18 7/7 +212−0 Dean Rasheed (deanr) Alexandra Wang (alexandrawang) Dean Rasheed (deanr) 5 1 year ago Add OR REPLACE option to CREATE MATERIALIZED VIEW 5099 Moved to different CF SQL Commands 9/10 +694−98 Erik Wienhold (ewie) Paul Jungwirth (pjungwir), newtglobal postgresql_contributors (newtpostgrescontributors) 9 2 months ago Improved crc32c performance with AVX-512 algorithm. 5100 Moved to different CF Performance 18 Needs rebase! Paul Amonson (pamonson), Raghuveer Devulapalli (rdevulap) Nathan Bossart (bossartn) 4 1 year ago psql: Add leakproof field to \dAo+ meta-command results 5102 Committed libpq Not processed Yugo Nagata (yugo.nagata) Dean Rasheed (deanr), Erik Wienhold (ewie) Dean Rasheed (deanr) 3 1 year ago Prevent incorrect entries in pg_stat_activity. 5105 Moved to different CF Bugfix 10/10 +19−2 Fujii Masao (masaofujii) 5 1 year ago Add XMLCast (SQL/XML X025) 5110 Moved to different CF SQL Commands 19 10/10 +2746−26 Jim Jones (jimus) Vik Fearing (xocolatl), newtglobal postgresql_contributors (newtpostgrescontributors) 10 5 days ago Synchronization of sequences to subscriber 5111 Moved to different CF Logical Replication 10/10 +357−49 vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), Hayato Kuroda (ha-kun), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) Amit Kapila (amitkapila) 7 4 months ago MergeJoin beats HashJoin in the case of multiple hash clauses 5114 Moved to different CF Performance Needs rebase! Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 4 8 months ago VACUUM FULL / CLUSTER CONCURRENTLY 5117 Moved to different CF DDL Needs rebase! Antonin Houska (a.houska) Álvaro Herrera (alvherre), Mihail Nikalayeu (mihailnikalayeu) 9 3 hours ago SendProcSignal(), SetLatch() → SendInterrupt() 5118 Moved to different CF Refactoring Only Needs rebase! Heikki Linnakangas (heikki), Thomas Munro (macdice) 5 3 weeks ago Fix rare checksum failure in EXEC_BACKEND LocalProcessControlFile() 5124 Moved to different CF Bugfix 10/10 +64−8 Thomas Munro (macdice) Noah Misch (nmisch) 8 2 months ago Allow partition-wise join when whole row var is needed 5128 Moved to different CF Performance 18 Needs rebase! Ashutosh Bapat (ashutoshbapat), Alexander Pyhalov (a.pyhalov) 5 7 months ago Asynchronous MergeAppend Execution 5129 Moved to different CF Performance 9/10 +1427−744 Alexander Pyhalov (a.pyhalov) Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) 8 8 hours ago Track collation and ctype versions separately 5141 Withdrawn System Administration 18 Not processed Jeff Davis (jdavis) 3 1 year ago Clarify the behavior of AT TIME ZONE 5146 Moved to different CF Docs Only 7/8 +0−0 Aleksander Alekseev (a.alekseev) Laurenz Albe (laurenz) Bruce Momjian (bmomjian) 4 1 year ago Remove duplicated smgrclose call 5149 Moved to different CF Refactoring Only 18 7/7 +0−6 Steven Niu (niushiji) Cary Huang (cary), Kirill Reshke (reshke), Zhao Junwang (zhjwpku) 4 1 year ago DirtySnapshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication 5151 Moved to different CF Bugfix Logical Replication Help - Stuck Rebasing stable Needs rebase! Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Luan Silva (luansilva) 8 3 weeks ago Casts from jsonb to other types should cope with json null 5152 Committed Not processed Tom Lane (tgl) Tom Lane (tgl) 3 1 year ago Prohibit to use EphemeralNamedRelation in materialized views 5153 Committed Not processed Yugo Nagata (yugo.nagata) Tom Lane (tgl) Tom Lane (tgl) 3 1 year ago psql client does not handle WSAEWOULDBLOCK on Windows 5154 Moved to different CF Bugfix 10/10 +15−12 Tom Lane (tgl), Umar Hayat (pgwizard) Tom Lane (tgl) 6 5 months ago doc: Meson is not experimental on Windows 5156 Committed Docs Only Not processed Aleksander Alekseev (a.alekseev) Peter Eisentraut (petere) Peter Eisentraut (petere) 3 1 year ago Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY 5160 Moved to different CF Bugfix stable Needs rebase! Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Álvaro Herrera (alvherre) 7 2 months ago Use read streams in autoprewarm 5162 Moved to different CF Performance 6/7 +178−76 Nazir Bilal Yavuz (nbyavuz) Daniel Gustafsson (d_gustafsson) Melanie Plageman (melanieplageman) 4 1 year ago Fix a few issues in collation cache 5164 Withdrawn Refactoring Only 18 Not processed Jeff Davis (jdavis) 3 1 year ago Make ECPG locale usage thread-safe 5166 Moved to different CF Multithreading Refactoring Only Needs rebase! Thomas Munro (macdice) Peter Eisentraut (petere) 5 1 year ago Thread-safe nl_langinfo(), localeconv(), check_locale() 5170 Moved to different CF Refactoring Only 7/7 +71−52 Thomas Munro (macdice) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 1 year ago Allow casting between bytea and integer types 5176 Moved to different CF 7/7 +274−0 Aleksander Alekseev (a.alekseev) Joel Jacobson (joeljacobson) Dean Rasheed (deanr) 4 1 year ago Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) 5183 Moved to different CF Monitoring 7/7 +306−49 Peter Geoghegan (pgeoghegan) Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (alenka) Peter Geoghegan (pgeoghegan) 4 1 year ago [PROPOSAL] : Disallow use of empty column name in (column_name '') in ALTER or CREATE of foreign table. 5184 Moved to different CF 7/7 +61−0 Nishant Sharma (nishant-at-edb) 4 1 year ago Expose the acquired_by parameter to the pg_replication_origin_session_setup function 5189 Moved to different CF 18 Needs rebase! Doruk Yılmaz (dorukyilmaz) Euler Taveira (eulerto) 5 2 months ago CREATE SUBSCRIPTION - add missing test case 5190 Moved to different CF Testing 6/7 +14−0 Peter Smith (smithpb2250) vigneshwaran C (vignesh.postgres) Heikki Linnakangas (heikki) 4 1 year ago Index AM API cleanup 5195 Moved to different CF 6/7 +399−334 Mark Dilger (mark.dilger) Peter Eisentraut (petere), Andrew Dunstan (adunstan), Alexandra Wang (l-wang) Peter Eisentraut (petere) 4 1 year ago Use function smgrclose() to replace the loop 5196 Withdrawn Refactoring Only 18 Not processed Steven Niu (niushiji) 3 1 year ago Fix standby may crash when switching-over in certain special cases 5199 Moved to different CF Bugfix Needs rebase! pixian shi (pxshi) 7 1 year ago Make MultiXactOffset 64-bit type 5205 Moved to different CF 18 10/10 +1792−703 Maxim Orlov (m.orlov) Heikki Linnakangas (heikki) 6 4 months ago pg_upgrade: Support for upgrading to checksums enabled 5206 Moved to different CF System Administration Needs rebase! Peter Eisentraut (petere) Nathan Bossart (bossartn), Ilya Kosmodemiansky (hydrobiont) 4 1 year ago Support POSITION with nondeterministic collations 5209 Moved to different CF SQL Commands 7/7 +247−48 Peter Eisentraut (petere) Peter Eisentraut (petere) 4 1 year ago SQL:2023 JSON simplified accessor support 5214 Moved to different CF SQL Commands 19 Needs rebase! Alexandra Wang (alexandrawang) Peter Eisentraut (petere), Vik Fearing (xocolatl), Jelte Fennema-Nio (jeltef), Chao Li (chaol) 9 4 days ago Add roman support for to_number function 5221 Committed SQL Commands 18 Not processed Hunaid Sohail (hunaid) Maciek Sakrejda (msakrejda-pga) Tom Lane (tgl) 3 1 year ago AIO 5227 Moved to different CF Performance 7/7 +5611−79 Andres Freund (andresfreund) Noah Misch (nmisch) Andres Freund (andresfreund) 4 11 months ago Add ExprState hashing for GROUP BY and hashed SubPlans 5229 Committed Performance Not processed David Rowley (davidrowley) David Rowley (davidrowley) 3 1 year ago Add IGNORE NULLS to Window functions 5230 Moved to different CF SQL Commands 19 10/10 +3−1 Oliver Ford (ojford) Tatsuo Ishii (ishii), Krasiyan Andreev (krasiyan) Tatsuo Ishii (ishii) 5 6 months ago per backend I/O statistics 5232 Committed Monitoring 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 1 year ago JIT: The nullness of casetest.value can be determined at the JIT compile time. 5236 Committed Refactoring Only 18 Not processed Xing Guo (higuoxing) Tom Lane (tgl) Tom Lane (tgl) 2 1 year ago Fix RelationTruncate() corruption 5242 Moved to different CF Bugfix Not processed Robert Haas (rhaas), Thomas Munro (macdice) Thomas Munro (macdice) 3 11 months ago Allow SQL functions use CachedPlan machinery 5246 Moved to different CF Performance 18 7/7 +2109−972 Alexander Pyhalov (a.pyhalov) Tom Lane (tgl), Pavel Stehule (okbobcz) Tom Lane (tgl) 3 1 year ago Allow CI to only run the compiler warnings task 5249 Moved to different CF Testing 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) Rustam ALLAKOV (rustam.allakov) 5 10 months ago Refactor SLRU to always use long file names 5250 Moved to different CF Refactoring Only 10/10 +105−88 Aleksander Alekseev (a.alekseev) 9 2 months ago libpq: Fix processing of SSL records >8kB on async API 5251 Moved to different CF Bugfix Backport libpq stable 10/10 +208−11 Jacob Champion (jchampion), Lars Kanis (larsk) Jacob Champion (jchampion) 7 1 week ago C-Language Functions docs on how to call internal functions 5255 Committed Docs Only Not processed Florents Tselai (florentst) Pavel Stehule (okbobcz) Tom Lane (tgl) 2 1 year ago Make pg_stat_io view count IOs as bytes instead of blocks 5256 Committed Monitoring 18 Not processed Nazir Bilal Yavuz (nbyavuz) Michael Paquier (michael-kun), Andrew Dunstan (adunstan) Michael Paquier (michael-kun) 2 1 year ago Add parameter in jsonb_strip_nulls(jsonb, bool) to strip nulls from arrays 5260 Moved to different CF SQL Commands 7/7 +95−5 Florents Tselai (florentst) Andrew Dunstan (adunstan) Andrew Dunstan (adunstan) 3 1 year ago ensure we have a snapshot when dropping an index concurrently 5262 Moved to different CF Bugfix stable Needs rebase! Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 10 months ago removes attndims and typndims entirely 5263 Rejected 18 Not processed Jian He (stayreal) 2 1 year ago Add column name to error description 5266 Moved to different CF 18 0/1 +0−0 Marcos Pegoraro (pegorarof10), Jian He (stayreal) Vladlen Popolitov (vladlenpopolitov) Tom Lane (tgl) 3 1 year ago Fix incorrect Assert in gistFindCorrectParent() 5268 Moved to different CF Bugfix 6/7 +2−1 Tender Wang (tndrwang) Heikki Linnakangas (heikki) 3 1 year ago Improve statistics estimation considering GROUP-BY as a 'uniqueiser' 5269 Moved to different CF Performance 18 2/7 +37−0 Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 3 1 year ago Add GUC log_parameter_max_length to limit logged SQL statements 5272 Moved to different CF GUC Good First Review 19 10/10 +145−6 Kirill Gavrilov (diphantxm) Fujii Masao (masaofujii), Jim Jones (jimus) 5 yesterday Introduce the ability to enable/disable indexes using ALTER INDEX 5274 Moved to different CF SQL Commands 18 Needs rebase! Shayon Mukherjee (shayonj) Sami Imseih (simseih), newtglobal postgresql_contributors (newtpostgrescontributors) 4 8 months ago Fix race between WAL flush and InstallXLogFileSegment() 5276 Moved to different CF Bugfix 10/10 +45−0 Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc), Soumya S Murali (soumyamurali) 6 2 months ago general purpose array_sort 5277 Moved to different CF SQL Commands 18 7/7 +425−0 Zhao Junwang (zhjwpku) Tom Lane (tgl) Tom Lane (tgl) 3 1 year ago Add XMLSerialize: version (SQL/XML X076), explicit declaration (SQL/XML X078) 5279 Moved to different CF SQL Commands 19 10/10 +1559−59 Jim Jones (jimus) newtglobal postgresql_contributors (newtpostgrescontributors) 8 1 week ago Enhance file_fdw to report processed and skipped tuples in COPY progress 5282 Moved to different CF Monitoring Needs rebase! Fujii Masao (masaofujii) 3 1 year ago Replace IN VALUES with ANY in WHERE clauses during optimization 5283 Moved to different CF Performance 18 Needs rebase! Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) newtglobal postgresql_contributors (newtpostgrescontributors) Alexander Korotkov (smagen) 3 1 year ago NOT ENFORCED constraint feature 5285 Moved to different CF 18 7/7 +1048−286 Amul Sul (sulamul) Peter Eisentraut (petere), Alexandra Wang (alexandrawang) Peter Eisentraut (petere) 3 1 year ago Refactor bytea_sortsupport() 5288 Moved to different CF Refactoring Only Not processed Aleksander Alekseev (a.alekseev) 3 1 year ago Move clause_sides_match_join() into pathnode.h 5289 Committed Refactoring Only Not processed James Hunter (hunjmes) David Rowley (davidrowley) 2 1 year ago Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c 5291 Moved to different CF 6/7 +2−3 Tender Wang (tndrwang) Alexander Korotkov (smagen) 3 1 year ago Add “FOR UPDATE NOWAIT” lock details to the log. 5294 Moved to different CF Monitoring 7/7 +4−2 Yuki Seino (seinoyu) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 3 1 year ago deprecate md5 passwords 5295 Committed Security 18 Not processed Nathan Bossart (bossartn) Greg Sabino Mullane (greg) Nathan Bossart (bossartn) 2 1 year ago Streaming Replication vs Logical 5296 Moved to different CF Docs Only 10/10 +31−22 Paul Jungwirth (pjungwir) Robert Treat (xzilla) Bruce Momjian (bmomjian) 4 3 months ago Limiting overshoot in nbtree SAOP parallel index scans 5299 Moved to different CF Performance 10/10 +151−23 Matthias van de Meent (mmeent) 4 8 months ago New "single" COPY format 5300 Withdrawn Not processed Joel Jacobson (joeljacobson) Masahiko Sawada (masahikosawada), newtglobal postgresql_contributors (newtpostgrescontributors) 2 1 year ago Collation and ctype method tables and extension hooks 5301 Moved to different CF Refactoring Only Needs rebase! Jeff Davis (jdavis) Peter Eisentraut (petere) Jeff Davis (jdavis) 5 9 months ago Fix for consume_xids advancing XIDs incorrectly 5303 Moved to different CF Bugfix stable Needs rebase! Yushi Ogiwara (yushi) 6 2 months ago Recommend --no-psqlrc when restoring a pg_dump script 5306 Committed Docs Only stable Not processed Shinya Kato (shinyakato) Robert Treat (xzilla) Tom Lane (tgl) 2 1 year ago doc: virtual envs with Pl/Python 5308 Withdrawn Docs Only Not processed Florents Tselai (florentst) 2 1 year ago Syncrep and improving latency due to WAL throttling 5309 Withdrawn 18 Not processed Tomas Vondra (fuzzycz), Jakub Wartak (jakub.wartak.tomtom) Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) 2 1 year ago Clarify old WAL files cannot be removed until they are summarized 5310 Committed Docs Only Not processed Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 1 year ago simplify regular expression locale global variables 5313 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 2 1 year ago System views for versions reporting 5318 Moved to different CF Monitoring stable Needs rebase! Dmitry Dolgov (erthalion) Laurenz Albe (laurenz) 9 4 months ago Changing shared_buffers without restart 5319 Moved to different CF Needs rebase! Dmitry Dolgov (erthalion) Vladlen Popolitov (vladlenpopolitov) 8 1 month ago Trigger more frequent autovacuums for insert-heavy tables 5320 Moved to different CF Performance 7/7 +37−16 Melanie Plageman (melanieplageman) Nathan Bossart (bossartn) Melanie Plageman (melanieplageman) 3 4 months ago use a non-locking initial test in TAS_SPIN on AArch64 5321 Committed Performance 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 year ago Support enabling checksums online 5323 Moved to different CF 10/10 +70−107 Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) Tomas Vondra (fuzzycz) 7 6 hours ago Add sortsupport for range types and btree_gist 5325 Moved to different CF Performance 7/7 +870−8 Bernd Helmle (psoo), Christoph Heiss (christoph.heiss) Andrey Borodin (x4m), jian he (hellothere) Heikki Linnakangas (heikki) 3 1 year ago Parallel heap vacuum 5326 Moved to different CF Performance Needs rebase! Masahiko Sawada (masahikosawada) Hayato Kuroda (ha-kun) 7 6 months ago Use read_stream in index vacuum 5327 Moved to different CF Performance 7/7 +167−25 Andrey Borodin (x4m) Melanie Plageman (melanieplageman), Kirill Reshke (reshke), Rahila Syed (rahila), Zhao Junwang (zhjwpku) Melanie Plageman (melanieplageman) 3 1 year ago Logging plan of the currently running query 5330 Moved to different CF Monitoring 18 10/10 +645−34 Atsushi Torikoshi (atsushitorikoshi) Hironobu Suzuki (suzuki_hironobu), Akshat Jaimini (akshatj), Sadeq Dousti (msdousti) 8 2 weeks ago Document how to run only specific regress tests 5333 Moved to different CF Docs Only 10/10 +12−0 Paul Jungwirth (pjungwir) Robert Treat (xzilla) Daniel Gustafsson (d_gustafsson) 3 1 year ago Support regular expressions with nondeterministic collations 5334 Withdrawn SQL Commands Not processed Peter Eisentraut (petere) 2 1 year ago Skip logical decoding of already-aborted transactions. 5338 Moved to different CF Not processed Masahiko Sawada (masahikosawada) vigneshwaran C (vignesh.postgres) Masahiko Sawada (masahikosawada) 3 1 year ago Use "protocol options" name instead of "protocol extensions" everywhere 5341 Moved to different CF Docs Only 7/7 +4−4 Jelte Fennema-Nio (jeltef) 3 1 year ago Increase 2Gb limit of memory GUC variables in 64-bit Windows 5343 Committed 18 Not processed Vladlen Popolitov (vladlenpopolitov) Tom Lane (tgl) Tom Lane (tgl) 2 1 year ago Count and log pages set all frozen by vacuum 5346 Committed Monitoring Not processed Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 2 1 year ago Additional function inlining for slow_deform_heap_tuple 5347 Committed Performance Not processed David Rowley (davidrowley) David Rowley (davidrowley) 2 1 year ago Allow default \watch interval in psql to be configured 5353 Moved to different CF libpq 6/7 +141−2 Daniel Gustafsson (d_gustafsson) Ashutosh Bapat (ashutoshbapat), Masahiro Ikeda (masahiro.ikeda) Daniel Gustafsson (d_gustafsson) 3 1 year ago Improve code coverage of network address functions 5354 Moved to different CF Testing 18 Not processed Aleksander Alekseev (a.alekseev) Jacob Champion (jchampion), Keisuke Kuroda (keisuke.kuroda.3862) Michael Paquier (michael-kun) 3 1 year ago Enhance memory context statistics reporting for all PostgreSQL processes. 5355 Moved to different CF Monitoring 18 6/7 +1383−45 Rahila Syed (rahila) Daniel Gustafsson (d_gustafsson), Atsushi Torikoshi (atsushitorikoshi) Daniel Gustafsson (d_gustafsson) 3 3 weeks ago Add support for database service to psql prompt 5356 Committed libpq Not processed Michael Banck (mbanck) Greg Sabino Mullane (greg) Michael Paquier (michael-kun) 2 1 year ago New predefined role pg_manage_extensions 5357 Moved to different CF System Administration 2/10 +22−5 Michael Banck (mbanck) Laurenz Albe (laurenz) 4 10 months ago Shave a few cycles off our ilog10 implementation 5358 Withdrawn Performance 18 Not processed David Fetter (dfetter) Heikki Linnakangas (heikki), David Rowley (davidrowley) 2 1 year ago Showing applied extended statistics in explain Part2 5359 Moved to different CF Performance 18 Needs rebase! Tatsuro Yamada (tatsuro_yamada) Tomas Vondra (fuzzycz), Andrei Lepikhov (lepikhov), Masahiro Ikeda (masahiro.ikeda), Ilia Evdokimov (ilidock95) Tomas Vondra (fuzzycz) 5 7 months ago Add NetBSD and OpenBSD OSes to Postgres CI 5360 Moved to different CF Testing Needs rebase! Nazir Bilal Yavuz (nbyavuz) Andres Freund (andresfreund) 3 11 months ago Let an Append to consider a tuple fraction when choosing fractional subpaths 5361 Moved to different CF Performance 18 Needs rebase! Andrei Lepikhov (lepikhov), Nikita Malakhov (nmalakh) Alexander Korotkov (smagen) 2 1 year ago Add missing tab completions 5362 Committed libpq 18 Not processed Kirill Reshke (reshke) Karina Litskevich (karinalitskevich) Tomas Vondra (fuzzycz) 1 1 year ago enable pg_recvlogical to use temporary slots 5363 Returned with feedback Not processed Torsten Foertsch (tfoertsch123) Michael Paquier (michael-kun) 1 1 year ago Using Expanded Objects other than Arrays from plpgsql 5364 Moved to different CF Performance Not processed Tom Lane (tgl) Tom Lane (tgl) 2 1 year ago Fix creation of empty .log files during log rotation 5365 Moved to different CF 10/10 +15−12 Arseny Kositsin (arseny114) 4 4 months ago Eagerly scan all-visible pages to amortize aggressive vacuum 5366 Moved to different CF Performance Not processed Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 2 1 year ago Clear padding in PgStat_HashKey keys 5367 Committed Refactoring Only 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 1 1 year ago Convert contrib SQL functions to new style 5368 Committed Security 18 Not processed Tom Lane (tgl), Ronan Dunklau (rdunklau) Tom Lane (tgl) 1 1 year ago optimize file transfer in pg_upgrade 5369 Moved to different CF Performance 18 7/7 +642−80 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 year ago Remove an obsolete comment in gistinsert() 5370 Committed Comments Only Not processed Tender Wang (tndrwang) Michael Paquier (michael-kun) 1 1 year ago TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' 5371 Returned with feedback Bugfix Not processed Aleksander Alekseev (a.alekseev) 1 1 year ago Use attribute function for SSE42 CRC32C code 5372 Committed Refactoring Only 18 Not processed Raghuveer Devulapalli (rdevulap) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago Tweak access BufferDescriptors array codes in BufferGetLSNAtomic() 5373 Moved to different CF 7/7 +2−0 Tender Wang (tndrwang) Xuneng Zhou (egoa) Richard Guo (richardguo) 2 1 year ago fix port/pg_iovec.h building extensions 5374 Committed Bugfix stable Not processed Wolfgang Walther (wolfgangwalther) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago If the psql process is idle, the user is not able to know that the server is not running until they enter a command. 5375 Returned with feedback libpq Not processed srinath reddy (s.srinathreddy) Tom Lane (tgl) 1 1 year ago pageinspect - bug in brin_page_items 5376 Committed Bugfix 17 Not processed Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 1 1 year ago Converting SetOp to read its two inputs separately 5377 Committed Performance Not processed Tom Lane (tgl) Tom Lane (tgl) 1 1 year ago Conflict detection for update_deleted in logical replication 5378 Moved to different CF Logical Replication Needs rebase! Zhijie Hou (houzj) Dilip Kumar (dilip.kumar), Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres) Amit Kapila (amitkapila) 4 6 months ago Fix bug with accessing to temporary tables of other sessions 5379 Moved to different CF Bugfix Backport 18 10/10 +182−23 Daniil Davydov (dddaniil) Tom Lane (tgl), Rafia Sabih (rafia.sabih), Jim Jones (jimus), Soumya S Murali (soumyamurali) 7 1 week ago Parametrization minimum password length 5380 Committed Security stable Not processed Emanuele Musella (musedexter) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago explain pgstatindex fragmentation 5381 Moved to different CF Docs Only 18 7/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 9 months ago Adding compression of temporary files 5382 Moved to different CF Performance Needs rebase! Filip Januš (fjanus) Zsolt Parragi (zsolt.parragi), lakshmi g (lakshmi) 6 1 week ago Fixed assertion issues in "pg_get_viewdef" 5383 Committed Bugfix stable Not processed Man Zeng (zengman) Tom Lane (tgl) 1 1 year ago fix deprecation mention for age() and mxid_age() 5384 Committed Docs Only 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 1 1 year ago clean up create|alter domain stmt incompatiable constraint error case and add regression test 5385 Withdrawn 18 Not processed 1 1 year ago Log LSN before table is dropped 5386 Moved to different CF 6/7 +8−0 Andrey Borodin (x4m), Nik Samokhvalov (nikolay), Kirk Wolak (kirkw) Jim Jones (jimus) 2 4 months ago Allow PGSERVICEFILE to be specified as part of the connection string 5387 Moved to different CF libpq 19 10/10 +160−7 Torsten Foertsch (tfoertsch123) Ryo Kanbayashi (ryokanbayashi) Michael Paquier (michael-kun) 2 8 months ago Improved psql tab completion for joins 5388 Committed libpq Not processed Andreas Karlsson (kandreas) Tomas Vondra (fuzzycz) 1 1 year ago Sampling of queries in pg_stat_statements 5389 Withdrawn Monitoring Not processed 1 1 year ago Sampling in pg_stat_statements 5390 Moved to different CF Monitoring 18 7/7 +291−8 Ilia Evdokimov (ilidock95) Andrey Borodin (x4m), Sami Imseih (simseih), Alena Rybakina (alenka) 2 1 year ago Forbid accessing other session's temporary tables 5392 Withdrawn Bugfix stable Not processed Mikhail Gribkov (youzhick) 1 1 year ago attempt multibyte-aware truncation of database names 5393 Committed Bugfix 17 Not processed Nathan Bossart (bossartn), Bertrand Drouvot (bdrouvot) Nathan Bossart (bossartn) 1 1 year ago Fix jsonb comparison for raw scalar pseudo arrays 5394 Committed Bugfix stable Not processed Jack Yan (jackyan) Andrew Dunstan (adunstan) 1 1 year ago Add Option to Check All Addresses For Matching target_session_attr 5396 Moved to different CF libpq 18 10/10 +334−10 Andrew Jackson (andrewjackson) Andrey Borodin (x4m) 6 3 weeks ago revamp row-security tracking 5397 Moved to different CF Security 19 9/10 +25−17 Nathan Bossart (bossartn) 5 1 year ago Parallel index build for BRIN 5398 Committed Docs Only 17 Not processed Egor Rogov (egorius) Tomas Vondra (fuzzycz) 1 1 year ago Windows pg_basebackup unable to create >2GB pg_wal.tar tarballs ("could not close file: Invalid argument" when creating pg_wal.tar of size ~ 2^31 bytes) 5399 Committed Bugfix stable Not processed Thomas Munro (macdice), davinder singh (davindersingh), Jakub Wartak (jakub.wartak.tomtom) Thomas Munro (macdice) Thomas Munro (macdice) 1 1 year ago avoid calling pgstat_read_current_status() in pg_signal_backend() 5400 Committed Performance 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago Improve the error message for logical replication of regular column to generated column. 5401 Committed Not processed Shubham Khanna (skhanna) Hayato Kuroda (ha-kun), vigneshwaran C (vignesh.postgres), Peter Smith (smithpb) Amit Kapila (amitkapila) 1 1 year ago Heap Use After Free in Window Aggregate Execution & custom malloc allocator implementation 5402 Committed Bugfix 17 Not processed Jayesh Dehankar (jayesh.dehankar) David Rowley (davidrowley) 1 1 year ago Windows pg_basebackup unable to create >2GB pg_wal.tar tarballs ("could not close file: Invalid argument" when creating pg_wal.tar of size ~ 2^31 bytes) 5403 Withdrawn Bugfix stable Not processed Thomas Munro (macdice), Jakub Wartak (jakub.wartak.tomtom) Thomas Munro (macdice) 1 1 year ago Self contradictory examining on rel's baserestrictinfo 5404 Returned with feedback 18 Not processed w q (wq) Tom Lane (tgl) 1 1 year ago Add 'make check-tests' behavior to the meson based builds 5405 Moved to different CF Testing 19 10/10 +16−6 Nazir Bilal Yavuz (nbyavuz) Ashutosh Bapat (ashutoshbapat), Josef Šimánek (retro), Jian He (stayreal) Andrew Dunstan (adunstan) 5 4 months ago [Fix] Heap Use After Free in parallel_vacuum_reset_dead_items Function 5406 Committed Bugfix 17 Not processed Vallimaharajan G (vallimaharajan001) John Naylor (john.naylor) 1 1 year ago Add Pipelining support to psql 5407 Moved to different CF libpq 18 Needs rebase! Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 11 months ago local and inherited NOT NULL constraints on non-local columsn 5408 Committed Bugfix Not processed Ashutosh Bapat (ashutoshbapat) Álvaro Herrera (alvarofherrera) Álvaro Herrera (alvherre) 1 1 year ago postgres_fdw could deparse ArrayCoerceExpr 5409 Moved to different CF 18 10/10 +0−0 Alexander Pyhalov (a.pyhalov) Maxim Orlov (m.orlov) Alexander Korotkov (smagen) 4 8 months ago Disable installcheck for tap and regress tests for injection_points module 5410 Moved to different CF Testing 18 2/7 +77−0 Michail Nikolaev (nkey) 2 1 year ago Memory leak in WAL sender with pgoutput (v10~) 5411 Committed Bugfix stable Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago Rework subscription-related code for psql and pg_dump 5412 Committed Refactoring Only 18 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago INSERT ... ON CONFLICT DO SELECT [FOR ...] 5413 Moved to different CF SQL Commands 7/7 +831−190 Andreas Karlsson (kandreas), Marko Tiikkaja (johto) Dean Rasheed (deanr) 2 1 year ago Tab completion for ALTER USER RESET 5414 Moved to different CF libpq 18 7/7 +28−0 Robins Tharakan (robins) Tomas Vondra (fuzzycz) 2 1 year ago Fix right-semi-joins in HashJoin rescans 5415 Committed Bugfix Not processed Richard Guo (richardguo) Richard Guo (richardguo) 1 1 year ago Use Python "Limited API" in PL/Python 5416 Moved to different CF 7/7 +0−0 Peter Eisentraut (petere) Peter Eisentraut (petere) 2 2 months ago pure parsers and reentrant scanners 5417 Committed Not processed Peter Eisentraut (petere) Andreas Karlsson (kandreas) Peter Eisentraut (petere) 1 1 year ago Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN 5418 Moved to different CF Docs Only 7/7 +0−0 Masahiro Ikeda (masahiro.ikeda) Robert Treat (xzilla) Álvaro Herrera (alvherre) 2 1 year ago Doc: clarify the log message level of the VERBOSE option 5419 Committed Docs Only Not processed Masahiro Ikeda (masahiro.ikeda) Fujii Masao (masaofujii) 1 1 year ago Pass ParseState down to utility functions in more places. 5420 Committed Bugfix stable Not processed Kirill Reshke (reshke), jian he (hellothere) Álvaro Herrera (alvherre), Tom Lane (tgl), Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago [PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause 5422 Moved to different CF Performance 18 7/7 +0−0 Ravi Revathy (revathyraavi) 2 1 year ago SCRAM authentication for postgres_fdw connections 5423 Committed Not processed Matheus Alcantara (matheus.alcantara) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago fixing tsearch locale support 5424 Committed Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago doc: Mention clock synchronization recommendation for hot_standby_feedback 5425 Moved to different CF Docs Only stable 5/7 +7−0 Jakub Wartak (jakub.wartak.tomtom) vigneshwaran C (vignesh.postgres) Peter Eisentraut (petere) 2 1 year ago Add a warning message when using unencrypted passwords 5426 Withdrawn Security Not processed Guillaume Lelarge (gleu) Nathan Bossart (bossartn) 1 1 year ago [BUG] Assert fails for local buffers in BufferIsExclusiveLocked 5427 Withdrawn Bugfix Not processed 1 1 year ago [BUG] Assert fails for local buffers in BufferIsDirty 5428 Committed Bugfix 17 Not processed srinath reddy (s.srinathreddy) Nazir Bilal Yavuz (nbyavuz) Tom Lane (tgl) 1 1 year ago Adopt <inttypes.h> macros in format strings. 5429 Moved to different CF Refactoring Only Needs rebase! Thomas Munro (macdice) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 1 year ago Lock tuple for dependecy change in REASSIGN OWNED. 5430 Committed Bugfix 18 Not processed Kirill Reshke (reshke) Noah Misch (nmisch), Alexander Kukushkin (cyberdem0n) Noah Misch (nmisch) 1 1 year ago Add XMLDocument (SQL/XML X030) 5431 Moved to different CF SQL Commands 19 10/10 +258−1 Jim Jones (jimus) Pavel Stehule (okbobcz), newtglobal postgresql_contributors (newtpostgrescontributors) 7 1 week ago URL extension with Unicode and setter-functions support 5432 Rejected Not processed Alexander Borisov (lexborisov) Victor Yegorov (vyegorov) 1 1 year ago Adding a '--two-phase' option to 'pg_createsubscriber' utility. 5433 Moved to different CF Needs rebase! Shubham Khanna (skhanna) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250), Shlok Kyal (shlokkyal) Amit Kapila (amitkapila) 2 1 year ago Avoid unnecessary wrapping for more complex expressions 5434 Committed Performance Not processed Richard Guo (richardguo) Richard Guo (richardguo) 1 1 year ago Unicode full case mapping and standard-compliant UCS_BASIC 5435 Committed 18 Not processed Jeff Davis (jdavis) Jeff Davis (jdavis) 1 1 year ago Unicode case folding: new CASEFOLD() function. 5436 Committed 18 Not processed Jeff Davis (jdavis) Jeff Davis (jdavis) 1 1 year ago IANA timezone abbreviations versus timezone_abbreviations 5437 Committed Bugfix 18 Not processed Tom Lane (tgl) Aleksander Alekseev (a.alekseev) Tom Lane (tgl) 1 1 year ago bt_index_parent_check false alarm for indexes created concurrently 5438 Moved to different CF Bugfix Backport 10/10 +70−40 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Andrey Borodin (x4m) Álvaro Herrera (alvherre) 6 2 months ago Issue with pgbench nested \if 5439 Committed Testing Not processed Michail Nikolaev (nkey) Tom Lane (tgl) 1 1 year ago Add PageData type and add const qualifiers to bufpage.h 5440 Committed Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago Separate GUC for replication origins 5441 Moved to different CF 18 7/7 +92−92 Euler Taveira (eulerto) Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres) Masahiko Sawada (masahikosawada) 2 1 year ago Log connection establishment timings 5442 Moved to different CF Monitoring 7/7 +508−25 Melanie Plageman (melanieplageman) Fujii Masao (masaofujii), Jacob Champion (jchampion), Bertrand Drouvot (bertranddrouvot.pg) Melanie Plageman (melanieplageman) 2 1 year ago accommodate large DSA requests in dshash 5443 Committed stable Not processed Matthias van de Meent (mmeent) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago using index to speedup add not null constraints to a table 5444 Moved to different CF 0/10 +392−6 Jian He (stayreal) Tanzeel Khan (tanzeelk) 6 1 month ago Question about behavior of deletes with REPLICA IDENTITY NOTHING 5445 Committed Docs Only Not processed Robert Treat (xzilla) Peter Smith (smithpb2250) Amit Kapila (amitkapila) 1 1 year ago Improving default column names/aliases of subscript text expressions 5446 Rejected Not processed Jelte Fennema-Nio (jeltef) 1 1 year ago log_min_messages per backend type 5447 Moved to different CF GUC System Administration 19 10/10 +398−43 Euler Taveira (eulerto) Surya Poondla (spoondla) Álvaro Herrera (alvherre) 7 1 month ago Incorrect result of bitmap heap scan. 5448 Moved to different CF Bugfix stable 7/7 +127−132 Matthias van de Meent (mmeent) Andres Freund (andresfreund) 2 1 year ago Allow subfield references without parentheses 5449 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) 2 1 year ago Eliminating SPI / SQL from some RI trigger functions 5450 Moved to different CF Performance 19 Needs rebase! Amit Langote (amitlan) Haibo Yan (billyean) 5 2 days ago Some ExecSeqScan optimizations 5453 Committed Performance 18 Not processed Amit Langote (amitlan) Amit Langote (amitlan) 1 1 year ago Clarify FileTag-based unlinking 5454 Moved to different CF Refactoring Only 10/10 +10−7 Matthias van de Meent (mmeent) Surya Poondla (spoondla) 4 4 days ago refactor AlterDomainAddConstraint (alter domain add constraint) 5455 Moved to different CF 18 10/10 +101−6 Jian He (stayreal) Peter Eisentraut (petere) 5 1 year ago Add XMLNamespaces option to XMLElement 5456 Moved to different CF SQL Commands 19 10/10 +1242−41 Pavel Stehule (okbobcz), Jim Jones (jimus) Pavel Stehule (okbobcz), Umar Hayat (pgwizard), newtglobal postgresql_contributors (newtpostgrescontributors) 7 1 week ago Fix 'unresolved external symbol' under Windows in meson build 5457 Committed Bugfix 18 Not processed Vladlen Popolitov (vladlenpopolitov) Heikki Linnakangas (heikki) 1 1 year ago Fix bank selection logic in SLRU 5458 Committed Bugfix 17 Not processed Yura Sokolov (funny_falcon) Andrey Borodin (x4m) Álvaro Herrera (alvherre) 1 1 year ago Parallel tests publication and subscription might fail due to concurrent tuple update 5459 Moved to different CF Testing 16 6/7 +4−2 Jelte Fennema-Nio (jeltef) 2 1 year ago More reliable nbtree detection of unsatisfiable RowCompare quals involving a leading NULL key/element 5460 Committed Performance Not processed Peter Geoghegan (pgeoghegan) Peter Geoghegan (pgeoghegan) 1 1 year ago Stores short varlena in an array 5461 Rejected 18 Not processed Zongliang Quan (quanzl) Tom Lane (tgl) 1 1 year ago history of vacuum / checkpoint runs 5462 Withdrawn Monitoring Not processed Tomas Vondra (fuzzycz) 1 1 year ago downgrade some aclchk.c errors to internal 5463 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago Fix handling of injection_points regarding pending stats 5464 Committed Bugfix 18 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago Add maintainer-defined module info into shared library 5465 Moved to different CF 18 7/7 +596−112 Andrei Lepikhov (lepikhov) Yurii Rashkovskii (yrashk) Tom Lane (tgl) 2 1 year ago WAL-logging facility for pgstats kinds 5466 Moved to different CF 18 Not processed Michael Paquier (michael-kun) 2 1 year ago speedup COPY TO for partitioned table 5467 Moved to different CF 19 10/10 +200−36 Jian He (stayreal) vigneshwaran C (vignesh.postgres), Kirill Reshke (reshke), Atsushi Torikoshi (atsushitorikoshi), newtglobal postgresql_contributors (newtpostgrescontributors) Masahiko Sawada (masahikosawada) 5 5 months ago Fix logging for invalid recovery timeline 5468 Moved to different CF Bugfix stable 7/7 +3−3 David Steele (dsteele) Michael Paquier (michael-kun) 2 1 year ago Give slotsync worker a reserved PGPROC 5469 Committed Bugfix 17 Not processed Tom Lane (tgl) Tom Lane (tgl) 1 1 year ago Function scan FDW pushdown 5470 Moved to different CF Performance 18 10/10 +1348−104 Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) Ashutosh Bapat (ashutoshbapat) 3 2 weeks ago Convert macros to static inline functions 5471 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago Unicode 16 update 5472 Moved to different CF 7/7 +7442−6609 Peter Eisentraut (petere), Jeff Davis (jdavis) Peter Eisentraut (petere) 2 11 months ago Proposal: Progressive explain 5473 Moved to different CF Needs rebase! Rafael Castro (rafaelthca) Robert Haas (rhaas) 2 1 year ago Speed up ICU case conversions 5474 Moved to different CF Performance 2/7 +86−41 Andreas Karlsson (kandreas) 2 2 months ago IWYU annotations 5475 Committed Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago psql: Option to use expanded mode for various meta-commands 5476 Committed libpq Not processed Dean Rasheed (deanr) Dean Rasheed (deanr) 1 1 year ago Allow EXPLAIN to Output Page Fault Information 5477 Withdrawn Monitoring Not processed Atsushi Torikoshi (torikoshia) 1 2 weeks ago SQL/JSON json_table PLAN clause 5478 Moved to different CF 18 10/10 +2312−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) 6 11 months ago Enable logical decoding when wal_level = 'replica' without a server restart 5479 Moved to different CF 9/10 +1598−145 Masahiko Sawada (masahikosawada) Dilip Kumar (dilip.kumar), Hayato Kuroda (ha-kun) Masahiko Sawada (masahikosawada) 6 2 months ago Ignore nullingrels when looking up statistics 5480 Committed Bugfix stable Not processed Richard Guo (richardguo) Richard Guo (richardguo) 1 1 year ago Modern SHA2- based password hashes for pgcrypto 5481 Moved to different CF Security 18 7/7 +1164−2 Bernd Helmle (psoo) Álvaro Herrera (alvherre) 2 11 months ago handle batch explosion in hash joins 5482 Moved to different CF Performance 2/7 +5635−0 Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 2 1 year ago Don't dirty pages while they are getting flushed out 5483 Moved to different CF Refactoring Only Needs rebase! Andres Freund (andresfreund) Andres Freund (andresfreund) 5 2 days ago