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