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 | ||||||||||
| 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 | Moved to next CF | 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 | 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 | |||
| 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 | ||
| orphaned function | 2850 | Moved to next CF | stable | Not processed | Bertrand Drouvot (bdrouvot) | Gilles Darold (darold) | 2 | 3 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 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 | ||
| 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 | ||
| 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 | |
| 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 | |
| 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 | |
| Documentation | ||||||||||
| 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 | ||
| 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 | |||
| 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 | |||
| (ALTER SYSTEM) SET +=/-= operator support | 2750 | Moved to next CF | 14 | Not processed | Abhijit Menon-Sen (ams) | Ibrar Ahmed (ibrar) | 3 | 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 | ||
| 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 | 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 | |||
| 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 | |
| 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 | |
| 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 | ||
| 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 | ||
| 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 | 5 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 | 4 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 | ||
| 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 | 6 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 | 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 | 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 | 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 | ||
| 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 | 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 | |||
| 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 | |
| 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 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 | 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 | |
| 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 | ||
| PoC Refactor AM analyse API | 2907 | Moved to next CF | Not processed | Denis Smirnov (darthunix) | Heikki Linnakangas (heikki) | 4 | 3 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 | ||
| 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 | ||
| 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 | |
| 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 | ||||
| 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 | 4 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 | ||||||||||
| 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 | |||
| 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 | 4 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 | 4 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 | |||
| 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 | 4 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 | ||
| 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 | 5 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 | 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 | Moved to next CF | 14 | Not processed | Mark Dilger (mark.dilger) | Robert Haas (rhaas) | Robert Haas (rhaas) | 4 | 3 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 | |||