Commitfest 2019-03
Status summary: Committed: 100. Moved to next CF: 84. Withdrawn: 5. Rejected: 3. Returned with Feedback: 15. Total: 207.
Closed patches
| Patch | ID | Status | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | ||||||||||
| Fix the optimization to skip WAL-logging on table created in same transaction | 528 | Moved to next CF | 13 | Not processed | Heikki Linnakangas (heikki), Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti) | Michael Paquier (michael-kun), Kyotaro Horiguchi (horiguti), Noah Misch (nmisch), satyanarayana Narlapuram (snarlap), Sameer Arora (sameera), Hüseyin Demir (huseyin.demir) | Noah Misch (nmisch) | 19 | 5 years ago | |
| postgres.exe doesn't output crash dump when it crashes before main() | 1525 | Moved to next CF | Not processed | Takayuki Tsunakawa (maumau) | Haribabu Kommi (haribabu) | 9 | 5 years ago | |||
| Strengthen PGSharedMemoryCreate checks for still-attached processes | 1767 | Moved to next CF | Not processed | Noah Misch (nmisch) | Daniel Gustafsson (d_gustafsson), Alexandra Wang (l-wang) | Noah Misch (nmisch) | 5 | 5 years ago | ||
| Allow AddForeignUpdateTargets to add extra target expressions other than columns | 1819 | Moved to next CF | Not processed | Etsuro Fujita (efujita), Kyotaro Horiguchi (horiguti) | Etsuro Fujita (efujita) | 6 | 5 years ago | |||
| Fix performance issue in foreign-key-aware join estimation | 1984 | Moved to next CF | 13 | Not processed | David Rowley (davidrowley) | Tom Lane (tgl) | David Rowley (davidrowley) | 2 | 5 years ago | |
| Generated as identity field in a temporary table with on commit drop corrupts system catalogs | 1997 | Moved to next CF | stable | Not processed | Michael Paquier (michael-kun) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 5 years ago | |
| Fix Deadlock Issue in Single User Mode When IO Failure Occurs | 2003 | Moved to next CF | stable | Not processed | Chengchao Yu (allelujava) | Amit Kapila (amitkapila), Kyotaro Horiguchi (horiguti) | 5 | 5 years ago | ||
| COPY FREEZE, PD_VISIBLE_ALL and VM status | 2009 | Moved to next CF | Not processed | Pavan Deolasee (pavan), Ibrar Ahmed (ibrar) | Darafei Praliaskouski (komzpa), Hamid Akhtar (hamidakhtar) | Tomas Vondra (fuzzycz) | 6 | 4 years ago | ||
| SimpleLruTruncate() mutual exclusion (data loss from lack thereof) | 2025 | Moved to next CF | stable | Not processed | Noah Misch (nmisch) | 5 | 5 years ago | |||
| Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) | 2026 | Moved to next CF | stable | Not processed | Noah Misch (nmisch) | Andrey Borodin (x4m) | Noah Misch (nmisch) | 10 | 4 years ago | |
| Problem with default partition pruning | 2029 | Moved to next CF | stable | Not processed | Yuzuko Hosoya (yuzu) | Thibaut MADELAINE (madtibo), Ibrar Ahmed (ibrar), Shawn Wang (shawnwang) | Álvaro Herrera (alvherre) | 3 | 5 years ago | |
| propagating replica identity to partitions | 2044 | Moved to next CF | 13 | Not processed | Álvaro Herrera (alvherre) | 3 | 5 years ago | |||
| Fix unique join costings | 2050 | Moved to next CF | stable | Not processed | David Rowley (davidrowley) | Tom Lane (tgl) | 9 | 4 years ago | ||
| Clients | ||||||||||
| pgbench - another attempt at tap test for time-related options | 1306 | Moved to next CF | Not processed | Fabien Coelho (calvin) | 14 | 4 years ago | ||||
| 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 | ||
| Psql patch to show access methods info | 1689 | Moved to next CF | 13 | Not processed | Alik Khilazhev (alikhil), Sergey Cherkashin (cherkashins) | Kyotaro Horiguchi (horiguti), Nikita Glukhov (n.glukhov), vigneshwaran C (vignesh.postgres) | Alexander Korotkov (smagen) | 10 | 5 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 | 4 years ago | ||
| libpq host/hostaddr consistency | 1769 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Artur Zakirov (a.zakirov) | Álvaro Herrera (alvherre) | 6 | 5 years ago | ||
| libpq trace log | 1854 | Moved to next CF | 13 | Not processed | Aya Iwata (iwata.aya) | Jacob Champion (jchampion), Jim Doty (doty-pivotal), Ramanarayana M (ramnar) | 5 | 4 years ago | ||
| \describe: verbose commands in psql | 1976 | Moved to next CF | 13 | Not processed | Corey Huinker (coreyh) | Ibrar Ahmed (ibrar) | 3 | 5 years ago | ||
| Documentation | ||||||||||
| documenting signal handling with readme | 1796 | Moved to next CF | Not processed | Chris Travers (einhverfr) | Tom Lane (tgl) | 5 | 5 years ago | |||
| Miscellaneous | ||||||||||
| Make installcheck-world in a clean environment | 1672 | Moved to next CF | Not processed | Alexander Lakhin (law) | 6 | 5 years ago | ||||
| anycompatible and anycompatiblearray polymorphic types | 1911 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Tom Lane (tgl) | Tom Lane (tgl) | 7 | 5 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 | 3 years ago | |||
| Log bind parameter values on error | 1934 | Moved to next CF | 13 | Not processed | Alexey Bashtanov (bashtanov) | Álvaro Herrera (alvherre) | 6 | 5 years ago | ||
| pg_stat_statements should notice FOR UPDATE clauses | 1974 | Moved to next CF | Not processed | Andrew Gierth (rhodiumtoad), Vik Fearing (xocolatl) | Greg Stark (stark), Takayuki Tsunakawa (maumau), Sergei Kornilov (melkij) | Andrew Gierth (rhodiumtoad) | 2 | 5 years ago | ||
| Planning counters in pg_stat_statements | 1999 | Moved to next CF | Not processed | Fujii Masao (masaofujii), Julien Rouhaud (rjuju), Thomas Munro (macdice), PAscal L (pascall) | Greg Stark (stark), Yoshikazu Imai (yimai), PAscal L (pascall) | Fujii Masao (masaofujii) | 6 | 5 years ago | ||
| query logging of prepared statements | 2002 | Moved to next CF | 12 | Not processed | Justin Pryzby (justinpryzby) | Artur Zakirov (a.zakirov) | 2 | 6 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 | |||
| Evaluate immutable functions during planning (in FROM clause) | 1664 | Moved to next CF | Not processed | Alexander Kuzmenkov (akuzmenkov), Aleksandr Parfenov (a.parfenov) | Antonin Houska (a.houska), Anastasia Lubennikova (lubennikovaav), Anthony Bykov (anthonyb) | Tom Lane (tgl) | 7 | 5 years ago | ||
| Global shared meta cache | 1695 | Moved to next CF | 13 | Not processed | Takeshi Ideriha (ideriha) | 7 | 5 years 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 | ||
| Autoprepare: implicitly replace literals with parameters and store generalized plan | 1747 | Moved to next CF | Not processed | Konstantin Knizhnik (knizhnik) | Ryo Yamaji (ryamaji), Ryohei Nagaura (nyannyan) | 10 | 4 years ago | |||
| Tid range scan | 1755 | Moved to next CF | 13 | Not processed | Edmund Horner (ejrh) | David Rowley (davidrowley), Shawn Wang (shawnwang) | David Rowley (davidrowley) | 7 | 4 years ago | |
| Block level parallel vacuum | 1774 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | Dilip Kumar (dilip.kumar), Sergei Kornilov (melkij) | Amit Kapila (amitkapila) | 8 | 5 years ago | ||
| KNN for B-tree | 1804 | Moved to next CF | Not processed | Nikita Glukhov (n.glukhov) | Alexander Korotkov (smagen), Anastasia Lubennikova (lubennikovaav) | Alexander Korotkov (smagen) | 8 | 4 months ago | ||
| Referential Integrity Checks with Statement Level Triggers | 1975 | Moved to next CF | 13 | Not processed | Corey Huinker (coreyh) | Antonin Houska (a.houska) | 2 | 5 years ago | ||
| SortSupport implementation on inet/cdir | 1991 | Moved to next CF | 13 | Not processed | Brandur Leach (brandur) | Edmund Horner (ejrh) | Peter Geoghegan (pgeoghegan) | 2 | 5 years ago | |
| Speed up transaction completion faster after many relations are accessed in a transaction | 1993 | Moved to next CF | 13 | Not processed | Takayuki Tsunakawa (maumau) | Takayuki Tsunakawa (maumau) | David Rowley (davidrowley) | 5 | 1 year ago | |
| Optimization of some jsonb functions | 2011 | Moved to next CF | 13 | Not processed | Nikita Glukhov (n.glukhov) | Andrew Dunstan (adunstan) | Álvaro Herrera (alvherre) | 3 | 5 years ago | |
| Convert Lists into arrays | 2019 | Moved to next CF | 13 | Not processed | Tom Lane (tgl) | David Rowley (davidrowley), Jesper Pedersen (jpedersen) | Tom Lane (tgl) | 2 | 5 years ago | |
| Convert NOT IN to anti-joins when possible | 2020 | Moved to next CF | 13 | Not processed | David Rowley (davidrowley) | Antonin Houska (a.houska) | 4 | 5 years ago | ||
| NOT IN to ANTI JOIN transformation | 2023 | Moved to next CF | 13 | Not processed | James Finnerty (jimfinnerty), Zheng Li (zhengli) | 6 | 5 years ago | |||
| Flexible partition pruning hook | 2028 | Moved to next CF | 13 | Not processed | Mike Palmiotto (mpalmiotto) | 3 | 5 years ago | |||
| Bloom index cost model | 2043 | Moved to next CF | 13 | Not processed | Jeff Janes (jjanes) | Julien Rouhaud (rjuju) | 4 | 5 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 | ||
| block level PRAGMA | 1925 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 3 | 6 years ago | ||||
| Refactoring | ||||||||||
| get rid of StdRdOptions, use individual binary reloptions representation for each relation kind instead | 1536 | Moved to next CF | Not processed | Nikolay Shaplov (nataraj) | John Dent (denty) | 8 | 5 years ago | |||
| Replication & Recovery | ||||||||||
| Respect client-initiated CopyDone during logical streaming replication | 621 | Moved to next CF | Not processed | Dave Cramer (dcramer), Vladimir Gordiychuk (gordiychuk) | Craig Ringer (ringerc) | 6 | 5 years ago | |||
| Logical decoding of two-phase transactions | 944 | Moved to next CF | 13 | Not processed | Nikhil Sontakke (nikkhils) | Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos) | 13 | 3 years ago | ||
| Restricting maximum keep segments by repslots | 1260 | Moved to next CF | 13 | Not processed | Kyotaro Horiguchi (horiguti) | Masahiko Sawada (masahikosawada), Greg Stark (stark), Jehan-Guillaume de Rorthais (ioguix) | 12 | 5 years ago | ||
| Synchronous replay mode for avoiding stale reads on hot standbys | 1589 | Moved to next CF | 13 | Not processed | Thomas Munro (macdice) | 7 | 6 years ago | |||
| pg_rewind: options to use restore_command from recovery.conf or command line | 1849 | Moved to next CF | 13 | Not processed | Alexey Kondratov (ololobus) | Andrey Borodin (x4m) | Michael Paquier (michael-kun) | 8 | 5 years ago | |
| online change primary_conninfo | 1896 | Moved to next CF | 13 | Not processed | Sergei Kornilov (melkij) | Fujii Masao (masaofujii) | Álvaro Herrera (alvherre) | 7 | 5 years ago | |
| Remove deprecated exclusive backup mode | 1913 | Moved to next CF | Not processed | David Steele (dsteele) | Magnus Hagander (mha) | 9 | 4 years ago | |||
| Add timeline to partial WAL segments | 1919 | Moved to next CF | Not processed | David Steele (dsteele) | 9 | 4 years ago | ||||
| logical streaming for large in-progress transactions | 1927 | Moved to next CF | Not processed | Amit Kapila (amitkapila), Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos), Dilip Kumar (dilip.kumar) | Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres) | Amit Kapila (amitkapila) | 9 | 4 years ago | ||
| Synchronizing slots from primary to standby | 1961 | Moved to next CF | 13 | Not processed | Petr Jelínek (pjmodos) | Shaun Thomas (bonesmoses) | 4 | 5 years ago | ||
| pg_basebackup to adjust existing data directory permissions | 2018 | Moved to next CF | Not processed | Haribabu Kommi (haribabu) | Martín Marqués (mmarques) | 4 | 5 years ago | |||
| Server Features | ||||||||||
| Generic type subscripting | 1062 | Moved to next CF | 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 | |||
| Custom compression methods | 1294 | Moved to next CF | Not processed | Ildus Kurbangaliev (ildus) | 10 | 4 years ago | ||||
| BRIN bloom and multi-minmax indexes | 1348 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | 11 | 4 years ago | ||||
| Add enum relation option type | 1489 | Moved to next CF | 13 | Not processed | Nikolay Shaplov (nataraj) | Álvaro Herrera (alvherre) | 8 | 5 years ago | ||
| Advanced partition matching for partition-wise join | 1553 | Moved to next CF | 13 | Not processed | Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat) | Etsuro Fujita (efujita), Amul Sul (sulamul), Ashutosh Bapat (ashutoshbapat), Mark Dilger (mark.dilger) | Etsuro Fujita (efujita) | 11 | 5 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 | |||
| Undo logs | 1649 | Moved to next CF | 13 | Not processed | Dilip Kumar (dilip.kumar), Thomas Munro (macdice) | Amit Kapila (amitkapila) | 8 | 5 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 | 3 years ago | ||
| SERIALIZABLE on standby servers | 1799 | Moved to next CF | 13 | Not processed | Thomas Munro (macdice) | Kevin Grittner (kgrittn) | 4 | 6 years ago | ||
| amcheck verification for GiST | 1800 | Moved to next CF | 13 | Not processed | Andrey Borodin (x4m) | Peter Geoghegan (pgeoghegan) | Peter Geoghegan (pgeoghegan) | 6 | 5 years ago | |
| Undo worker and transaction rollback | 1828 | Moved to next CF | 13 | Not processed | Amit Kapila (amitkapila), Dilip Kumar (dilip.kumar), mithun cy (mithun.cy), Rafia Sabih (rafia.sabih) | 5 | 6 years ago | |||
| Add Hook Functions for Disk Quota Extension | 1883 | Moved to next CF | Not processed | Haozhou Wang (hawang), Hubert Zhang (hubertz), Hao Wu (hwu) | Raymond Martin (ramarti) | 8 | 4 years ago | |||
| Implement NULL-related checks in object address functions to prevent cache lookup errors, take two | 1947 | Moved to next CF | Not processed | Michael Paquier (michael-kun) | Daniel Gustafsson (d_gustafsson) | Michael Paquier (michael-kun) | 8 | 4 years ago | ||
| Ltree syntax improvement | 1977 | Moved to next CF | Not processed | Dmitry Belyavsky (beldmit) | Nikolay Shaplov (nataraj), Nikita Glukhov (n.glukhov), Aleksandr Sorokin (mustiks) | 8 | 4 years ago | |||
| Replica with large recovery_min_apply_delay is not receiving changes from master after restart until this delay is expired | 1995 | Moved to next CF | Not processed | Konstantin Knizhnik (knizhnik) | Martín Marqués (mmarques) | 7 | 4 years ago | |||
| Don't count parallel worker transactions as commits or rollbacks | 2013 | Moved to next CF | 12 | Not processed | Haribabu Kommi (haribabu) | Rahila Syed (rahila.syed), Kirk Jamison (kirkjamison) | Amit Kapila (amitkapila) | 2 | 6 years ago | |
| SQL Commands | ||||||||||
| SQL/JSON: functions | 1472 | Moved to next CF | Not processed | Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg) | Pavel Stehule (okbobcz), Andrew Dunstan (adunstan), Gerdan Santos (gerdan), Andrew Alsup (ahalsup) | 13 | 3 years ago | |||
| SQL/JSON: JSON_TABLE | 1473 | Moved to next CF | Not processed | Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg) | Pavel Stehule (okbobcz), Andrew Dunstan (adunstan) | 12 | 3 years ago | |||
| FETCH FIRST clause WITH TIES option | 1844 | Moved to next CF | Not processed | Surafel Temesgen (surafel) | Tomas Vondra (fuzzycz), Vik Fearing (xocolatl) | Álvaro Herrera (alvherre) | 8 | 5 years ago | ||
| extension patch of CREATE OR REPLACE TRIGGER | 2034 | Moved to next CF | 13 | Not processed | Takamichi Osumi (tatatappp) | Surafel Temesgen (surafel), Philippe BEAUDOIN (beaud76) | 3 | 4 years ago | ||
| [WIP] Temporal query processing with range types - Temporal Normalization | 2045 | Moved to next CF | 13 | Not processed | Peter Moser (pemoser), Anton Dignös (dignoes) | Ibrar Ahmed (ibrar) | 5 | 5 years ago | ||
| SQL:2011 application time | 2048 | Moved to next CF | Not processed | Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) | Peter Eisentraut (petere) | 12 | 4 weeks ago | |||
| System Administration | ||||||||||
| Support huge_pages on AIX | 1960 | Moved to next CF | 13 | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 6 | 5 years ago | ||
| Windows Service status is set to "SERVICE_RUNNING" when timeout is occurred (version 9.6 or earlier). | 1970 | Moved to next CF | Not processed | daisuke higuchi (daisukehiguchi), Ramanarayana M (ramnar) | Takayuki Tsunakawa (maumau) | 4 | 5 years ago | |||