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 19 hours 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 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 2 days 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 +5481−2592 Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) 14 9 hours 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 7 hours 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 Sequence Access Methods, round two 4677 Moved to different CF Needs rebase! Michael Paquier (michael-kun) 12 2 months 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 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 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 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 Eager aggregation, take 3 4881 Committed 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 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 4 days 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 [CREATE|RE] INDEX CONCURRENTLY with single heap scan 4971 Moved to different CF Performance DDL 19 10/10 +3039−486 Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Matthias van de Meent (mmeent) 9 3 days 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 10/10 +6−2 Matthias van de Meent (mmeent) Akshat Jaimini (akshatj) 8 2 months 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 relfilenode statistics 5007 Moved to different CF Monitoring 18 10/10 +691−83 Bertrand Drouvot (bertranddrouvot.pg) 10 4 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 5 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 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 new plpgsql.extra_errors check - strict_expr_check 5044 Withdrawn 9/10 +172−18 Pavel Stehule (okbobcz) Gilles Darold (darold), Kirk Wolak (kirkw), newtglobal postgresql_contributors (newtpostgrescontributors) 9 4 months 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 Inline non-SQL SRFs 5083 Committed Performance 19 10/10 +755−115 Paul Jungwirth (pjungwir) Tom Lane (tgl) Tom Lane (tgl) 5 4 months ago Incremental Sort Cost Estimation Instability 5093 Moved to different CF Bugfix 18 Needs rebase! Andrei Lepikhov (lepikhov) 8 9 months 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 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 Committed 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 VACUUM FULL / CLUSTER CONCURRENTLY 5117 Moved to different CF DDL 10/10 +4154−382 Antonin Houska (a.houska) Álvaro Herrera (alvherre), Mihail Nikalayeu (mihailnikalayeu) 9 1 hour 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 Asynchronous MergeAppend Execution 5129 Moved to different CF Performance 10/10 +1473−737 Alexander Pyhalov (a.pyhalov) Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) 8 5 days 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 psql client does not handle WSAEWOULDBLOCK on Windows 5154 Committed Bugfix 10/10 +15−12 Tom Lane (tgl), Umar Hayat (pgwizard) Tom Lane (tgl) 6 5 months 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 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 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 Allow CI to only run the compiler warnings task 5249 Withdrawn Testing 18 Needs rebase! Bertrand Drouvot (bertranddrouvot.pg) Rustam ALLAKOV (rustam.allakov) 5 9 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 jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 5270 Moved to different CF SQL Commands 10/10 +1232−27 Florents Tselai (florentst) David Wheeler (theory) Andrew Dunstan (adunstan) 5 yesterday 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 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 for consume_xids advancing XIDs incorrectly 5303 Moved to different CF Bugfix stable Needs rebase! Yushi Ogiwara (yushi) 6 2 months 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 Support enabling checksums online 5323 Moved to different CF Needs rebase! Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) Tomas Vondra (fuzzycz) 7 14 hours ago Parallel heap vacuum 5326 Moved to different CF Performance Needs rebase! Masahiko Sawada (masahikosawada) Hayato Kuroda (ha-kun) 7 6 months 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 Fix creation of empty .log files during log rotation 5365 Rejected 10/10 +15−12 Arseny Kositsin (arseny114) 4 4 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 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 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 Withdrawn Security 19 9/10 +25−17 Nathan Bossart (bossartn) 5 1 year ago Add 'make check-tests' behavior to the meson based builds 5405 Committed 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 postgres_fdw could deparse ArrayCoerceExpr 5409 Committed 18 10/10 +0−0 Alexander Pyhalov (a.pyhalov) Maxim Orlov (m.orlov) Alexander Korotkov (smagen) 4 8 months 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 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 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 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 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 speedup COPY TO for partitioned table 5467 Committed 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 SQL/JSON json_table PLAN clause 5478 Moved to different CF 18 9/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 Pull-up subquery if INNER JOIN-ON contains refs to upper-query 5487 Moved to different CF Performance 19 10/10 +1508−58 Alena Rybakina (a.rybakina) Ilia Evdokimov (ilidock95) 7 5 days ago Non-text mode for pg_dumpall 5495 Moved to different CF Monitoring 19 Needs rebase! Mahendra Singh Thalor (mahithalor) Vaibhav Dalvi (vaibhavdalvi) Andrew Dunstan (adunstan) 3 1 week ago Extended Statistics set/restore/clear functions 5517 Moved to different CF Needs rebase! Corey Huinker (coreyh) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 5 2 months ago Windows meson build 5522 Returned with feedback Docs Only 9/10 +45−12 Kohei Harikae (koheiharikae) Vladlen Popolitov (vladlenpopolitov) Peter Eisentraut (petere) 3 1 year ago add function argument name to substring and substr 5524 Moved to different CF Needs rebase! Jian He (stayreal) David Johnston (polobo) Peter Eisentraut (petere) 5 1 week ago Add storage I/O tracking to EXPLAIN BUFFERS 5526 Moved to different CF Monitoring 10/10 +1257−35 Atsushi Torikoshi (atsushitorikoshi) Jelte Fennema-Nio (jeltef) 6 2 weeks ago SVE enablement for hex-encode and hex-decode 5538 Committed Performance 19 10/10 +418−4 Chiranmoy Bhattacharya (chiranmoy), Susmitha Devanga (susmithad) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 5 months ago Document how commit handles aborted transactions 5546 Moved to different CF Backport Docs Only 10/10 +55−5 David Johnston (polobo) Kirill Reshke (reshke), Ahmed Ashour (ahmedashour) Tom Lane (tgl) 6 1 week ago Waiting for LSN replay with WAIT FOR command 5550 Committed Needs rebase! Alexander Korotkov (smagen), Xuneng Zhou (egoa) Yura Sokolov (funny_falcon) Alexander Korotkov (smagen) 3 2 months ago Expanding HOT updates for expression and partial indexes 5556 Moved to different CF Performance 19 Needs rebase! Greg Burd (gregburd) Nathan Bossart (bossartn) 6 1 week ago Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup 5570 Moved to different CF Multithreading AIO 10/10 +448−37 Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 7 3 weeks ago Improve ACL checks in pg_prewarm for indexes 5583 Committed Bugfix Needs rebase! Ayush Vatsa (developerayuva) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 4 5 months ago psql \dN[ti]: Describe tables and indexes that are NO partitions of others 5594 Moved to different CF libpq stable Needs rebase! Sadeq Dousti (msdousti) Greg Sabino Mullane (greg), Sergey Dudoladov (sdudoladov), Matt Dailis (mattdailis) 5 8 months ago Leaf and internal block access stats for indexes 5614 Moved to different CF Monitoring My First Patch Help - User Testing 19 Needs rebase! Mircea Cadariu (mcadariu) Frédéric Yhuel (yhuelf), lakshmi g (lakshmi) 6 1 month ago Corrupted FSM page is not saved after zeroing. 5615 Moved to different CF Bugfix 10/10 +3−0 Anton Melnikov (antonmel) 6 5 months ago Beautify read stream "per buffer data" APIs 5617 Moved to different CF Refactoring Only 10/10 +116−44 Thomas Munro (macdice) Nazir Bilal Yavuz (nbyavuz) 5 3 days ago Compress big WAL records 5621 Moved to different CF Performance Needs rebase! Andrey Borodin (x4m) Fujii Masao (masaofujii), Zsolt Parragi (zsolt.parragi) 5 3 weeks ago Reduce timing overhead of EXPLAIN ANALYZE using rdtsc 5622 Moved to different CF Performance 10/10 +1270−52 Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) 5 5 hours ago Make numeric type accessible to third-party code. 5623 Moved to different CF Refactoring Only Extensions stable 10/10 +290−285 Ed Behn (edbehn) Jelte Fennema-Nio (jeltef) 5 1 week ago support fast default for domain with constraints 5641 Moved to different CF 10/10 +222−26 Jian He (stayreal) Viktor Holmberg (rutchkiwi) Andrew Dunstan (adunstan) 5 3 weeks ago support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint 5645 Moved to different CF 10/10 +57−27 Jian He (stayreal) Matheus Alcantara (matheus.alcantara) Peter Eisentraut (petere) 5 1 month ago Accessing an invalid pointer in BufferManagerRelation structure 5646 Committed Bugfix 18 10/10 +44−40 Daniil Davydov (dddaniil) Stepan Neretin (snpgg), Dmitrii Bondar (difesu) Álvaro Herrera (alvherre) 3 5 months ago Fix slot synchronization with two_phase decoding enabled 5664 Moved to different CF Bugfix Backport 17 Needs rebase! Zhijie Hou (houzj) 4 9 months ago support create index on virtual generated column. 5667 Moved to different CF Needs rebase! Jian He (stayreal) Soumya S Murali (soumyamurali) 6 2 weeks ago Produce LLVM bitcode files on meson builds 5671 Moved to different CF Performance 19 10/10 +928−58 Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) Peter Eisentraut (petere) 5 3 days ago Random pg_upgrade 004_subscription test failure on drongo 5673 Moved to different CF Bugfix 10/10 +25−0 vigneshwaran C (vignesh.postgres) 4 5 months ago pg_restore documentation and --create/--single-transaction limitation 5676 Moved to different CF Docs Only 18 10/10 +6−1 Ashutosh Bapat (ashutoshbapat) Laurenz Albe (laurenz) Tom Lane (tgl) 5 5 days ago Add comments about fire_triggers argument in ri_triggers.c 5679 Moved to different CF Comments Only 10/10 +0−0 Yugo Nagata (yugo.nagata) Surya Poondla (spoondla) Amit Langote (amitlan) 5 4 days ago Improve coments on structures in trigger.c 5680 Moved to different CF Comments Only 10/10 +47−40 Yugo Nagata (yugo.nagata) 4 5 months ago Prevent internal error at concurrent CREATE OR REPLACE / ALTER FUNCTION 5681 Moved to different CF Bugfix 10/10 +132−19 Yugo Nagata (yugo.nagata) Jim Jones (jimus), Daniil Davydov (dddaniil) 6 6 months ago Add os_page_num to pg_buffercache 5690 Committed Monitoring 19 9/10 +333−96 Bertrand Drouvot (bertranddrouvot.pg) Mircea Cadariu (mcadariu) Michael Paquier (michael-kun) 3 4 months ago Create DATA dump objects for partitioned tables too 5692 Moved to different CF Performance Needs rebase! Tom Lane (tgl) 6 11 months ago Add pg_buffercache_mark_dirty[_all]() functions to the pg_buffercache 5694 Committed 10/10 +494−8 Nazir Bilal Yavuz (nbyavuz) Michael Paquier (michael-kun), Aidar Imamov (gipergeek) Michael Paquier (michael-kun) 3 4 months ago Allow to collect statistics on virtual generated columns 5714 Moved to different CF 19 Needs rebase! Yugo Nagata (yugo.nagata) Dean Rasheed (deanr) Dean Rasheed (deanr) 5 yesterday virtual generated column as partition key 5720 Moved to different CF 19 3/10 +665−65 Jian He (stayreal) Rustam ALLAKOV (rustam.allakov), Haibo Yan (billyean) 5 2 weeks ago temporary file usage report with extended protocol and unnamed portals 5724 Committed Bugfix 9/10 +16−13 Sami Imseih (simseih), Frédéric Yhuel (yhuelf) Mircea Cadariu (mcadariu) Michael Paquier (michael-kun) 3 4 months ago domain over virtual generated column 5725 Moved to different CF 19 Needs rebase! Jian He (stayreal) 4 10 months ago Enable auto-vectorization for page checksum calculations 5726 Moved to different CF Performance 19 10/10 +219−35 Matthew Sterrett (matthew.sterrett.intel.com), Andrew Kim (andrewk1) John Naylor (john.naylor) John Naylor (john.naylor) 3 1 hour ago Accounting for metapages in genericcostestimate() 5727 Moved to different CF Performance 9/10 +55−13 Tom Lane (tgl) Henson Choi (assam258.gmail.com) Tom Lane (tgl) 5 2 weeks ago Improve logicalrep_worker_launch() logic 5734 Moved to different CF Refactoring Only Needs rebase! Fujii Masao (masaofujii) Fujii Masao (masaofujii) 4 10 months ago Improve hash join's handling of tuples with null join keys 5738 Moved to different CF Performance 10/10 +414−82 Tom Lane (tgl) Chao Li (chaol) Tom Lane (tgl) 5 2 weeks ago Parallel processing of indexes in autovacuum 5755 Moved to different CF Performance 18 10/10 +616−33 Maxim Orlov (m.orlov), Daniil Davydov (dddaniil) Masahiko Sawada (masahikosawada), Sami Imseih (simseih) 5 6 hours ago finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it 5759 Moved to different CF 19 9/10 +367−70 Jian He (stayreal) Vaibhav Dalvi (vaibhavdalvi) Andrew Dunstan (adunstan) 5 2 weeks ago Add guard to prevent recursive memory context logging. 5766 Committed Bugfix 10/10 +40−18 Fujii Masao (masaofujii) Ian Ilyasov (ianilyasov), Artem Gavrilov (artem.gavrilov) Fujii Masao (masaofujii) 3 8 months ago ALTER DOMAIN ADD NOT NULL NOT VALID 5768 Moved to different CF 19 10/10 +219−29 Jian He (stayreal) Peter Eisentraut (petere) 6 1 month ago make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated 5769 Moved to different CF 19 9/10 +22−19 Jian He (stayreal) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 1 month ago Disallow concurrent ALTER DOMAIN and DROP DOMAIN 5773 Moved to different CF 19 0/10 +126−0 Jian He (stayreal) 4 2 months ago Extend skipping FK checks on replicas to include ADD FK and TRUNCATE 5774 Moved to different CF Performance Help - Stuck Rebasing Logical Replication 19 10/10 +96−3 Hannu Krosing (hannukrosing) 5 2 months ago Make wal_receiver_timeout configurable per subscription 5781 Moved to different CF 10/10 +245−101 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 5 1 month ago foreign key on virtual generated column 5782 Moved to different CF 19 Needs rebase! Jian He (stayreal) Srinath Reddy (srinath-reddy-sadipiralla) 5 4 months ago Add --continue-on-abort option to pgbench 5790 Committed 19 10/10 +171−33 Yugo Nagata (yugo.nagata), Rintaro Ikeda (rintaro) Yugo Nagata (yugo.nagata), Hayato Kuroda (ha-kun) Fujii Masao (masaofujii) 3 4 months ago alter check constraint enforceability 5796 Moved to different CF 19 10/10 +479−66 Jian He (stayreal) Amul Sul (sulamul), Robert Treat (xzilla), Kirill Reshke (reshke), Zsolt Parragi (zsolt.parragi) Andrew Dunstan (adunstan) 4 3 weeks ago Add log_autoanalyze_min_duration 5797 Committed GUC System Administration 19 10/10 +120−31 Shinya Kato (shinyakato) Tatsuhito Kasahara (tatsuhito.kasahara) Peter Eisentraut (petere) 3 5 months ago psql: tab-completion support for COPY ... TO/FROM STDIN, STDOUT, and PROGRAM 5800 Committed libpq 19 10/10 +44−24 Yugo Nagata (yugo.nagata) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 3 4 months ago Improve the performance of Unicode Normalization Forms. 5802 Moved to different CF Performance 10/10 +7706−12726 Alexander Borisov (lexborisov) Victor Yegorov (vyegorov) 5 1 week ago Support tid range scan in parallel 5803 Committed 10/10 +442−58 Cary Huang (cary) David Rowley (davidrowley) 2 4 months ago display current search_path in psql prompt 5808 Committed libpq 10/10 +21−0 Florents Tselai (florentst) Nathan Bossart (bossartn), Jim Jones (jimus) Nathan Bossart (bossartn) 3 5 months ago parallel pg_restore: avoid disk seeks when jumping short distance forward 5809 Committed Performance 19 10/10 +5−1 Dimitrios Apostolou (jimis) Tom Lane (tgl) Tom Lane (tgl) 2 5 months ago Improve tab completion for various SET/RESET forms 5810 Moved to different CF libpq 19 10/10 +74−11 Dagfinn Ilmari Mannsåker (ilmari) Shinya Kato (shinyakato) 3 4 months ago Expose internal MultiXact member count function for efficient monitoring 5811 Moved to different CF Monitoring 19 10/10 +394−14 Naga Appani (naga.appani) Atsushi Torikoshi (atsushitorikoshi) Michael Paquier (michael-kun) 4 3 months ago pg_restore add note about -n 5818 Moved to different CF Docs Only 10/10 +26−16 Florents Tselai (florentst) Álvaro Herrera (alvherre) 4 2 months ago Add \pset options for boolean value display 5828 Committed psql libpq 19 10/10 +120−1 David Johnston (polobo) Álvaro Herrera (alvherre) 3 5 months ago Support for 8-byte TOAST values (aka the TOAST infinite loop problem) 5830 Moved to different CF 19 Needs rebase! Michael Paquier (michael-kun) Tom Lane (tgl), Nikhil Kumar Veldanda (nikhilkumarv) 5 1 month ago pgindent: improve formatting of multiline comments 5831 Moved to different CF Good First Review Devtools 19 10/10 +36−0 Aleksander Alekseev (a.alekseev) Payal Singh (payal) 5 1 week ago Change the names generated for index partitions 5832 Moved to different CF 19 Needs rebase! Tom Lane (tgl) 4 6 months ago SQL:2011 Application Time Update & Delete 5836 Moved to different CF SQL Commands 19 Needs rebase! Paul Jungwirth (pjungwir) Peter Eisentraut (petere) Peter Eisentraut (petere) 5 1 week ago problems with toast.* reloptions 5839 Moved to different CF Bugfix stable Needs rebase! Nathan Bossart (bossartn) 6 8 months ago Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume 5841 Moved to different CF Performance 19 Needs rebase! Melanie Plageman (melanieplageman) Kirill Reshke (reshke) Melanie Plageman (melanieplageman) 5 yesterday Carefully exposing information without authentication 5845 Moved to different CF Monitoring 19 3/10 +466−0 Greg Sabino Mullane (greg) 3 1 week ago Docs and tests for RLS policies applied by command type 5851 Committed Testing Docs Only 19 10/10 +159−44 Dean Rasheed (deanr) Viktor Holmberg (rutchkiwi) Dean Rasheed (deanr) 3 4 months ago Allow ON CONFLICT DO SELECT/UPDATE to return EXCLUDED values 5854 Moved to different CF SQL Commands 19 9/10 +747−282 Dean Rasheed (deanr) Viktor Holmberg (rutchkiwi) 5 1 month ago docs: Include protocol version changes made without a version bump or extension 5863 Moved to different CF Docs Only 10/10 +22−104 Jelte Fennema-Nio (jeltef) 5 1 month ago Add prompt option to display read-only and read/write states in psql 5872 Moved to different CF psql Good First Review 19 10/10 +35−0 Jim Jones (jimus) Fujii Masao (masaofujii), Nathan Bossart (bossartn), Srinath Reddy (srinath-reddy-sadipiralla) Fujii Masao (masaofujii) 5 2 months ago Support for basic ALTER TABLE progress reporting. 5873 Moved to different CF Monitoring Needs rebase! Jiří Kavalík (jkavalik) Jian He (stayreal) 4 8 months ago Report bytes and transactions actually sent downtream 5877 Moved to different CF Monitoring Logical Replication 10/10 +434−166 Ashutosh Bapat (ashutoshbapat) 5 1 week ago amcheck: support for GiST 5879 Moved to different CF 10/10 +1034−110 Andrey Borodin (x4m) Sergey Dudoladov (sdudoladov), Miłosz Bieniek (moozzi) 4 2 months ago Decouple C++ support in Meson's PGXS from LLVM enablement 5885 Moved to different CF Good First Review Bugfix stable 10/10 +34−22 Tristan Partin (tristan957) Josef Šimánek (retro), Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 3 2 months ago Refactor bytea_sortsupport(), take two 5889 Moved to different CF Refactoring Only 19 10/10 +239−41 Aleksander Alekseev (a.alekseev) John Naylor (john.naylor) John Naylor (john.naylor) 3 4 months ago GIN tries to form a tuple with a partial compressedList during insertion 5890 Committed Bugfix 10/10 +0−0 Arseniy Mukhin (amukhin) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 2 5 months ago pg_restore --no-policies should not restore policies' comment 5891 Committed Bugfix Backport 18 10/10 +1−6 Jian He (stayreal) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 5 months ago Don't keep closed WAL segment in page cache after replay 5894 Moved to different CF Performance 19 10/10 +60−6 Anthonin Bonnefoy (bonnefoa) Hüseyin Demir (demir) 4 4 weeks ago Improve error reporting in 027_stream_regress test 5900 Committed Good First Review Testing 19 10/10 +0−0 Nazir Bilal Yavuz (nbyavuz) Ben Mejia (benmejia), Brandon Tat (bjtat) Michael Paquier (michael-kun) 2 4 months ago Making pg_rewind faster 5902 Committed Performance libpq 19 10/10 +215−13 Justin Kwan (justinpkwan.outlook.com), John Hsu (johnhsu) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 3 5 months ago Invalid pointer access in logical decoding after error 5903 Committed Logical Replication Needs rebase! vigneshwaran C (vignesh.postgres) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 2 5 months ago no table rewrite when set column type to constrained domain 5907 Moved to different CF 19 9/10 +167−10 Jian He (stayreal) Yogesh Sharma (sharmay), Viktor Holmberg (rutchkiwi), Aditya Gollamudi (adigoll) 4 1 week ago Unnecessary delay in streaming replication due to replay lag 5908 Moved to different CF Good First Review Logical Replication Physical Replication Backport GUC stable 9/10 +406−9 Sunil Seetharama (sunils26) Fujii Masao (masaofujii), Josef Šimánek (retro), Huansong Fu (huansong) 3 4 months ago Document DSM Registry 5914 Moved to different CF Docs Only 19 Needs rebase! Florents Tselai (florentst) 3 5 months ago ALTER TABLE ... OWNER TO affects permissions too 5915 Committed Good First Review Docs Only 19 10/10 +2−0 Laurenz Albe (laurenz) Daniel Gustafsson (d_gustafsson), Josef Šimánek (retro), Shuntian Jiao (jiaoshuntian) Daniel Gustafsson (d_gustafsson) 2 5 months ago Eagerly evict bulkwrite strategy ring 5919 Moved to different CF Performance 19 Needs rebase! Melanie Plageman (melanieplageman) 5 2 months ago Document AccessExclusive lock behaviour on standbys 5920 Withdrawn Docs Only 10/10 +8−0 Anthonin Bonnefoy (bonnefoa) 2 8 months ago update-po for PGXS does not work 5922 Committed Bugfix Good First Review 10/10 +5−0 Álvaro Herrera (alvherre), Ryo Matsumura (ryo) Bryan Green (lispyone) Álvaro Herrera (alvherre) 2 5 months ago Fix incorrect comment in pg_get_shmem_allocations_numa() 5927 Committed Comments Only 19 10/10 +6−9 Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 2 5 months ago Optimize join selectivity estimation for tables with large number of MCVs 5929 Committed Performance 19 0/10 +456−121 David Geier (geidav), Ilia Evdokimov (ilidock95) Tom Lane (tgl), Ilia Evdokimov (ilidock95) Tom Lane (tgl) 2 4 months ago Making jsonb_agg() faster 5930 Moved to different CF Performance Needs rebase! Tom Lane (tgl) Tom Lane (tgl) 3 2 months ago Enhancing Memory Context Statistics Reporting 5938 Moved to different CF Monitoring 19 Needs rebase! Rahila Syed (rahila) Atsushi Torikoshi (atsushitorikoshi) 4 3 weeks ago Improve LWLock tranche name visibility across backends 5940 Moved to different CF Monitoring 19 10/10 +535−174 Sami Imseih (simseih) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 4 months ago CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 5941 Moved to different CF SQL Commands 19 10/10 +2698−108 Jian He (stayreal) Corey Huinker (coreyh) Peter Eisentraut (petere) 4 19 hours ago Adding locks statistics 5942 Moved to different CF Monitoring 19 10/10 +50−18 Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 4 4 days ago Correction of RowMark Removal During Sel-Join Elimination 5943 Committed Bugfix 19 Needs rebase! Andrei Lepikhov (lepikhov) Alexander Korotkov (smagen) 2 7 months ago Fixing the btree_gist inet mess 5944 Moved to different CF Bugfix 19 10/10 +2206−9 Tom Lane (tgl) Peter Eisentraut (petere), Matthias van de Meent (mmeent) Tom Lane (tgl) 3 2 months ago Adding per backend commit and rollback counters 5947 Moved to different CF Monitoring 19 10/10 +304−2 Bertrand Drouvot (bertranddrouvot.pg) Miłosz Bieniek (moozzi), Kuba Knysiak (xsni12) 4 4 days ago psql: Count all table footer lines in pager setup 5949 Committed psql libpq stable 10/10 +382−84 Erik Wienhold (ewie) Tom Lane (tgl), lakshmi g (lakshmi) Tom Lane (tgl) 2 5 months ago pg_waldump: support decoding of WAL inside tarfile 5955 Moved to different CF 19 10/10 +1557−251 Amul Sul (sulamul) Andrew Dunstan (adunstan) 4 13 hours ago Enhance statistics reset functions to return reset timestamp 5956 Withdrawn 19 9/10 +307−239 Shinya Kato (shinyakato) 2 5 months ago implement CAST(expr AS type FORMAT 'template') 5957 Moved to different CF 19 Needs rebase! Jian He (stayreal) Corey Huinker (coreyh), Surya Poondla (spoondla) 4 3 days ago Per backend relation statistics tracking 5958 Moved to different CF Monitoring 19 9/10 +261−2 Bertrand Drouvot (bertranddrouvot.pg) 4 7 months ago Import Statistics in postgres_fdw before resorting to sampling. 5959 Moved to different CF 19 Needs rebase! Corey Huinker (coreyh) Etsuro Fujita (efujita) 4 22 hours ago Tab completion for large objects 5963 Committed libpq 10/10 +12−5 Dagfinn Ilmari Mannsåker (ilmari) Fujii Masao (masaofujii) Fujii Masao (masaofujii) 2 5 months ago Add mode and reason columns to pg_stat_progress_vacuum 5969 Moved to different CF Monitoring 19 10/10 +179−10 Shinya Kato (shinyakato) Nathan Bossart (bossartn), Sami Imseih (simseih) Masahiko Sawada (masahikosawada) 3 3 months ago Panic during xlog building with big values 5970 Moved to different CF Bugfix 19 10/10 +52−0 Maksim Melnikov (manaldush) Andy Pogrebnoi (birdofdada) 3 5 months ago plpython: Remove support for major version conflict detection 5972 Committed PL/Python 10/10 +4−61 Peter Eisentraut (petere) Euler Taveira (eulerto), Mario Gonzalez (gonzalemario) Peter Eisentraut (petere) 2 5 months ago When deleting the plpgsql function, release the CachedPlan of the function 5975 Moved to different CF PL/pgSQL 19 9/10 +118−2 Man Zeng (zengman) 3 6 months ago Improve initial slot synchronization in pg_sync_replication_slots() 5976 Committed Logical Replication 19 10/10 +95−53 Ajin Cherian (ajinc) Amit Kapila (amitkapila) 2 4 weeks ago Align tests for stored and virtual generated columns 5981 Moved to different CF Testing Needs rebase! Yugo Nagata (yugo.nagata) Paul Jungwirth (pjungwir), mutaamba maasha (mutaambam) Peter Eisentraut (petere) 4 1 week ago JIT works only partially with meson build 5984 Moved to different CF Docs Only Needs rebase! Yugo Nagata (yugo.nagata) Laurenz Albe (laurenz) 4 6 months ago CREATE SCHEMA ... CREATE DOMAIN support 5985 Moved to different CF SQL Commands 19 10/10 +908−149 Jian He (stayreal) Tom Lane (tgl) 4 20 hours ago disallow alter individual column if partition key contains wholerow reference 5988 Moved to different CF Bugfix Backport 18 10/10 +39−0 Jian He (stayreal) Sergey Dudoladov (sdudoladov), Matt Dailis (mattdailis) 4 5 months ago bug: virtual generated column can be partition key 5989 Committed Bugfix Backport 18 10/10 +86−40 Ashutosh Bapat (ashutoshbapat) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 5 months ago Fix ALTER TABLE DROP EXPRESSION with ONLY option 5992 Moved to different CF Bugfix stable 3/10 +6−6 Jian He (stayreal) Peter Eisentraut (petere), Kirill Reshke (reshke), lakshmi g (lakshmi) Peter Eisentraut (petere) 4 3 months ago extensible planner state 5994 Committed Extensions Refactoring Only 19 10/10 +0−0 Robert Haas (rhaas) Tom Lane (tgl) Robert Haas (rhaas) 2 5 months ago GetNamedLWLockTranche crashes on Windows in normal backend 5995 Moved to different CF Bugfix 10/10 +244−0 Sami Imseih (simseih) Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 6 months ago Treat semaphores similar to other shared memory structures 5997 Committed Refactoring Only 10/10 +11−31 Ashutosh Bapat (ashutoshbapat) Heikki Linnakangas (heikki) 2 4 months ago plan shape work 5998 Committed Extensions Refactoring Only 19 10/10 +810−653 Robert Haas (rhaas) Robert Haas (rhaas) 2 5 months ago Optimize JsonbContainerTypeName by reordering type checks 6000 Withdrawn Refactoring Only Performance 19 10/10 +5−5 Chao Li (chaol) 2 6 months ago minor refactor on src/test/modules/test_ddl_deparse/sql/alter_table.sql 6001 Moved to different CF Refactoring Only 19 10/10 +36−32 Jian He (stayreal) Heikki Linnakangas (heikki) 3 7 months ago Add memory_limit_hits to pg_stat_replication_slots 6002 Committed Logical Replication 19 10/10 +112−59 Bertrand Drouvot (bertranddrouvot.pg) Masahiko Sawada (masahikosawada) 2 5 months ago Reset recovery target parameters in pg_createsubscriber 6004 Committed Bugfix My First Patch 18 7/10 +161−21 Alyona Vinter (dlaaren) Ian Ilyasov (ianilyasov), mutaamba maasha (mutaambam) Michael Paquier (michael-kun) 2 4 months ago Avoid overwiriting cache entry (src/backend/utils/cache/relcache.c) 6008 Committed 19 10/10 +5−6 Ranier Vilela (raniervilela) Álvaro Herrera (alvherre) 2 5 months ago ALTER COLUMN SET EXPRESSION [GENERATED|STORED] 6010 Moved to different CF 19 Needs rebase! Jian He (stayreal) 4 2 months ago List TAP test files in makefiles 6011 Rejected Refactoring Only 0/10 +63−0 Peter Eisentraut (petere) Nathan Bossart (bossartn) 2 5 months ago pgbench: extend variable usage in scripts 6012 Moved to different CF libpq 19 Needs rebase! Yugo Nagata (yugo.nagata) lakshmi g (lakshmi) 5 2 months ago Add process updating for GNU/Hurd 6013 Committed 10/10 +0−0 Michael Banck (mbanck) Thomas Munro (macdice) 2 4 months ago Add error_on_null() to produce an error if the input is null 6017 Committed 9/10 +74−0 Joel Jacobson (joeljacobson) Vik Fearing (xocolatl) Michael Paquier (michael-kun) 2 5 months ago ternary reloption type 6021 Moved to different CF Refactoring Only 19 10/10 +323−131 Nikolay Shaplov (nataraj) Álvaro Herrera (alvherre) 3 2 months ago Use streaming read I/O in BRIN vacuuming 6022 Committed 9/10 +23−9 Arseniy Mukhin (amukhin) Masahiko Sawada (masahikosawada) Masahiko Sawada (masahikosawada) 2 4 months ago Stack-based tracking of per-node WAL/buffer usage 6023 Moved to different CF Performance 19 10/10 +3096−682 Lukas Fittl (lfittl) Zsolt Parragi (zsolt.parragi) 4 5 hours ago Improve read_local_xlog_page_guts by replacing polling with latch-based waiting 6024 Moved to different CF Performance Logical Replication 19 10/10 +40−11 Xuneng Zhou (dylanzhou) 3 2 months ago Get rid of pgstat_count_backend_io_op*() functions 6025 Moved to different CF Performance Refactoring Only 19 10/10 +31−57 Bertrand Drouvot (bertranddrouvot.pg) 3 6 months ago Fix a bug where ALTER SYSTEM SET with empty strings for GUC_LIST_QUOTE parameters (like shared_preload_libraries) results in malformed configuration entries that cause server crashes on restart. 6026 Committed Bugfix stable 9/10 +126−16 Andrew Klychkov (andreiklychkov) Tom Lane (tgl), Jim Jones (jimus) Tom Lane (tgl) 1 4 months ago Use enum type replacing #define for exec state of hashjoin and mergejoin 6027 Moved to different CF Needs rebase! Tender Wang (tndrwang) 4 5 months ago Support existing publications in pg_createsubscriber. 6028 Moved to different CF 19 Needs rebase! Shubham Khanna (skhanna) Euler Taveira (eulerto), Peter Smith (smithpb2250) Amit Kapila (amitkapila) 2 3 months ago NOT NULL NOT ENFORCED 6029 Moved to different CF DDL 19 2/10 +832−109 Jian He (stayreal) Haritabh Gupta (haritabhgupta), Kuba Knysiak (xsni12) Álvaro Herrera (alvherre) 3 1 month ago fix NOT VALID NOT NULL with ALTER COLUMN SET IDENTITY 6030 Committed Bugfix Backport 18 10/10 +37−0 Jian He (stayreal) Álvaro Herrera (alvherre) 1 5 months ago UPDATE with invalid domain constraint 6031 Moved to different CF Bugfix Backport stable 0/10 +114−0 Jian He (stayreal) 3 7 months ago revert some recent changes to RequestNamedLWLockTranche() 6032 Moved to different CF 19 Not processed Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 4 months ago PgStat_HashKey padding issue when passed by value 6033 Moved to different CF Bugfix 10/10 +19−13 Michael Paquier (michael-kun) Sami Imseih (simseih) Michael Paquier (michael-kun) 2 6 months ago Fix inconsistencies with code and beautify xlog structures description and fin hash_xlog.h 6034 Committed Comments Only stable Needs rebase! Kirill Reshke (reshke) Michael Paquier (michael-kun) 1 6 months ago Allow using replication origins in SQL level parallel sessions 6035 Withdrawn Good First Review Logical Replication 19 9/10 +30−1 Emre Hasegeli (hasegeli) 1 6 months ago Update parser README to include parse_jsontable.c 6036 Committed Comments Only 19 Needs rebase! Karthik S (karthikselvaam.gmail.com) Michael Paquier (michael-kun) 1 6 months ago Fix race condition in SSI when reading PredXact->SxactGlobalXmin 6037 Moved to different CF Bugfix Backport My First Patch stable 10/10 +259−13 Josh Curtis (joshcurtis) Mihail Nikalayeu (mihailnikalayeu) 3 1 week ago Timeline switching with partial WAL records can break replica recovery 6038 Moved to different CF Bugfix 18 Needs rebase! Alyona Vinter (dlaaren) Artem Gavrilov (artem.gavrilov) 2 2 months ago Fix read/write races with pg_control file in case when postgres was compiled with DEXEC_BACKEND option 6040 Moved to different CF Bugfix 19 10/10 +32−1 Maksim Melnikov (manaldush) 2 4 months ago Fix pg_rewind false positives caused by shutdown-only WAL 6041 Moved to different CF Bugfix 8/10 +193−24 Srinath Reddy (srinath-reddy-sadipiralla) 2 5 months ago fix shmem_startup_hook documentation 6042 Moved to different CF Docs Only 16 10/10 +22−10 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 6 months ago Checkpointer write combining 6043 Moved to different CF Performance Needs rebase! Melanie Plageman (melanieplageman) Soumya S Murali (soumyamurali) 3 1 month ago PostgreSQL crashes with ThreadSanitizer during early initialization 6044 Committed Bugfix My First Patch 8/10 +62−28 Emmanuel Sibi (emmanuelsibi) Tom Lane (tgl) 1 4 months ago Mark ItemPointer arguments as const thoughoutly 6046 Committed Refactoring Only 9/10 +100−100 Chao Li (chaol) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 5 months ago Fix replica identity mismatch for partitioned tables with publish_via_partition_root 6047 Moved to different CF Bugfix Logical Replication stable 9/10 +211−38 Mikhail Kharitonov (mkharitonov) 3 2 months ago Display is_prev_bucket_same_wrt of xl_hash_squeeze_page 6048 Moved to different CF Bugfix Backport Needs rebase! Kirill Reshke (reshke) Michael Paquier (michael-kun) 2 6 months ago Unexpected changes of CurrentResourceOwner and CurrentMemoryContext 6051 Moved to different CF Bugfix stable 10/10 +15−0 Antonin Houska (a.houska) Mihail Nikalayeu (mihailnikalayeu) Álvaro Herrera (alvherre) 2 6 months ago Add support for entry counting in pgstats 6052 Committed Monitoring 19 Needs rebase! Michael Paquier (michael-kun) Sami Imseih (simseih) Michael Paquier (michael-kun) 1 6 months ago Report reorder buffer size 6053 Moved to different CF Monitoring Logical Replication 10/10 +75−11 Ashutosh Bapat (ashutoshbapat) Masahiko Sawada (masahikosawada) 3 6 months ago let ALTER COLUMN SET DATA TYPE cope with POLICY dependency 6054 Moved to different CF 19 9/10 +705−61 Jian He (stayreal) 3 6 months ago let ALTER TABLE DROP COLUMN drop whole-row referenced object 6055 Moved to different CF Bugfix Backport stable 3/10 +634−5 Jian He (stayreal) 3 1 month ago meson: Fix libpq search order 6056 Moved to different CF Bugfix Needs rebase! Thomas Munro (macdice) Mario Gonzalez (gonzalemario) 3 4 months ago Fix missing EvalPlanQual recheck for TID scans 6057 Moved to different CF Bugfix Backport My First Patch 10/10 +84−25 Sophie Alpert (sophiebits) David Rowley (davidrowley) 2 6 months ago Marking shared buffer lookup table as HASH_FIXED_SIZE 6058 Moved to different CF Refactoring Only 10/10 +1−1 Ashutosh Bapat (ashutoshbapat) Andres Freund (andresfreund) 2 6 months ago Improving the names generated for indexes on expressions 6059 Moved to different CF 10/10 +265−159 Tom Lane (tgl) 3 5 months ago MPTCP - multiplexing many TCP connections through one socket to get better bandwidth 6061 Moved to different CF Performance 19 0/10 +72−2 Jakub Wartak (jakub.wartak.tomtom) 2 7 months ago CREATE/ALTER PUBLICATION improvements for syntax synopsis 6062 Committed Docs Only Good First Review 18 Needs rebase! Peter Smith (smithpb2250) Fujii Masao (masaofujii) 1 4 months ago DOCS: What SGML markup to use for user objects like tables, columns, etc? 6063 Committed Docs Only stable 9/10 +0−0 Peter Smith (smithpb2250) Bruce Momjian (bmomjian) 1 4 months ago CREATE TABLE LIKE INCLUDING POLICIES 6064 Moved to different CF 19 Needs rebase! Jian He (stayreal) lakshmi g (lakshmi) 3 1 month ago fix re-initialization of LWLock-related shared memory 6065 Moved to different CF Bugfix 19 9/10 +19−1 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 6 months ago Negative RelfilenumberMap cache entries from pg_filenode_relation() 6066 Withdrawn Good First Review Security 10/10 +31−9 Ashutosh Bapat (ashutoshbapat) 1 6 months ago Include extension path on pg_available_extensions 6067 Moved to different CF Extensions System Administration 10/10 +145−39 Matheus Alcantara (matheus.alcantara) Rohit Prasad (rohitprasad) Andrew Dunstan (adunstan) 2 3 months ago fix obsolete references to postgres.h in comments 6068 Moved to different CF Comments Only 19 10/10 +5−5 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 6 months ago Free memory allocated by waitonlock_error_callback() 6069 Withdrawn 19 10/10 +2−0 Aleksander Alekseev (a.alekseev) 1 5 months ago MultiXact corruption and standby deadlock 6070 Committed Bugfix 10/10 +7−2 Andrey Borodin (x4m) Ivan Bykov (ibykov) Heikki Linnakangas (heikki) 1 4 months ago Doc: add XML ID attributes to <varlistentry> tags for create_foreign_table, alter_foreign_table 6071 Moved to different CF Docs Only stable 10/10 +63−63 Jian He (stayreal) Zongliang Quan (quanzl) Peter Eisentraut (petere) 3 1 month ago Replace relation_{open,close} to table_{open,close} in policy.c 6072 Moved to different CF Good First Review stable 10/10 +6−7 Jian He (stayreal) Shinya Kato (shinyakato) Peter Eisentraut (petere) 3 1 month ago We broke the defense against accessing other sessions' temp tables 6073 Moved to different CF Bugfix 17 Needs rebase! Tom Lane (tgl) Jim Jones (jimus) 3 5 months ago Disallow BEGIN ATOMIC SQL functions depending on temp relations 6074 Committed 19 10/10 +58−57 Jim Jones (jimus) Tom Lane (tgl) Tom Lane (tgl) 2 4 months ago Add assertion for bmr.rel in ExtendBufferedRelTo function 6075 Moved to different CF Bugfix 16 Not processed Алена Васильева (eugenygoryachev) 2 5 months ago a couple of small patches for simd.h 6076 Committed 19 10/10 +10−27 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 6 months ago pgstattuple "unexpected zero page" for gist and hash indexes 6077 Committed Bugfix 19 10/10 +16−6 Nitin Motiani (nitinmotiani) Dilip Kumar (dilip.kumar) Michael Paquier (michael-kun) 1 6 months ago Optimize LISTEN/NOTIFY 6078 Moved to different CF Performance 10/10 +1161−184 Joel Jacobson (joeljacobson) Tom Lane (tgl) Tom Lane (tgl) 2 2 months ago Avoiding roundoff error in pg_sleep() 6080 Moved to different CF Bugfix 10/10 +20−9 Tom Lane (tgl) Tom Lane (tgl) 2 6 months ago Mark function arguments of type "Datum *" as "const Datum *" where possible 6081 Committed Refactoring Only 19 10/10 +151−151 Chao Li (chaol) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 5 months ago Add stats related to slot sync skip 6082 Moved to different CF Needs rebase! Shlok Kyal (shlokkyal) Amit Kapila (amitkapila) 2 4 months ago Make few enhancements in GIN redo and GIN pg_waldump . 6083 Committed Performance stable Needs rebase! Kirill Reshke (reshke) Michael Paquier (michael-kun) 1 5 months ago Allow setting the collation strength in ICU tailoring rules. 6084 Moved to different CF 10/10 +17−1 Daniel Vérité (danielverite) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 2 weeks ago GROUP BY ALL 6085 Moved to different CF SQL Commands 19 10/10 +300−4 David Christensen (davidchristensen) Tom Lane (tgl) Tom Lane (tgl) 2 6 months ago Add jsonb_translate(jsonb, from, to) 6086 Withdrawn SQL Commands 19 9/10 +210−0 Florents Tselai (florentst) 1 6 months ago CREATE TABLE LIKE INCLUDING TRIGGERS 6087 Moved to different CF SQL Commands 19 10/10 +556−23 Jian He (stayreal) Andrey Borodin (x4m), Zsolt Parragi (zsolt.parragi) 3 1 week ago create table like including storage parameter 6088 Moved to different CF SQL Commands 19 10/10 +218−9 Jian He (stayreal) 3 yesterday let ALTER COLUMN SET DATA TYPE cope with trigger dependency 6089 Moved to different CF 19 9/10 +496−27 Jian He (stayreal) 3 2 months ago Clarify EXPLAIN ANALYZE docs on fractional rows and parallelism 6090 Moved to different CF Docs Only 10/10 +60−4 Maciek Sakrejda (msakrejda) Tom Lane (tgl), Ilia Evdokimov (ilidock95) Tom Lane (tgl) 3 1 week ago Accept connections post recovery without waiting for RemoveOldXlogFiles 6091 Moved to different CF 19 10/10 +61−1 Nitin Motiani (nitinmotiani) 2 6 months ago Fix const-simplification for index expressions and predicate 6092 Committed Bugfix 19 10/10 +102−10 Richard Guo (richardguo) Richard Guo (richardguo) 1 6 months ago Fix pushdown of degenerate HAVING clauses 6093 Committed Bugfix 18 10/10 +0−0 Richard Guo (richardguo) Richard Guo (richardguo) 1 5 months ago Allow virtual columns in index expressions or predicate 6094 Moved to different CF 19 Needs rebase! Richard Guo (richardguo) 2 6 months ago LISTEN/NOTIFY bug: VACUUM sets frozenxid past a xid in async queue 6095 Committed Bugfix Help - Bikeshedding Needs rebase! Matheus Alcantara (matheus.alcantara) Arseniy Mukhin (amukhin) Heikki Linnakangas (heikki) 1 4 months ago Infinite loop in pgbench when running COPY command 6096 Committed Bugfix stable 10/10 +24−0 Anthonin Bonnefoy (bonnefoa) Michael Paquier (michael-kun) 1 6 months ago Add stats_reset to pg_stat_all_tables|indexes and related views 6097 Committed Monitoring 19 10/10 +776−619 Bertrand Drouvot (bertranddrouvot.pg) Michael Paquier (michael-kun) 1 5 months ago disallow big-endian on aarch64 6098 Withdrawn 19 Not processed Nathan Bossart (bossartn) 1 6 months ago sql/json query function JsonBehavior default expression's collation may differ from returning type's collation 6100 Committed Bugfix Backport stable 10/10 +113−14 Jian He (stayreal) Amit Langote (amitlan) 1 5 months ago use SIMD in GetPrivateRefCountEntry() 6101 Moved to different CF Performance 19 Needs rebase! Nathan Bossart (bossartn) 2 5 months ago Termination of Background Workers for ALTER/DROP DATABASE 6102 Moved to different CF Monitoring 10/10 +268−6 Aya Iwata (iwata.aya) Pavel Stehule (okbobcz) Michael Paquier (michael-kun) 2 2 months ago Remove Item type 6104 Committed Refactoring Only 9/10 +109−184 Peter Eisentraut (petere) Nathan Bossart (bossartn) Peter Eisentraut (petere) 1 5 months ago Reorganize GUC structs 6105 Committed Multithreading Refactoring Only Needs rebase! Peter Eisentraut (petere) Peter Eisentraut (petere) 1 4 months ago refactor CreateStatsStmt 6106 Moved to different CF Refactoring Only 19 10/10 +149−101 Jian He (stayreal) Álvaro Herrera (alvherre) 3 4 months ago Cleanup INFINITY related code in float.h 6107 Committed Refactoring Only 19 10/10 +9−44 David Rowley (davidrowley) David Rowley (davidrowley) 1 5 months ago Preferred use of macro GetPGProcByNumber 6108 Committed Refactoring Only 19 10/10 +9−9 Maksim Melnikov (manaldush) David Rowley (davidrowley) 1 6 months ago ON CONFLICT DO SELECT 6109 Moved to different CF SQL Commands 19 10/10 +1677−367 Viktor Holmberg (rutchkiwi) Dean Rasheed (deanr), Jian He (stayreal) Dean Rasheed (deanr) 3 1 month ago ecpg: check return value of replace_variables() 6110 Committed Bugfix 19 6/10 +7−1 Aleksander Alekseev (a.alekseev) Daniel Gustafsson (d_gustafsson) 1 5 months ago add objects file path to oid2name 6111 Moved to different CF 9/10 +7−7 david bidoc (dwayne) Laurenz Albe (laurenz), Phil Alger (paalger) Michael Paquier (michael-kun) 3 1 month ago Remove unused #include's 6112 Withdrawn Refactoring Only 19 10/10 +0−64 Aleksander Alekseev (a.alekseev) 1 5 months ago Little refactoring of portalcmds.c 6113 Moved to different CF Refactoring Only Good First Review 10/10 +16−24 Aleksander Alekseev (a.alekseev) 4 5 months ago incremental autovacuum scheduling improvements 6114 Moved to different CF 19 10/10 +481−48 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 3 1 week ago doc: Improve description of io_combine_limit and io_max_combine_limit GUCs 6115 Committed Backport Docs Only 10/10 +16−9 Karina Litskevich (karinalitskevich) Chao Li (chaol) Fujii Masao (masaofujii) 1 4 months ago Add Windows support for backtrace_functions (MSVC only) 6116 Moved to different CF My First Patch 19 10/10 +174−3 Bryan Green (lispyone) Álvaro Herrera (alvherre) 3 1 month ago Add generic routine to retrieve PG_VERSION contents (Executing pg_createsubscriber with a non-compatible control file) 6117 Committed 19 10/10 +30−84 Michael Paquier (michael-kun) Michael Paquier (michael-kun) 1 5 months ago Preserve index stats during ALTER TABLE ... TYPE ... 6118 Moved to different CF Bugfix 19 10/10 +576−4 Bertrand Drouvot (bertranddrouvot.pg) Yogesh Sharma (sharmay) 3 5 months ago Migrate pg_commit_ts directory to the new node during an upgrade 6119 Moved to different CF 19 8/10 +353−3 Sergey Levin (lsv) Hayato Kuroda (ha-kun), Maxim Orlov (m.orlov) 3 1 week ago Remove make_temptable_name_n() 6120 Committed Refactoring Only 19 10/10 +15−26 Aleksander Alekseev (a.alekseev) Nathan Bossart (bossartn) 1 5 months ago avoid call ATPostAlterTypeCleanup twice 6121 Moved to different CF Bugfix Backport stable 10/10 +88−0 Jian He (stayreal) 3 5 months ago Fix CancelRequest documentation for protocol 3.2 6123 Committed Docs Only 18 10/10 +0−0 Jelte Fennema-Nio (jeltef) Magnus Hagander (mha) 1 5 months ago Allow reads to proceed during FK/trigger drops by reducing relation-level lock from AccessExclusive to ShareRowExclusive 6124 Withdrawn My First Patch 19 10/10 +285−10 Shayon Mukherjee (shayonj) 1 5 months ago pgstattuple: Use streaming read API in pgstatindex functions 6125 Moved to different CF Extensions AIO Performance 19 Needs rebase! Xuneng Zhou (dylanzhou) Shinya Kato (shinyakato) Michael Paquier (michael-kun) 3 4 months ago Fix incorrect fprintf usage in log_error FRONTEND path 6126 Committed Bugfix Good First Review 19 10/10 +15−4 Bryan Green (lispyone) Tom Lane (tgl) 1 5 months ago GIN pageinspect support for entry tree and non-leaf posting tree 6128 Moved to different CF Extensions stable 0/10 +794−43 Kirill Reshke (reshke) Andrey Borodin (x4m), Japin Li (japin), Chao Li (chaol) 3 2 months ago pg_createsubscriber --dry-run logging concerns 6129 Committed System Administration 19 2/10 +23−4 Peter Smith (smithpb2250) Álvaro Herrera (alvherre) 1 4 months ago pg_createsubscriber - more logging to say if there are no pubs to drop 6130 Withdrawn Good First Review System Administration 10/10 +9−4 Peter Smith (smithpb2250) Masahiko Sawada (masahikosawada) 1 5 months ago Add pg_get_trigger_ddl() to retrieve the CREATE TRIGGER statement 6131 Moved to different CF Good First Review My First Patch 19 10/10 +312−0 Phil Alger (paalger) Josef Šimánek (retro), Jim Jones (jimus) 3 4 months ago Issue with synced logical replication slot during switchover 6132 Moved to different CF Bugfix Logical Replication My First Patch 19 10/10 +9−5 Fabrice Chapuis (fabricec) Alexander Kukushkin (cyberdem0n) 2 4 months ago Extend documentation for pg_stat_replication.backend_xmin 6133 Committed Docs Only 19 9/10 +4−0 Renzo Dani (renzo.dani) Fujii Masao (masaofujii) 1 5 months ago remove partColsUpdated 6134 Committed Refactoring Only 19 10/10 +0−27 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 5 months ago pg_stat_statements: faster search by queryid 6136 Moved to different CF Performance Needs rebase! Karina Litskevich (karinalitskevich) 2 5 months ago postgres_fdw: Use COPY to speed up batch inserts 6137 Moved to different CF Performance 10/10 +449−9 Matheus Alcantara (matheus.alcantara) Masahiko Sawada (masahikosawada) 3 2 days ago Fix lag columns in pg_stat_replication not advancing when replay LSN stalls 6138 Committed Bugfix Backport 10/10 +13−0 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 5 months ago Invalid primary_slot_name triggers warnings in all processes on reload 6139 Committed Bugfix Backport GUC 9/10 +58−2 Fujii Masao (masaofujii) Fujii Masao (masaofujii) 1 5 months ago track ABI breaks in stable branches 6140 Committed stable 10/10 +24−0 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 5 months ago Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array 6141 Moved to different CF Performance Logical Replication Refactoring Only 19 10/10 +307−69 Xuneng Zhou (dylanzhou) Kirill Reshke (reshke) 3 2 months ago Fix POSIX compliance in pgwin32_unsetenv() 6142 Committed 19 10/10 +0−0 Bryan Green (lispyone) Michael Paquier (michael-kun) 1 5 months ago BRIN: Prevent the heapblk overflow during index summarization on very large tables resulting in an infinite loop 6143 Committed Bugfix Good First Review Backport stable 10/10 +10−4 Sunil Seetharama (sunils26) David Rowley (davidrowley) 1 5 months ago refactor func-matching.sgml, make regexp* function more readable 6144 Moved to different CF Docs Only 19 9/10 +114−76 Jian He (stayreal) Tom Lane (tgl) Tom Lane (tgl) 3 1 week ago Fix race condition in SSI when reading PredXact->SxactGlobalXmin 6145 Withdrawn Bugfix 9/10 +15−13 Josh Curtis (joshcurtis) Mihail Nikalayeu (mihailnikalayeu) 1 1 week ago Alow ALTER COLUMN TYPE when dependent generated column has SET EXPRESSION 6146 Moved to different CF 19 Needs rebase! Chao Li (chaol) 2 5 months ago pg_recvlogical: Prevent flushed data from being re-sent after restarting replication 6147 Moved to different CF Logical Replication 10/10 +160−37 Fujii Masao (masaofujii) Mircea Cadariu (mcadariu) Fujii Masao (masaofujii) 2 2 months ago CI: Add task that runs pgindent 6148 Moved to different CF CI Testing 10/11 +40−2 Jelte Fennema-Nio (jeltef) 4 4 months ago A tidyup for match_orclause_to_indexcol() 6149 Committed 9/10 +45−70 Tender Wang (tndrwang) Tom Lane (tgl) Tom Lane (tgl) 1 4 months ago Add wal_fpi_bytes to pg_stat_wal 6150 Committed Monitoring 19 10/10 +0−0 Shinya Kato (shinyakato) Michael Paquier (michael-kun) 1 5 months ago fix type of infomask parameter in static inline functions 6151 Committed Refactoring Only 19 10/10 +3−3 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 1 5 months ago Optimization of the is_normalized() function. 6152 Moved to different CF Performance 19 Needs rebase! Alexander Borisov (lexborisov) 3 5 months ago issue with synchronized_standby_slots 6153 Committed GUC Logical Replication 19 10/10 +41−43 Shlok Kyal (shlokkyal) Fujii Masao (masaofujii) Amit Kapila (amitkapila) 1 5 months ago docs: Link to the correct protocol version inspection function External 6154 Committed Docs Only 9/10 +0−0 Jelte Fennema-Nio (jeltef) Peter Eisentraut (petere) 1 5 months ago Add a warning on stats manipulation functions 6155 Moved to different CF Docs Only 19 Needs rebase! Yugo Nagata (yugo.nagata) 3 5 months ago Add GoAway protocol message for graceful but fast server shutdown/switchover 6156 Moved to different CF libpq 10/10 +553−21 Jelte Fennema-Nio (jeltef) 4 4 days ago libpq: Bump protocol version to version 3.2 at least until the first/second beta (aka protocol grease) 6157 Moved to different CF libpq 10/10 +140−15 Jelte Fennema-Nio (jeltef) Jacob Champion (jchampion) Jacob Champion (jchampion) 3 1 month ago Use log_newpage_range in HASH index build 6158 Moved to different CF Performance stable Needs rebase! Kirill Reshke (reshke) lakshmi g (lakshmi) 2 2 months ago Consistently use uppercase keywords 6159 Committed Docs Only 19 10/10 +259−259 Erik Wienhold (ewie) Nathan Bossart (bossartn) David Rowley (davidrowley) 1 4 months ago ci: Improve OpenBSD core dump backtrace handling 6160 Committed CI Testing Needs rebase! Nazir Bilal Yavuz (nbyavuz) Thomas Munro (macdice) 1 5 months ago Improve docs syntax checking and enable it in the meson build 6161 Moved to different CF CI Testing 10/10 +141−16 Nazir Bilal Yavuz (nbyavuz) 2 1 week ago ci: Upgrade Debian CI image from Bookworm to Trixie 6163 Committed CI Testing 10/10 +17−22 Nazir Bilal Yavuz (nbyavuz) Andres Freund (andresfreund) 1 4 months ago ci: Upgrade macOS CI image from Sonoma to Sequoia 6164 Committed CI Testing Needs rebase! Nazir Bilal Yavuz (nbyavuz) Andres Freund (andresfreund) 1 5 months ago Add pg_get_role_ddl() functions for role recreation 6166 Moved to different CF 10/10 +551−1 Mario Gonzalez (gonzalemario), Bryan Green (lispyone) Japin Li (japin) 3 2 months ago Bug in pg_stat_statements 6167 Committed Bugfix 18 Needs rebase! Sami Imseih (simseih) Álvaro Herrera (alvherre) 1 5 months ago Use BumpContext contexts for TupleHashTables' tablecxt 6168 Committed Performance 10/10 +90−82 Tom Lane (tgl) Tom Lane (tgl) 1 5 months ago Consistently use the XLogRecPtrIsInvalid() macro 6169 Committed Refactoring Only 19 10/10 +451−457 Bertrand Drouvot (bertranddrouvot.pg) Álvaro Herrera (alvherre) 1 4 months ago Unused variable in perl test 6170 Committed Testing Refactoring Only 19 10/10 +0−1 Daniil Davydov (dddaniil) Tom Lane (tgl) 1 5 months ago Make pg_numa_init() cope with Docker 6171 Withdrawn Bugfix Backport stable Needs rebase! Christoph Berg (myon) 1 4 months ago NLS: use gettext() to translate system error messages 6172 Moved to different CF 19 10/10 +71−2 Jeff Davis (jdavis) 3 1 week ago C11: should we use char32_t for unicode code points? 6173 Committed Refactoring Only 19 8/10 +0−0 Jeff Davis (jdavis) Jeff Davis (jdavis) 1 5 months ago Remove remaining dependencies on setlocale() 6174 Moved to different CF Refactoring Only 19 Needs rebase! Jeff Davis (jdavis) Peter Eisentraut (petere) Jeff Davis (jdavis) 3 2 months ago Add pg_get_tablespace_ddl() function to reconstruct CREATE TABLESPACE statement 6175 Moved to different CF My First Patch DDL 9/10 +308−2 Nishant Sharma (nishant-at-edb), Manni Wood (manniwoodedb) Jim Jones (jimus) 2 4 months ago Batching in executor, part 1: add batch variant of table AM scan API 6176 Moved to different CF Help - Benchmarks Performance 19 7/10 +1877−3 Amit Langote (amitlan) 2 2 months ago Add archive_mode to prevent unarchived WAL on permanent primary failure 6177 Moved to different CF Physical Replication 19 0/10 +712−38 Andrey Borodin (x4m) 3 2 weeks ago COPY FROM with RLS 6178 Moved to different CF SQL Commands 19 10/10 +238−14 Jian He (stayreal) 3 5 months ago COPY WHERE clause generated/system column reference 6179 Moved to different CF Bugfix Backport stable Needs rebase! Jian He (stayreal) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 2 months ago minor error message enhance: print RLS policy name when only one permissive policy exists 6180 Moved to different CF 19 2/10 +48−39 Jian He (stayreal) Florin Irion (irionr) 3 2 months ago copy.sgml: add XML ID attributes to <varlistentry> tags. 6181 Committed Docs Only 19 Needs rebase! Jian He (stayreal) Álvaro Herrera (alvherre) 1 4 months ago MSVC: Improve warning options set 6182 Committed Needs rebase! Peter Eisentraut (petere) Peter Eisentraut (petere) 1 4 months ago Allow to set PGOAUTHCAFILE out of debug mode for libpq-oauth 6183 Moved to different CF Good First Review My First Patch [oauth] System Administration 19 10/10 +86−22 Jonathan Gonzalez V. (sxd) Jacob Champion (jchampion), Zsolt Parragi (zsolt.parragi) Jacob Champion (jchampion) 2 4 days ago pg_plan_advice 6184 Moved to different CF Extensions Missing Docs 10/10 +3053−0 Robert Haas (rhaas) 2 5 hours ago Add pg_get_type_ddl() to retrieve the CREATE TYPE statement 6185 Moved to different CF 9/10 +1019−0 Phil Alger (paalger) 2 5 months ago Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) 6186 Committed Performance 19 10/10 +317−36 David Rowley (davidrowley) David Rowley (davidrowley) 1 4 months ago Optimize SnapBuild by maintaining committed.xip in sorted order 6187 Moved to different CF Performance Logical Replication 19 10/10 +151−25 Xuneng Zhou (dylanzhou) Yogesh Sharma (sharmay), Aditya Gollamudi (adigoll) 3 3 months ago Report oldest xmin source when autovacuum cannot remove tuples 6188 Moved to different CF Monitoring 19 Needs rebase! Shinya Kato (shinyakato) Fujii Masao (masaofujii), Sami Imseih (simseih) 3 2 weeks ago Fix distinctness check for queries with grouping sets 6189 Committed Bugfix 19 10/10 +127−7 Richard Guo (richardguo) Richard Guo (richardguo) 1 5 months ago Fix comments for ChangeVarNodes() and related functions 6190 Committed Comments Only stable 10/10 +17−20 Richard Guo (richardguo) Richard Guo (richardguo) 1 4 months ago Optimize shared LWLock acquisition for high-core-count systems 6191 Moved to different CF Performance Multithreading 19 10/10 +88−16 Zhiguo Zhou (zhiguozhou) 3 8 months ago Lock-free XLog Reservation from WAL 6192 Moved to different CF Performance Multithreading 19 0/10 +532−57 Yura Sokolov (funny_falcon), Zhiguo Zhou (zhiguozhou) 3 5 months ago Increase NUM_XLOGINSERT_LOCKS 6193 Moved to different CF Multithreading Performance 19 9/10 +34−21 Yura Sokolov (funny_falcon) 3 1 year ago Improving planner's estimates of TupleHashTable sizes 6196 Committed Performance 10/10 +261−126 Tom Lane (tgl) Tom Lane (tgl) 1 5 months ago O_CLOEXEC not honored on Windows - handle inheritance chain 6197 Moved to different CF 19 Needs rebase! Bryan Green (lispyone) Thomas Munro (macdice) 2 3 months ago Change initdb default to the builtin collation provider 6198 Moved to different CF System Administration 19 6/10 +28−3 Jeff Davis (jdavis) 2 5 months ago Fix LTREE subpath with negative offset 6199 Committed Bugfix Needs rebase! Marcus Gartner (mgartner) Tom Lane (tgl) 2 5 months ago Instead of dynamically allocating a StringInfo instance and then throwing it away or destroying it at the end of the function, use a stack-allocated StringInfoData. 6200 Committed Refactoring Only stable 10/10 +344−124 Mats Kindahl (mkindahl) David Rowley (davidrowley) 2 4 months ago fix corner cases involving failed DSM registry entry initialization and leaked LWLock tranches 6211 Committed Bugfix stable 10/10 +49−12 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 4 months ago remove obsolete autovacuum comment 6213 Committed Comments Only 19 9/10 +0−5 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 4 months ago Add support for COPY TO in tablesync for partitioned tables. 6214 Committed Logical Replication 19 10/10 +3−2 Ajin Cherian (ajinc) Masahiko Sawada (masahikosawada) 2 4 months ago postgresql.conf.sample tab width 6223 Committed stable Needs rebase! Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 4 months ago gen_guc_tables.pl: Validate required GUC fields before code generation 6226 Committed 19 10/10 +46−0 Chao Li (chaol) Mahmoud Ayman (mahmoudayman) Peter Eisentraut (petere) 2 4 months ago backend/nodes cleanup: Move loop variables definitions into for statement 6227 Committed Refactoring Only 19 10/10 +20−35 Chao Li (chaol) Peter Eisentraut (petere) 2 4 months ago transformJsonFuncExpr pathspec cache lookup failed 6232 Committed Bugfix Backport stable Needs rebase! Jian He (stayreal) Amit Langote (amitlan) 2 4 months ago fix documentation for insert vacuum formula 6236 Committed Docs Only 18 2/10 +7−3 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 4 months ago Remove useless casts to (void *) 6241 Committed Refactoring Only 19 9/10 +0−0 Bertrand Drouvot (bertranddrouvot.pg) Peter Eisentraut (petere) 2 4 months ago better handle errors in dsm registry functions 6250 Committed stable 10/10 +78−69 Nathan Bossart (bossartn) Nathan Bossart (bossartn) 2 4 months ago Remove unused struct fields 6256 Committed Refactoring Only 19 10/10 +2−6 Bertrand Drouvot (bertranddrouvot.pg) Nathan Bossart (bossartn) 2 4 months ago