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 2 days ago 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 functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) 3256 Moved to different CF libpq Not processed Justin Pryzby (justinpryzby) David Christensen (davidchristensen) 16 1 year ago In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal) 3461 Moved to different CF Performance Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom) 16 1 year 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 warn if GUC set to an invalid shared library 3482 Returned with feedback System Administration Not processed Justin Pryzby (justinpryzby) Christoph Berg (myon), cary huang (caryh), Maciek Sakrejda (msakrejda), Cary Huang (cary) 14 1 year 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 Switching XLog source from archive to streaming when primary available 3663 Returned with feedback Not processed Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) Nathan Bossart (bossartn) 13 1 year ago nbtree performance improvements through specialization on key shape 3672 Moved to different CF Performance Not processed Matthias van de Meent (mmeent) 14 1 year 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 ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables 3705 Moved to different CF Performance Not processed Justin Pryzby (justinpryzby) Bertrand Drouvot (bertranddrouvot.pg) 13 1 year ago CI and test improvements 3709 Moved to different CF Testing Not processed Justin Pryzby (justinpryzby) 14 1 year 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 BCP 47 locale names for Windows 3772 Moved to different CF Not processed Thomas Munro (macdice) 8 1 year ago pg_rewind WAL deletion pitfall 3874 Committed Bugfix Not processed Alexander Kukushkin (cyberdem0n), Polina Bungina (hughcapet) Kyotaro Horiguchi (horiguti), Atsushi Torikoshi (atsushitorikoshi), moro dream (morod) Álvaro Herrera (alvherre) 12 1 year ago Post-special Page Storage TDE support (aka Reserved Page Size) 3986 Moved to different CF Not processed David Christensen (davidchristensen) 12 1 year ago SetLatches() 3998 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) 12 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 Cross-database SERIALIZABLE safe snapshots 4240 Moved to different CF Performance Not processed Thomas Munro (macdice) Heikki Linnakangas (heikki) 9 2 years 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 Moved to different CF 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 10/10 +5138−2325 Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) 14 1 hour ago Add last_commit_lsn to pg_stat_database 4355 Moved to different CF Monitoring Not processed James Coleman (jcole1989) Wen Yi (wenyi) 9 1 year ago UUID v7 4388 Moved to different CF 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 10 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 Replace a large number of OR clauses with ANY expression 4450 Committed Performance 17 Not processed Andrei Lepikhov (lepikhov), Alena Rybakina (alenka) Nikolay Shaplov (nataraj), Ranier Vilela (raniervilela) Alexander Korotkov (smagen) 7 1 year 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 12 hours ago Extract numeric field in JSONB more effectively 4476 Moved to different CF Performance Not processed Andy Fan (andyf) Chapman Flack (chap) 8 2 days ago 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 Separate memory contexts for relcache and catcache 4554 Returned with feedback Monitoring Not processed Melih Mutlu (melihmutlu) Atsushi Torikoshi (atsushitorikoshi) 6 1 year 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 nbtree: implement dynamic prefix truncation 4635 Moved to different CF Performance Not processed Matthias van de Meent (mmeent) 7 1 year ago nbtree: downlink right separator/HIKEY optimization 4638 Moved to different CF Performance Not processed Matthias van de Meent (mmeent) 7 2 years 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 2 years ago Add the page header to each SLRU page. 4709 Moved to different CF Not processed Rishu Bagga (rishubagga), Yong Li (yoli) Thomas Munro (macdice), Shawn Debnath (sd) 6 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 Moved to different CF 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 Add LSN <-> time conversion facility 4754 Withdrawn Not processed Melanie Plageman (melanieplageman) Daniel Gustafsson (d_gustafsson), Andrey Borodin (x4m) 5 1 year ago shared detoast datum 4759 Moved to different CF Performance Not processed Andy Fan (andy2) 6 1 year ago date_trunc function in interval version 4761 Moved to different CF Not processed Przemysław Sztoch (psztoch) 5 1 year ago Change prefetch and read strategies to use range in pg_prewarm 4763 Moved to different CF Refactoring Only Not processed Cédric Villemain (c2main) Nazir Bilal Yavuz (nbyavuz) 5 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 Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM 4777 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) Jeff Davis (jdavis) 5 1 year ago Reordering DISTINCT keys to match input path's pathkeys 4787 Committed Performance Not processed Richard Guo (richardguo) Richard Guo (richardguo) 4 1 year ago add COPY option REJECT_LIMIT 4797 Committed SQL Commands Not processed Atsushi Torikoshi (atsushitorikoshi) Fujii Masao (masaofujii), Kirill Reshke (reshke) Fujii Masao (masaofujii) 4 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 Moved to different CF Not processed Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) Peter Eisentraut (petere) 5 1 year ago Avoid mixing custom and OpenSSL BIO functions 4835 Committed Security Not processed David Benjamin (dbenjamin) Daniel Gustafsson (d_gustafsson) Daniel Gustafsson (d_gustafsson) 4 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 Moved to different CF 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 Moved to different CF 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 Recheck foreign key if a referenced collation was nondeterministic 4908 Committed Bugfix 18 Not processed Paul Jungwirth (pjungwir) Peter Eisentraut (petere), Jian He (stayreal) Peter Eisentraut (petere) 3 1 year ago Add a attopt to disable MCV when estimating for Var = Const 4909 Moved to different CF Performance Not processed Andy Fan (andy2) 4 1 year ago CSN snapshots in hot standby 4912 Moved to different CF 18 Not processed Heikki Linnakangas (heikki) 4 1 year 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 Moved to different CF Docs Only 18 Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) 4 1 year ago allow changing autovacuum_max_workers without restarting 4921 Moved to different CF System Administration 18 Not processed Nathan Bossart (bossartn) Yogesh Sharma (sharmay) Nathan Bossart (bossartn) 4 1 year ago add multiple client certificate selection feature 4924 Moved to different CF Security Not processed Cary Huang (cary) 4 1 year ago apply_scanjoin_target_to_paths and partitionwise join 4929 Moved to different CF Bugfix stable Not processed Ashutosh Bapat (ashutoshbapat) 4 1 year ago Identify huge pages accessibility using madvise 4937 Withdrawn stable Not processed Dmitry Dolgov (erthalion) Gabriele Bartolini (gbartolini), Niccolo Fei (nfei) 3 1 year ago Use <stdint.h> for int64_t and other exact-width integer types 4938 Moved to different CF Refactoring Only Not processed Thomas Munro (macdice) Peter Eisentraut (petere) Thomas Munro (macdice) 4 1 year ago ECPG cleanup and fix for clang compile-time problem 4939 Committed Refactoring Only Not processed Tom Lane (tgl) John Naylor (john.naylor) Tom Lane (tgl) 3 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 Moved to different CF 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 Support LIKE with nondeterministic collations 4965 Committed SQL Commands Not processed Peter Eisentraut (petere) Paul Jungwirth (pjungwir) Peter Eisentraut (petere) 3 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 5 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 pg_parse_json: don't leak token copies on failure 4975 Committed Bugfix Not processed Jacob Champion (jchampion) Andrew Dunstan (adunstan) Andrew Dunstan (adunstan) 3 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 Moved to different CF 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 AIX support, revert the changes from 0b16bb8776bb8 5003 Returned with feedback Refactoring Only Not processed Sriram RK (sriramrk) 3 3 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 GUC names in messages 5011 Committed 18 Not processed Peter Smith (smithpb2250) Michael Paquier (michael-kun) 3 1 year 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 7/10 +765−143 Jelte Fennema-Nio (jeltef) Sadeq Dousti (msdousti), Artem Gavrilov (artem.gavrilov) 10 3 weeks ago Detection and resolution of logical replication conflict 5021 Returned with feedback 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 1 year ago Relcache refactoring 5022 Committed Refactoring Only Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 3 1 year ago Add support to TLS 1.3 cipher suites and curves lists in Postgres 5025 Committed Security Not processed Erica Zhang (zerica) Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) Daniel Gustafsson (d_gustafsson) 3 1 year ago Parallel CREATE INDEX for GiST indexes 5026 Moved to different CF 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 Moved to different CF 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 Moved to different CF 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 Fix race conditions with concurrent drops of shared pgstats entries 5045 Committed Bugfix stable Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 1 year 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 Moved to different CF 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 New function rand_array() to contrib/tablefunc 5061 Moved to different CF Not processed Andy Fan (andy2) Dean Rasheed (deanr), Aleksander Alekseev (a.alekseev), Jim Jones (jimus) 4 1 year ago Improve EXPLAIN output for multicolumn B-Tree Index 5063 Moved to different CF Monitoring 18 Not processed Masahiro Ikeda (masahiro.ikeda) 4 1 year ago Allow logical decoding to output generated columns 5068 Returned with feedback 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 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 Moved to different CF 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 Moved to different CF 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 6 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 8/10 +3692−279 Antonin Houska (a.houska) Álvaro Herrera (alvherre), Mihail Nikalayeu (mihailnikalayeu) 9 4 hours ago SendProcSignal(), SetLatch() → SendInterrupt() 5118 Moved to different CF Refactoring Only Needs rebase! Heikki Linnakangas (heikki), Thomas Munro (macdice) 5 3 weeks ago REINDEX not updating partition progress 5122 Moved to different CF stable Not processed Ilya Gladyshev (qoops) 3 1 year ago Converting tab-complete.c's else-if chain to a switch 5123 Committed Refactoring Only Not processed Tom Lane (tgl) Tom Lane (tgl) 2 1 year 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 10/10 +1427−744 Alexander Pyhalov (a.pyhalov) Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) 8 22 hours ago add log_transaction GUC setting 5131 Moved to different CF Monitoring 18 Not processed Sergey Solovev (ashblade) 3 1 year ago Make PG_TEST_EXTRA env variable override its Meson configure option 5134 Committed Testing Not processed Jacob Champion (jchampion), Nazir Bilal Yavuz (nbyavuz) Ashutosh Bapat (ashutoshbapat) Heikki Linnakangas (heikki) 2 1 year ago Add min/max aggregate functions to BYTEA 5138 Committed 18 Not processed Aleksander Alekseev (a.alekseev), Marat Bukharov (maratik) Andrey Borodin (x4m) Tom Lane (tgl) 2 1 year ago Track collation and ctype versions separately 5141 Moved to different CF 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 Recovery of .partial WAL segments 5148 Moved to different CF Not processed Stefan Fercot (stefan.fercot) 3 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 Set query_id for queries contained in utility statement 5150 Committed Bugfix Not processed Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 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 4 weeks ago Casts from jsonb to other types should cope with json null 5152 Moved to different CF Not processed Tom Lane (tgl) Tom Lane (tgl) 3 1 year ago Prohibit to use EphemeralNamedRelation in materialized views 5153 Moved to different CF 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 6 months ago doc: Meson is not experimental on Windows 5156 Moved to different CF Docs Only Not processed Aleksander Alekseev (a.alekseev) Peter Eisentraut (petere) Peter Eisentraut (petere) 3 1 year ago Blast-RADIUS mitigation 5158 Moved to different CF Security Not processed Thomas Munro (macdice) Heikki Linnakangas (heikki) 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 Moved to different CF 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 Improvements for pg_wal_replay_wait() 5167 Returned with feedback 18 Not processed Alexander Korotkov (smagen) Alexander Korotkov (smagen) 2 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 Call rm_redo in a temporary memory context 5174 Moved to different CF Refactoring Only Not processed Heikki Linnakangas (heikki) 3 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 Enable data checksums by default with initdb 5178 Committed System Administration Not processed Greg Sabino Mullane (greg) Peter Eisentraut (petere), Nathan Bossart (bossartn) Peter Eisentraut (petere) 2 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 Refactor postmaster child handling 5185 Committed Refactoring Only Not processed Heikki Linnakangas (heikki) Heikki Linnakangas (heikki) 2 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 Moved to different CF Refactoring Only 18 Not processed Steven Niu (niushiji) 3 1 year ago Add contrib/pg_logicalsnapinspect 5197 Committed 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 2 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 prefetching for nestloop / indexscan 5208 Withdrawn Performance Not processed Tomas Vondra (fuzzycz) 2 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 remove adaptive spins_per_delay code 5210 Withdrawn 18 Not processed Nathan Bossart (bossartn) 2 1 year ago Collect statistics about conflicts in logical replication 5211 Committed 18 Not processed Zhijie Hou (houzj) Hayato Kuroda (ha-kun), Peter Smith (smithpb), shveta malik (shvetam) Amit Kapila (amitkapila) 2 1 year ago Parallel workers stats in pg_stat_database 5212 Committed Monitoring 18 Not processed Benoit Lobréau (benoitl) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 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 5 days ago Backport of LLVM memory manager to fix ARM relocation bug 5220 Committed Bugfix stable Not processed Thomas Munro (macdice), Anthonin Bonnefoy (bonnefoa) Anthonin Bonnefoy (bonnefoa) Thomas Munro (macdice) 2 1 year ago Add roman support for to_number function 5221 Moved to different CF SQL Commands 18 Not processed Hunaid Sohail (hunaid) Maciek Sakrejda (msakrejda-pga) Tom Lane (tgl) 3 1 year ago Avoiding superfluous buffer locking during nbtree backwards scans 5222 Committed Performance Not processed Matthias van de Meent (mmeent) Peter Geoghegan (pgeoghegan) 2 1 year ago not-null constraints 5224 Committed Not processed Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 2 1 year ago Vectored IO in XLogWrite() 5225 Moved to different CF Refactoring Only Not processed Melih Mutlu (melihmutlu) 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 Moved to different CF 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 Consider the number of columns in the sort cost model 5231 Moved to different CF Performance 18 Not processed Andrei Lepikhov (lepikhov) Kirill Reshke (reshke), Alena Rybakina (alenka) 2 1 year ago per backend I/O statistics 5232 Moved to different CF Monitoring 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 1 year ago Add roman support for to_number function 5233 Withdrawn Not processed Maciek Sakrejda (msakrejda) 1 1 year ago Add callback in pgstats for backend initialization 5234 Committed 18 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago JIT: Remove some unnecessary instructions. 5235 Committed Refactoring Only 18 Not processed Xing Guo (higuoxing) Heikki Linnakangas (heikki) 1 1 year ago JIT: The nullness of casetest.value can be determined at the JIT compile time. 5236 Moved to different CF Refactoring Only 18 Not processed Xing Guo (higuoxing) Tom Lane (tgl) Tom Lane (tgl) 2 1 year ago Add callbacks for fixed-numbered stats flush in pgstats 5237 Committed 18 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago Add parallel columns for seq scan and index scan on pg_stat_all_tables and _indexes 5238 Returned with feedback Monitoring 18 Not processed Guillaume Lelarge (gleu) Alena Rybakina (alenka), Bertrand Drouvot (bertranddrouvot.pg) 1 1 year ago Add parallel columns for pg_stat_statements 5239 Committed Monitoring 18 Not processed Guillaume Lelarge (gleu) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago add TOAST table to pg_index 5240 Committed 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 10 months ago Use syscache to do lookups in pg_extension 5241 Committed Performance 18 Not processed Andrei Lepikhov (lepikhov) Jelte Fennema-Nio (jeltef) Michael Paquier (michael-kun) 1 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 Issue with set_indexsafe_procflags in ReindexRelationConcurrently 5243 Committed Bugfix Not processed Michail Nikolaev (nkey) Michael Paquier (michael-kun) 1 1 year ago fix use after free inside json_unique_check_key 5244 Committed Bugfix 17 Not processed Zhao Junwang (zhjwpku) Tomas Vondra (fuzzycz) 1 1 year ago Test improvements and minor code fixes for formatting.c 5245 Committed Testing Not processed Tom Lane (tgl) Nathan Bossart (bossartn) Tom Lane (tgl) 1 1 year 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 Fix small overread during SASLprep 5247 Committed Bugfix stable Not processed Jacob Champion (jchampion) Daniel Gustafsson (d_gustafsson) 1 1 year ago Allow pushdown of HAVING clauses with grouping sets 5248 Committed Performance 18 Not processed Richard Guo (richardguo) Richard Guo (richardguo) 1 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 9/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 Trim the heap free memory 5252 Moved to different CF Monitoring 18 Not processed Shawn Wang (shawnwang) 2 1 year ago Support Int64 GUCs 5253 Rejected Not processed Aleksander Alekseev (a.alekseev), Maxim Orlov (m.orlov) Nathan Bossart (bossartn) 1 1 year ago Cleaning up ERRCODE usage in our XML code 5254 Committed Not processed Tom Lane (tgl) Tom Lane (tgl) 1 1 year ago C-Language Functions docs on how to call internal functions 5255 Moved to different CF 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 Moved to different CF Monitoring 18 Not processed Nazir Bilal Yavuz (nbyavuz) Michael Paquier (michael-kun), Andrew Dunstan (adunstan) Michael Paquier (michael-kun) 2 1 year ago miscellaneous pg_upgrade cleanup 5257 Committed 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago define pg_structiszero(addr, s, r) 5258 Committed Refactoring Only 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago Extending with C: doc on how to call internal functions 5259 Withdrawn Docs Only Not processed 1 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 Add jsonpath string method $.replace(from, to) 5261 Withdrawn SQL Commands Not processed Florents Tselai (florentst) 1 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 Moved to different CF 18 Not processed Jian He (stayreal) 2 1 year ago remove pg_authid's TOAST table 5264 Committed Bugfix 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago Consider explicit incremental sort for mergejoins 5265 Committed Performance 18 Not processed Richard Guo (richardguo) Richard Guo (richardguo) 1 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 Introduce the ability to enable/disable indexes 5267 Withdrawn SQL Commands 18 Not processed Shayon Mukherjee (shayonj) 1 8 months 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 jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 5270 Moved to different CF SQL Commands Needs rebase! Florents Tselai (florentst) David Wheeler (theory) Andrew Dunstan (adunstan) 5 2 days ago pg_ctl/miscinit: print "MyStartTime" as a long long instead of long to avoid 2038 problem 5271 Committed Bugfix 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago Add GUC log_parameter_max_length to limit logged SQL statements 5272 Moved to different CF GUC Good First Review 19 9/10 +145−6 Kirill Gavrilov (diphantxm) Fujii Masao (masaofujii), Jim Jones (jimus) 5 2 days ago micro-optimize nbtcompare.c routines 5273 Withdrawn Performance 18 Not processed Nathan Bossart (bossartn) 1 1 year ago 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 Better error reporting from extension scripts 5275 Committed Not processed Tom Lane (tgl) Pavel Stehule (okbobcz) Tom Lane (tgl) 1 1 year 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 Consistently use <optional> to indicate optional parameters 5278 Committed Docs Only stable Not processed Dagfinn Ilmari Mannsåker (ilmari) Jian He (stayreal) Heikki Linnakangas (heikki) 1 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 Fix orphaned 2pc file which may casue instance restart failed 5280 Committed Bugfix stable Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago pgbench: Improve result outputs related to failed transactinos 5281 Committed libpq 18 Not processed Yugo Nagata (yugo.nagata) Tatsuo Ishii (ishii) Tatsuo Ishii (ishii) 1 1 year 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 database-specific role memberships 5284 Moved to different CF System Administration Not processed Denis Laxalde (dlax), Kenaniah Cerny (kenaniah) 2 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 add pg_ls_summariesdir() 5286 Committed Monitoring 18 Not processed Yushi Ogiwara (yushiogiwara.gmail.com) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago Fix inconsistent RestrictInfo serial numbers 5287 Committed Bugfix Not processed Richard Guo (richardguo) Richard Guo (richardguo) 1 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 Moved to different CF Refactoring Only Not processed James Hunter (hunjmes) David Rowley (davidrowley) 2 1 year ago Remove the RTE_GROUP RTE if we drop the groupClause 5290 Committed Bugfix 18 Not processed Richard Guo (richardguo) Richard Guo (richardguo) 1 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 Remove unlogged materialized view persistence handling 5292 Committed libpq Not processed Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii) 1 1 year ago Missing deconstruct_array_builtin usage 5293 Committed Refactoring Only 18 Not processed Bertrand Drouvot (bertranddrouvot.pg) Álvaro Herrera (alvherre) 1 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 Moved to different CF 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 Fix validation of COPY options FORCE_NOT_NULL/FORCE_NULL 5297 Committed Bugfix Not processed Joel Jacobson (joeljacobson) Michael Paquier (michael-kun) 1 1 year ago Use MAX_PARALLEL_WORKER_LIMIT consistently in guc_tables.c 5298 Committed Not processed Matthias van de Meent (mmeent) Michael Paquier (michael-kun), Mingli Zhang (zml) Michael Paquier (michael-kun) 1 1 year 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 Moved to different CF 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 make foreach_ptr macro work in C++ extensions 5302 Committed stable Not processed Jelte Fennema-Nio (jeltef) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago Fix for consume_xids advancing XIDs incorrectly 5303 Moved to different CF Bugfix stable Needs rebase! Yushi Ogiwara (yushi) 6 2 months ago introduce INT64_HEX_FORMAT/UINT64_HEX_FORMAT 5304 Committed Refactoring Only 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago use __attribute__((target(...))) for AVX-512 stuff 5305 Committed Refactoring Only 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago Recommend --no-psqlrc when restoring a pg_dump script 5306 Moved to different CF Docs Only stable Not processed Shinya Kato (shinyakato) Robert Treat (xzilla) Tom Lane (tgl) 2 1 year ago Doc fix for shared_memory_size_in_huge_pages 5307 Committed Docs Only Not processed Yuki Seino (seinoyu) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago doc: virtual envs with Pl/Python 5308 Moved to different CF Docs Only Not processed Florents Tselai (florentst) 2 1 year ago Syncrep and improving latency due to WAL throttling 5309 Moved to different CF 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 Moved to different CF Docs Only Not processed Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 1 year ago Refactor GetLockStatusData() by skipping unused backends and groups 5311 Committed Refactoring Only Not processed Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 1 year ago BUG #18568: BUG: Result wrong when do group by on partition table! 5312 Committed Bugfix stable Not processed Webbo Han (webbohan) Amit Langote (amitlan), Jian He (stayreal) Amit Langote (amitlan) 1 1 year ago simplify regular expression locale global variables 5313 Moved to different CF Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 2 1 year ago Add array_reverse() function 5314 Committed 18 Not processed Aleksander Alekseev (a.alekseev) Michael Paquier (michael-kun), Vladlen Popolitov (vladlenpopolitov) Michael Paquier (michael-kun) 1 1 year ago More CppAsString2() in psql's describe.c 5315 Committed 18 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago Use more CppAsString2() in pg_amcheck.c 5316 Committed 18 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 1 year ago type cache cleanup improvements 5317 Committed Performance 18 Not processed Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 1 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 Moved to different CF Performance 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 1 year ago Avoid possible overflow (src/port/bsearch_arg.c) 5322 Committed Bugfix 18 Not processed Ranier Vilela (raniervilela) Heikki Linnakangas (heikki) 1 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) Daniel Gustafsson (d_gustafsson) 7 34 minutes ago Wrong result when enable_partitionwise_join is on if collation of PartitionKey and Column is different. 5324 Committed Bugfix Not processed Tender Wang (tndrwang) Amit Langote (amitlan) 1 1 year 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 fix autovacuum assertion failure when dropping indexes 5328 Committed Bugfix 18 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 1 year ago make all ereport in gram.y print out relative location 5329 Committed 18 Not processed Jian He (stayreal) Tom Lane (tgl) 1 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 Add reject_limit option to file_fdw 5331 Committed 18 Not processed Atsushi Torikoshi (atsushitorikoshi) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 1 year ago Provide means to disable legacy crypt() and gen_salt() functions in pgcrypto 5332 Moved to different CF Security 18 Not processed Joe Conway (jconway) 2 1 year 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 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) 2 1 year ago Rename trim_array() for consistency with the rest of array_* functions 5335 Withdrawn Refactoring Only 18 Not processed Aleksander Alekseev (a.alekseev) 1 1 year ago Improve error messages for database object stats manipulation functions during recovery 5336 Committed Not processed Fujii Masao (masaofujii) Maxim Orlov (m.orlov) Fujii Masao (masaofujii) 1 1 year ago Reorganize CacheMemoryContext 5337 Withdrawn Refactoring Only 18 Not processed Jeff Davis (jdavis) 1 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 Inconsistent output handling in 002_pg_upgrade.pl test logs 5339 Committed Bugfix Not processed Joel Jacobson (joeljacobson) Michael Paquier (michael-kun) 1 1 year ago Useless field ispartitioned in CreateStmtContext 5340 Rejected Refactoring Only Not processed hugo zhang (2689496754.qq.com) Kirill Reshke (reshke), Alena Rybakina (alenka) 1 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 Consider pipeline implicit transaction as a transaction block 5342 Committed Not processed Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) 1 1 year ago Increase 2Gb limit of memory GUC variables in 64-bit Windows 5343 Moved to different CF 18 Not processed Vladlen Popolitov (vladlenpopolitov) Tom Lane (tgl) Tom Lane (tgl) 2 1 year ago Always have pg_dump write rules in a consistent order 5344 Committed libpq Not processed Andreas Karlsson (kandreas) Tom Lane (tgl) Tom Lane (tgl) 1 1 year ago small pg_combinebackup improvements 5345 Committed Bugfix 18 Not processed Robert Haas (rhaas) Robert Haas (rhaas) 1 1 year ago Count and log pages set all frozen by vacuum 5346 Moved to different CF Monitoring Not processed Melanie Plageman (melanieplageman) Melanie Plageman (melanieplageman) 2 1 year ago Additional function inlining for slow_deform_heap_tuple 5347 Moved to different CF Performance Not processed David Rowley (davidrowley) David Rowley (davidrowley) 2 1 year ago Making error message more user-friendly with spaces in a URI 5348 Committed Refactoring Only Not processed Yushi Ogiwara (yushi) Michael Paquier (michael-kun) 1 1 year ago Fix for Extra Parenthesis in pgbench progress message 5349 Committed Bugfix Not processed Yushi Ogiwara (yushi) Fujii Masao (masaofujii) 1 1 year ago Remove useless casts to (void *) 5350 Committed Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago Proper object locking for GRANT/REVOKE 5351 Committed Refactoring Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 1 year ago event trigger matrix cleanup 5352 Committed Docs Only Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 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 Moved to different CF 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 Moved to different CF 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 8 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