Commitfest 2022-07 (2022-07-01 - 2022-07-31)
Status summary: Waiting on Author: 1. Committed: 77. Moved to next CF: 182. Withdrawn: 12. Returned with Feedback: 32. Rejected: 4. Total: 308.
Closed patches
| Patch | ID | Status | Tags | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | |||||||||||
| Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns | 3041 | Moved to different CF | Not processed | Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) | Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) | Amit Kapila (amitkapila) | 7 | 2 years ago | |||
| pgbench: using prepared BEGIN statement in a pipeline could cause an error | 3260 | Moved to different CF | 15 | Not processed | Yugo Nagata (yugo.nagata) | Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege) | Álvaro Herrera (alvherre) | 9 | 2 years ago | ||
| Error "initial slot snapshot too large" in create replication slot | 3445 | Moved to different CF | Not processed | Kyotaro Horiguchi (horiguti), Dilip Kumar (dilip.kumar) | Akshat Jaimini (akshatj) | 11 | 1 year ago | ||||
| Fix Windows network event handling | 3523 | Moved to different CF | Not processed | Thomas Munro (macdice) | Robert Haas (rhaas) | 4 | 1 year ago | ||||
| Fix checkpointer sync request queue problems | 3583 | Moved to different CF | Not processed | Thomas Munro (macdice) | 3 | 3 years ago | |||||
| Nonreplayable XLog records by means of overflows and >MaxAllocSize lengths | 3590 | Moved to different CF | stable | Not processed | Matthias van de Meent (mmeent) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 3 | 2 years ago | ||
| Remove pgwin32_is_junction(), add lstat() for Windows | 3598 | Moved to different CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 3 | 2 years ago | ||||
| Fix dsa_free() to re-bin segment | 3607 | Moved to different CF | Not processed | Dongming Liu (inferyes) | clundro infdahai (infdahai.outlook.com) | Thomas Munro (macdice) | 6 | 2 years ago | |||
| Fix recovery conflict SIGUSR1 handling | 3615 | Moved to different CF | Not processed | Thomas Munro (macdice) | Michael Paquier (michael-kun), KARAM MOORE (global) | Thomas Munro (macdice) | 7 | 1 year ago | |||
| Prohibit RESETing transaction-property GUCs | 3620 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada) | Michael Paquier (michael-kun) | Tom Lane (tgl) | 2 | 2 years ago | |||
| Data is copied twice when specifying both child and parent table in publication | 3623 | Moved to different CF | Not processed | wei wang (wangwei), Yu Shi (shiy.fnst) | Amit Kapila (amitkapila), Takamichi Osumi (tatatappp), vigneshwaran C (vignesh.postgres), Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 5 | 2 years ago | |||
| Fix the statistics gathering in case of commit and chain | 3657 | Moved to different CF | Not processed | Lætitia AVROT (arkhena) | 2 | 2 years ago | |||||
| Fix assertion failure with barriers in parallel hash join | 3662 | Moved to different CF | stable | Not processed | Thomas Munro (macdice), Melanie Plageman (melanieplageman) | David Geier (geidav) | Thomas Munro (macdice) | 5 | 2 years ago | ||
| pg_rewind: warn when checkpoint hasn't happened after promotion | 3670 | Moved to different CF | Not processed | James Coleman (jcole1989) | Keisuke Kuroda (kiskk) | Heikki Linnakangas (heikki) | 5 | 2 years ago | |||
| [BUG] Panic due to incorrect missingContrecPtr after promotion | 3675 | Moved to different CF | Not processed | Sami Imseih (simseih) | 2 | 2 years ago | |||||
| ENABLE/DISABLE broken for statement triggers on partitioned tables | 3728 | Moved to different CF | Not processed | Amit Langote (amitlan) | Dmitry Koval (d.koval) | Álvaro Herrera (alvherre) | 2 | 2 years ago | |||
| pg_visibility's pg_check_visible() yields false positive when working in parallel with autovacuum | 3739 | Moved to different CF | 17 | Not processed | Daniel Shelepanov (dshelepanov) | Alexander Korotkov (smagen) | 6 | 1 year ago | |||
| Patch to address creation of PgStat* contexts with null parent context | 3746 | Moved to different CF | Not processed | Reid Thompson (jreidthompsoncd) | Bertrand Drouvot (bdrouvot), Mingli Zhang (zml) | Andres Freund (andresfreund) | 2 | 2 years ago | |||
| Clients | |||||||||||
| pg_dump - read data for some options from external file | 2573 | Moved to different 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 | |||
| functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) | 3256 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby) | David Christensen (davidchristensen) | 16 | 1 year ago | ||||
| Add non-blocking version of PQcancel | 3511 | Moved to different CF | 17 | Not processed | Jelte Fennema-Nio (jeltef) | Denis Laxalde (dlax) | Álvaro Herrera (alvherre) | 11 | 6 months ago | ||
| Add LZ4 compression in pg_dump | 3571 | Moved to different CF | 16 | Not processed | Georgios Kokolatos (gkokolatos), Rachel Heaton (rheaton) | Tomas Vondra (fuzzycz), Justin Pryzby (justinpryzby), Yu Shi (shiy.fnst) | Tomas Vondra (fuzzycz) | 6 | 2 years ago | ||
| Support load balancing in libpq | 3679 | Moved to different CF | 16 | Not processed | Jelte Fennema-Nio (jeltef) | Daniel Gustafsson (d_gustafsson), Andrey Borodin (x4m), Michael Banck (mbanck) | Daniel Gustafsson (d_gustafsson) | 5 | 2 years ago | ||
| Documentation | |||||||||||
| Improve role attributes docs | 3516 | Moved to different CF | Not processed | Shinya Kato (shinyakato) | Fujii Masao (masaofujii), Swaha Miller (swaha) | Bruce Momjian (bmomjian) | 3 | 2 years ago | |||
| doc: PQexecParams binary handling example for REAL data type | 3568 | Moved to different CF | Not processed | Mark Wong (markwkm) | 6 | 2 years ago | |||||
| Doc about how to set max_wal_senders when setting minimal wal_level | 3586 | Moved to different CF | Not processed | Japin Li (japin) | Lætitia AVROT (arkhena) | Bruce Momjian (bmomjian) | 2 | 2 years ago | |||
| Clarify Routines and Extension Membership | 3693 | Moved to different CF | Not processed | David Johnston (polobo) | Bruce Momjian (bmomjian) | 2 | 2 years ago | ||||
| Fix description of how the default user name is chosen | 3694 | Moved to different CF | Not processed | David Johnston (polobo) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 3 | 2 years ago | |||
| Make selectivity example match wording | 3695 | Moved to different CF | Not processed | David Johnston (polobo) | Dian Fay (dmfay) | 3 | 3 years ago | ||||
| Select Reference Page - Make Join Syntax More Prominent | 3726 | Moved to different CF | Not processed | David Johnston (polobo) | 2 | 3 years ago | |||||
| Miscellaneous | |||||||||||
| Function to log backtrace of postgres processes | 2863 | Moved to different CF | Not processed | vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) | Christoph Berg (myon), Maciek Sakrejda (msakrejda) | 17 | 1 year ago | ||||
| pgbench: add multiconnect support | 3227 | Moved to different CF | 16 | Not processed | David Christensen (davidchristensen) | Jelte Fennema-Nio (jeltef) | 9 | 2 years ago | |||
| building postgres with meson | 3395 | Moved to different CF | 16 | Not processed | Andres Freund (andresfreund) | Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) | Andres Freund (andresfreund) | 5 | 2 years ago | ||
| disallow HEAP_XMAX_COMMITTED and HEAP_XMAX_IS_LOCKED_ONLY | 3434 | Moved to different CF | 16 | Not processed | Nathan Bossart (bossartn) | Mark Dilger (mark.dilger) | 7 | 2 years ago | |||
| reduce impact of lengthy startup and checkpoint tasks | 3448 | Moved to different CF | 17 | Not processed | Nathan Bossart (bossartn) | Bharath Rupireddy (bharathrupireddy) | 9 | 2 years ago | |||
| more descriptive message for process termination due to max_slot_wal_keep_size | 3472 | Moved to different CF | Not processed | Kyotaro Horiguchi (horiguti) | Bertrand Drouvot (bdrouvot) | Tom Lane (tgl) | 4 | 2 years ago | |||
| new diagnostic items for the dynamic sql | 3537 | Moved to different CF | Not processed | Dinesh Kumar (dineshkumar) | 4 | 2 years ago | |||||
| Preventing indirection for IndexPageGetOpaque for known-size page special areas | 3543 | Moved to different CF | 16 | Not processed | Matthias van de Meent (mmeent) | 4 | 2 years ago | ||||
| Add native windows on arm64 support | 3561 | Moved to different CF | Not processed | Niyas Sait (niyassait) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 4 | 1 year ago | |||
| 64-bit XIDs | 3594 | Moved to different CF | Not processed | Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Aleksander Alekseev (a.alekseev), Konstantin Knizhnik (knizhnik), Nikita Glukhov (n.glukhov), Yura Sokolov (funny_falcon), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Aleksander Alekseev (a.alekseev), Chris Travers (einhverfr) | 6 | 10 months ago | ||||
| use has_privs_of_role() for pg_hba.conf | 3609 | Moved to different CF | 16 | Not processed | Nathan Bossart (bossartn) | Michael Paquier (michael-kun), Joe Conway (jconway), Joshua Brindle (joshuab) | Joe Conway (jconway) | 3 | 2 years ago | ||
| Completed unaccent dictionary with many missing characters | 3631 | Moved to different CF | 15 | Not processed | Przemysław Sztoch (psztoch) | 4 | 2 years ago | ||||
| OAT_POST_CREATE object visibility | 3676 | Moved to different CF | Not processed | Mary Xu (maryxu-pg) | Jeff Davis (jdavis) | 2 | 2 years ago | ||||
| generate_series in selected timezone, date_add in selected timezone | 3699 | Moved to different CF | 16 | Not processed | Gurjeet Singh (gurjeet), Przemysław Sztoch (psztoch) | Tom Lane (tgl), Gurjeet Singh (gurjeet) | Tom Lane (tgl) | 5 | 2 years ago | ||
| SYSTEM_USER reserved word implementation | 3703 | Moved to different CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 2 | 2 years ago | ||
| explain analyze rows=%.0f | 3704 | Moved to different CF | Not processed | Ibrar Ahmed (ibrar) | Amit Kapila (amitkapila), Hamid Akhtar (hamidakhtar), Naeem Akhter (naeem) | 5 | 3 months ago | ||||
| making relfilenodes 56 bit | 3711 | Moved to different CF | Not processed | Dilip Kumar (dilip.kumar) | Robert Haas (rhaas) | 4 | 2 years ago | ||||
| Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row | 3713 | Moved to different CF | 16 | Not processed | Hamid Akhtar (hamidakhtar) | Ibrar Ahmed (ibrar), Asif Rehman (asifrana), Muhammad Usama (muhammad_usama), Bertrand Drouvot (bdrouvot), Naeem Akhter (naeem) | Tom Lane (tgl) | 2 | 2 years ago | ||
| New hooks in the connection path | 3735 | Moved to different CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Joe Conway (jconway), Bharath Rupireddy (bharathrupireddy) | 5 | 2 years ago | |||
| Check consistency of GUC defaults between .sample.conf and pg_settings.boot_val | 3736 | Moved to different CF | Not processed | Kyotaro Horiguchi (horiguti), Justin Pryzby (justinpryzby) | Justin Pryzby (justinpryzby) | 9 | 1 year ago | ||||
| Allow placeholders in ALTER ROLE w/o superuser | 3749 | Moved to different CF | Not processed | Steve Chávez (steve-chavez) | Nathan Bossart (bossartn) | 2 | 2 years ago | ||||
| Create subscription stats entry at CREATE SUBSCRIPTION | 3776 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada) | Andres Freund (andresfreund) | 2 | 2 years ago | ||||
| Improve description of XLOG_RUNNING_XACTS | 3779 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada) | Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila) | 3 | 2 years ago | |||
| Monitoring & Control | |||||||||||
| Add extra statistics to explain for Nested Loop | 2765 | Moved to different 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 different 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 months ago | ||
| pg_stat_statements: Track statement entry timestamp | 3048 | Moved to different 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 different 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 month ago | |||
| Add system view tracking shared buffer actions | 3272 | Moved to different CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Justin Pryzby (justinpryzby) | Andres Freund (andresfreund) | 9 | 2 years ago | ||
| Extend postgres_fdw_get_connections() to print the user_name | 3388 | Moved to different CF | Not processed | Hayato Kuroda (ha-kun) | Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Shinya Kato (shinyakato), Yuta Katsuragi (katsuragiy) | Fujii Masao (masaofujii) | 15 | 9 months ago | |||
| Add pg_stat_session | 3405 | Moved to different CF | Needs rebase! | Rafia Sabih (rafia.sabih), Sergey Dudoladov (sdudoladov) | Bertrand Drouvot (bdrouvot), Atsushi Torikoshi (atsushitorikoshi), Andrei Zubkov (zubkov), Sadeq Dousti (msdousti) | 17 | 3 months ago | ||||
| explain_regress, explain(MACHINE), and default to explain(BUFFERS) | 3409 | Moved to different CF | 16 | Not processed | Justin Pryzby (justinpryzby), Nikolay Samokhvalov (nikolay) | Laurenz Albe (laurenz), Justin Pryzby (justinpryzby) | 6 | 2 years ago | |||
| Add Amcheck option for checking unique constraints in btree indexes | 3464 | Moved to different CF | Not processed | Anastasia Lubennikova (lubennikovaav), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Peter Geoghegan (pgeoghegan), Aleksander Alekseev (a.alekseev), Mark Dilger (mark.dilger) | Alexander Korotkov (smagen) | 10 | 11 months ago | |||
| jit_warn_above_fraction parameter | 3573 | Moved to different CF | Not processed | Magnus Hagander (mha) | Julien Rouhaud (rjuju) | 3 | 2 years ago | ||||
| Add index scan progress to pg_stat_progress_vacuum | 3617 | Moved to different CF | Not processed | Sami Imseih (simseih) | Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn) | Masahiko Sawada (masahikosawada) | 5 | 2 years ago | |||
| Add description about using geqo to EXPLAIN or debug log. | 3680 | Moved to different CF | Not processed | masaya kawamoto (kawamoto) | 2 | 2 years ago | |||||
| Add JIT deform_counter | 3688 | Moved to different CF | Not processed | Dmitry Dolgov (erthalion) | Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson) | Daniel Gustafsson (d_gustafsson) | 7 | 1 year ago | |||
| Amcheck verification of GiST and GIN | 3733 | Moved to different CF |
6/7
|
+1508−215 | Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) | José Villanova (azlev), Mark Dilger (mark.dilger) | Tomas Vondra (fuzzycz) | 15 | 3 months ago | ||
| Performance | |||||||||||
| Remove self join on a unique column | 1712 | Moved to different CF | Not processed | Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) | Alena Rybakina (a.rybakina) | Alexander Korotkov (smagen) | 27 | 3 months ago | |||
| Fast COPY FROM command for the foreign tables | 2601 | Moved to different 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 different 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 different CF | Not processed | Álvaro Herrera (alvherre) | 11 | 1 year ago | |||||
| Consider parallel for LATERAL subqueries having LIMIT/OFFSET | 2851 | Moved to different CF | Not processed | James Coleman (jcole1989) | Greg Nancarrow (gregn1234) | 11 | 2 years ago | ||||
| Faster pglz compression | 2897 | Moved to different 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 different CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Thomas Munro (macdice) | Thomas Munro (macdice) | 12 | 2 years ago | ||
| Lazy JIT IR code generation to increase JIT speed with partitions | 3071 | Moved to different CF | Not processed | David Geier (geidav), Luc Vlaming (luc.vlaming) | Dmitry Dolgov (erthalion) | 9 | 2 years ago | ||||
| Add proper planner support for ORDER BY / DISTINCT aggregates | 3164 | Moved to different CF | Not processed | David Rowley (davidrowley) | Ronan Dunklau (rdunklau), Richard Guo (richardguo) | David Rowley (davidrowley) | 7 | 2 years ago | |||
| Fix ExecRTCheckPerms() inefficiency with many prunable partitions | 3224 | Moved to different CF | 16 | Not processed | Amit Langote (amitlan) | Álvaro Herrera (alvherre), Tom Lane (tgl) | Álvaro Herrera (alvherre) | 8 | 2 years ago | ||
| Using each rel as both outer and inner for anti-joins | 3235 | Moved to different 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 different CF | 14 | Not processed | Andrei Lepikhov (lepikhov) | 7 | 2 years ago | ||||
| Parallelize correlated subqueries that execute within each worker | 3246 | Moved to different CF | Not processed | James Coleman (jcole1989) | Akshat Jaimini (akshatj) | 15 | 11 months ago | ||||
| Cache tuple routing info during bulk loads into partitioned tables | 3270 | Moved to different 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 | |||
| KnownAssignedXidsGetAndSetXmin performance | 3271 | Moved to different CF | Not processed | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Kirill Reshke (reshke), Andrey Borodin (x4mmm) | 6 | 2 years ago | ||||
| Asynchronous and "direct" IO support for PostgreSQL | 3316 | Moved to different CF | Not processed | Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice) | 6 | 2 years ago | |||||
| postgres_fdw: commit remote (sub)transactions in parallel during pre-commit | 3392 | Moved to different CF | 16 | Not processed | Etsuro Fujita (efujita) | Fujii Masao (masaofujii), David Zhang (david.z) | Etsuro Fujita (efujita) | 8 | 2 years ago | ||
| partIndexlist for partitioned tables uniqueness | 3452 | Moved to different CF | Not processed | Arne Roland (harks) | David Rowley (davidrowley) | David Rowley (davidrowley) | 6 | 2 years ago | |||
| In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal) | 3461 | Moved to different CF | Not processed | Kyotaro Horiguchi (horiguti) | Heikki Linnakangas (heikki), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom) | 16 | 6 months ago | ||||
| AcquireExecutorLocks() and run-time pruning | 3478 | Moved to different CF | Needs rebase! | Amit Langote (amitlan) | Tom Lane (tgl) | Amit Langote (amitlan) | 17 | 4 months ago | |||
| BufferAlloc: don't take two simultaneous locks | 3483 | Moved to different CF | 16 | Not processed | Yura Sokolov (funny_falcon) | Michail Nikolaev (nkey) | 4 | 2 years ago | |||
| Speed up releasing of locks | 3501 | Moved to different CF | Not processed | Andres Freund (andresfreund), David Rowley (davidrowley) | Heikki Linnakangas (heikki) | 13 | 1 year ago | ||||
| [PATCH] Equivalence Class Filters | 3524 | Moved to different CF | 16 | Not processed | David Rowley (davidrowley), Andy Fan (andyf) | Andrei Lepikhov (lepikhov) | 4 | 2 years ago | |||
| postgres_fdw - use TABLESAMPLE when analyzing foreign tables | 3535 | Moved to different CF | Not processed | Tomas Vondra (fuzzycz) | Tom Lane (tgl), James Finnerty (jimfinnerty) | Tomas Vondra (fuzzycz) | 5 | 2 years ago | |||
| Allow parallel plan for referential integrity checks | 3539 | Moved to different CF | Not processed | Frédéric Yhuel (yhuelf) | Sami Imseih (simseih) | 7 | 1 year ago | ||||
| nbtree performance improvements through specialization on key shape | 3672 | Moved to different CF | Not processed | Matthias van de Meent (mmeent) | 14 | 8 months ago | |||||
| Add sortsupport for range types and btree_gist | 3686 | Moved to different CF | Not processed | Christoph Heiss (christoph.heiss) | Tomas Vondra (fuzzycz), Bernd Helmle (psoo) | 12 | 3 months ago | ||||
| Improve dead tuple storage for lazy vacuum | 3687 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada), John Naylor (john.naylor) | Masahiko Sawada (masahikosawada) | 10 | 1 year ago | ||||
| Reducing planning time when tables have many partitions | 3701 | Moved to different CF |
7/7
|
+446−120 | Yuya Watari (watari) | Tom Lane (tgl), Thom Brown (thom), Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), newtglobal postgresql_contributors (newtpostgrescontributors) | David Rowley (davidrowley) | 15 | 3 months ago | ||
| ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables | 3705 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby) | Bertrand Drouvot (bertranddrouvot.pg) | 13 | 7 months ago | ||||
| Use fadvise in wal replay | 3707 | Moved to different CF | Not processed | Kirill Reshke (reshke), Jakub Wartak (jakub.wartak.tomtom) | Andrey Borodin (x4m), Pavel Borisov (pborisov) | 5 | 2 years ago | ||||
| Eliminating SPI from RI triggers | 3750 | Moved to different CF | Not processed | Amit Langote (amitlan) | 6 | 2 years ago | |||||
| Reduce timing overhead of EXPLAIN ANALYZE using rdtsc | 3751 | Moved to different CF | 16 | Not processed | Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) | Lukas Fittl (lfittl), Hannu Krosing (hannukrosing) | 8 | 1 year ago | |||
| Procedural Languages | |||||||||||
| declarative session variables, LET command | 1608 | Moved to different CF |
10/10
|
+7793−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 | 1 week ago | |||
| Documentation (mostly) of implementing TRANSFORM FOR TYPE in a PL | 3554 | Moved to different CF | 15 | Not processed | Chapman Flack (chap) | Pavel Stehule (okbobcz) | 3 | 2 years ago | |||
| Refactoring | |||||||||||
| psql - refactor echo code | 3140 | Moved to different CF | Not processed | Fabien Coelho (calvin) | Pavel Stehule (okbobcz), Peter Eisentraut (petere) | 10 | 2 years ago | ||||
| Move SLRU data into the regular buffer pool | 3514 | Moved to different CF | Not processed | Heikki Linnakangas (heikki), Thomas Munro (macdice) | Aleksander Alekseev (a.alekseev) | 8 | 1 year ago | ||||
| New [relation] options engine | 3536 | Moved to different CF | Not processed | Nikolay Shaplov (nataraj) | 5 | 4 months ago | |||||
| Use "WAL segment" instead of "log segment" consistently in user-facing messages | 3584 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Tom Lane (tgl) | 2 | 2 years ago | |||
| Refactor add_path for clarity and extensibility | 3599 | Moved to different CF | Not processed | Nils Dijk (nilsdijk) | 2 | 2 years ago | |||||
| Add internal Numeric to Uint64 conversion function. | 3627 | Moved to different CF | 16 | Not processed | Amul Sul (sulamul) | 3 | 2 years ago | ||||
| Refactoring MemSet/memset api usage | 3645 | Moved to different CF | 16 | Not processed | Ranier Vilela (raniervilela) | Peter Eisentraut (petere) | 2 | 2 years ago | |||
| Expand palloc/pg_malloc API | 3650 | Moved to different CF | Not processed | Peter Eisentraut (petere) | Tom Lane (tgl) | Peter Eisentraut (petere) | 2 | 2 years ago | |||
| Temporary file access API | 3722 | Moved to different CF | Not processed | Antonin Houska (a.houska) | 2 | 2 years ago | |||||
| Allow specification of custom slot for custom nodes | 3743 | Moved to different CF | 16 | Not processed | Alexander Korotkov (smagen) | Pavel Borisov (pborisov) | Alexander Korotkov (smagen) | 3 | 2 years ago | ||
| POC: Lock updated tuples in tuple_update() and tuple_delete() | 3752 | Moved to different CF | Not processed | Alexander Korotkov (smagen) | Aleksander Alekseev (a.alekseev), Pavel Borisov (pborisov) | 2 | 1 year ago | ||||
| Replication & Recovery | |||||||||||
| Make message at end-of-recovery less scary | 2490 | Moved to different CF | Not processed | Kyotaro Horiguchi (horiguti) | Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) | 20 | 1 year ago | ||||
| PITR enhance getRecordTimestamp() | 3222 | Moved to different CF | Not processed | Simon Riggs (simon) | 8 | 3 years ago | |||||
| schema change not getting invalidated, both renamed table and new table data were getting replicated | 3262 | Moved to different CF | Not processed | vigneshwaran C (vignesh.postgres) | Tom Lane (tgl) | Tom Lane (tgl) | 8 | 2 years ago | |||
| Add checkpoint stats of snapshot and mapping files of pg_logical dir | 3389 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | 5 | 2 years ago | ||||
| Add WAL recovery info such as current WAL file and WAL source to server logs | 3443 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | 5 | 2 years ago | ||||
| Add log messages when replication slots become active and inactive | 3492 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila) | 10 | 1 year ago | ||||
| Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work | 3496 | Moved to different CF | 16 | Not processed | Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 4 | 2 years ago | ||
| pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory | 3503 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | 11 | 1 year ago | |||||
| Suppressing useless wakeups in walreceiver | 3520 | Moved to different CF | Not processed | Thomas Munro (macdice), Nathan Bossart (bossartn) | Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) | Thomas Munro (macdice) | 5 | 2 years ago | |||
| Time-delayed logical replication subscriber | 3581 | Moved to different CF | Not processed | Euler Taveira (eulerto) | vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250) | 6 | 2 years ago | ||||
| Support logical replication of DDL commands | 3595 | Moved to different CF | Not processed | Zheng Li (zhengli), vigneshwaran C (vignesh.postgres), Ajin Cherian (ajinc), Zhijie Hou (houzj), Runqi Tian (runqitian) | Amit Kapila (amitkapila), Peter Smith (smithpb2250) | 10 | 1 year ago | ||||
| Handle infinite recursion in logical replication setup | 3610 | Moved to different CF | Not processed | vigneshwaran C (vignesh.postgres) | Amit Kapila (amitkapila), Ashutosh Bapat (ashutoshbapat), Hayato Kuroda (ha-kun), Peter Smith (smithpb2250) | Amit Kapila (amitkapila) | 2 | 2 years ago | |||
| Perform streaming logical transactions by background workers | 3621 | Moved to different CF | Not processed | Zhijie Hou (houzj) | Peter Smith (smithpb2250) | Amit Kapila (amitkapila) | 5 | 2 years ago | |||
| Skip replicating the tables specified in except table option | 3646 | Moved to different CF | Not processed | vigneshwaran C (vignesh.postgres) | Takamichi Osumi (tatatappp), Peter Smith (smithpb) | 9 | 1 year ago | ||||
| Switching XLog source from archive to streaming when primary available | 3663 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | Nathan Bossart (bossartn) | 13 | 10 months ago | ||||
| An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication | 3665 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 6 | 1 year ago | |||||
| Add last failed connection error message to pg_stat_wal_receiver | 3666 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 2 | 2 years ago | |||||
| Minimal logical decoding on standbys | 3740 | Moved to different CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Bharath Rupireddy (bharathrupireddy) | Andres Freund (andresfreund) | 5 | 2 years ago | ||
| Security | |||||||||||
| Expose authenticated identity to extensions and triggers | 3563 | Moved to different CF | Not processed | Jacob Champion (jchampion) | Bertrand Drouvot (bdrouvot) | Michael Paquier (michael-kun) | 3 | 2 years ago | |||
| Kerberos delegation | 3582 | Moved to different CF | Not processed | Stephen Frost (sfrost), Peifeng Qiu (peifengq) | Jacob Champion (jchampion) | 3 | 2 years ago | ||||
| USAGE privilege on PUBLICATION | 3641 | Moved to different CF | Not processed | Antonin Houska (a.houska) | 9 | 2 years ago | |||||
| Let libpq reject unexpected authentication requests | 3716 | Moved to different CF | 16 | Not processed | Jacob Champion (jchampion) | Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) | Michael Paquier (michael-kun) | 5 | 2 years ago | ||
| automatic client-side column-level encryption | 3718 | Moved to different CF | Not processed | Peter Eisentraut (petere) | 6 | 1 year ago | |||||
| grant-level NOINHERIT option | 3744 | Moved to different CF | 16 | Not processed | Robert Haas (rhaas) | Nathan Bossart (bossartn) | Robert Haas (rhaas) | 2 | 2 years ago | ||
| pg_auth_members.grantor is bunk | 3745 | Moved to different CF | 16 | Not processed | Robert Haas (rhaas) | Robert Haas (rhaas) | 2 | 2 years ago | |||
| Server Features | |||||||||||
| Fix partitionwise join with partially-redundant join clauses | 2266 | Moved to different CF | Not processed | Richard Guo (richardguo) | Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) | Richard Guo (richardguo) | 16 | 11 months ago | |||
| Extended statistics / estimate Var op Var clauses | 2831 | Moved to different 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 different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 9 | 8 months ago | |||||
| On client login event trigger | 2900 | Moved to different 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 | ||
| Allow batched insert during cross-partition updates | 2992 | Moved to different 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 different CF | Not processed | Magnus Hagander (mha) | Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) | 7 | 2 years ago | ||||
| Add callback table access method to reset filenode when dropping relation | 3073 | Moved to different CF | Not processed | Mats Kindahl (matski) | Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) | 7 | 2 years ago | ||||
| Asymmetric partition-wise JOIN | 3099 | Moved to different CF | 15 | Not processed | KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) | Alexander Pyhalov (a.pyhalov) | 7 | 3 years ago | |||
| pg_stats and range statistics | 3184 | Moved to different CF | 17 | Not processed | Egor Rogov (egorius) | Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) | Alexander Korotkov (smagen) | 13 | 1 year ago | ||
| Atomic rename feature for Windows | 3347 | Moved to different CF | Not processed | Victor Spirin (v.spirin) | 6 | 2 years ago | |||||
| Update relfrozenxmin when truncating temp tables | 3358 | Moved to different CF | 16 | Not processed | Greg Stark (stark) | 12 | 1 year ago | ||||
| WIN32 pg_import_system_collations | 3450 | Moved to different CF | Not processed | Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 6 | 2 years ago | |||
| Daitch-Mokotoff soundex | 3451 | Moved to different CF | Not processed | Dag Lem (daglem) | Paul Ramsey (pramsey) | Tom Lane (tgl) | 7 | 2 years ago | |||
| Index SLRUs by 64-bit integers rather than by 32-bit integers | 3489 | Moved to different CF | 16 | Not processed | Aleksander Alekseev (a.alekseev), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Alexander Korotkov (smagen), Jacob Champion (jchampion) | Alexander Korotkov (smagen) | 11 | 1 year ago | ||
| Pluggable toaster | 3490 | Moved to different CF | Not processed | Fedor Sigaev (sigaev), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg), Nikita Malakhov (nmalakh) | Andres Freund (andresfreund), Aleksander Alekseev (a.alekseev), Matthias van de Meent (mmeent) | 7 | 2 years ago | ||||
| Allow file inclusion in pg_hba and pg_ident files | 3558 | Moved to different CF | Not processed | Julien Rouhaud (rjuju) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 4 | 2 years ago | |||
| Reducing power consumption when idle | 3566 | Moved to different CF | Not processed | Simon Riggs (simon) | Thomas Munro (macdice) | 4 | 2 years ago | ||||
| Compression dictionaries | 3626 | Moved to different CF | 17 | Not processed | Aleksander Alekseev (a.alekseev) | Matthias van de Meent (mmeent), Nikita Malakhov (nmalakh) | 9 | 1 year ago | |||
| Add initdb option to initialize cluster with non-standard xid/mxid/mxoff. | 3634 | Moved to different CF | 16 | Not processed | Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | 5 | 2 years ago | ||||
| Support % wildcard in extension upgrade scripts | 3654 | Moved to different CF | 16 | Not processed | Sandro Santilli (strk) | Regina Obe (reginaobe) | 6 | 1 year ago | |||
| Allow foreign keys to reference a superset of unique columns | 3678 | Moved to different CF | 16 | Not processed | Kaiting Chen (ktchen14) | 2 | 2 years ago | ||||
| ALTER TABLE SET ACCESS METHOD on partitioned tables | 3727 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) | Álvaro Herrera (alvherre) | Álvaro Herrera (alvherre) | 10 | 1 year ago | |||
| Support multiple password-based authentication tokens concurrently | 3748 | Moved to different CF | 17 | Not processed | Joshua Brindle (joshuab) | Gurjeet Singh (gurjeet) | 2 | 1 year ago | |||
| SQL Commands | |||||||||||
| Incremental Materialized View Maintenance | 2138 | Moved to different 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 | |||
| CREATE INDEX CONCURRENTLY on partitioned table | 2815 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) | Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) | 15 | 2 weeks ago | ||||
| Support for grabbing multiple consecutive values with nextval() | 3577 | Moved to different CF | 15 | Not processed | Jille Timmermans (quis) | Ronan Dunklau (rdunklau) | 3 | 2 years ago | |||
| Summary Sort workers Stats in EXPLAIN ANALYZE | 3601 | Moved to different CF | Not processed | Jian Guo (jiang) | 2 | 2 years ago | |||||
| Add SPLIT PARTITION/MERGE PARTITIONS commands | 3659 | Moved to different CF | Needs rebase! | Dmitry Koval (d.koval) | stephane tachoires (sttachoires) | Alexander Korotkov (smagen) | 14 | 2 days ago | |||
| Add checks on search_path for IMMUTABLE and SECURITY DEFINER functions | 3684 | Moved to different CF | Not processed | Greg Stark (stark) | 2 | 2 years ago | |||||
| System Administration | |||||||||||
| Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) | 2377 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby) | Fabien Coelho (calvin) | 21 | 1 year ago | ||||
| Fix pg_rewind race condition just after promotion | 2864 | Moved to different CF | Not processed | Heikki Linnakangas (heikki) | Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) | Heikki Linnakangas (heikki) | 12 | 2 years ago | |||
| add guc: hugepages_active | 3310 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda) | Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun) | 7 | 2 years ago | |||
| Allows database-specific role memberships | 3374 | Moved to different CF | 18 | Not processed | Denis Laxalde (dlax), Kenaniah Cerny (kenaniah) | Antonin Houska (a.houska) | Stephen Frost (sfrost) | 6 | 9 months ago | ||
| warn if GUC set to an invalid shared library | 3482 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby) | Christoph Berg (myon), cary huang (caryh), Maciek Sakrejda (msakrejda), Cary Huang (cary) | 14 | 8 months ago | ||||
| Teach pg_waldump to extract FPIs from the WAL stream | 3628 | Moved to different CF | 16 | Not processed | David Christensen (davidchristensen) | Bharath Rupireddy (bharathrupireddy) | Michael Paquier (michael-kun) | 4 | 2 years ago | ||
| pg_walcleaner - new tool to detect, archive and delete the unneeded wal files | 3667 | Moved to different CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 2 | 3 years ago | |||||
| Testing | |||||||||||
| Added Windows with MinGW environment in Cirrus CI | 3575 | Moved to different CF | Not processed | Melih Mutlu (melihmutlu) | Andres Freund (andresfreund), Justin Pryzby (justinpryzby) | Andres Freund (andresfreund) | 4 | 2 years ago | |||
| Unit tests for SLRU | 3608 | Moved to different CF | 16 | Not processed | Aleksander Alekseev (a.alekseev) | Daniel Gustafsson (d_gustafsson), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Michael Paquier (michael-kun) | 3 | 2 years ago | ||
| Improve TAP tests of pg_upgrade for cross-version tests | 3649 | Moved to different CF | Not processed | Michael Paquier (michael-kun) | Justin Pryzby (justinpryzby), Anton Melnikov (antonmel) | Michael Paquier (michael-kun) | 2 | 2 years ago | |||
| Add TAP test for auth_delay extension | 3677 | Moved to different CF | Not processed | DongWook Lee (dongwooklee) | 2 | 2 years ago | |||||
| CI and test improvements | 3709 | Moved to different CF | Not processed | Justin Pryzby (justinpryzby) | 14 | 8 months ago | |||||
| add test: pg_rowlocks extension | 3724 | Moved to different CF | Not processed | DongWook Lee (dongwooklee) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 2 years ago | |||
| Testing autovacuum wraparound | 3729 | Moved to different CF | Not processed | Andres Freund (andresfreund), Masahiko Sawada (masahikosawada) | Masahiko Sawada (masahikosawada) | 8 | 1 year ago | ||||
| Introduce wait_for_subscription_sync for TAP tests | 3780 | Moved to different CF | Not processed | Masahiko Sawada (masahikosawada) | Amit Kapila (amitkapila) | 2 | 2 years ago | ||||