Commitfest 2021-03 (2021-03-01 – 2021-03-31)

Make async slave to wait for lsn to be replayed 772 Moved to different CF Not processed Ivan Kartyshov (fenimorkin) Thomas Munro (macdice), Dmitry Ivanov (funbringer), Anna Akenteva (a.akenteva), Alexandra Pervushina (a.pervushina) 14 5 years ago Protect syscache from bloating with negative cache entries 931 Moved to different CF Performance Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha) 23 5 years ago Push aggregation down to base relations and joins 1247 Withdrawn Not processed Antonin Houska (a.houska) Tom Lane (tgl), Ashutosh Bapat (ashutoshbapat), Richard Guo (richardguo), Andy Fan (andyf) 19 5 years ago Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT 1533 Returned with feedback SQL Commands Not processed Matheus Oliveira (matheus.oliveira) Gerdan Santos (gerdan), Ashutosh Bapat (ashutoshbapat), José Villanova (azlev), Lucas Viecelli (lucasviecelli), Cleysson Lima (cleyssonlima) 15 4 years ago Transactions involving multiple postgres foreign servers 1574 Moved to different CF Not processed Masahiko Sawada (masahikosawada), Ashutosh Bapat (ashutoshbapat) Takayuki Tsunakawa (maumau), Ashutosh Bapat (ashutoshbapat), Chris Travers (einhverfr), Muhammad Usama (muhammad_usama), Masahiro Ikeda (masahiro.ikeda) 18 4 years ago 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 3 days ago GROUP BY optimization 1651 Moved to different CF Performance 15 Not processed Fedor Sigaev (sigaev), Pavel Borisov (pborisov) Tomas Vondra (fuzzycz) Tomas Vondra (fuzzycz) 12 2 years ago New libpq option to prefer standby for connection 1677 Committed libpq Not processed Haribabu Kommi (haribabu), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) Laurenz Albe (laurenz), Takayuki Tsunakawa (maumau), Peter Smith (smithpb) Tom Lane (tgl) 15 5 years ago Shared-memory based stats collector 1708 Moved to different CF Monitoring Not processed Kyotaro Horiguchi (horiguti) Tomas Vondra (fuzzycz), Antonin Houska (a.houska) 17 3 years ago Remove self join on a unique column 1712 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) Alena Rybakina (a.rybakina) Alexander Korotkov (smagen) 27 11 months ago pgbench - add pseudo-random permutation function 1736 Committed libpq Not processed Fabien Coelho (calvin), Hironobu Suzuki (suzuki_hironobu) Muhammad Usama (muhammad_usama) Dean Rasheed (deanr) 14 4 years ago Index Skip Scan 1741 Moved to different CF 16 Not processed Dmitry Dolgov (erthalion), Thomas Munro (macdice), Jesper Pedersen (jpedersen) Peter Geoghegan (pgeoghegan), Dilip Kumar (dilip.kumar), Thomas Munro (macdice), Chris Travers (einhverfr), James Coleman (jcole1989), Cristiano Duarte (cunha17), Andy Fan (andyf), Yuming Wang (yumwang), Jet Zhang (thinkj), Alexandre Felipe (bob.tpro) 19 4 years ago Expose queryid in pg_stat_activity and log_line_prefix 2069 Committed Monitoring Not processed Julien Rouhaud (rjuju) atsushi torikoshi (atorik), Evgeny Efimkin (efimkine), Nitin Jadhav (nitinjadhav11) Bruce Momjian (bmomjian) 10 4 years ago parse-time support function for "any" datatype 2081 Withdrawn Not processed Pavel Stehule (okbobcz) 10 5 years ago psql - add SHOW_ALL_RESULTS option 2096 Moved to different CF libpq Not processed Fabien Coelho (calvin) Peter Eisentraut (petere) Peter Eisentraut (petere) 13 4 years ago Remove page-read callback from XLogReaderState 2113 Moved to different CF Refactoring Only Not processed Kyotaro Horiguchi (horiguti) Heikki Linnakangas (heikki), Antonin Houska (a.houska), Takashi Menjo (tmenjo) Thomas Munro (macdice) 13 4 years ago Incremental Materialized View Maintenance 2138 Moved to different CF SQL Commands 16 Not processed Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) 17 3 years ago Allow an alias to be attached directly to a JOIN ... USING 2158 Committed SQL Commands Not processed Peter Eisentraut (petere) Tom Lane (tgl) Peter Eisentraut (petere) 10 5 years ago standby recovery fails when re-replaying due to missing directory which was removed in previous replay. 2161 Moved to different CF Bugfix stable Not processed Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) Michael Paquier (michael-kun) Álvaro Herrera (alvherre) 16 3 years ago FETCH FIRST clause PERCENT option 2176 Moved to different CF SQL Commands Not processed Surafel Temesgen (surafel) 12 4 years ago pg_upgrade fails with non-standard ACL 2215 Moved to different CF Bugfix Not processed Anastasia Lubennikova (lubennikovaav), Artur Zakirov (a.zakirov) Grigory Smolkin (g.smolkin.postgrespro.ru) Noah Misch (nmisch) 12 4 years ago Implement INSERT SET syntax 2218 Moved to different CF SQL Commands Not processed Gareth Palmer (gareth) Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj) 15 3 years ago A hook for path-removal decision on add_path 2234 Moved to different CF Not processed KaiGai Kohei (kaigai) 11 3 years ago Fix partitionwise join with partially-redundant join clauses 2266 Moved to different CF Not processed Richard Guo (richardguo) Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) Richard Guo (richardguo) 16 1 year ago Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLESPACE 2269 Committed SQL Commands Not processed Justin Pryzby (justinpryzby), Alexey Kondratov (ololobus) Justin Pryzby (justinpryzby), Cleysson Lima (cleyssonlima) Michael Paquier (michael-kun) 9 5 years ago WITH SYSTEM VERSIONING Temporal Tables 2316 Moved to different CF SQL Commands Not processed Surafel Temesgen (surafel) Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre) 11 4 years ago ECPG new statement: DECLARE STATEMENT 2334 Committed libpq Not processed Hayato Kuroda (ha-kun) Shawn Wang (shawnwang) Michael Meskes (meskes) 8 5 years ago Global temporary table 2349 Moved to different CF 16 Not processed Wenjing Zeng (wenjing.zwj) Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) 13 3 years ago Split StdRdOptions into HeapOptions and ToastOptions 2370 Moved to different CF Refactoring Only Not processed Nikolay Shaplov (nataraj) 10 4 years ago UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR 2376 Moved to different CF Not processed John Dent (denty) Daniel Vérité (danielverite) 9 4 years ago Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) 2377 Moved to different CF System Administration Not processed Justin Pryzby (justinpryzby) Fabien Coelho (calvin) 21 2 years ago Using multicolumn statistics for more precise join selectivity estimatation 2386 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) Yugo Nagata (yugo.nagata) 9 4 years ago GUC to disable cancellation of awaiting for synchronous replication 2402 Moved to different CF Not processed Andrey Borodin (x4m) Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev) 9 4 years ago WAL prefetch (another approach) 2410 Committed Not processed Thomas Munro (macdice) David Kimura (dgkimura) Thomas Munro (macdice) 7 3 years ago Erase the distinctClause if the result is unique by definition 2433 Moved to different CF Performance Not processed Andy Fan (andyf) David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Zhijie Hou (houzj) 11 4 years ago Reduce WaitEventSet system call spam 2452 Committed Refactoring Only Not processed Thomas Munro (macdice) Thomas Munro (macdice) 6 5 years ago truncating timestamps on arbitrary intervals 2474 Committed Not processed John Naylor (john.naylor) Peter Eisentraut (petere) Peter Eisentraut (petere) 6 5 years ago jsonpath syntax extensions 2482 Moved to different CF 15 Not processed Nikita Glukhov (n.glukhov) 12 4 years ago Make message at end-of-recovery less scary 2490 Moved to different CF Not processed Kyotaro Horiguchi (horiguti) Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) 20 2 years ago Asynchronous Append on postgres_fdw nodes. 2491 Committed Performance 14 Not processed Kyotaro Horiguchi (horiguti) Andrei Lepikhov (lepikhov), movead li (movead.li), Muhammad Usama (muhammad_usama) Etsuro Fujita (efujita) 6 5 years ago Auto-analyze on partitioned tables 2492 Committed Not processed Yuzuko Hosoya (yuzu) Justin Pryzby (justinpryzby) Álvaro Herrera (alvherre) 6 4 years ago Improve standby connection denied error message 2509 Committed Not processed James Coleman (jcole1989) David Zhang (david.z) Fujii Masao (masaofujii) 5 5 years ago Corruption during WAL replay 2518 Moved to different CF Bugfix stable Not processed Teja Mupparti (tejam) Robert Haas (rhaas), Daniel Shelepanov (dshelepanov) Robert Haas (rhaas) 10 4 years ago archive status ".ready" files may be created too early 2520 Moved to different CF Bugfix stable Not processed Nathan Bossart (bossartn) Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 7 4 years ago Return ERROR on COMMIT instead of silently ROLLBACK 2522 Returned with feedback SQL Commands Not processed Dave Cramer (dcramer) Laurenz Albe (laurenz) 5 5 years ago BRIN multi-minmax and bloom indexes 2523 Committed Performance Not processed Tomas Vondra (fuzzycz) John Naylor (john.naylor) Tomas Vondra (fuzzycz) 5 5 years ago psql - possibility to specify where status row should be displayed 2536 Rejected libpq Not processed Pavel Stehule (okbobcz) 5 5 years ago allow to set a pager for psql's watch command 2539 Moved to different CF libpq Not processed Pavel Stehule (okbobcz) Thomas Munro (macdice) Thomas Munro (macdice) 6 4 years ago Additional Chapter "Architecture" for Part "Tutorial" 2541 Returned with feedback Docs Only Not processed Jürgen Purtz (juergen@purtz.de) Peter Eisentraut (petere), David Johnston (polobo), Joshua Drake (linuxpoet) 5 5 years ago Binary search in ScalarArrayOpExpr for OR'd constant arrays 2542 Committed Performance Not processed David Rowley (davidrowley), James Coleman (jcole1989) Heikki Linnakangas (heikki), David Rowley (davidrowley), Tomas Vondra (fuzzycz) David Rowley (davidrowley) 3 5 years ago INSERT SELECT: BulkInsertState and table_multi_insert 2553 Moved to different CF Performance 15 Not processed Justin Pryzby (justinpryzby) 8 4 years ago pgbench - add a synchronization barrier when starting 2557 Committed libpq Not processed Fabien Coelho (calvin), Thomas Munro (macdice) Marina Polyakova (whipping.top1991), Hayato Kuroda (ha-kun) Thomas Munro (macdice) 5 5 years ago Hybrid Hash/Nested Loop joins and caching results from subplans 2569 Committed Performance 14 Not processed David Rowley (davidrowley) Andy Fan (andyf) David Rowley (davidrowley) 5 5 years ago SEARCH and CYCLE clauses 2570 Committed SQL Commands Not processed Peter Eisentraut (petere) Pavel Stehule (okbobcz), Vik Fearing (xocolatl) Peter Eisentraut (petere) 5 5 years ago pg_dump - read data for some options from external file 2573 Moved to different CF libpq Not processed Pavel Stehule (okbobcz) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v) Daniel Gustafsson (d_gustafsson) 18 2 years ago Overhaul UPDATE/DELETE processing 2575 Committed Performance Not processed Amit Langote (amitlan) Tom Lane (tgl) Tom Lane (tgl) 5 5 years ago Support for NSS as TLS backend 2592 Returned with feedback Security Not processed Daniel Gustafsson (d_gustafsson) Andres Freund (andresfreund), Jacob Champion (jchampion) 5 4 years ago Problem with RETURNING and update tuple routing 2597 Moved to different CF Bugfix Not processed Amit Langote (amitlan) Etsuro Fujita (efujita) Tom Lane (tgl) 6 4 years ago Fast COPY FROM command for the foreign tables 2601 Moved to different CF Performance Not processed Andrei Lepikhov (lepikhov) Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) Etsuro Fujita (efujita) 13 3 years ago ALTER SYSTEM READ { ONLY | WRITE } 2602 Moved to different CF Not processed Amul Sul (sulamul) 9 4 years ago DROP relation IF EXISTS Docs and Tests - Bug Fix 2603 Moved to different CF Bugfix Not processed David Johnston (polobo) Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com) 7 4 years ago Support parallelism for copy command 2610 Withdrawn Performance Not processed vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) Amit Kapila (amitkapila), Greg Nancarrow (gregn1234), Zhijie Hou (houzj) Amit Kapila (amitkapila) 5 5 years ago Enabling data checksums in an online cluster 2611 Withdrawn Not processed Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) 5 5 years ago unicode unescape function 2613 Committed Not processed Pavel Stehule (okbobcz) Asif Rehman (asifrana) Peter Eisentraut (petere) 5 5 years ago Add table expansion hook 2614 Moved to different CF Not processed Erik Nordström (enordstr) Euler Taveira (eulerto), Aleksander Alekseev (aalekseev) 7 4 years ago Non-volatile WAL buffer 2615 Moved to different CF Not processed Takashi Menjo (tmenjo) 6 5 years ago Refactor nodeModifyTable.c to allow lazy opening of result relations 2621 Committed Refactoring Only Not processed Amit Langote (amitlan) Heikki Linnakangas (heikki), Tom Lane (tgl) Tom Lane (tgl) 5 4 years ago More scalable multixacts buffers and locking 2627 Moved to different CF Performance Not processed Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) Álvaro Herrera (alvherre) 20 1 year ago Implement <null treatment> for window functions 2628 Returned with feedback 15 Not processed Vik Fearing (xocolatl) David Fetter (dfetter), Krasiyan Andreev (krasiyan) Tom Lane (tgl) 4 5 years ago SQL-standard function body 2630 Committed SQL Commands Not processed Peter Eisentraut (petere) Julien Rouhaud (rjuju) Peter Eisentraut (petere) 5 4 years ago postgres_fdw connection caching enable/disable or timeout feature 2650 Committed Not processed Bharath Rupireddy (bharathrupireddy) Fujii Masao (masaofujii), Alexey Kondratov (ololobus) Fujii Masao (masaofujii) 4 5 years ago Prefer explicit JOIN syntax over (old) implicit syntax in tutorial 2652 Committed Docs Only Not processed Jürgen Purtz (juergen@purtz.de) Peter Eisentraut (petere), David Johnston (polobo) Peter Eisentraut (petere) 4 4 years ago Add a feature that enables row-wise comparison partition pruning 2654 Returned with feedback Not processed sho kato (kato-sho) Anastasia Lubennikova (lubennikovaav), ahsan hadi (ahsan.hadi) 4 4 years ago shared tempfile was not removed on statement_timeout 2657 Committed Bugfix stable Not processed Thomas Munro (macdice), Justin Pryzby (justinpryzby) Thomas Munro (macdice) 4 5 years ago implement LogicalDecodeMessageCB for pgoutput 2661 Committed 13 Not processed Dave Cramer (dcramer) Euler Taveira (eulerto), Ashutosh Bapat (ashutoshbapat) Amit Kapila (amitkapila) 4 4 years ago extend amcheck module to check heaps 2670 Committed System Administration 14 Not processed Mark Dilger (mark.dilger) Robert Haas (rhaas) Robert Haas (rhaas) 4 4 years ago Covering SPGiST index 2675 Committed Performance Not processed Pavel Borisov (pborisov) Andrey Borodin (x4m) Tom Lane (tgl) 4 5 years ago Change return type of EXTRACT to numeric 2679 Committed SQL Commands Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 3 5 years ago enhancing plpgsql API for debugging and tracing 2684 Moved to different CF Not processed Pavel Stehule (okbobcz) Aleksander Alekseev (aalekseev) Tom Lane (tgl) 9 4 years ago Fix collation handling in postgres_fdw 2685 Moved to different CF Bugfix Not processed Tom Lane (tgl) Etsuro Fujita (efujita) 6 4 years ago Automatic HASH and LIST partition creation 2694 Moved to different CF SQL Commands Not processed Anastasia Lubennikova (lubennikovaav) Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) 7 4 years ago Dumping/restoring fails on inherited generated column 2698 Committed Bugfix Not processed Masahiko Sawada (masahikosawada) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 5 years ago Optimizing NULL check on pkey column 2699 Moved to different CF Performance Not processed Surafel Temesgen (surafel) Ashutosh Bapat (ashutoshbapat) 6 4 years ago PATCH: Attempt to make dbsize a bit more consistent 2701 Returned with feedback Not processed Georgios Kokolatos (gkokolatos) Daniel Gustafsson (d_gustafsson), David Zhang (david.z), Soumyadeep Chakraborty (soumyadeepc) 4 4 years ago pg_read_all_data default role 2702 Committed Security 14 Not processed Stephen Frost (sfrost) Georgios Kokolatos (gkokolatos) Stephen Frost (sfrost) 4 4 years ago Background writer and checkpointer in crash recovery 2706 Moved to different CF Not processed Thomas Munro (macdice) Aleksander Alekseev (aalekseev) Thomas Munro (macdice) 6 4 years ago Boundary value check in lazy_tid_reaped() 2707 Committed Performance Not processed Masahiko Sawada (masahikosawada) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 5 years ago Allow CRL "directory" for crl_file 2709 Committed Not processed Kyotaro Horiguchi (horiguti) Peter Eisentraut (petere) Peter Eisentraut (petere) 4 5 years ago Fix behavior of geo_ops when NaN is involved 2710 Moved to different CF Not processed Kyotaro Horiguchi (horiguti) Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) 10 4 years ago Get memory contexts of an arbitrary backend process 2711 Committed Monitoring 14 Not processed Atsushi Torikoshi (atsushitorikoshi) Fujii Masao (masaofujii), Kasahara Tatsuhito (kasahara), Shawn Wang (shawnwang) Fujii Masao (masaofujii) 4 5 years ago Add information about generic/custom plan to pg_stat_statements 2713 Withdrawn Monitoring 14 Not processed Atsushi Torikoshi (atsushitorikoshi) Fujii Masao (masaofujii), Tatsuro Yamada (tatsuro_yamada), PAscal L (pascall), Chengxi Sun (martin-sun) 4 5 years ago ALTER TABLE .. DETACH PARTITION CONCURRENTLY 2714 Committed Not processed Álvaro Herrera (alvherre) Anastasia Lubennikova (lubennikovaav), Justin Pryzby (justinpryzby) Álvaro Herrera (alvherre) 4 5 years ago fix spinlock contention in LogwrtResult 2716 Moved to different CF Performance Not processed Álvaro Herrera (alvherre) 11 1 year ago Reloptions for table access methods 2717 Withdrawn Not processed Jeff Davis (jdavis) Georgios Kokolatos (gkokolatos) 4 5 years ago Fix checksum verification in base backups for zero page headers 2719 Moved to different CF Bugfix Not processed Michael Banck (mbanck) Anastasia Lubennikova (lubennikovaav), David Steele (dsteele) 6 4 years ago Pipelining/batch mode support for libpq 2724 Committed Performance Not processed Álvaro Herrera (alvherre), Craig Ringer (ringerc), Matthieu Garrigues (matt-42) Justin Pryzby (justinpryzby) Álvaro Herrera (alvherre) 4 5 years ago Reduce PostmasterIsAlive() checks during recovery 2733 Committed Performance Not processed Thomas Munro (macdice) Thomas Munro (macdice) 3 4 years ago Extending the range operators so they can cope with range <op> element and element <op> range in addition to the existing range <op> range 2747 Returned with feedback SQL Commands Not processed Esteban Zimanyi (ezimanyi) Tomas Vondra (fuzzycz) 3 4 years ago (ALTER SYSTEM) SET +=/-= operator support 2750 Returned with feedback 14 Not processed Abhijit Menon-Sen (ams) Ibrar Ahmed (ibrar) 3 5 years ago Add extra statistics to explain for Nested Loop 2765 Moved to different CF Monitoring Not processed Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) 10 3 years ago parallel distinct union and aggregate support patch 2769 Moved to different CF Performance Not processed bucoo hsiao (bucoo) 6 4 years ago Wrong statistics for size of XLOG_SWITCH during pg_waldump 2770 Committed Not processed movead li (movead.li) Shinya Kato (kato-shinya) Fujii Masao (masaofujii) 3 5 years ago Some cosmetic improvements of partition pruning code 2771 Committed Refactoring Only 14 Not processed Amit Langote (amitlan) Ryan Lambert (ryanlambert), Andy Fan (andyf) David Rowley (davidrowley) 3 4 years ago libpq compression 2773 Moved to different CF libpq 15 Not processed Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag) 6 4 years ago Further note require activity aspect of automatic checkpoint and archiving 2774 Moved to different CF Docs Only Not processed David Johnston (polobo) 6 4 years ago Introduce view updating options more succinctly 2777 Committed Docs Only Not processed David Johnston (polobo) Magnus Hagander (mha) 3 5 years ago Minor variable related cleanup and rewording of plpgsql docs 2778 Committed Docs Only Not processed David Johnston (polobo) Pavel Stehule (okbobcz), David Steele (dsteele) Tom Lane (tgl) 3 5 years ago Allow COPY "text" to output a header and add header matching mode to COPY FROM 2780 Moved to different CF SQL Commands Not processed Rémi Lapeyre (remilapeyre) Peter Eisentraut (petere) Peter Eisentraut (petere) 8 4 years ago Replace polyphase merge with a simple k-way balanced merge 2781 Moved to different CF Performance Not processed Heikki Linnakangas (heikki) John Naylor (john.naylor) Heikki Linnakangas (heikki) 6 4 years ago allow partial union-all and improve parallel subquery costing 2787 Returned with feedback Performance Not processed Luc Vlaming (luc.vlaming) 3 4 years ago psql \df choose functions by their arguments 2788 Committed libpq 14 Not processed Greg Sabino Mullane (greg) Ian Barwick (barwick), Zhijie Hou (houzj) Tom Lane (tgl) 3 4 years ago Improve replay pause 2795 Committed Not processed Dilip Kumar (dilip.kumar) Kyotaro Horiguchi (horiguti), Yugo Nagata (yugo.nagata), Bharath Rupireddy (bharathrupireddy) Robert Haas (rhaas) 3 5 years ago Use posix fadvise to speed up analyze + improve automatic analyze with "avg read rate" log message 2799 Committed Monitoring 14 Not processed Stephen Frost (sfrost), Jakub Wartak (jakub.wartak.tomtom) Heikki Linnakangas (heikki), Tomas Vondra (fuzzycz) Stephen Frost (sfrost) 3 5 years ago CLUSTER on partitioned table 2800 Moved to different CF SQL Commands 15 Not processed Justin Pryzby (justinpryzby) Matthias van de Meent (mmeent) Álvaro Herrera (alvherre) 8 4 years ago cleanup temporary files after crash 2803 Committed 14 Not processed Euler Taveira (eulerto) Anastasia Lubennikova (lubennikovaav), Gerdan Santos (gerdan) Tomas Vondra (fuzzycz) 3 5 years ago DROP INDEX CONCURRENTLY on partitioned index 2805 Moved to different CF SQL Commands 15 Not processed Justin Pryzby (justinpryzby) 4 4 years ago remove pg_standby 2806 Committed System Administration 14 Not processed Justin Pryzby (justinpryzby) Thomas Munro (macdice) 3 5 years ago New wal_level to disable WAL logging 2807 Moved to different CF Performance Not processed Takamichi Osumi (tatatappp) Takayuki Tsunakawa (maumau) 4 4 years ago OpenSSL 3.0.0 compatibility 2810 Withdrawn Security Not processed Daniel Gustafsson (d_gustafsson) 3 5 years ago protocol default result formats setting 2812 Returned with feedback Not processed Peter Eisentraut (petere) Emre Hasegeli (hasegeli) 3 5 years ago custom compression methods for toast 2813 Committed 14 Not processed Dilip Kumar (dilip.kumar), Ildus Kurbangaliev (ildus) Justin Pryzby (justinpryzby) Robert Haas (rhaas) 3 5 years ago CREATE INDEX CONCURRENTLY on partitioned table 2815 Moved to different CF SQL Commands Not processed Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) 15 9 months ago Reduce the number of special cases to build contrib modules on windows 2817 Moved to different CF Not processed David Rowley (davidrowley) David Rowley (davidrowley) 5 4 years ago pg_wait_backend() and pg_terminate_backend_and_wait() functions with wait and timeout capability 2822 Committed System Administration Not processed Bharath Rupireddy (bharathrupireddy) Muhammad Usama (muhammad_usama), Zhijie Hou (houzj) Magnus Hagander (mha) 2 4 years ago Functions for sorting GiST build of gist_btree types 2824 Moved to different CF Not processed Andrey Borodin (x4m) Heikki Linnakangas (heikki), Emre Hasegeli (hasegeli) Heikki Linnakangas (heikki) 7 4 years ago pgbench stopped supporting large number of client connections on Windows 2827 Returned with feedback Bugfix Not processed Marina Polyakova (whipping.top1991) 2 5 years ago Make Append Cost aware of some run time partition prune case 2829 Moved to different CF Performance Not processed Andy Fan (andyf) 5 4 years ago Extended statistics / estimate Var op Var clauses 2831 Moved to different CF Not processed Tomas Vondra (fuzzycz) Dean Rasheed (deanr), Mark Dilger (mark.dilger) 9 3 years ago Extended statistics on expressions 2832 Committed 14 Not processed Tomas Vondra (fuzzycz) Justin Pryzby (justinpryzby) Tomas Vondra (fuzzycz) 2 5 years ago Add nullif case for eval_const_expressions 2833 Committed Performance Not processed Zhijie Hou (houzj) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 5 years ago ResourceOwner refactoring 2834 Moved to different CF Refactoring Only Not processed Heikki Linnakangas (heikki) Aleksander Alekseev (a.alekseev) 4 2 years ago Allow match a whole DN of a client certificate 2835 Committed 14 Not processed Andrew Dunstan (adunstan) Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) Andrew Dunstan (adunstan) 2 5 years ago Optimising latch signals 2836 Committed Refactoring Only Not processed Thomas Munro (macdice) Thomas Munro (macdice) 2 5 years 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 brin: avoid errors processing work item following concurrent reindex 2838 Moved to different CF Bugfix stable Not processed Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby) Gurjeet Singh (gurjeet) 5 4 years ago possibility to rename root namespace in plpgsql 2839 Moved to different CF Not processed Pavel Stehule (okbobcz) Julien Rouhaud (rjuju) 7 4 years ago Parallel Inserts in CREATE TABLE AS 2841 Withdrawn Performance Not processed Bharath Rupireddy (bharathrupireddy) vigneshwaran C (vignesh.postgres), Zhijie Hou (houzj), Luc Vlaming (luc.vlaming) 2 5 years ago Initial mach based shared memory support. 2843 Returned with feedback Not processed James Hilliard (jameshilliard) 2 5 years ago Parallel INSERT (INTO ... SELECT ...) 2844 Returned with feedback Performance 14 Not processed Greg Nancarrow (gregn1234) Antonin Houska (a.houska), Takayuki Tsunakawa (maumau), vigneshwaran C (vignesh.postgres), Haiying Tang (tanghy), Zhijie Hou (houzj) Amit Kapila (amitkapila) 2 5 years ago Printing LSN made easy 2848 Committed Refactoring Only Not processed Ashutosh Bapat (ashutoshbapat) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 5 years ago orphaned function 2850 Returned with feedback Bugfix stable Not processed Bertrand Drouvot (bdrouvot) Gilles Darold (darold) 2 4 years ago Consider parallel for LATERAL subqueries having LIMIT/OFFSET 2851 Moved to different CF Performance Not processed James Coleman (jcole1989) Greg Nancarrow (gregn1234) 11 3 years ago Fixes for phrase search with multi-lexeme tokens 2854 Committed Bugfix 14 Not processed Alexander Korotkov (smagen) Neil Chen (carpenter.nail.cz.gmail.com) Alexander Korotkov (smagen) 2 5 years ago Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW 2856 Committed Performance Not processed Bharath Rupireddy (bharathrupireddy) Zhijie Hou (houzj), Luc Vlaming (luc.vlaming) Thomas Munro (macdice) 2 5 years ago ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently 2857 Withdrawn Bugfix Not processed Takayuki Tsunakawa (maumau) Bharath Rupireddy (bharathrupireddy) 2 5 years ago Update the default of checkpoint_completion_target to 0.9 2858 Committed Performance 14 Not processed Stephen Frost (sfrost) David Steele (dsteele) Stephen Frost (sfrost) 2 5 years ago About to add WAL write/fsync statistics to pg_stat_wal view 2859 Committed Monitoring 14 Not processed Masahiro Ikeda (masahiro.ikeda) Fujii Masao (masaofujii) 2 5 years ago Xact event callback at command start 2860 Moved to different CF Not processed Gilles Darold (darold) Julien Rouhaud (rjuju) 4 4 years ago move pg_upgrade test.sh kludges to a SQL script 2861 Moved to different CF Not processed Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) Michael Paquier (michael-kun) 6 4 years ago WIP: macOS SIP workaround 2862 Returned with feedback Not processed Peter Eisentraut (petere) 2 5 years ago Function to log backtrace of postgres processes 2863 Moved to different CF Not processed vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) Christoph Berg (myon), Maciek Sakrejda (msakrejda) 17 2 years ago Fix pg_rewind race condition just after promotion 2864 Moved to different CF System Administration Not processed Heikki Linnakangas (heikki) Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) Heikki Linnakangas (heikki) 12 3 years ago create table like: ACCESS METHOD 2865 Moved to different CF SQL Commands 15 Not processed Justin Pryzby (justinpryzby) Simon Riggs (simon) 4 4 years ago Protect archive recovery from missing data 2867 Committed Bugfix Not processed Takamichi Osumi (tatatappp) Fujii Masao (masaofujii), Laurenz Albe (laurenz), David Steele (dsteele), Rajesh Kumar (rajeshmonk2509) Fujii Masao (masaofujii) 2 4 years ago Mitigate pg_rewind race condition, if config file is enlarged concurrently. 2869 Moved to different CF System Administration Not processed Heikki Linnakangas (heikki) Daniel Gustafsson (d_gustafsson), Cary Huang (cary) Daniel Gustafsson (d_gustafsson) 7 4 years ago autovacuum exit on postmaster death when sleeping 2870 Committed 14 Not processed Stephen Frost (sfrost) Stephen Frost (sfrost) 2 5 years ago New Table Access Methods for Multi and Single Inserts 2871 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) 9 1 year ago Fix firing of RI triggers during cross-partition updates of partitioned tables 2877 Moved to different CF Bugfix Not processed Amit Langote (amitlan) Masahiko Sawada (masahikosawada) Álvaro Herrera (alvherre) 7 4 years ago Refactoring HMAC in the core code 2878 Committed 14 Not processed Michael Paquier (michael-kun) Michael Paquier (michael-kun) 2 5 years ago Improve \e, \ef and \ev if the editor is quit 2879 Committed libpq 14 Not processed Laurenz Albe (laurenz) Jacob Champion (jchampion) Tom Lane (tgl) 2 5 years ago Perform COPY FROM encoding conversions in larger chunks 2880 Committed Performance Not processed Heikki Linnakangas (heikki) John Naylor (john.naylor) Heikki Linnakangas (heikki) 2 5 years ago Add wait_start column to pg_locks 2883 Committed Monitoring 14 Not processed Atsushi Torikoshi (atsushitorikoshi) Ian Barwick (barwick) Fujii Masao (masaofujii) 2 5 years ago zstd compression for pg_dump 2888 Moved to different CF System Administration Not processed Justin Pryzby (justinpryzby) Andreas Karlsson (kandreas), Jacob Champion (jchampion) Tomas Vondra (fuzzycz) 4 2 years ago libpq trace log 2889 Committed libpq 14 Not processed Aya Iwata (iwata.aya) Takayuki Tsunakawa (maumau), Kirk Jamison (kirkjamison) Álvaro Herrera (alvherre) 2 5 years ago doc review for v14 2890 Committed Docs Only 14 Not processed Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) 2 5 years ago install path aware subclass of PostgresNode 2891 Committed 14 Not processed Andrew Dunstan (adunstan) Daniel Gustafsson (d_gustafsson) Andrew Dunstan (adunstan) 2 5 years ago Move regression tablespace cleanup from makefiles pg_regress? (Occasional tablespace.sql failures in check-world -jnn) 2893 Committed 14 Not processed Michael Paquier (michael-kun) Peter Eisentraut (petere) Michael Paquier (michael-kun) 2 5 years ago REINDEX backend filtering 2895 Moved to different CF SQL Commands Not processed Julien Rouhaud (rjuju) 3 5 years ago Add is_toplevel flag in pg_stat_statements 2896 Committed Monitoring Not processed Julien Rouhaud (rjuju) Magnus Hagander (mha), Masahiro Ikeda (masahiro.ikeda) Magnus Hagander (mha) 2 4 years ago Faster pglz compression 2897 Moved to different CF Performance Not processed Andrey Borodin (x4m), Владимир Лесков (tinsane) Mark Dilger (mark.dilger) Tomas Vondra (fuzzycz) 12 3 years ago New IndexAM API controlling index vacuum strategies 2898 Committed Not processed Masahiko Sawada (masahikosawada) Peter Geoghegan (pgeoghegan), Matthias van de Meent (mmeent) Peter Geoghegan (pgeoghegan) 2 4 years ago Add OID allocation retry log to GetNewOidWithIndex() 2899 Committed 14 Not processed tomohiro hiramitsu (hiramit) Kasahara Tatsuhito (kasahara) Fujii Masao (masaofujii) 2 5 years ago On client login event trigger 2900 Moved to different CF 17 Not processed Konstantin Knizhnik (knizhnik), Greg Nancarrow (gregn1234), Mikhail Gribkov (youzhick) Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234) Alexander Korotkov (smagen) 15 2 years ago SQL/JSON: functions 2901 Moved to different CF 15 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) 7 3 years ago SQL/JSON: JSON_TABLE 2902 Moved to different CF 15 Not processed Nikita Glukhov (n.glukhov) Andrew Dunstan (adunstan) 7 4 years ago Parallel Hash Full Join 2903 Moved to different CF Performance 16 Not processed Melanie Plageman (melanieplageman) Thomas Munro (macdice) Thomas Munro (macdice) 12 2 years ago Row filtering for logical replication 2906 Moved to different CF 15 Not processed Euler Taveira (eulerto), Peter Smith (smithpb), Ajin Cherian (ajinc), Zhijie Hou (houzj) Dilip Kumar (dilip.kumar), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Zhijie Hou (houzj), Rahila Syed (rahila) Amit Kapila (amitkapila) 7 4 years ago PoC Refactor AM analyse API 2907 Moved to different CF Refactoring Only Not processed Denis Smirnov (darthunix) Heikki Linnakangas (heikki) 4 4 years ago VACUUM (FAST_FREEZE ) 2908 Returned with feedback System Administration Not processed Simon Riggs (simon) Masahiko Sawada (masahikosawada) 2 4 years ago Maximize page freezing 2909 Moved to different CF System Administration Not processed Simon Riggs (simon) Álvaro Herrera (alvherre) 3 4 years ago wal_sessioninfo 2910 Moved to different CF Not processed Simon Riggs (simon) Cleysson Lima (cleyssonlima) 4 4 years ago Dynamic result sets from procedures 2911 Moved to different CF SQL Commands Not processed Peter Eisentraut (petere) 12 3 years ago Tying an object's ownership to datdba 2913 Committed Security 14 Not processed Noah Misch (nmisch) Daniel Gustafsson (d_gustafsson), John Naylor (john.naylor) Noah Misch (nmisch) 2 5 years ago logical decoding of two-phase transactions 2914 Moved to different CF 15 Not processed Stas Kelvich (kelvich), Nikhil Sontakke (nikkhils), Ajin Cherian (ajinc), Peter Smith (smithpb2250) Amit Kapila (amitkapila), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) Amit Kapila (amitkapila) 4 4 years ago document the hook system 2915 Returned with feedback Docs Only 14 Not processed David Fetter (dfetter) 2 5 years ago Let people set host(no)ssl settings from initdb 2916 Rejected Security 14 Not processed David Fetter (dfetter) 2 5 years ago Make popcount available to SQL 2917 Committed Performance Not processed David Fetter (dfetter) Peter Eisentraut (petere) Peter Eisentraut (petere) 2 5 years ago New default role allowing to change per-role settings 2918 Moved to different CF System Administration Not processed Michael Banck (mbanck) Stephen Frost (sfrost), Shinya Kato (kato-shinya) 8 4 years ago Discarding DISCARD ALL 2919 Moved to different CF 15 Not processed Simon Riggs (simon) 3 4 years ago MERGE SQL command 2920 Moved to different CF SQL Commands 15 Not processed Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) 4 4 years ago Clarify that CREATEROLE roles can GRANT default roles 2921 Committed Docs Only Not processed Michael Banck (mbanck) Robert Treat (xzilla) Magnus Hagander (mha) 2 5 years ago Table AM modifications to accept column projection lists 2922 Moved to different CF Not processed Jacob Champion (jchampion), Soumyadeep Chakraborty (soumyadeepc) 3 4 years ago Tid scan improvements 2924 Committed Performance Not processed David Rowley (davidrowley), Edmund Horner (ejrh) David Rowley (davidrowley) 2 5 years ago Key management with tests 2925 Moved to different CF 15 Not processed Stephen Frost (sfrost), Masahiko Sawada (masahikosawada), Bruce Momjian (bmomjian) 3 3 years ago Fix code comment typo 2926 Committed Comments Only Not processed Peter Smith (smithpb2250) Amit Kapila (amitkapila) 1 5 years ago Report tranche ID and LWLock pointer in LWLock static tracepoints 2927 Returned with feedback Monitoring Not processed Craig Ringer (ringerc) Peter Eisentraut (petere) 1 5 years ago EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW 2928 Moved to different CF Not processed Bharath Rupireddy (bharathrupireddy) Japin Li (japin) 2 4 years ago Adjust default wal_sync_method on FreeBSD 2929 Committed Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 5 years ago Fix memory bloat caused by foreign key checking involving partitions 2930 Committed Performance Not processed Amit Langote (amitlan), Keisuke Kuroda (keisuke.kuroda.3862) Amit Langote (amitlan) Tom Lane (tgl) 1 5 years ago pg_test_fsync should use pwrite( ) 2931 Committed Refactoring Only Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 5 years ago Partial foreign key updates in referential integrity triggers 2932 Moved to different CF SQL Commands 15 Not processed Paul Martinez (pauljulius) Peter Eisentraut (petere) Peter Eisentraut (petere) 5 4 years ago WIP: Track relation size in shared memory 2933 Moved to different CF Performance Not processed Thomas Munro (macdice) 3 4 years ago has_column_privilege() issue with attnums and non-existent columns 2934 Committed Bugfix stable Not processed Ian Barwick (barwick) Joe Conway (jconway), Chengxi Sun (martin-sun) Joe Conway (jconway) 1 5 years ago Reduce the time required for a database recovery from archive. 2935 Moved to different CF Not processed Anna Akenteva (a.akenteva), Dmitry Shulga (d.shulga), Ivan Taranov (i.taranov) 3 5 years ago Reduce vacuum_cost_page_miss GUC's default to account for modern storage characteristics 2936 Committed Performance Not processed Peter Geoghegan (pgeoghegan) Peter Geoghegan (pgeoghegan) 1 5 years ago NOT VALID for Unique Indexes 2937 Moved to different CF SQL Commands Not processed Simon Riggs (simon) 3 4 years ago invalid data in file backup_label problem on windows 2938 Withdrawn Bugfix Not processed Shenhao Wang (wangshenhao) 1 5 years ago Pg14, pg_dumpall and "password_encryption=true" 2939 Withdrawn Bugfix 14 Not processed Ian Barwick (barwick) 1 5 years ago Teach VACUUM to ignore CIC / RC 2940 Committed Not processed Álvaro Herrera (alvherre) Matthias van de Meent (mmeent) Álvaro Herrera (alvherre) 1 5 years ago some pointless HeapTupleHeaderIndicatesMovedPartitions calls 2941 Committed Not processed Álvaro Herrera (alvherre) Michael Paquier (michael-kun), Anastasia Lubennikova (lubennikovaav) Álvaro Herrera (alvherre) 1 5 years ago increase size of pg_commit_ts buffers 2942 Moved to different CF Performance Not processed Álvaro Herrera (alvherre) Noah Misch (nmisch) Álvaro Herrera (alvherre) 4 4 years ago Rename of triggers for partitioned tables 2943 Moved to different CF SQL Commands Not processed Arne Roland (harks) Álvaro Herrera (alvherre) Álvaro Herrera (alvherre) 2 4 years ago Logical Replication - bug in behavior of ALTER PUBLICATION .. DROP TABLE 2944 Committed Not processed Japin Li (japin), Bharath Rupireddy (bharathrupireddy) Amit Kapila (amitkapila) 1 5 years ago Fix typo about WalSndPrepareWrite 2945 Withdrawn Comments Only Not processed Japin Li (japin) 1 5 years ago Feature improvement for CLOSE, FETCH, MOVE tab completion 2946 Committed SQL Commands Not processed Shinya Kato (kato-shinya) Fujii Masao (masaofujii) 1 5 years ago Full support for index LP_DEAD hint bits on standby 2947 Moved to different CF Performance Not processed Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) Antonin Houska (a.houska) 6 4 years ago Simplify some RI checks to reduce SPI overhead 2948 Moved to different CF Performance Not processed Amit Langote (amitlan) Tom Lane (tgl), Corey Huinker (coreyh) Álvaro Herrera (alvherre) 6 3 years ago Error reporting for multi-line JSON 2949 Committed Bugfix stable Not processed Simon Riggs (simon), Hamid Akhtar (hamidakhtar) Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) 1 5 years ago postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition) 2950 Committed 14 Not processed Matthias van de Meent (mmeent) Bernd Helmle (psoo) Fujii Masao (masaofujii) 1 5 years ago Extend comments on signal handling and cross-reference comments on signal handling functions 2951 Moved to different CF Comments Only Not processed Craig Ringer (ringerc) Mark Dilger (mark.dilger) 3 4 years ago Introduce ProcessInterrupts_hook for C extensions 2952 Moved to different CF Not processed Craig Ringer (ringerc) 3 4 years ago Extend docs on how to write correct postgres-dialect C including extensions and bgworkers 2953 Moved to different CF Docs Only Not processed Craig Ringer (ringerc) Laurenz Albe (laurenz) 4 4 years ago Extend more usecase for planning time partition pruning and init partition pruning. 2954 Withdrawn Performance 14 Not processed 1 5 years ago System catalog accesses in error context callback 2955 Moved to different CF Bugfix Not processed Masahiko Sawada (masahikosawada), Bharath Rupireddy (bharathrupireddy) Tom Lane (tgl) Tom Lane (tgl) 2 4 years ago Add pg_dump --extension to dump specific extensions 2956 Committed System Administration Not processed Guillaume Lelarge (gleu) Asif Rehman (asifrana) Michael Paquier (michael-kun) 1 4 years ago Identify missing publications from publisher while create/alter subscription. 2957 Moved to different CF Not processed vigneshwaran C (vignesh.postgres) Dilip Kumar (dilip.kumar), Euler Taveira (eulerto), Ashutosh Sharma (ashu_coek), Japin Li (japin), Bharath Rupireddy (bharathrupireddy) Amit Kapila (amitkapila) 6 4 years ago Adaptive query optimization: create extented statistics using auto_explain extension 2958 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) 4 4 years ago Improve join selectivity estimation using extended statistics 2959 Moved to different CF Performance Not processed Konstantin Knizhnik (knizhnik) 3 4 years ago Infrastructure changes to make the code less sensitive to transaction id bit width 2960 Moved to different CF Refactoring Only Not processed James Finnerty (jimfinnerty) 3 4 years ago Add PROCESS_TOAST option to VACUUM 2961 Committed SQL Commands Not processed Nathan Bossart (bossartn) Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) 1 5 years ago Fix DROP TABLESPACE on Windows with ProcSignalBarrier? 2962 Moved to different CF Bugfix Not processed Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) Thomas Munro (macdice) 6 4 years ago Record the system catalogs' FK relationships explicitly 2963 Committed Not processed Tom Lane (tgl) Joel Jacobson (joeljacobson) Tom Lane (tgl) 1 5 years ago remove deprecated v8.2 containment operators 2964 Committed 14 Not processed Justin Pryzby (justinpryzby) Tom Lane (tgl) Tom Lane (tgl) 1 5 years ago Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax 2965 Committed SQL Commands Not processed Japin Li (japin) Bharath Rupireddy (bharathrupireddy) Peter Eisentraut (petere) 1 4 years ago Foreign Key Arrays 2966 Moved to different CF SQL Commands Not processed Mark Rofail (markmoheb) Joel Jacobson (joeljacobson), Justin Pryzby (justinpryzby) 3 4 years ago Fix faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination 2967 Committed Bugfix Not processed Julien Rouhaud (rjuju) Dilip Kumar (dilip.kumar), Mahendra Singh Thalor (mahithalor) Álvaro Herrera (alvherre) 1 5 years ago Minimal logical decoding on standbys (take 6) 2968 Moved to different CF Not processed Amit Khandekar (amitdkhan) Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) 5 2 years ago parse mistake in ecpg connect string 2969 Committed Bugfix Not processed Kyotaro Horiguchi (horiguti) Tom Lane (tgl), Hayato Kuroda (ha-kun), Shenhao Wang (wangshenhao) Tom Lane (tgl) 1 5 years ago Set default transactions to read-only at servers start in pg_upgrade 2970 Moved to different CF Bugfix Not processed Denis Laxalde (dlax) Julien Rouhaud (rjuju) 4 4 years ago Fix detection of preadv/pwritev support for OSX. 2971 Moved to different CF Bugfix Not processed James Hilliard (jameshilliard) Cleysson Lima (cleyssonlima) Tom Lane (tgl) 2 4 years ago TRUNCATE on foreign table 2972 Committed SQL Commands 14 Not processed KaiGai Kohei (kaigai), kazutaka onishi (onishi) Fujii Masao (masaofujii), Bharath Rupireddy (bharathrupireddy) Fujii Masao (masaofujii) 1 4 years ago In psql \copy from, send data to server in larger chunks 2973 Moved to different CF Performance Not processed Heikki Linnakangas (heikki) Aleksander Alekseev (aalekseev) Heikki Linnakangas (heikki) 2 4 years ago Simplify COPY FROM parsing by forcing lookahead. 2974 Returned with feedback Refactoring Only Not processed Heikki Linnakangas (heikki) John Naylor (john.naylor) 1 5 years ago Extend more usecase for planning time partition pruning and init partition pruning. 2975 Returned with feedback Performance Not processed 1 5 years ago Improve amcheck to check UNIQUE constraint in btree index 2976 Returned with feedback Monitoring Not processed Anastasia Lubennikova (lubennikovaav), Pavel Borisov (pborisov) Mark Dilger (mark.dilger) 1 1 year ago Improvements and additions to COPY progress reporting 2977 Committed Monitoring 14 Not processed Matthias van de Meent (mmeent) Josef Šimánek (retro), Bharath Rupireddy (bharathrupireddy) Michael Paquier (michael-kun) 1 5 years ago Log authenticated identity from all auth methods 2978 Committed Not processed Jacob Champion (jchampion) Magnus Hagander (mha) Michael Paquier (michael-kun) 1 4 years ago Support tab completion for upper character inputs in psql 2979 Moved to different CF libpq Not processed Haiying Tang (tanghy) Tom Lane (tgl), Peter Eisentraut (petere) Tom Lane (tgl) 5 4 years ago bitwise XOR aggregate functions 2980 Committed stable Not processed Alexey Bashtanov (bashtanov) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 5 years ago partial heap only tuples 2981 Moved to different CF Performance 15 Not processed Nathan Bossart (bossartn) 4 4 years ago 64-bit XIDs in deleted nbtree pages 2982 Committed Bugfix Not processed Peter Geoghegan (pgeoghegan) Masahiko Sawada (masahikosawada) Peter Geoghegan (pgeoghegan) 1 5 years ago Autovacuum dynamic cost_limit, cost_delay 2983 Moved to different CF Bugfix Not processed Scott Mead (meads-amazon) Masahiko Sawada (masahikosawada) 3 4 years ago Some regular-expression performance hacking 2984 Committed Performance Not processed Tom Lane (tgl) Joel Jacobson (joeljacobson) Tom Lane (tgl) 1 5 years ago [DOC] add missing "[ NO ]" to various "DEPENDS ON" synopses 2985 Committed Docs Only stable Not processed Ian Barwick (barwick) Michael Paquier (michael-kun) 1 5 years ago Fallback table AM for relkinds without storage 2986 Returned with feedback 14 Not processed Michael Paquier (michael-kun) 1 5 years ago Allow setting parallel_workers on partitioned tables 2987 Moved to different CF Performance Not processed Seamus Abshere (seamusabshere) Amit Langote (amitlan), Laurenz Albe (laurenz), Zhijie Hou (houzj) 3 4 years ago Minor cleanup patches for collations 2988 Committed Refactoring Only Not processed Thomas Munro (macdice) Thomas Munro (macdice) 1 5 years ago progress reporting for partitioned REINDEX 2989 Committed Monitoring Not processed Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) 1 5 years ago speed up pg_rewind by using copy_file_range() and skipping some fsync 2990 Moved to different CF Performance Not processed Paul Guo (paulguo-vmware) Michael Paquier (michael-kun) 3 4 years ago A qsort template 2991 Committed Refactoring Only Not processed Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) Thomas Munro (macdice) 1 4 years ago Allow batched insert during cross-partition updates 2992 Moved to different CF Not processed Amit Langote (amitlan) Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Zhijie Hou (houzj) Etsuro Fujita (efujita) 10 3 years ago documentation fix for SET ROLE 2993 Committed Docs Only stable Not processed Nathan Bossart (bossartn) Laurenz Albe (laurenz), Joe Conway (jconway), Gerdan Santos (gerdan) Joe Conway (jconway) 1 5 years ago Track wal_level drop for backup management 2994 Moved to different CF Monitoring Not processed Takamichi Osumi (tatatappp) 3 4 years ago Freeze the inserted tuples during CTAS 2995 Withdrawn Performance Not processed Paul Guo (paulguo-vmware) Masahiko Sawada (masahikosawada) 1 5 years ago Speed up verifying UTF-8 2996 Moved to different CF Performance Not processed John Naylor (john.naylor) Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan) John Naylor (john.naylor) 5 4 years ago TRIM_ARRAY 2997 Committed SQL Commands 14 Not processed Vik Fearing (xocolatl) Dian Fay (dmfay) Tom Lane (tgl) 1 5 years ago GROUP BY DISTINCT 2998 Committed SQL Commands 14 Not processed Vik Fearing (xocolatl) Georgios Kokolatos (gkokolatos) Tomas Vondra (fuzzycz) 1 5 years ago Catalog version access 2999 Moved to different CF System Administration Not processed Vik Fearing (xocolatl), Nathan Bossart (bossartn) Nathan Bossart (bossartn) 5 4 years ago Report text parameter values in errors during typinput 3000 Committed 14 Not processed Justin Pryzby (justinpryzby) Tom Lane (tgl) Tom Lane (tgl) 1 5 years ago Feature improvement for TRUNCATE tab completion 3001 Committed libpq Not processed Kota Miyake (ekayim) Muhammad Usama (muhammad_usama) Fujii Masao (masaofujii) 1 5 years ago Deprecate SSL compression 3002 Committed Security Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) Michael Paquier (michael-kun) 1 5 years ago pg_upgrade binary version checks 3003 Committed Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 5 years ago contrib/cube - binary send/recv handlers 3004 Committed Not processed KaiGai Kohei (kaigai) Tom Lane (tgl) Tom Lane (tgl) 1 5 years ago Refactor ECPGconnect() and allow IPv6 connection 3005 Moved to different CF libpq Not processed Hayato Kuroda (ha-kun) 3 4 years ago segfault with after trigger during delete or update 3006 Committed Bugfix stable Not processed Amit Langote (amitlan), Bertrand Drouvot (bdrouvot) Amit Langote (amitlan) Álvaro Herrera (alvherre) 1 5 years ago pgbench: Bug fix for the -d option 3007 Committed libpq Not processed Kota Miyake (ekayim) Michael Paquier (michael-kun) 1 5 years ago Replace buffer I/O locks with condition variables 3008 Committed Refactoring Only Not processed Robert Haas (rhaas) Julien Rouhaud (rjuju), Thomas Munro (macdice) Thomas Munro (macdice) 1 5 years ago Add --tablespace option to reindexdb 3009 Committed libpq 14 Not processed Michael Paquier (michael-kun) Daniel Gustafsson (d_gustafsson), Mark Dilger (mark.dilger) Michael Paquier (michael-kun) 1 5 years ago SSL SNI 3010 Committed System Administration Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 4 years ago pgbench: Remove ecnt, a member variable of CState 3011 Committed libpq Not processed Kota Miyake (ekayim) Michael Paquier (michael-kun) 1 5 years ago archive_command / pg_stat_archiver & documentation 3012 Committed Docs Only 14 Not processed Benoit Lobréau (benoitl) Julien Rouhaud (rjuju) Michael Paquier (michael-kun) 1 5 years ago fix skipping FSM for large tuples and low fillfactors 3013 Committed Bugfix 14 Not processed John Naylor (john.naylor), Floris van Nee (fvannee) Matthias van de Meent (mmeent) Noah Misch (nmisch) 1 5 years ago Fix use of cursor sensitivity terminology 3014 Committed SQL Commands Not processed Peter Eisentraut (petere) Peter Eisentraut (petere) 1 5 years ago wal_compression = pglz/zlib/lz4/zstd 3015 Moved to different CF Performance 15 Not processed Andrey Borodin (x4m), Justin Pryzby (justinpryzby) Michael Paquier (michael-kun), Justin Pryzby (justinpryzby) Michael Paquier (michael-kun) 2 4 years ago Dump public schema ownership, seclabels and comments 3016 Moved to different CF Security Not processed Noah Misch (nmisch) Noah Misch (nmisch) 2 4 years ago public schema default ACL 3017 Moved to different CF Security Not processed Noah Misch (nmisch) Peter Eisentraut (petere) Noah Misch (nmisch) 3 4 years ago Hooks and API to allow loadable wire protocol extensions 3018 Moved to different CF Not processed Jan Wieck (wieck) 3 5 years ago Remove authtype environment variable 3019 Committed Not processed Daniel Gustafsson (d_gustafsson) Peter Eisentraut (petere) Peter Eisentraut (petere) 1 5 years ago alter table set TABLE ACCESS METHOD 3020 Moved to different CF SQL Commands Not processed Justin Pryzby (justinpryzby) Jeff Davis (jdavis) 2 4 years ago Regex backref fixes 3021 Committed Not processed Tom Lane (tgl) Joel Jacobson (joeljacobson) Tom Lane (tgl) 1 5 years ago add DETAIL for wrong SCRAM password 3022 Returned with feedback Bugfix Not processed Jeff Janes (jjanes) Jacob Champion (jchampion) 1 4 years ago Speeding up GIST index builds using popcount 3023 Moved to different CF Performance Not processed Amit Khandekar (amitdkhan) John Naylor (john.naylor) 3 4 years ago Detect dropped connections while running queries 3024 Committed Not processed Thomas Munro (macdice), Sergey Cherkashin (cherkashins) Takayuki Tsunakawa (maumau) Thomas Munro (macdice) 1 4 years ago postgres_fdw: suppress explicit casts in text:text comparisons 3025 Moved to different CF Not processed Dian Fay (dmfay) Tom Lane (tgl), Georgios Kokolatos (gkokolatos) Tom Lane (tgl) 4 4 years ago Add --create-only option to pg_dump/pg_dumpall 3026 Moved to different CF System Administration Not processed Michael Banck (mbanck) Cary Huang (cary), Nitin Jadhav (nitinjadhav11) 3 4 years ago