Commitfest 2020-11
Status summary: Committed: 69. Moved to next CF: 151. Withdrawn: 10. Rejected: 1. Returned with Feedback: 13. Total: 244.
Closed patches
| Patch | ID | Status | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | ||||||||||
| COPY FREEZE, PD_VISIBLE_ALL and VM status | 2009 | 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 | ||
| 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 | |
| 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 | 3 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 | 4 years ago | ||
| DROP relation IF EXISTS Docs and Tests - Bug Fix | 2603 | Moved to next CF | Not processed | David Johnston (polobo) | Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com) | 7 | 3 years ago | |||
| fix (partially) pgbench :variable substitution for -M extended and prepared | 2624 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Tom Lane (tgl) | Tom Lane (tgl) | 4 | 4 years ago | ||
| shared tempfile was not removed on statement_timeout | 2657 | Moved to next CF | stable | Not processed | Thomas Munro (macdice), Justin Pryzby (justinpryzby) | Thomas Munro (macdice) | 4 | 4 years ago | ||
| Fix autovac for large number of tables | 2658 | Moved to next CF | Not processed | Kasahara Tatsuhito (kasahara) | Fujii Masao (masaofujii) | Fujii Masao (masaofujii) | 3 | 4 years ago | ||
| Fix collation handling in postgres_fdw | 2685 | Moved to next CF | Not processed | Tom Lane (tgl) | Etsuro Fujita (efujita) | 6 | 3 years ago | |||
| Dumping/restoring fails on inherited generated column | 2698 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 4 | 4 years ago | ||
| Fix checksum verification in base backups for zero page headers | 2719 | Moved to next CF | Not processed | Michael Banck (mbanck) | Anastasia Lubennikova (lubennikovaav), David Steele (dsteele) | 6 | 3 years ago | |||
| Corner-case bug in pg_rewind | 2730 | Moved to next CF | stable | Not processed | Ian Barwick (barwick) | Pavel Borisov (pborisov) | Heikki Linnakangas (heikki) | 2 | 4 years ago | |
| Incorrect usages of PG_GETARG_UINT32 | 2742 | Moved to next CF | Not processed | Ashutosh Bapat (ashutoshbapat) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 4 years ago | ||
| Fix broken query with gather merge paths added in incremental sort patch | 2754 | Moved to next CF | 13 | Not processed | James Coleman (jcole1989) | Tomas Vondra (fuzzycz), Jaime Casanova (jcasanov) | Tomas Vondra (fuzzycz) | 2 | 4 years ago | |
| explain: show JIT details in non-text format, even if zero | 2766 | Moved to next CF | stable | Not processed | Justin Pryzby (justinpryzby) | Tom Lane (tgl) | 2 | 4 years ago | ||
| Clients | ||||||||||
| New libpq option to prefer standby for connection | 1677 | Moved to next CF | Not processed | Haribabu Kommi (haribabu), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) | Laurenz Albe (laurenz), Takayuki Tsunakawa (maumau), Peter Smith (smithpb) | Tom Lane (tgl) | 15 | 4 years ago | ||
| pgbench - add pseudo-random permutation function | 1736 | Moved to next CF | Not processed | Fabien Coelho (calvin), Hironobu Suzuki (suzuki_hironobu) | Muhammad Usama (muhammad_usama) | Dean Rasheed (deanr) | 14 | 4 years ago | ||
| ECPG new statement: DECLARE STATEMENT | 2334 | Moved to next CF | Not processed | Hayato Kuroda (ha-kun) | Shawn Wang (shawnwang) | Michael Meskes (meskes) | 8 | 4 years ago | ||
| psql - possibility to specify where status row should be displayed | 2536 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 5 | 4 years ago | ||||
| allow to set a pager for psql's watch command | 2539 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Thomas Munro (macdice) | Thomas Munro (macdice) | 6 | 3 years ago | ||
| pgbench - add a synchronization barrier when starting | 2557 | Moved to next CF | Not processed | Fabien Coelho (calvin), Thomas Munro (macdice) | Marina Polyakova (whipping.top1991), Hayato Kuroda (ha-kun) | Thomas Munro (macdice) | 5 | 4 years ago | ||
| pg_dump - read data for some options from external file | 2573 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v) | Daniel Gustafsson (d_gustafsson) | 18 | 1 year ago | ||
| Improve pg_dump dumping publication tables | 2728 | Moved to next CF | stable | Not processed | John Hsu (jhsu) | Cary Huang (cary) | 2 | 4 years ago | ||
| libpq compression | 2773 | Moved to next CF | 15 | Not processed | Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) | Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag) | 6 | 3 years ago | ||
| psql \df choose functions by their arguments | 2788 | Moved to next CF | 14 | Not processed | Greg Sabino Mullane (greg) | Ian Barwick (barwick), Zhijie Hou (houzj) | Tom Lane (tgl) | 3 | 4 years ago | |
| list of extended statistics on psql | 2801 | Moved to next CF | 14 | Not processed | Tatsuro Yamada (tatsuro_yamada) | Álvaro Herrera (alvherre), Tomas Vondra (fuzzycz), Pavel Stehule (okbobcz), Julien Rouhaud (rjuju), Atsushi Torikoshi (atsushitorikoshi) | Tomas Vondra (fuzzycz) | 2 | 4 years ago | |
| Documentation | ||||||||||
| Document concurrent index builds waiting on each other | 2454 | Moved to next CF | stable | Not processed | James Coleman (jcole1989) | David Johnston (polobo) | Álvaro Herrera (alvherre) | 5 | 4 years ago | |
| Additional Chapter "Architecture" for Part "Tutorial" | 2541 | Moved to next CF | Not processed | Jürgen Purtz (juergen@purtz.de) | Peter Eisentraut (petere), David Johnston (polobo), Joshua Drake (linuxpoet) | 5 | 4 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 | 4 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 | ||
| 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 | 4 years ago | ||
| Add table expansion hook | 2614 | Moved to next CF | Not processed | Erik Nordström (enordstr) | Euler Taveira (eulerto), Aleksander Alekseev (aalekseev) | 7 | 3 years ago | |||
| Allow terminating the idle sessions | 2646 | Moved to next CF | Not processed | Japin Li (japin) | David Johnston (polobo), Hayato Kuroda (ha-kun) | Tom Lane (tgl) | 3 | 4 years ago | ||
| PATCH: Attempt to make dbsize a bit more consistent | 2701 | Moved to next CF | Not processed | Georgios Kokolatos (gkokolatos) | Daniel Gustafsson (d_gustafsson), David Zhang (david.z), Soumyadeep Chakraborty (soumyadeepc) | 4 | 4 years ago | |||
| Allow CRL "directory" for crl_file | 2709 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 4 | 4 years ago | ||
| Fix behavior of geo_ops when NaN is involved | 2710 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti) | Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) | 10 | 3 years ago | |||
| Reloptions for table access methods | 2717 | Moved to next CF | Not processed | Jeff Davis (jdavis) | Georgios Kokolatos (gkokolatos) | 4 | 4 years ago | |||
| Runtime control over CLOBBER_CACHE_ALWAYS for targeted debugging | 2749 | Moved to next CF | Not processed | Craig Ringer (ringerc) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 4 years ago | ||
| (ALTER SYSTEM) SET +=/-= operator support | 2750 | Moved to next CF | 14 | Not processed | Abhijit Menon-Sen (ams) | Ibrar Ahmed (ibrar) | 3 | 4 years ago | ||
| scram-sha-256 broken with FIPS and OpenSSL 1.0.2 (Switch SHA2 to use EVP for OpenSSL) | 2762 | Moved to next CF | 14 | Not processed | Michael Paquier (michael-kun) | Daniel Gustafsson (d_gustafsson) | Michael Paquier (michael-kun) | 2 | 4 years ago | |
| Improve replay pause | 2795 | Moved to next CF | Not processed | Dilip Kumar (dilip.kumar) | Kyotaro Horiguchi (horiguti), Yugo Nagata (yugo.nagata), Bharath Rupireddy (bharathrupireddy) | Robert Haas (rhaas) | 3 | 4 years ago | ||
| remove deprecated v8.2 containment operators | 2798 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby) | Peter Eisentraut (petere) | 2 | 4 years ago | ||
| Reduce the number of special cases to build contrib modules on windows | 2817 | Moved to next CF | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 5 | 3 years ago | |||
| 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 | |||
| 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 | 4 years ago | ||
| Add Information during standby recovery conflicts | 2604 | Moved to next CF | 14 | Not processed | Bertrand Drouvot (bdrouvot) | Masahiko Sawada (masahikosawada) | Fujii Masao (masaofujii) | 4 | 4 years ago | |
| Add session statistics to pg_stat_database | 2639 | Moved to next CF | 14 | Not processed | Laurenz Albe (laurenz) | Magnus Hagander (mha), ahsan hadi (ahsan.hadi), Masahiro Ikeda (masahiro.ikeda), Soumyadeep Chakraborty (soumyadeepc) | Magnus Hagander (mha) | 3 | 4 years ago | |
| update ps display for recovery checkpoint | 2688 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Nathan Bossart (bossartn), Kirk Jamison (kirkjamison) | Michael Paquier (michael-kun) | 3 | 4 years ago | ||
| Get memory contexts of an arbitrary backend process | 2711 | Moved to next CF | 14 | Not processed | Atsushi Torikoshi (atsushitorikoshi) | Fujii Masao (masaofujii), Kasahara Tatsuhito (kasahara), Shawn Wang (shawnwang) | Fujii Masao (masaofujii) | 4 | 4 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 | 4 years ago | ||
| Feature improvement for pg_stat_statements | 2738 | Moved to next CF | 14 | Not processed | Naoki Nakamichi (naokinakamichi) | Yuki Seino (seinoyu) | Fujii Masao (masaofujii) | 2 | 4 years ago | |
| Add extra statistics to explain for Nested Loop | 2765 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) | Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) | 10 | 2 years ago | |||
| Use posix fadvise to speed up analyze + improve automatic analyze with "avg read rate" log message | 2799 | Moved to next CF | 14 | Not processed | Stephen Frost (sfrost), Jakub Wartak (jakub.wartak.tomtom) | Heikki Linnakangas (heikki), Tomas Vondra (fuzzycz) | Stephen Frost (sfrost) | 3 | 4 years ago | |
| 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 | 2 months ago | ||
| bitmap cost should account for correlated indexes | 2310 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby) | 7 | 4 years ago | |||
| Optimize dropping of relation buffers during recovery | 2319 | Moved to next CF | Not processed | Kirk Jamison (kirkjamison) | Takayuki Tsunakawa (maumau), Haiying Tang (tanghy) | Amit Kapila (amitkapila) | 7 | 4 years ago | ||
| Using multicolumn statistics for more precise join selectivity estimatation | 2386 | Moved to next CF | Not processed | Konstantin Knizhnik (knizhnik) | Yugo Nagata (yugo.nagata) | 9 | 3 years ago | |||
| Erase the distinctClause if the result is unique by definition | 2433 | Moved to next CF | Not processed | Andy Fan (andyf) | David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Zhijie Hou (houzj) | 11 | 3 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 | 4 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 | 4 years ago | |
| Overhaul UPDATE/DELETE processing | 2575 | Moved to next CF | Not processed | Amit Langote (amitlan) | Tom Lane (tgl) | Tom Lane (tgl) | 5 | 4 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), Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 5 | 4 years ago | ||
| postgres_fdw insert batching | 2620 | Moved to next CF | 14 | Not processed | Takayuki Tsunakawa (maumau) | Tomas Vondra (fuzzycz) | 4 | 4 years ago | ||
| More scalable multixacts buffers and locking | 2627 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | Álvaro Herrera (alvherre) | 20 | 1 year ago | |||
| avoid bitmapOR-ing indexes for scan conditions implied by partition constraint | 2644 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) | Konstantin Knizhnik (knizhnik), Justin Pryzby (justinpryzby) | Tom Lane (tgl) | 3 | 4 years ago | |
| Covering SPGiST index | 2675 | Moved to next CF | Not processed | Pavel Borisov (pborisov) | Andrey Borodin (x4m) | Tom Lane (tgl) | 4 | 4 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 | 1 year ago | ||||
| Pipelining/batch mode support for libpq | 2724 | Moved to next CF | Not processed | Álvaro Herrera (alvherre), Craig Ringer (ringerc), Matthieu Garrigues (matt-42) | Justin Pryzby (justinpryzby) | Álvaro Herrera (alvherre) | 4 | 4 years ago | ||
| Reduce PostmasterIsAlive() checks during recovery | 2733 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 3 | 3 years ago | |||
| Bottom-up index deletion (targets old duplicate versions from non-HOT updates) | 2757 | Moved to next CF | 14 | Not processed | Peter Geoghegan (pgeoghegan) | Peter Geoghegan (pgeoghegan) | 2 | 4 years ago | ||
| parallel distinct union and aggregate support patch | 2769 | Moved to next CF | Not processed | bucoo hsiao (bucoo) | 6 | 3 years ago | ||||
| Replace polyphase merge with a simple k-way balanced merge | 2781 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | John Naylor (john.naylor) | Heikki Linnakangas (heikki) | 6 | 3 years ago | ||
| allow partial union-all and improve parallel subquery costing | 2787 | Moved to next CF | Not processed | Luc Vlaming (luc.vlaming) | 3 | 3 years ago | ||||
| New wal_level to disable WAL logging | 2807 | Moved to next CF | Not processed | Takamichi Osumi (tatatappp) | Takayuki Tsunakawa (maumau) | 4 | 3 years ago | |||
| Procedural Languages | ||||||||||
| declarative session variables, LET command | 1608 | Moved to next CF |
7/7
|
+7762−63 | 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 | 6 days 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 | 3 years ago | ||
| possibility to write window function in PL languages (like PLpgSQL) | 2697 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 3 | 4 years ago | ||||
| Refactoring | ||||||||||
| Remove page-read callback from XLogReaderState | 2113 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti) | Heikki Linnakangas (heikki), Antonin Houska (a.houska), Takashi Menjo (tmenjo) | Thomas Munro (macdice) | 13 | 3 years ago | ||
| Split StdRdOptions into HeapOptions and ToastOptions | 2370 | Moved to next CF | Not processed | Nikolay Shaplov (nataraj) | 10 | 3 years ago | ||||
| Reduce WaitEventSet system call spam | 2452 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 6 | 4 years ago | |||
| Refactor nodeModifyTable.c to allow lazy opening of result relations | 2621 | Moved to next CF | Not processed | Amit Langote (amitlan) | Heikki Linnakangas (heikki), Tom Lane (tgl) | Tom Lane (tgl) | 5 | 4 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 | 4 years ago | |
| Replication & Recovery | ||||||||||
| Make async slave to wait for lsn to be replayed | 772 | Moved to next CF | Not processed | Ivan Kartyshov (fenimorkin) | Thomas Munro (macdice), Dmitry Ivanov (funbringer), Anna Akenteva (a.akenteva), Alexandra Pervushina (a.pervushina) | 14 | 4 years ago | |||
| WAL prefetch (another approach) | 2410 | Moved to next CF | Not processed | Thomas Munro (macdice) | David Kimura (dgkimura) | Thomas Munro (macdice) | 7 | 3 years ago | ||
| Improve handling of parameter differences in physical replication | 2489 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Sergei Kornilov (melkij) | Peter Eisentraut (petere) | 5 | 4 years ago | ||
| Make message at end-of-recovery less scary | 2490 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti) | Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) | 20 | 1 year ago | |||
| Improve standby connection denied error message | 2509 | Moved to next CF | Not processed | James Coleman (jcole1989) | David Zhang (david.z) | Fujii Masao (masaofujii) | 5 | 4 years ago | ||
| implement LogicalDecodeMessageCB for pgoutput | 2661 | Moved to next CF | 13 | Not processed | Dave Cramer (dcramer) | Euler Taveira (eulerto), Ashutosh Bapat (ashutoshbapat) | Amit Kapila (amitkapila) | 4 | 4 years ago | |
| Background writer and checkpointer in crash recovery | 2706 | Moved to next CF | Not processed | Thomas Munro (macdice) | Aleksander Alekseev (aalekseev) | Thomas Munro (macdice) | 6 | 3 years ago | ||
| allow restore_command to be changed with reload | 2802 | Moved to next CF | Not processed | Sergei Kornilov (melkij) | Fujii Masao (masaofujii) | 2 | 4 years ago | |||
| cleanup temporary files after crash | 2803 | Moved to next CF | 14 | Not processed | Euler Taveira (eulerto) | Anastasia Lubennikova (lubennikovaav), Gerdan Santos (gerdan) | Tomas Vondra (fuzzycz) | 3 | 4 years ago | |
| 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 | 4 years ago | |
| OpenSSL 3.0.0 compatibility | 2810 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | 3 | 4 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 | |||
| 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 | 3 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 | 10 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 | 4 years ago | |||
| Extended statistics improvements | 2421 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Dean Rasheed (deanr) | Dean Rasheed (deanr) | 5 | 4 years ago | ||
| truncating timestamps on arbitrary intervals | 2474 | Moved to next CF | Not processed | John Naylor (john.naylor) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 6 | 4 years ago | ||
| jsonpath syntax extensions | 2482 | Moved to next CF | 15 | Not processed | Nikita Glukhov (n.glukhov) | 12 | 3 years ago | |||
| Auto-analyze on partitioned tables | 2492 | Moved to next CF | Not processed | Yuzuko Hosoya (yuzu) | Justin Pryzby (justinpryzby) | Álvaro Herrera (alvherre) | 6 | 4 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 | ||||
| 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 | 4 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 | 4 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 | 4 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 | 4 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 | 4 years ago | |||
| range_agg / multiranges | 2112 | Moved to next CF | 14 | Not processed | Paul Jungwirth (pjungwir) | Pavel Stehule (okbobcz), Jeff Davis (jdavis) | Alexander Korotkov (smagen) | 9 | 4 years ago | |
| Incremental Materialized View Maintenance | 2138 | Moved to next CF | 16 | Not processed | Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) | Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) | 17 | 2 years ago | ||
| Allow an alias to be attached directly to a JOIN ... USING | 2158 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Tom Lane (tgl) | Peter Eisentraut (petere) | 10 | 4 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 | 4 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 | 4 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 | |
| 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 | 7 months 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 | 4 years ago | |
| Parameters for initdb and pg_upgrade to avoid printing next-step instructions | 2752 | Moved to next CF | Not processed | Magnus Hagander (mha) | Peter Eisentraut (petere) | Magnus Hagander (mha) | 2 | 4 years ago | ||
| pg_dump: independently restorable child partitions | 2794 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 4 years ago | ||
| remove pg_standby | 2806 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby) | Thomas Munro (macdice) | 3 | 4 years ago | ||