Commitfest 2021-11
Status summary: Committed: 58. Moved to next CF: 184. Withdrawn: 13. Rejected: 1. Returned with Feedback: 31. Total: 287.
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 | |
| 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 | 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 | ||
| Fix DROP TABLESPACE on Windows with ProcSignalBarrier? | 2962 | Moved to next CF | Not processed | Thomas Munro (macdice) | Daniel Gustafsson (d_gustafsson) | Thomas Munro (macdice) | 6 | 3 years ago | ||
| Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns | 3041 | Moved to next CF | Not processed | Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) | Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) | Amit Kapila (amitkapila) | 7 | 2 years ago | ||
| Eliminating "Permission denied" errors on stat() (on Windows) | 3058 | Moved to next CF | Not processed | Alexander Lakhin (law) | 4 | 3 years ago | ||||
| generate fractional cheapest paths in generate_orderedappend_paths | 3080 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Arne Roland (harks) | Tomas Vondra (fuzzycz) | 4 | 3 years ago | ||
| psql: exclude valid constraints in tab-complete for ALTER TABLE .. VALIDATE CONSTRAINT | 3113 | Moved to next CF | Not processed | David Fetter (dfetter) | Aleksander Alekseev (aalekseev) | Tom Lane (tgl) | 4 | 3 years ago | ||
| Support of time zone patterns - of, tzh and tzm | 3121 | Moved to next CF | Not processed | Nitin Jadhav (nitinjadhav11) | David Zhang (david.z) | Robert Haas (rhaas) | 5 | 3 years ago | ||
| Update Toast data failure in logical replication | 3162 | Moved to next CF | Not processed | Dilip Kumar (dilip.kumar) | Euler Taveira (eulerto), Haiying Tang (tanghy) | Amit Kapila (amitkapila) | 5 | 3 years ago | ||
| Fix uninitialized variable access (freepages) | 3236 | Moved to next CF | 15 | Not processed | Ranier Vilela (raniervilela) | Greg Nancarrow (gregn1234), David Zhang (david.z) | 4 | 3 years ago | ||
| Fix handling of outer GroupingFunc within subqueries | 3250 | Moved to next CF | Not processed | Richard Guo (richardguo) | Tom Lane (tgl), Platon Pronko (rogach) | Tom Lane (tgl) | 4 | 3 years ago | ||
| pgbench: using prepared BEGIN statement in a pipeline could cause an error | 3260 | Moved to next CF | 15 | Not processed | Yugo Nagata (yugo.nagata) | Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege) | Álvaro Herrera (alvherre) | 9 | 2 years ago | |
| Fix postgres_fdw's ORDER BY pushdown handling | 3264 | Moved to next CF | Not processed | Ronan Dunklau (rdunklau) | Tom Lane (tgl), David Zhang (david.z) | Tom Lane (tgl) | 4 | 3 years ago | ||
| Do not start bgworker processes during binary upgrade | 3299 | Moved to next CF | Not processed | Denis Laxalde (dlax) | Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju) | 4 | 3 years ago | |||
| Correct handling of blank/commented lines in PSQL interactive-mode history | 3318 | Moved to next CF | 15 | Not processed | Greg Nancarrow (gregn1234) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 3 years ago | |
| document the need to analyze partitioned tables | 3320 | Moved to next CF | stable | Not processed | Justin Pryzby (justinpryzby) | Tomas Vondra (fuzzycz) | Tomas Vondra (fuzzycz) | 3 | 1 year ago | |
| Check for STATUS_DELETE_PENDING on Windows | 3326 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 3 | 3 years ago | |||
| drop tablespace failed when location contains .. on win32 | 3331 | Moved to next CF | stable | Not processed | Shenhao Wang (wangshenhao) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 3 years ago | |
| PQcancel does not use tcp_user_timeout, connect_timeout and keepalive settings | 3348 | Moved to next CF | Not processed | Jelte Fennema-Nio (jeltef) | Tom Lane (tgl), Fujii Masao (masaofujii) | Tom Lane (tgl) | 2 | 3 years ago | ||
| fix psql pattern handling | 3367 | Moved to next CF | Not processed | Mark Dilger (mark.dilger) | Robert Haas (rhaas) | Robert Haas (rhaas) | 3 | 3 years ago | ||
| Clients | ||||||||||
| psql - add SHOW_ALL_RESULTS option | 2096 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 13 | 3 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 | ||
| Support tab completion for upper character inputs in psql | 2979 | Moved to next CF | Not processed | Haiying Tang (tanghy) | Tom Lane (tgl), Peter Eisentraut (petere) | Tom Lane (tgl) | 5 | 3 years ago | ||
| pg_dump new feature: exporting functions only | 3051 | Moved to next CF | 15 | Not processed | Lætitia AVROT (arkhena) | ahsan hadi (ahsan.hadi), Ryan Lambert (ryanlambert) | 5 | 3 years ago | ||
| functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) | 3256 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | David Christensen (davidchristensen) | 16 | 10 months ago | |||
| Allow escape sequence in application_name | 3277 | Moved to next CF | Not processed | Hayato Kuroda (ha-kun) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 3 | 3 years ago | ||
| psql: add xheader_width option to handle very long record lines | 3295 | Moved to next CF | Not processed | Platon Pronko (rogach) | Andrew Dunstan (adunstan) | Andrew Dunstan (adunstan) | 5 | 2 years ago | ||
| psql: \dl+ to list large objects privileges | 3313 | Moved to next CF | Not processed | Pavel Luzanov (pluzanov) | Daniel Gustafsson (d_gustafsson), Georgios Kokolatos (gkokolatos) | Tom Lane (tgl) | 3 | 3 years ago | ||
| Assorted improvements in pg_dump | 3368 | Moved to next CF | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 3 years ago | |||
| Code Comments | ||||||||||
| Add comment about startup process getting a free procState array slot always | 3355 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Robert Haas (rhaas), Yura Sokolov (funny_falcon), Gopi I (gopi.inupanuri570.gmail.com) | Robert Haas (rhaas) | 3 | 3 years ago | ||
| Documentation | ||||||||||
| Improve documentation for pg_upgrade, standbys and rsync | 3125 | Moved to next CF | 15 | Not processed | Laurenz Albe (laurenz) | David Fetter (dfetter) | 5 | 3 years ago | ||
| Consistent use of SSL/TLS in docs | 3172 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | Robert Haas (rhaas), Lætitia AVROT (arkhena) | Daniel Gustafsson (d_gustafsson) | 5 | 3 years ago | ||
| Undocumented AT TIME ZONE INTERVAL syntax | 3325 | Moved to next CF | Not processed | Corey Huinker (coreyh) | Tom Lane (tgl) | 2 | 3 years ago | |||
| Document atthasmissing default optimization avoids verification table scan | 3329 | Moved to next CF | Not processed | James Coleman (jcole1989) | Robert Haas (rhaas), David Johnston (polobo), Nathan Bossart (bossartn) | 3 | 3 years ago | |||
| Reword docs of GUCs restart_after_crash and remove_temp_files_after_crash | 3356 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | David Fetter (dfetter) | 3 | 3 years ago | |||
| Miscellaneous | ||||||||||
| 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 | |||
| 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 | ||
| 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 | |||
| Allow multiple recursive self-references | 3046 | Moved to next CF | Not processed | Denis Hirn (brainy) | Peter Eisentraut (petere) | 6 | 2 years ago | |||
| Avoid orphaned dependencies | 3106 | Moved to next CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Ronan Dunklau (rdunklau) | 6 | 3 years ago | ||
| Fully WAL logged CREATE DATABASE - No Checkpoints | 3192 | Moved to next CF | Not processed | Dilip Kumar (dilip.kumar) | Ashutosh Sharma (ashu_coek) | Robert Haas (rhaas) | 5 | 3 years ago | ||
| Expose get_query_def() | 3204 | Moved to next CF | Not processed | Julien Rouhaud (rjuju) | Pavel Stehule (okbobcz), Gilles Darold (darold) | Tom Lane (tgl) | 5 | 3 years ago | ||
| pgbench: add multiconnect support | 3227 | Moved to next CF | 16 | Not processed | David Christensen (davidchristensen) | Jelte Fennema-Nio (jeltef) | 9 | 2 years ago | ||
| disallow external access to MaxBackends | 3276 | Moved to next CF | Not processed | Nathan Bossart (bossartn) | Greg Sabino Mullane (greg) | Michael Paquier (michael-kun) | 4 | 2 years ago | ||
| Allow special values in GUC configurations | 3290 | Moved to next CF | 16 | Not processed | David Christensen (davidchristensen) | Cary Huang (cary) | 4 | 3 years ago | ||
| Add PGDLLIMPORT to all direct or indirect GUC variables | 3291 | Moved to next CF | 15 | Not processed | Robert Haas (rhaas), Julien Rouhaud (rjuju) | Robert Haas (rhaas) | 4 | 3 years ago | ||
| Showing I/O timings spent reading/writing temp buffers in EXPLAIN | 3298 | Moved to next CF | 15 | Not processed | Masahiko Sawada (masahikosawada) | Julien Rouhaud (rjuju), Melanie Plageman (melanieplageman), Georgios Kokolatos (gkokolatos) | Michael Paquier (michael-kun) | 4 | 3 years ago | |
| lax reloptions parsing for views | 3340 | Moved to next CF | Not processed | Mark Dilger (mark.dilger) | 3 | 3 years ago | ||||
| add subscription TAP test option "vcregress subscriptioncheck" for MSVC builds | 3354 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com) | 2 | 3 years ago | |||
| Inconsistency in startup process's MyBackendId and procsignal array registration with ProcSignalInit() | 3357 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 3 | 3 years ago | ||||
| Prefer getenv("HOME") to find the UNIX home directory | 3362 | Moved to next CF | Not processed | Anders Kaseorg (anderskaseorg) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 3 years ago | ||
| preserve timestamps when installing headers | 3363 | Moved to next CF | Not processed | Alexander Kuzmenkov (akuzmenkov) | Aleksander Alekseev (a.alekseev) | 2 | 2 years ago | |||
| building postgres with meson | 3395 | Moved to next CF | 16 | Not processed | Andres Freund (andresfreund) | Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) | Andres Freund (andresfreund) | 5 | 2 years ago | |
| Use -fvisibility=hidden for shared libraries | 3396 | Moved to next CF | Not processed | Andres Freund (andresfreund) | Tom Lane (tgl) | Andres Freund (andresfreund) | 4 | 2 years ago | ||
| Add CI | 3398 | Moved to next CF | Not processed | Andres Freund (andresfreund) | Andres Freund (andresfreund) | 2 | 3 years ago | |||
| Monitoring & Control | ||||||||||
| 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 | |||
| 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 | 3 weeks ago | |
| Add system views pg_permissions and pg_ownerships | 3033 | Moved to next CF | Not processed | Joel Jacobson (joeljacobson) | 5 | 6 months ago | ||||
| pg_stat_statements: Track statement entry timestamp | 3048 | Moved to next CF | 17 | Not processed | Andrei Zubkov (zubkov) | Alena Rybakina (a.rybakina) | Alexander Korotkov (smagen) | 13 | 1 year ago | |
| Logging plan of the currently running query | 3142 | Moved to next CF | 16 | Not processed | atsushi torikoshi (atorik) | Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) | 9 | 1 week ago | ||
| Add system view tracking shared buffer actions | 3272 | Moved to next CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Justin Pryzby (justinpryzby) | Andres Freund (andresfreund) | 9 | 2 years ago | |
| Trap SIGCHLD in pg_basebackup to exit early on stream child failure | 3302 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | Magnus Hagander (mha), Bharath Rupireddy (bharathrupireddy) | Daniel Gustafsson (d_gustafsson) | 4 | 3 years ago | ||
| enhance pg_log_backend_memory_contexts() to log memory contexts of auxiliary processes | 3385 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | vigneshwaran C (vignesh.postgres) | Fujii Masao (masaofujii) | 2 | 3 years ago | ||
| Extend postgres_fdw_get_connections() to print the user_name | 3388 | Moved to next CF | Not processed | Hayato Kuroda (ha-kun) | Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Shinya Kato (shinyakato), Yuta Katsuragi (katsuragiy) | Fujii Masao (masaofujii) | 15 | 6 months ago | ||
| Performance | ||||||||||
| 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 | 1 week 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), Zhijie Hou (houzj) | 11 | 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 | ||
| 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 | 1 year ago | |||
| fix spinlock contention in LogwrtResult | 2716 | Moved to next CF | Not processed | Álvaro Herrera (alvherre) | 11 | 1 year 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 | |||
| 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 | 2 years ago | |
| Full support for index LP_DEAD hint bits on standby | 2947 | Moved to next CF | Not processed | Michail Nikolaev (nkey) | Antonin Houska (a.houska) | 6 | 3 years ago | |||
| Simplify some RI checks to reduce SPI overhead | 2948 | Moved to next CF | Not processed | Amit Langote (amitlan) | Tom Lane (tgl), Corey Huinker (coreyh) | Álvaro Herrera (alvherre) | 6 | 3 years ago | ||
| Speed up verifying UTF-8 | 2996 | Moved to next CF | Not processed | John Naylor (john.naylor) | Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan) | John Naylor (john.naylor) | 5 | 3 years ago | ||
| More sort-related specialisation | 3038 | Moved to next CF | Not processed | Thomas Munro (macdice) | John Naylor (john.naylor) | John Naylor (john.naylor) | 5 | 3 years ago | ||
| Lazy JIT IR code generation to increase JIT speed with partitions | 3071 | Moved to next CF | Not processed | David Geier (geidav), Luc Vlaming (luc.vlaming) | Dmitry Dolgov (erthalion) | 9 | 2 years ago | |||
| Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation | 3078 | Moved to next CF | 15 | Not processed | Matthias van de Meent (mmeent) | 4 | 3 years ago | |||
| Parallel INSERT SELECT take 2 | 3143 | Moved to next CF | Not processed | Greg Nancarrow (gregn1234), Zhijie Hou (houzj) | 6 | 2 years ago | ||||
| pre-allocating WAL files | 3158 | Moved to next CF | 16 | Not processed | Nathan Bossart (bossartn) | Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | 6 | 2 years ago | ||
| Add proper planner support for ORDER BY / DISTINCT aggregates | 3164 | Moved to next CF | Not processed | David Rowley (davidrowley) | Ronan Dunklau (rdunklau), Richard Guo (richardguo) | David Rowley (davidrowley) | 7 | 2 years ago | ||
| Map WAL segment files on PMEM as WAL buffers | 3181 | Moved to next CF | Not processed | Takashi Menjo (tmenjo) | 6 | 3 years ago | ||||
| Write visibility map during CLUSTER/VACUUM FULL | 3206 | Moved to next CF | Not processed | Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva) | Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) | 6 | 2 years ago | |||
| Fix ExecRTCheckPerms() inefficiency with many prunable partitions | 3224 | Moved to next CF | 16 | Not processed | Amit Langote (amitlan) | Álvaro Herrera (alvherre), Tom Lane (tgl) | Álvaro Herrera (alvherre) | 8 | 1 year ago | |
| Window function run conditions | 3234 | Moved to next CF | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 5 | 3 years ago | |||
| Using each rel as both outer and inner for anti-joins | 3235 | Moved to next CF | Not processed | Richard Guo (richardguo) | Ronan Dunklau (rdunklau) | Tom Lane (tgl) | 9 | 2 years ago | ||
| Postgres picks suboptimal index after building extended statistics | 3245 | Moved to next CF | 14 | Not processed | Andrei Lepikhov (lepikhov) | 7 | 2 years ago | |||
| Parallelize correlated subqueries that execute within each worker | 3246 | Moved to next CF | Not processed | James Coleman (jcole1989) | Akshat Jaimini (akshatj) | 15 | 8 months ago | |||
| Cache tuple routing info during bulk loads into partitioned tables | 3270 | Moved to next CF | Not processed | David Rowley (davidrowley), Amit Langote (amitlan), Zhijie Hou (houzj) | Álvaro Herrera (alvherre), David Rowley (davidrowley) | David Rowley (davidrowley) | 6 | 2 years ago | ||
| Push down time-related SQLValue functions to foreign server | 3289 | Moved to next CF | 15 | Not processed | Alexander Pyhalov (a.pyhalov) | 5 | 3 years ago | |||
| Asynchronous and "direct" IO support for PostgreSQL | 3316 | Moved to next CF | Not processed | Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice) | 6 | 2 years ago | ||||
| Partial aggregates push down | 3369 | Moved to next CF | 15 | Not processed | Alexander Pyhalov (a.pyhalov) | Ilya Gladyshev (qoops) | 3 | 7 months ago | ||
| Start WAL receiver eagerly | 3376 | Moved to next CF | 15 | Not processed | Konstantin Knizhnik (knizhnik), Asim Rama Praveen (apraveen), Ashwin Agrawal (ashwinstar), Soumyadeep Chakraborty (soumyadeepc) | 2 | 3 years ago | |||
| Use generation context to speed up tuplesorts | 3381 | Moved to next CF | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 3 | 3 years ago | |||
| postgres_fdw: commit remote (sub)transactions in parallel during pre-commit | 3392 | Moved to next CF | 16 | Not processed | Etsuro Fujita (efujita) | Fujii Masao (masaofujii), David Zhang (david.z) | Etsuro Fujita (efujita) | 8 | 2 years ago | |
| Procedural Languages | ||||||||||
| declarative session variables, LET command | 1608 | Moved to next CF |
6/7
|
+9966−64 | Pavel Stehule (okbobcz) | Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), newtglobal postgresql_contributors (newtpostgrescontributors) | 36 | 1 week 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 | 3 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 | ||||||||||
| Extend portability of client_connection_check_interval | 3098 | Moved to next CF | Not processed | Thomas Munro (macdice) | Maksim Milyutin (maksm90) | Thomas Munro (macdice) | 5 | 3 years ago | ||
| psql - refactor echo code | 3140 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Pavel Stehule (okbobcz), Peter Eisentraut (petere) | 10 | 2 years ago | |||
| A micro-optimisation for ProcSendSignal() | 3146 | Moved to next CF | Not processed | Thomas Munro (macdice) | Soumyadeep Chakraborty (soumyadeepc) | Thomas Munro (macdice) | 4 | 3 years ago | ||
| automatically generating node support functions | 3182 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Tom Lane (tgl) | Peter Eisentraut (petere) | 6 | 2 years ago | ||
| Extensible storage manager API - smgr hooks | 3216 | Moved to next CF | Not processed | Anastasia Lubennikova (lubennikovaav) | 5 | 3 years ago | ||||
| Some RELKIND macro refactoring | 3308 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Michael Paquier (michael-kun) | Peter Eisentraut (petere) | 3 | 3 years ago | ||
| ResourceOwner refactoring | 3364 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | Julien Rouhaud (rjuju), Aleksander Alekseev (aalekseev) | 2 | 1 year ago | |||
| using an end-of-recovery record in all cases | 3365 | Moved to next CF | 15 | Not processed | Robert Haas (rhaas), Amul Sul (sulamul) | 2 | 3 years ago | |||
| Replication & Recovery | ||||||||||
| 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 | |||
| Row filtering for logical replication | 2906 | Moved to next CF | 15 | Not processed | Euler Taveira (eulerto), Peter Smith (smithpb), Ajin Cherian (ajinc), Zhijie Hou (houzj) | Dilip Kumar (dilip.kumar), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Zhijie Hou (houzj), Rahila Syed (rahila) | Amit Kapila (amitkapila) | 7 | 3 years ago | |
| Identify missing publications from publisher while create/alter subscription. | 2957 | Moved to next CF | Not processed | vigneshwaran C (vignesh.postgres) | Dilip Kumar (dilip.kumar), Euler Taveira (eulerto), Ashutosh Sharma (ashu_coek), Japin Li (japin), Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila) | 6 | 3 years ago | ||
| Minimal logical decoding on standbys (take 6) | 2968 | Moved to next CF | Not processed | Amit Khandekar (amitdkhan) | Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) | 5 | 2 years ago | |||
| tablesync early exit | 3062 | Moved to next CF | 15 | Not processed | Peter Smith (smithpb2250) | 6 | 3 years ago | |||
| A test for replay of regression tests | 3090 | Moved to next CF | Not processed | Thomas Munro (macdice) | Anastasia Lubennikova (lubennikovaav) | Thomas Munro (macdice) | 4 | 3 years ago | ||
| avoid logical replication empty transactions | 3093 | Moved to next CF | 15 | Not processed | Euler Taveira (eulerto), Ajin Cherian (ajinc) | vigneshwaran C (vignesh.postgres), Peter Smith (smithpb), Greg Nancarrow (gregn1234) | Amit Kapila (amitkapila) | 5 | 3 years ago | |
| Detectable crashes and unlogged table resets | 3183 | Moved to next CF | Not processed | Jeff Davis (jdavis) | 5 | 3 years ago | ||||
| Skipping logical replication transactions on subscriber side | 3205 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Mark Dilger (mark.dilger), Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 5 | 3 years ago | ||
| Allow providing restore_command as a command line option to pg_rewind | 3213 | Moved to next CF | Not processed | Alexey Kondratov (ololobus) | Andrey Borodin (x4m) | 5 | 3 years ago | |||
| PITR enhance getRecordTimestamp() | 3222 | Moved to next CF | Not processed | Simon Riggs (simon) | 8 | 3 years ago | ||||
| Column filtering in logical replication | 3230 | Moved to next CF | 15 | Not processed | Álvaro Herrera (alvherre), Rahila Syed (rahila.syed), Tomas Vondra (fuzzycz) | Álvaro Herrera (alvherre), Peter Eisentraut (petere), vigneshwaran C (vignesh.postgres) | Tomas Vondra (fuzzycz) | 5 | 3 years ago | |
| parse_subscription_options - some suggested improvements | 3244 | Moved to next CF | 15 | Not processed | Peter Smith (smithpb2250) | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 3 | 3 years ago | |
| schema change not getting invalidated, both renamed table and new table data were getting replicated | 3262 | Moved to next CF | Not processed | vigneshwaran C (vignesh.postgres) | Tom Lane (tgl) | Tom Lane (tgl) | 8 | 2 years ago | ||
| archive modules | 3337 | Moved to next CF | 15 | Not processed | Nathan Bossart (bossartn) | Magnus Hagander (mha), Stephen Frost (sfrost), Robert Haas (rhaas), Michael Paquier (michael-kun), Fujii Masao (masaofujii), David Steele (dsteele) | Robert Haas (rhaas) | 3 | 2 years ago | |
| Add checkpoint stats of snapshot and mapping files of pg_logical dir | 3389 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | 5 | 2 years ago | |||
| Synchronize logical replication slots from primary to standby | 3393 | Moved to next CF | Not processed | Peter Eisentraut (petere) | 3 | 1 year ago | ||||
| Logical insert/update/delete WAL records for custom table AMs | 3394 | Moved to next CF | 15 | Not processed | Jeff Davis (jdavis) | Simon Riggs (simon) | 4 | 2 years ago | ||
| Prefetching in recovery, take II | 3397 | Moved to next CF | 15 | Not processed | Thomas Munro (macdice) | Julien Rouhaud (rjuju) | Thomas Munro (macdice) | 3 | 3 years ago | |
| Security | ||||||||||
| Improve sepgsql logging so it follows the behaviour of selinux's logging. | 3076 | Moved to next CF | Not processed | Dave Page (dpage) | Jacob Champion (jchampion) | Tom Lane (tgl) | 4 | 3 years ago | ||
| Support for NSS as a libpq TLS backend | 3138 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) | Joshua Brindle (joshuab) | 5 | 3 years ago | |||
| Upgrade pgcrypto to crypt_blowfish 1.3 | 3338 | Moved to next CF | Not processed | Daniel Fone (daniel.fone) | Daniel Gustafsson (d_gustafsson) | 4 | 3 years ago | |||
| Server Features | ||||||||||
| 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 | 3 years 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 | ||
| jsonpath syntax extensions | 2482 | Moved to next CF | 15 | Not processed | Nikita Glukhov (n.glukhov) | 12 | 3 years ago | |||
| ALTER SYSTEM READ { ONLY | WRITE } | 2602 | Moved to next CF | Not processed | Amul Sul (sulamul) | 9 | 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 | |||
| New Table Access Methods for Multi and Single Inserts | 2871 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 9 | 5 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 | 3 years ago | ||
| SQL/JSON: JSON_TABLE | 2902 | Moved to next CF | 15 | Not processed | Nikita Glukhov (n.glukhov) | Andrew Dunstan (adunstan) | 7 | 3 years ago | ||
| Allow batched insert during cross-partition updates | 2992 | Moved to next CF | Not processed | Amit Langote (amitlan) | Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Zhijie Hou (houzj) | Etsuro Fujita (efujita) | 10 | 2 years ago | ||
| PROXY protocol support | 3032 | Moved to next CF | Not processed | Magnus Hagander (mha) | Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) | 7 | 2 years ago | |||
| Extended statistics in EXPLAIN | 3050 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Tatsuro Yamada (tatsuro_yamada) | 6 | 3 years ago | |||
| Merging statistics from children instead of re-sampling everything | 3052 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | 5 | 3 years ago | ||||
| estimating joins using extended statistics | 3055 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Andy Fan (andyf) | 4 | 3 years ago | |||
| Add callback table access method to reset filenode when dropping relation | 3073 | Moved to next CF | Not processed | Mats Kindahl (matski) | Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) | 7 | 2 years ago | |||
| Asymmetric partition-wise JOIN | 3099 | Moved to next CF | 15 | Not processed | KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) | Alexander Pyhalov (a.pyhalov) | 7 | 3 years ago | ||
| Extensible parsing | 3100 | Moved to next CF | 15 | Not processed | Julien Rouhaud (rjuju) | 4 | 3 years ago | |||
| logical decoding and replication of sequences | 3155 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Peter Eisentraut (petere) | Tomas Vondra (fuzzycz) | 5 | 2 years ago | ||
| Range Merge Join | 3160 | Moved to next CF | 15 | Not processed | Thomas Mannhart (thomasmannhart97) | 4 | 3 years ago | |||
| pg_stats and range statistics | 3184 | Moved to next CF | 17 | Not processed | Egor Rogov (egorius) | Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) | Alexander Korotkov (smagen) | 13 | 1 year ago | |
| PoC: improving join estimates using sampling | 3211 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | 5 | 3 years ago | ||||
| Cleaning up orphaned files using undo logs | 3228 | Moved to next CF | Not processed | Antonin Houska (a.houska) | Dmitry Dolgov (erthalion) | 4 | 3 years ago | |||
| Gather partial paths for subproblem's topmost scan/join rel | 3274 | Moved to next CF | Not processed | Richard Guo (richardguo) | Antonin Houska (a.houska) | Tom Lane (tgl) | 5 | 2 years ago | ||
| Tags in errordata | 3293 | Moved to next CF | 15 | Not processed | Ronan Dunklau (rdunklau) | Greg Stark (stark), Justin Pryzby (justinpryzby) | 4 | 3 years ago | ||
| Preserving db/ts/relfilenode OIDs across pg_upgrade | 3296 | Moved to next CF | Not processed | Antonin Houska (a.houska), Shruthi Gowda (shruthi) | Robert Haas (rhaas), Rushabh Lathia (rlathia) | Robert Haas (rhaas) | 4 | 2 years ago | ||
| Support pg_ident mapping for LDAP | 3314 | Moved to next CF | Not processed | Jacob Champion (jchampion) | Magnus Hagander (mha) | 5 | 3 years ago | |||
| extended statistics on partitioned tables | 3330 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Tomas Vondra (fuzzycz) | 2 | 3 years ago | |||
| Atomic rename feature for Windows | 3347 | Moved to next CF | Not processed | Victor Spirin (v.spirin) | 6 | 2 years ago | ||||
| Update relfrozenxmin when truncating temp tables | 3358 | Moved to next CF | 16 | Not processed | Greg Stark (stark) | 12 | 1 year ago | |||
| Multi-column list partitioning | 3383 | Moved to next CF | Not processed | Nitin Jadhav (nitinjadhav11) | 2 | 3 years ago | ||||
| use has_privs_for_role for predefined roles | 3384 | Moved to next CF | 15 | Not processed | Joshua Brindle (joshuab) | Nathan Bossart (bossartn) | Joe Conway (jconway) | 3 | 2 years ago | |
| SQL Commands | ||||||||||
| SQL:2011 application time | 2048 | Moved to next CF | Not processed | Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) | Peter Eisentraut (petere) | 12 | 3 weeks 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 | ||
| 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 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 | 3 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 | 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 | |||
| Dynamic result sets from procedures | 2911 | Moved to next CF | Not processed | Peter Eisentraut (petere) | 12 | 2 years ago | ||||
| Partial foreign key updates in referential integrity triggers | 2932 | Moved to next CF | 15 | Not processed | Paul Martinez (pauljulius) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 5 | 3 years ago | |
| rename column if exists | 3045 | Moved to next CF | Not processed | David Oksman (oks) | Yagiz Nizipli (yagiznizipli) | 4 | 3 years ago | |||
| DELETE CASCADE | 3195 | Moved to next CF | 15 | Not processed | David Christensen (davidchristensen) | 4 | 3 years ago | |||
| Non-decimal integer literals | 3292 | Moved to next CF | Not processed | Peter Eisentraut (petere) | John Naylor (john.naylor) | Peter Eisentraut (petere) | 6 | 2 years ago | ||
| UNIQUE null treatment option | 3307 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Vik Fearing (xocolatl), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Peter Eisentraut (petere) | 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 | |||
| 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 | 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 | |||
| Catalog version access | 2999 | Moved to next CF | Not processed | Vik Fearing (xocolatl), Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 5 | 3 years ago | |||
| add guc: hugepages_active | 3310 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda) | Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun) | 7 | 1 year ago | ||
| Add JSON logging via jsonlog log_destination | 3312 | Moved to next CF | 15 | Not processed | Michael Paquier (michael-kun), Sehrope Sarkuni (sehrope) | Michael Paquier (michael-kun) | 3 | 3 years ago | ||
| CREATE ROLE IF NOT EXISTS | 3370 | Moved to next CF | Not processed | David Christensen (davidchristensen) | 2 | 3 years ago | ||||
| Allows database-specific role memberships | 3374 | Moved to next CF | 18 | Not processed | Denis Laxalde (dlax), Kenaniah Cerny (kenaniah) | Antonin Houska (a.houska) | Stephen Frost (sfrost) | 6 | 6 months ago | |
| Allow root ownership of client certificate key | 3379 | Moved to next CF | Not processed | David Steele (dsteele) | Stephen Frost (sfrost), Tom Lane (tgl) | Tom Lane (tgl) | 3 | 3 years ago | ||