Commitfest 2021-01
Status summary: Committed: 56. Moved to next CF: 192. Withdrawn: 8. Returned with Feedback: 4. Total: 260.
Closed patches
| Patch | ID | Status | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | ||||||||||
| COPY FREEZE, PD_VISIBLE_ALL and VM status | 2009 | Committed | Not processed | Pavan Deolasee (pavan), Ibrar Ahmed (ibrar) | Darafei Praliaskouski (komzpa), Hamid Akhtar (hamidakhtar) | Tomas Vondra (fuzzycz) | 6 | 4 years ago | ||
| Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) | 2026 | Committed | stable | Not processed | Noah Misch (nmisch) | Andrey Borodin (x4m) | Noah Misch (nmisch) | 10 | 4 years ago | |
| 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 | |||
| fix (partially) pgbench :variable substitution for -M extended and prepared | 2624 | Committed | Not processed | Fabien Coelho (calvin) | Tom Lane (tgl) | Tom Lane (tgl) | 4 | 4 years ago | ||
| shared tempfile was not removed on statement_timeout | 2657 | Moved to next CF | stable | Not processed | Thomas Munro (macdice), Justin Pryzby (justinpryzby) | Thomas Munro (macdice) | 4 | 4 years ago | ||
| Fix autovac for large number of tables | 2658 | Committed | Not processed | Kasahara Tatsuhito (kasahara) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 3 | 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 | Moved to next CF | 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 | |||
| Corner-case bug in pg_rewind | 2730 | Committed | stable | Not processed | Ian Barwick (barwick) | Pavel Borisov (pborisov) | Heikki Linnakangas (heikki) | 2 | 4 years ago | |
| Incorrect usages of PG_GETARG_UINT32 | 2742 | Committed | Not processed | Ashutosh Bapat (ashutoshbapat) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 4 years ago | ||
| Fix broken query with gather merge paths added in incremental sort patch | 2754 | Committed | 13 | Not processed | James Coleman (jcole1989) | Tomas Vondra (fuzzycz), Jaime Casanova (jcasanov) | Tomas Vondra (fuzzycz) | 2 | 4 years ago | |
| explain: show JIT details in non-text format, even if zero | 2766 | Withdrawn | stable | Not processed | Justin Pryzby (justinpryzby) | Tom Lane (tgl) | 2 | 4 years ago | ||
| pgbench stopped supporting large number of client connections on Windows | 2827 | Moved to next CF | 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 | ||
| CLUSTER blocks scanned progress reporting | 2840 | Committed | stable | Not processed | Matthias van de Meent (mmeent) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 1 | 4 years ago | |
| BUG FIX: Btree index should not be built in parallel in standalone mode | 2847 | Committed | stable | Not processed | Yulin PEI (pylser) | Tom Lane (tgl), Masahiko Sawada (masahikosawada) | Tom Lane (tgl) | 1 | 4 years ago | |
| orphaned function | 2850 | Moved to next CF | stable | Not processed | Bertrand Drouvot (bdrouvot) | Gilles Darold (darold) | 2 | 3 years ago | ||
| Fix generate_useful_gather_paths for parallel unsafe pathkeys | 2852 | Committed | Not processed | James Coleman (jcole1989) | Tomas Vondra (fuzzycz) | Tomas Vondra (fuzzycz) | 1 | 4 years ago | ||
| Fixes for phrase search with multi-lexeme tokens | 2854 | Moved to next CF | 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 | Moved to next CF | Not processed | Takayuki Tsunakawa (maumau) | Bharath Rupireddy (bharathrupireddy) | 2 | 3 years ago | |||
| Protect archive recovery from missing data | 2867 | Moved to next CF | 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 possible segfault in walreceiver | 2873 | Withdrawn | Not processed | Fujii Masao (masaofujii) | 1 | 4 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 | ||
| postgres_fdw - cached connection leaks if the associated user mapping/foreign server is dropped | 2882 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Fujii Masao (masaofujii), Hou Zhijie (houzj) | Fujii Masao (masaofujii) | 1 | 4 years ago | ||
| CREATE INDEX CONCURRENTLY does not index prepared xact's data | 2886 | Committed | Not processed | Andrey Borodin (x4m) | Noah Misch (nmisch) | Noah Misch (nmisch) | 1 | 4 years ago | ||
| Incorrect allocation handling for cryptohash functions with OpenSSL | 2887 | Committed | 14 | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 4 years ago | ||
| Clients | ||||||||||
| New libpq option to prefer standby for connection | 1677 | Moved to next CF | 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 | Moved to next CF | Not processed | Fabien Coelho (calvin), Hironobu Suzuki (suzuki_hironobu) | Muhammad Usama (muhammad_usama) | Dean Rasheed (deanr) | 14 | 3 years ago | ||
| ECPG new statement: DECLARE STATEMENT | 2334 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | ||
| Improve pg_dump dumping publication tables | 2728 | Withdrawn | stable | Not processed | John Hsu (jhsu) | Cary Huang (cary) | 2 | 4 years 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 | Moved to next CF | 14 | Not processed | Greg Sabino Mullane (greg) | Ian Barwick (barwick), Hou Zhijie (houzj) | Tom Lane (tgl) | 3 | 3 years ago | |
| list of extended statistics on psql | 2801 | Committed | 14 | Not processed | Tatsuro Yamada (tatsuro_yamada) | Álvaro Herrera (alvherre), Tomas Vondra (fuzzycz), Pavel Stehule (okbobcz), Julien Rouhaud (rjuju), Atsushi Torikoshi (atsushitorikoshi) | Tomas Vondra (fuzzycz) | 2 | 4 years ago | |
| Multiple hosts in connection string failed to failover in non-hot standby mode | 2823 | Committed | Not processed | Hubert Zhang (hubertz) | Takayuki Tsunakawa (maumau) | Tom Lane (tgl) | 1 | 4 years ago | ||
| allow to \dtS+ pg_toast.* | 2855 | Committed | 14 | Not processed | Justin Pryzby (justinpryzby) | Laurenz Albe (laurenz) | Tom Lane (tgl) | 1 | 4 years ago | |
| Feature improvement for CLOSE, FETCH, MOVE tab completion | 2875 | Committed | 14 | Not processed | Shinya Kato (kato-shinya) | Fujii Masao (masaofujii) | 1 | 4 years ago | ||
| Improve \e, \ef and \ev if the editor is quit | 2879 | Moved to next CF | 14 | Not processed | Laurenz Albe (laurenz) | Jacob Champion (jchampion) | Tom Lane (tgl) | 2 | 3 years ago | |
| Add table access method as an option to pgbench | 2884 | Withdrawn | Not processed | David Zhang (david.z) | Michael Paquier (michael-kun), Fabien Coelho (calvin), youichi aramaki (aramaky) | 1 | 4 years ago | |||
| libpq trace log | 2889 | Moved to next CF | 14 | Not processed | Aya Iwata (iwata.aya) | Takayuki Tsunakawa (maumau), Kirk Jamison (kirkjamison) | Álvaro Herrera (alvherre) | 2 | 3 years ago | |
| Code Comments | ||||||||||
| Fix comment about generate_gather_paths | 2876 | Returned with feedback | Not processed | Hou Zhijie (houzj) | 1 | 4 years ago | ||||
| Documentation | ||||||||||
| Document concurrent index builds waiting on each other | 2454 | Committed | stable | Not processed | James Coleman (jcole1989) | David Johnston (polobo) | Álvaro Herrera (alvherre) | 5 | 4 years ago | |
| Additional Chapter "Architecture" for Part "Tutorial" | 2541 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | Not processed | David Johnston (polobo) | Magnus Hagander (mha) | 3 | 4 years ago | |||
| Minor variable related cleanup and rewording of plpgsql docs | 2778 | Moved to next CF | Not processed | David Johnston (polobo) | Pavel Stehule (okbobcz), David Steele (dsteele) | Tom Lane (tgl) | 3 | 4 years ago | ||
| Consistent linking of RFC mentions | 2828 | Committed | Not processed | Daniel Gustafsson (d_gustafsson) | Heikki Linnakangas (heikki) | 1 | 4 years ago | |||
| doc review for v14 | 2890 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun) | 2 | 4 years ago | ||
| document the hook system | 2915 | Moved to next CF | 14 | Not processed | David Fetter (dfetter) | 2 | 4 years ago | |||
| Clarify that CREATEROLE roles can GRANT default roles | 2921 | Moved to next CF | Not processed | Michael Banck (mbanck) | Robert Treat (xzilla) | Magnus Hagander (mha) | 2 | 4 years ago | ||
| Miscellaneous | ||||||||||
| parse-time support function for "any" datatype | 2081 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 10 | 4 years ago | ||||
| unicode unescape function | 2613 | Moved to next CF | 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 | |||
| Allow terminating the idle sessions | 2646 | Committed | Not processed | Japin Li (japin) | David Johnston (polobo), Hayato Kuroda (ha-kun) | Tom Lane (tgl) | 3 | 4 years ago | ||
| PATCH: Attempt to make dbsize a bit more consistent | 2701 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | Not processed | Jeff Davis (jdavis) | Georgios Kokolatos (gkokolatos) | 4 | 4 years ago | |||
| Runtime control over CLOBBER_CACHE_ALWAYS for targeted debugging | 2749 | Committed | Not processed | Craig Ringer (ringerc) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 4 years ago | ||
| (ALTER SYSTEM) SET +=/-= operator support | 2750 | Moved to next CF | 14 | Not processed | Abhijit Menon-Sen (ams) | Ibrar Ahmed (ibrar) | 3 | 4 years ago | ||
| scram-sha-256 broken with FIPS and OpenSSL 1.0.2 (Switch SHA2 to use EVP for OpenSSL) | 2762 | Committed | 14 | Not processed | Michael Paquier (michael-kun) | Daniel Gustafsson (d_gustafsson) | Michael Paquier (michael-kun) | 2 | 4 years ago | |
| Improve replay pause | 2795 | Moved to next CF | Not processed | Dilip Kumar (dilip.kumar) | Kyotaro Horiguchi (horiguti), Yugo Nagata (yugo.nagata), Bharath Rupireddy (bharathrupireddy) | Robert Haas (rhaas) | 3 | 4 years ago | ||
| remove deprecated v8.2 containment operators | 2798 | Returned with feedback | 14 | Not processed | Justin Pryzby (justinpryzby) | Peter Eisentraut (petere) | 2 | 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 | |||
| Improving the connection authorization message for GSS authenticated/encrypted connections | 2821 | Committed | Not processed | vigneshwaran C (vignesh.postgres) | Bharath Rupireddy (bharathrupireddy) | Stephen Frost (sfrost) | 1 | 4 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 | ||
| Pageinspect functions for GiST | 2825 | Committed | Not processed | Heikki Linnakangas (heikki) | Andrey Borodin (x4m) | Heikki Linnakangas (heikki) | 1 | 3 years ago | ||
| Sloppiness around failure handling of parsePGArray in pg_dump | 2830 | Committed | 14 | Not processed | Michael Paquier (michael-kun) | Daniel Gustafsson (d_gustafsson) | Michael Paquier (michael-kun) | 1 | 4 years ago | |
| Refactor MD5 implementations and switch to EVP for OpenSSL | 2846 | Committed | 14 | Not processed | Michael Paquier (michael-kun) | Daniel Gustafsson (d_gustafsson) | Michael Paquier (michael-kun) | 1 | 4 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 | Moved to next CF | 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 | |||
| Some more hackery around cryptohashes (some fixes + SHA1) | 2868 | Committed | 14 | Not processed | Michael Paquier (michael-kun) | Heikki Linnakangas (heikki) | Michael Paquier (michael-kun) | 1 | 4 years ago | |
| Add primary keys to system catalogs | 2872 | Committed | Not processed | Peter Eisentraut (petere) | Tom Lane (tgl) | Peter Eisentraut (petere) | 1 | 4 years ago | ||
| Refactoring HMAC in the core code | 2878 | Moved to next CF | 14 | Not processed | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 2 | 3 years ago | ||
| install path aware subclass of PostgresNode | 2891 | Moved to next CF | 14 | Not processed | Andrew Dunstan (adunstan) | Daniel Gustafsson (d_gustafsson) | Andrew Dunstan (adunstan) | 2 | 3 years ago | |
| Fail Fast In CTAS/CMV If Relation Already Exists To Avoid Unnecessary Rewrite, Planning Costs | 2892 | Committed | 14 | Not processed | Bharath Rupireddy (bharathrupireddy) | Michael Paquier (michael-kun), Hou Zhijie (houzj) | Michael Paquier (michael-kun) | 1 | 4 years ago | |
| Move regression tablespace cleanup from makefiles pg_regress? (Occasional tablespace.sql failures in check-world -jnn) | 2893 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 14 | Not processed | tomohiro hiramitsu (hiramit) | Kasahara Tatsuhito (kasahara) | Fujii Masao (masaofujii) | 2 | 4 years ago | |
| Let's start using setenv() | 2904 | Committed | Not processed | Tom Lane (tgl) | Thomas Munro (macdice) | Tom Lane (tgl) | 1 | 4 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 | Moved to next CF | Not processed | Julien Rouhaud (rjuju) | atsushi torikoshi (atorik), Evgeny Efimkin (efimkine), Nitin Jadhav (nitinjadhav11) | Bruce Momjian (bmomjian) | 10 | 3 years ago | ||
| Add Information during standby recovery conflicts | 2604 | Committed | 14 | Not processed | Bertrand Drouvot (bdrouvot) | Masahiko Sawada (masahikosawada) | Fujii Masao (masaofujii) | 4 | 4 years ago | |
| Add session statistics to pg_stat_database | 2639 | Committed | 14 | Not processed | Laurenz Albe (laurenz) | Magnus Hagander (mha), ahsan hadi (ahsan.hadi), Masahiro Ikeda (masahiro.ikeda), Soumyadeep Chakraborty (soumyadeepc) | Magnus Hagander (mha) | 3 | 4 years ago | |
| update ps display for recovery checkpoint | 2688 | Committed | Not processed | Justin Pryzby (justinpryzby) | Nathan Bossart (bossartn), Kirk Jamison (kirkjamison) | Michael Paquier (michael-kun) | 3 | 4 years ago | ||
| Get memory contexts of an arbitrary backend process | 2711 | Moved to next CF | 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 | Moved to next CF | 14 | Not processed | Atsushi Torikoshi (atsushitorikoshi) | Fujii Masao (masaofujii), Tatsuro Yamada (tatsuro_yamada), PAscal L (pascall), Chengxi Sun (martin-sun) | 4 | 3 years ago | ||
| Feature improvement for pg_stat_statements | 2738 | Committed | 14 | Not processed | Naoki Nakamichi (naokinakamichi) | Yuki Seino (seinoyu) | Fujii Masao (masaofujii) | 2 | 4 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 | Moved to next CF | 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 | Moved to next CF | 14 | Not processed | Masahiro Ikeda (masahiro.ikeda) | Fujii Masao (masaofujii) | 2 | 3 years ago | ||
| Add wait_start column to pg_locks | 2883 | Moved to next CF | 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 | Moved to next CF | Not processed | Julien Rouhaud (rjuju) | Magnus Hagander (mha), Masahiro Ikeda (masahiro.ikeda) | Magnus Hagander (mha) | 2 | 3 years ago | ||
| Simple progress reporting for COPY command | 2923 | Committed | Not processed | Josef Šimánek (retro) | Tomas Vondra (fuzzycz) | Tomas Vondra (fuzzycz) | 1 | 4 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 | ||
| bitmap cost should account for correlated indexes | 2310 | Returned with feedback | 14 | Not processed | Justin Pryzby (justinpryzby) | 7 | 4 years ago | |||
| Optimize dropping of relation buffers during recovery | 2319 | Committed | Not processed | Kirk Jamison (kirkjamison) | Takayuki Tsunakawa (maumau), Haiying Tang (tanghy) | Amit Kapila (amitkapila) | 7 | 4 years 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 | Moved to next CF | 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 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | John Naylor (john.naylor) | Tomas Vondra (fuzzycz) | 5 | 3 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 | Moved to next CF | 14 | Not processed | David Rowley (davidrowley) | Andy Fan (andyf) | David Rowley (davidrowley) | 5 | 3 years ago | |
| Overhaul UPDATE/DELETE processing | 2575 | Moved to next CF | 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 | Moved to next CF | 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 | ||
| postgres_fdw insert batching | 2620 | Committed | 14 | Not processed | Takayuki Tsunakawa (maumau) | Tomas Vondra (fuzzycz) | 4 | 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 | |||
| avoid bitmapOR-ing indexes for scan conditions implied by partition constraint | 2644 | Returned with feedback | 14 | Not processed | Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) | Konstantin Knizhnik (knizhnik), Justin Pryzby (justinpryzby) | Tom Lane (tgl) | 3 | 4 years ago | |
| Covering SPGiST index | 2675 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 3 | 3 years ago | |||
| Bottom-up index deletion (targets old duplicate versions from non-HOT updates) | 2757 | Committed | 14 | Not processed | Peter Geoghegan (pgeoghegan) | Peter Geoghegan (pgeoghegan) | 2 | 4 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 | Moved to next CF | 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 | Moved to next CF | Not processed | Hou Zhijie (houzj) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 3 years ago | ||
| Parallel Inserts in CREATE TABLE AS | 2841 | Moved to next CF | 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 | Moved to next CF | 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 | |
| {CREATE INDEX, REINDEX} CONCURRENTLY improvements | 2849 | Committed | 14 | Not processed | Álvaro Herrera (alvherre) | Hamid Akhtar (hamidakhtar) | Álvaro Herrera (alvherre) | 1 | 4 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | Not processed | David Fetter (dfetter) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 4 years ago | ||
| Tid scan improvements | 2924 | Moved to next CF | Not processed | David Rowley (davidrowley), Edmund Horner (ejrh) | David Rowley (davidrowley) | 2 | 4 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 write window function in PL languages (like PLpgSQL) | 2697 | Withdrawn | Not processed | Pavel Stehule (okbobcz) | 3 | 4 years ago | ||||
| faster execution of CALL statement from plpgsql | 2819 | Committed | Not processed | Pavel Stehule (okbobcz) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 4 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 | |||
| Reimplement assignment in pl/pgsql | 2874 | Committed | Not processed | Tom Lane (tgl) | Pavel Stehule (okbobcz) | Tom Lane (tgl) | 1 | 4 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 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 6 | 4 years ago | |||
| Refactor nodeModifyTable.c to allow lazy opening of result relations | 2621 | Moved to next CF | 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 | Moved to next CF | 14 | Not processed | Amit Langote (amitlan) | Ryan Lambert (ryanlambert), Andy Fan (andyf) | David Rowley (davidrowley) | 3 | 3 years ago | |
| Remove the -o commandline switch to postmaster | 2820 | Committed | Not processed | Magnus Hagander (mha) | Magnus Hagander (mha) | 1 | 4 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 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 2 | 4 years ago | |||
| Printing LSN made easy | 2848 | Moved to next CF | Not processed | Ashutosh Bapat (ashutoshbapat) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 4 years ago | ||
| Remove make_sort from create_gather_merge_plan; error instead | 2853 | Committed | Not processed | James Coleman (jcole1989) | Tomas Vondra (fuzzycz) | Tomas Vondra (fuzzycz) | 1 | 4 years ago | ||
| pg_preadv() and pg_pwritev() | 2885 | Committed | Not processed | Thomas Munro (macdice) | James Hilliard (jameshilliard) | Thomas Munro (macdice) | 1 | 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 | |||
| Moving other hex functions to /common | 2912 | Committed | stable | Not processed | Bruce Momjian (bmomjian) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 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 | Moved to next CF | Not processed | Thomas Munro (macdice) | David Kimura (dgkimura) | Thomas Munro (macdice) | 7 | 2 years ago | ||
| Improve handling of parameter differences in physical replication | 2489 | Committed | Not processed | Peter Eisentraut (petere) | Sergei Kornilov (melkij) | Peter Eisentraut (petere) | 5 | 4 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 | Moved to next CF | Not processed | James Coleman (jcole1989) | David Zhang (david.z) | Fujii Masao (masaofujii) | 5 | 4 years ago | ||
| implement LogicalDecodeMessageCB for pgoutput | 2661 | Moved to next CF | 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 | ||
| allow restore_command to be changed with reload | 2802 | Committed | Not processed | Sergei Kornilov (melkij) | Fujii Masao (masaofujii) | 2 | 4 years ago | |||
| cleanup temporary files after crash | 2803 | Moved to next CF | 14 | Not processed | Euler Taveira (eulerto) | Anastasia Lubennikova (lubennikovaav), Gerdan Santos (gerdan) | Tomas Vondra (fuzzycz) | 3 | 4 years ago | |
| Fix walsender not to fail to track timeline switch. | 2894 | Committed | Not processed | Kyotaro Horiguchi (horiguti) | Fujii Masao (masaofujii) | 1 | 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 | |
| Security | ||||||||||
| Support for NSS as TLS backend | 2592 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | Andres Freund (andresfreund), Jacob Champion (jchampion) | 5 | 3 years ago | |||
| pg_read_all_data default role | 2702 | Moved to next CF | 14 | Not processed | Stephen Frost (sfrost) | Georgios Kokolatos (gkokolatos) | Stephen Frost (sfrost) | 4 | 3 years ago | |
| OpenSSL 3.0.0 compatibility | 2810 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | 3 | 4 years ago | ||||
| Fix OpenSSL connection setup debug callback | 2905 | Committed | Not processed | Daniel Gustafsson (d_gustafsson) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 4 years ago | ||
| Tying an object's ownership to datdba | 2913 | Moved to next CF | 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 | Moved to next CF | 14 | Not processed | David Fetter (dfetter) | 2 | 4 years ago | |||
| Server Features | ||||||||||
| Generic type subscripting | 1062 | Committed | 14 | Not processed | Dmitry Dolgov (erthalion) | Tom Lane (tgl), Pavel Stehule (okbobcz), Artur Zakirov (a.zakirov) | Alexander Korotkov (smagen) | 19 | 4 years ago | |
| Push aggregation down to base relations and joins | 1247 | Moved to next CF | 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 | |||
| Extended statistics improvements | 2421 | Committed | Not processed | Tomas Vondra (fuzzycz) | Dean Rasheed (deanr) | Dean Rasheed (deanr) | 5 | 4 years ago | ||
| truncating timestamps on arbitrary intervals | 2474 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | Not processed | sho kato (kato-sho) | Anastasia Lubennikova (lubennikovaav), ahsan hadi (ahsan.hadi) | 4 | 3 years ago | |||
| ALTER TABLE .. DETACH PARTITION CONCURRENTLY | 2714 | Moved to next CF | 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 | Moved to next CF | Not processed | movead li (movead.li) | Shinya Kato (kato-shinya) | Fujii Masao (masaofujii) | 3 | 4 years ago | ||
| protocol default result formats setting | 2812 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Emre Hasegeli (hasegeli) | 3 | 4 years ago | |||
| custom compression methods for toast | 2813 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | Not processed | James Hilliard (jameshilliard) | 2 | 3 years ago | ||||
| global temporary table v37 | 2845 | Withdrawn | Not processed | 1 | 2 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 | Moved to next CF | 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 | |||
| SQL Commands | ||||||||||
| Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT | 1533 | Moved to next CF | 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 | |||
| range_agg / multiranges | 2112 | Committed | 14 | Not processed | Paul Jungwirth (pjungwir) | Pavel Stehule (okbobcz), Jeff Davis (jdavis) | Alexander Korotkov (smagen) | 9 | 4 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 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | Not processed | Dave Cramer (dcramer) | Laurenz Albe (laurenz) | 5 | 3 years ago | |||
| SEARCH and CYCLE clauses | 2570 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Pavel Stehule (okbobcz), Vik Fearing (xocolatl) | Peter Eisentraut (petere) | 5 | 4 years ago | ||
| SQL-standard function body | 2630 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Julien Rouhaud (rjuju) | Peter Eisentraut (petere) | 5 | 3 years ago | ||
| Allow queries in WHEN expression of FOR EACH STATEMENT triggers | 2648 | Withdrawn | Not processed | Joe Wildish (joewildish) | 2 | 3 years ago | ||||
| Change return type of EXTRACT to numeric | 2679 | Moved to next CF | 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 | Moved to next CF | 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 | |||
| A few new options for CHECKPOINT | 2842 | Withdrawn | 14 | Not processed | Nathan Bossart (bossartn) | 1 | 4 years ago | |||
| create table like: ACCESS METHOD | 2865 | Moved to next CF | 15 | Not processed | Justin Pryzby (justinpryzby) | Simon Riggs (simon) | 4 | 3 years ago | ||
| Add support for leading/trailing bytea trim()ing | 2866 | Committed | Not processed | Joel Jacobson (joeljacobson) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 4 years ago | ||
| Allow GRANTED BY clause in normal GRANT and REVOKE statements | 2881 | Committed | Not processed | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 4 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 | |||
| 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 | Moved to next CF | 14 | Not processed | Mark Dilger (mark.dilger) | Robert Haas (rhaas) | Robert Haas (rhaas) | 4 | 3 years ago | |
| Parameters for initdb and pg_upgrade to avoid printing next-step instructions | 2752 | Committed | Not processed | Magnus Hagander (mha) | Peter Eisentraut (petere) | Magnus Hagander (mha) | 2 | 4 years ago | ||
| pg_dump: independently restorable child partitions | 2794 | Committed | Not processed | Justin Pryzby (justinpryzby) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 4 years ago | ||
| remove pg_standby | 2806 | Moved to next CF | 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 | Moved to next CF | 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 | Moved to next CF | 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 | |||