Commitfest 2021-03
Status summary: Committed: 122. Moved to next CF: 133. Withdrawn: 14. Rejected: 2. Returned with Feedback: 24. Total: 295.
Closed patches
| Patch | ID | Status | 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 next 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 next 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 next CF | stable | Not processed | Teja Mupparti (tejam) | Robert Haas (rhaas), Daniel Shelepanov (dshelepanov) | Robert Haas (rhaas) | 10 | 2 years ago | |
| archive status ".ready" files may be created too early | 2520 | Moved to next 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 next CF | Not processed | Amit Langote (amitlan) | Etsuro Fujita (efujita) | Tom Lane (tgl) | 6 | 3 years ago | ||
| DROP relation IF EXISTS Docs and Tests - Bug Fix | 2603 | Moved to next 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 next 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 next 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 | 3 years ago | ||||
| brin: avoid errors processing work item following concurrent reindex | 2838 | Moved to next 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 | 3 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 | 3 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 | 3 years ago | ||
| Fix firing of RI triggers during cross-partition updates of partitioned tables | 2877 | Moved to next 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 | 3 years ago | |
| invalid data in file backup_label problem on windows | 2938 | Withdrawn | Not processed | Shenhao Wang (wangshenhao) | 1 | 3 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 next CF | Not processed | Masahiko Sawada (masahikosawada), Bharath Rupireddy (bharathrupireddy) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 3 years ago | ||
| Fix DROP TABLESPACE on Windows with ProcSignalBarrier? | 2962 | Moved to next 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 next CF | Not processed | Denis Laxalde (dlax) | Julien Rouhaud (rjuju) | 4 | 3 years ago | |||
| Fix detection of preadv/pwritev support for OSX. | 2971 | Moved to next 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 next CF | Not processed | Scott Mead (meads-amazon) | Masahiko Sawada (masahikosawada) | 3 | 3 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 | 3 years ago | |
| add DETAIL for wrong SCRAM password | 3022 | Returned with feedback | Not processed | Jeff Janes (jjanes) | Jacob Champion (jchampion) | 1 | 3 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 | 3 years ago | ||
| psql - add SHOW_ALL_RESULTS option | 2096 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 13 | 2 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 next 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 next 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 next 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), Hou Zhijie (houzj) | Tom Lane (tgl) | 3 | 3 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 | 3 years ago | |
| libpq trace log | 2889 | Committed | 14 | Not processed | Aya Iwata (iwata.aya) | Takayuki Tsunakawa (maumau), Kirk Jamison (kirkjamison) | Álvaro Herrera (alvherre) | 2 | 3 years ago | |
| Support tab completion for upper character inputs in psql | 2979 | Moved to next 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 next 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 next 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 | 3 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 | 3 years ago | ||
| Further note require activity aspect of automatic checkpoint and archiving | 2774 | Moved to next 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 next 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 | 3 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 | 3 years ago | ||
| Add table expansion hook | 2614 | Moved to next 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 | 3 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 next 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 next 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 next 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 next 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 next 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 | 3 years ago | ||
| install path aware subclass of PostgresNode | 2891 | Committed | 14 | Not processed | Andrew Dunstan (adunstan) | Daniel Gustafsson (d_gustafsson) | Andrew Dunstan (adunstan) | 2 | 3 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 | 3 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 | 3 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 | 3 years ago | |
| Introduce ProcessInterrupts_hook for C extensions | 2952 | Moved to next 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 | 3 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 next 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 next CF | Not processed | Kyotaro Horiguchi (horiguti) | Tomas Vondra (fuzzycz), Antonin Houska (a.houska) | 17 | 2 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 | 3 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 | 3 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 | 3 years ago | ||
| Add extra statistics to explain for Nested Loop | 2765 | Moved to next 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 next 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 | 2 days 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 | 3 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 | 3 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 | 7 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 next CF | Not processed | Takamichi Osumi (tatatappp) | 3 | 3 years ago | ||||
| Performance | ||||||||||
| Protect syscache from bloating with negative cache entries | 931 | Moved to next 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 next 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 next CF | Not processed | Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) | Alena Rybakina (a.rybakina) | Alexander Korotkov (smagen) | 27 | 3 days ago | ||
| Using multicolumn statistics for more precise join selectivity estimatation | 2386 | Moved to next 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 next CF | Not processed | Andy Fan (andyf) | David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Hou Zhijie (houzj) | 11 | 2 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 | 3 years ago | |
| BRIN multi-minmax and bloom indexes | 2523 | Committed | Not processed | Tomas Vondra (fuzzycz) | John Naylor (john.naylor) | Tomas Vondra (fuzzycz) | 5 | 3 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 next 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 | 3 years ago | |
| Overhaul UPDATE/DELETE processing | 2575 | Committed | Not processed | Amit Langote (amitlan) | Tom Lane (tgl) | Tom Lane (tgl) | 5 | 3 years ago | ||
| Fast COPY FROM command for the foreign tables | 2601 | Moved to next 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), Hou Zhijie (houzj) | Amit Kapila (amitkapila) | 5 | 4 years ago | ||
| More scalable multixacts buffers and locking | 2627 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | Álvaro Herrera (alvherre) | 20 | 11 months ago | |||
| Covering SPGiST index | 2675 | Committed | Not processed | Pavel Borisov (pborisov) | Andrey Borodin (x4m) | Tom Lane (tgl) | 4 | 3 years ago | ||
| Optimizing NULL check on pkey column | 2699 | Moved to next 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 next CF | Not processed | Álvaro Herrera (alvherre) | 11 | 11 months 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 next CF | Not processed | bucoo hsiao (bucoo) | 6 | 3 years ago | ||||
| Replace polyphase merge with a simple k-way balanced merge | 2781 | Moved to next 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 next CF | Not processed | Takamichi Osumi (tatatappp) | Takayuki Tsunakawa (maumau) | 4 | 3 years ago | |||
| Make Append Cost aware of some run time partition prune case | 2829 | Moved to next CF | Not processed | Andy Fan (andyf) | 5 | 3 years ago | ||||
| Add nullif case for eval_const_expressions | 2833 | Committed | Not processed | Hou Zhijie (houzj) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 3 years ago | ||
| Parallel Inserts in CREATE TABLE AS | 2841 | Withdrawn | Not processed | Bharath Rupireddy (bharathrupireddy) | vigneshwaran C (vignesh.postgres), Hou Zhijie (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), Hou Zhijie (houzj) | Amit Kapila (amitkapila) | 2 | 3 years ago | |
| Consider parallel for LATERAL subqueries having LIMIT/OFFSET | 2851 | Moved to next 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) | Hou Zhijie (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 | 3 years ago | ||
| Faster pglz compression | 2897 | Moved to next 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 next CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Thomas Munro (macdice) | Thomas Munro (macdice) | 12 | 1 year 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 next 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 next 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 next CF | Not processed | Michail Nikolaev (nkey) | Antonin Houska (a.houska) | 6 | 2 years ago | |||
| Simplify some RI checks to reduce SPI overhead | 2948 | Moved to next CF | Not processed | Amit Langote (amitlan) | Tom Lane (tgl), Corey Huinker (coreyh) | Álvaro Herrera (alvherre) | 6 | 2 years ago | ||
| Extend more usecase for planning time partition pruning and init partition pruning. | 2954 | Withdrawn | 14 | Not processed | 1 | 3 years ago | ||||
| Adaptive query optimization: create extented statistics using auto_explain extension | 2958 | Moved to next CF | Not processed | Konstantin Knizhnik (knizhnik) | 4 | 3 years ago | ||||
| Improve join selectivity estimation using extended statistics | 2959 | Moved to next CF | Not processed | Konstantin Knizhnik (knizhnik) | 3 | 3 years ago | ||||
| In psql \copy from, send data to server in larger chunks | 2973 | Moved to next 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 | 3 years ago | |||||
| partial heap only tuples | 2981 | Moved to next 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 next CF | Not processed | Seamus Abshere (seamusabshere) | Amit Langote (amitlan), Laurenz Albe (laurenz), Hou Zhijie (houzj) | 3 | 3 years ago | |||
| speed up pg_rewind by using copy_file_range() and skipping some fsync | 2990 | Moved to next 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 next 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 next CF | 15 | Not processed | Andrey Borodin (x4m), Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun), Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun) | 2 | 3 years ago | |
| Speeding up GIST index builds using popcount | 3023 | Moved to next CF | Not processed | Amit Khandekar (amitdkhan) | John Naylor (john.naylor) | 3 | 3 years ago | |||
| Procedural Languages | ||||||||||
| declarative session variables, LET command | 1608 | Moved to next CF |
6/7
|
+9964−65 | 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) | 35 | 1 week ago | ||
| UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR | 2376 | Moved to next CF | Not processed | John Dent (denty) | Daniel Vérité (danielverite) | 9 | 3 years ago | |||
| enhancing plpgsql API for debugging and tracing | 2684 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Aleksander Alekseev (aalekseev) | Tom Lane (tgl) | 9 | 2 years ago | ||
| possibility to rename root namespace in plpgsql | 2839 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Julien Rouhaud (rjuju) | 7 | 3 years ago | |||
| Refactoring | ||||||||||
| Remove page-read callback from XLogReaderState | 2113 | Moved to next 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 next 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 | 3 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 | 3 years ago | |
| ResourceOwner refactoring | 2834 | Moved to next 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 next 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 next 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 | 3 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 | 2 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 next 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 | 2 years ago | ||
| Make message at end-of-recovery less scary | 2490 | Moved to next 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 | 3 years ago | |
| Background writer and checkpointer in crash recovery | 2706 | Moved to next 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 next CF | 15 | Not processed | Euler Taveira (eulerto), Peter Smith (smithpb), Ajin Cherian (ajinc), Hou Zhijie (houzj) | Dilip Kumar (dilip.kumar), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Hou Zhijie (houzj), Rahila Syed (rahila) | Amit Kapila (amitkapila) | 7 | 3 years ago | |
| wal_sessioninfo | 2910 | Moved to next CF | Not processed | Simon Riggs (simon) | Cleysson Lima (cleyssonlima) | 4 | 3 years ago | |||
| logical decoding of two-phase transactions | 2914 | Moved to next 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 next 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 next 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 | 2 years ago | ||
| Minimal logical decoding on standbys (take 6) | 2968 | Moved to next CF | Not processed | Amit Khandekar (amitdkhan) | Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) | 5 | 1 year 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 | 3 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 | 3 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 next CF | Not processed | Noah Misch (nmisch) | Noah Misch (nmisch) | 2 | 3 years ago | |||
| public schema default ACL | 3017 | Moved to next 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 next 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 next 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 | 2 years ago | ||
| A hook for path-removal decision on add_path | 2234 | Moved to next CF | Not processed | KaiGai Kohei (kaigai) | 11 | 2 years ago | ||||
| Fix partitionwise join with partially-redundant join clauses | 2266 | Moved to next CF | Not processed | Richard Guo (richardguo) | Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) | Richard Guo (richardguo) | 16 | 7 months ago | ||
| Global temporary table | 2349 | Moved to next CF | 16 | Not processed | Wenjing Zeng (wenjing.zwj) | Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) | 13 | 2 years ago | ||
| GUC to disable cancellation of awaiting for synchronous replication | 2402 | Moved to next CF | Not processed | Andrey Borodin (x4m) | Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev) | 9 | 3 years ago | |||
| truncating timestamps on arbitrary intervals | 2474 | Committed | Not processed | John Naylor (john.naylor) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 6 | 3 years ago | ||
| jsonpath syntax extensions | 2482 | Moved to next CF | 15 | Not processed | Nikita Glukhov (n.glukhov) | 12 | 2 years ago | |||
| Auto-analyze on partitioned tables | 2492 | Committed | Not processed | Yuzuko Hosoya (yuzu) | Justin Pryzby (justinpryzby) | Álvaro Herrera (alvherre) | 6 | 3 years ago | ||
| ALTER SYSTEM READ { ONLY | WRITE } | 2602 | Moved to next 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 next 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 | 3 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 | 3 years ago | |||
| ALTER TABLE .. DETACH PARTITION CONCURRENTLY | 2714 | Committed | Not processed | Álvaro Herrera (alvherre) | Anastasia Lubennikova (lubennikovaav), Justin Pryzby (justinpryzby) | Álvaro Herrera (alvherre) | 4 | 3 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 | 3 years ago | |
| Extended statistics / estimate Var op Var clauses | 2831 | Moved to next 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 | 3 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 | 3 years ago | |
| Initial mach based shared memory support. | 2843 | Returned with feedback | Not processed | James Hilliard (jameshilliard) | 2 | 3 years ago | ||||
| Xact event callback at command start | 2860 | Moved to next 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 | 3 years ago | ||
| New Table Access Methods for Multi and Single Inserts | 2871 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 9 | 4 months ago | ||||
| On client login event trigger | 2900 | Moved to next 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 next CF | 15 | Not processed | Nikita Glukhov (n.glukhov) | Andrew Dunstan (adunstan) | 7 | 2 years ago | ||
| SQL/JSON: JSON_TABLE | 2902 | Moved to next CF | 15 | Not processed | Nikita Glukhov (n.glukhov) | Andrew Dunstan (adunstan) | 7 | 2 years ago | ||
| Discarding DISCARD ALL | 2919 | Moved to next CF | 15 | Not processed | Simon Riggs (simon) | 3 | 3 years ago | |||
| Table AM modifications to accept column projection lists | 2922 | Moved to next CF | Not processed | Jacob Champion (jchampion), Soumyadeep Chakraborty (soumyadeepc) | 3 | 3 years ago | ||||
| Key management with tests | 2925 | Moved to next CF | 15 | Not processed | Stephen Frost (sfrost), Masahiko Sawada (masahikosawada), Bruce Momjian (bmomjian) | 3 | 2 years ago | |||
| EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW | 2928 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Japin Li (japin) | 2 | 3 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 next CF | Not processed | Amit Langote (amitlan) | Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Hou Zhijie (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 next 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 | 3 years ago | |||
| Incremental Materialized View Maintenance | 2138 | Moved to next 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 | 3 years ago | ||
| FETCH FIRST clause PERCENT option | 2176 | Moved to next CF | Not processed | Surafel Temesgen (surafel) | 12 | 3 years ago | ||||
| Implement INSERT SET syntax | 2218 | Moved to next 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 next 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 | 3 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 | 3 years ago | ||
| Change return type of EXTRACT to numeric | 2679 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 3 | 3 years ago | |||
| Automatic HASH and LIST partition creation | 2694 | Moved to next 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 | 3 years ago | |||
| Allow COPY "text" to output a header and add header matching mode to COPY FROM | 2780 | Moved to next CF | Not processed | Rémi Lapeyre (remilapeyre) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 8 | 2 years ago | ||
| CLUSTER on partitioned table | 2800 | Moved to next CF | 15 | Not processed | Justin Pryzby (justinpryzby) | Matthias van de Meent (mmeent) | Álvaro Herrera (alvherre) | 8 | 2 years ago | |
| DROP INDEX CONCURRENTLY on partitioned index | 2805 | Moved to next CF | 15 | Not processed | Justin Pryzby (justinpryzby) | 4 | 3 years ago | |||
| CREATE INDEX CONCURRENTLY on partitioned table | 2815 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) | Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) | 15 | 4 months ago | |||
| create table like: ACCESS METHOD | 2865 | Moved to next CF | 15 | Not processed | Justin Pryzby (justinpryzby) | Simon Riggs (simon) | 4 | 3 years ago | ||
| REINDEX backend filtering | 2895 | Moved to next CF | Not processed | Julien Rouhaud (rjuju) | 3 | 4 years ago | ||||
| Dynamic result sets from procedures | 2911 | Moved to next CF | Not processed | Peter Eisentraut (petere) | 12 | 2 years ago | ||||
| MERGE SQL command | 2920 | Moved to next CF | 15 | Not processed | Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) | 4 | 2 years ago | |||
| Partial foreign key updates in referential integrity triggers | 2932 | Moved to next 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 next CF | Not processed | Simon Riggs (simon) | 3 | 3 years ago | ||||
| Rename of triggers for partitioned tables | 2943 | Moved to next 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 | 3 years ago | ||
| Foreign Key Arrays | 2966 | Moved to next 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 | 3 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 next 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 next 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 | 3 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), Hou Zhijie (houzj) | Magnus Hagander (mha) | 2 | 3 years ago | ||
| Fix pg_rewind race condition just after promotion | 2864 | Moved to next 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 next CF | Not processed | Heikki Linnakangas (heikki) | Daniel Gustafsson (d_gustafsson), Cary Huang (cary) | Daniel Gustafsson (d_gustafsson) | 7 | 2 years ago | ||
| zstd compression for pg_dump | 2888 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Andreas Karlsson (kandreas), Jacob Champion (jchampion) | Tomas Vondra (fuzzycz) | 4 | 1 year 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 next 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 next 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 | 3 years ago | ||
| Catalog version access | 2999 | Moved to next 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 | 3 years ago | |||
| Add --create-only option to pg_dump/pg_dumpall | 3026 | Moved to next CF | Not processed | Michael Banck (mbanck) | Cary Huang (cary), Nitin Jadhav (nitinjadhav11) | 3 | 3 years ago | |||