Commitfest 2022-09
Status summary: Committed: 65. Moved to next CF: 183. Withdrawn: 9. Returned with Feedback: 36. Rejected: 3. Total: 296.
Closed patches
| Patch | ID | Status | 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 | Committed | 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 next CF | 15 | Not processed | Yugo Nagata (yugo.nagata) | Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege) | Álvaro Herrera (alvherre) | 9 | 2 years ago | |
| Error "initial slot snapshot too large" in create replication slot | 3445 | Moved to next 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 next CF | Not processed | Thomas Munro (macdice) | Robert Haas (rhaas) | 4 | 1 year ago | |||
| Fix checkpointer sync request queue problems | 3583 | Moved to next CF | Not processed | Thomas Munro (macdice) | 3 | 3 years ago | ||||
| Nonreplayable XLog records by means of overflows and >MaxAllocSize lengths | 3590 | Moved to next CF | stable | Not processed | Matthias van de Meent (mmeent) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 3 | 1 year ago | |
| Remove pgwin32_is_junction(), add lstat() for Windows | 3598 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 3 | 2 years ago | |||
| Fix dsa_free() to re-bin segment | 3607 | Moved to next CF | Not processed | Dongming Liu (inferyes) | clundro infdahai (infdahai.outlook.com) | Thomas Munro (macdice) | 6 | 1 year ago | ||
| Fix recovery conflict SIGUSR1 handling | 3615 | Moved to next 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 | Committed | 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 next CF | Not processed | wei wang (wangwei), Yu Shi (shiy.fnst) | Amit Kapila (amitkapila), Takamichi Osumi (tatatappp), vigneshwaran C (vignesh.postgres), Hou Zhijie (houzj) | Amit Kapila (amitkapila) | 5 | 1 year ago | ||
| Fix the statistics gathering in case of commit and chain | 3657 | Returned with feedback | Not processed | Lætitia AVROT (arkhena) | 2 | 2 years ago | ||||
| Fix assertion failure with barriers in parallel hash join | 3662 | Moved to next 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 next 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 | Withdrawn | Not processed | Sami Imseih (simseih) | 2 | 2 years ago | ||||
| ENABLE/DISABLE broken for statement triggers on partitioned tables | 3728 | Committed | 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 next 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 | Committed | Not processed | Reid Thompson (jreidthompsoncd) | Bertrand Drouvot (bdrouvot), Mingli Zhang (zml) | Andres Freund (andresfreund) | 2 | 2 years ago | ||
| Fix test for pg_upgrade from 10x and some earlier versions. | 3757 | Returned with feedback | Not processed | Justin Pryzby (justinpryzby), Anton Melnikov (antonmel) | 1 | 2 years ago | ||||
| pg_stat_activity: avoid showing state=active with wait_event=ClientRead | 3760 | Moved to next CF | stable | Not processed | Yura Sokolov (funny_falcon), Mikhail Zhilin (mizhka-at-pgpro) | Justin Pryzby (justinpryzby), kamal priya (kamalp) | 2 | 2 years ago | ||
| Bug: Reading from single byte character column type may cause out of bounds memory reads | 3767 | Returned with feedback | Not processed | Nikolay Shaplov (nataraj) | 1 | 2 years ago | ||||
| Collect ObjectAddress for ATTACH DETACH PARTITION to use in event trigger | 3769 | Committed | Not processed | Hou Zhijie (houzj) | Michael Paquier (michael-kun) | 1 | 2 years ago | |||
| Fix GUC permissions check when restoring a previous setting | 3770 | Committed | 15 | Not processed | Tom Lane (tgl) | Nathan Bossart (bossartn) | Tom Lane (tgl) | 1 | 2 years ago | |
| Fix ruleutils' handling of dropped columns in composite-returning function RTEs | 3773 | Committed | stable | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago | ||
| Fix bounds check in trim_array() | 3778 | Committed | Not processed | Martin Kalcher (mkalcher) | Nathan Bossart (bossartn) | Tom Lane (tgl) | 1 | 2 years ago | ||
| Changing I/O format for non-ASCII data in "char" type | 3789 | Committed | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago | |||
| Fix GIN indexes cost estimation | 3796 | Moved to next CF | 16 | Not processed | Ronan Dunklau (rdunklau) | Tom Lane (tgl), Alexander Korotkov (smagen) | Alexander Korotkov (smagen) | 3 | 2 years ago | |
| pg_get_constraintdef: Schema qualify foreign tables unless pretty printing is enabled | 3811 | Moved to next CF | 16 | Not processed | Lukas Fittl (lfittl) | 2 | 2 years ago | |||
| Assertion failure in WaitForWALToBecomeAvailable state machine | 3814 | Committed | Not processed | Dilip Kumar (dilip.kumar), Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Noah Misch (nmisch) | 1 | 2 years ago | ||
| Bug: When user-defined AM is used, the index path cannot be selected correctly | 3819 | Committed | Not processed | Zongliang Quan (quanzl) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago | ||
| [BUG] Logical replica crash if there was an error in a function. | 3828 | Moved to next CF | Not processed | Maxim Orlov (m.orlov), Anton Melnikov (antonmel) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 1 year ago | ||
| pg_stat_have_stats() returns true for dropped indexes (or for index creation transaction rolled back) | 3832 | Committed | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Yogesh Sharma (sharmay) | Andres Freund (andresfreund) | 1 | 2 years ago | |
| Fix alter subscription concurrency errors | 3842 | Moved to next CF | 16 | Not processed | Jelte Fennema-Nio (jeltef) | 4 | 2 years ago | |||
| Fix bogus array out-of-bounds BRIN Indexes | 3846 | Committed | 16 | Not processed | Ranier Vilela (raniervilela) | David Rowley (davidrowley) | 1 | 2 years ago | ||
| test Windows plperl fix | 3847 | Committed | Not processed | John Naylor (john.naylor) | 1 | 2 years ago | ||||
| Convert *GetDatum() and DatumGet*() macros to inline functions | 3859 | Committed | 16 | Not processed | Peter Eisentraut (petere) | Aleksander Alekseev (a.alekseev) | Peter Eisentraut (petere) | 1 | 2 years ago | |
| ensure get_database_list() switches back to the memory context in use upon entry rather than returning with TopMemoryContext as the context. | 3866 | Committed | Not processed | Tom Lane (tgl) | 1 | 2 years ago | ||||
| pg_rewind WAL deletion pitfall | 3874 | Moved to next CF | Not processed | Alexander Kukushkin (cyberdem0n), Polina Bungina (hughcapet) | Kyotaro Horiguchi (horiguti), Atsushi Torikoshi (atsushitorikoshi), moro dream (morod) | Álvaro Herrera (alvherre) | 12 | 4 months ago | ||
| Crash of logical replica with trigger | 3918 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 1 year ago | ||
| Clients | ||||||||||
| 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 | ||
| Add non-blocking version of PQcancel | 3511 | Moved to next CF | 17 | Not processed | Jelte Fennema-Nio (jeltef) | Denis Laxalde (dlax) | Álvaro Herrera (alvherre) | 11 | 3 months ago | |
| Add LZ4 compression in pg_dump | 3571 | Moved to next CF | 16 | Not processed | Georgios Kokolatos (gkokolatos), Rachel Heaton (rheaton) | Tomas Vondra (fuzzycz), Justin Pryzby (justinpryzby), Yu Shi (shiy.fnst) | Tomas Vondra (fuzzycz) | 6 | 1 year ago | |
| Support load balancing in libpq | 3679 | Moved to next CF | 16 | Not processed | Jelte Fennema-Nio (jeltef) | Daniel Gustafsson (d_gustafsson), Andrey Borodin (x4m), Michael Banck (mbanck) | Daniel Gustafsson (d_gustafsson) | 5 | 1 year ago | |
| Code Comments | ||||||||||
| Fix annotations nextFullXid | 3775 | Committed | 15 | Not processed | Mingli Zhang (zml) | Fujii Masao (masaofujii) | 1 | 2 years ago | ||
| fix out of date comment in commit_ts.c | 3786 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Thomas Munro (macdice) | 1 | 2 years ago | ||
| Fix obsoleted comments for function prototypes | 3798 | Committed | Not processed | Richard Guo (richardguo) | Michael Paquier (michael-kun) | 1 | 2 years ago | |||
| Clarify the comments about varlena header encoding | 3820 | Returned with feedback | 16 | Not processed | Aleksander Alekseev (a.alekseev) | 1 | 2 years ago | |||
| Documentation | ||||||||||
| Improve role attributes docs | 3516 | Committed | 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 next CF | Not processed | Mark Wong (markwkm) | 6 | 1 year ago | ||||
| Doc about how to set max_wal_senders when setting minimal wal_level | 3586 | Committed | Not processed | Japin Li (japin) | Lætitia AVROT (arkhena) | Bruce Momjian (bmomjian) | 2 | 2 years ago | ||
| Clarify Routines and Extension Membership | 3693 | Committed | 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 next CF | Not processed | David Johnston (polobo) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 3 | 2 years ago | ||
| Make selectivity example match wording | 3695 | Moved to next CF | Not processed | David Johnston (polobo) | Dian Fay (dmfay) | 3 | 2 years ago | |||
| Select Reference Page - Make Join Syntax More Prominent | 3726 | Returned with feedback | Not processed | David Johnston (polobo) | 2 | 2 years ago | ||||
| doc: mention CREATE+ATTACH PARTITION as an alternative to CREATE..PARTITION OF | 3790 | Moved to next CF | 12 | Not processed | Justin Pryzby (justinpryzby) | Robert Treat (xzilla), Jakub Wartak (jakub.wartak.tomtom) | Tom Lane (tgl) | 4 | 2 years ago | |
| improve information about psqlrc on windows | 3797 | Committed | Not processed | Robert Treat (xzilla) | Tom Lane (tgl), Julien Rouhaud (rjuju) | Tom Lane (tgl) | 1 | 2 years ago | ||
| Document customized options visibility in pg_settings | 3856 | Committed | Not processed | Benoit Lobréau (benoitl) | Nathan Bossart (bossartn) | Tom Lane (tgl) | 1 | 2 years ago | ||
| plpgsql-trigger.html: more concise wording for TG_ variables | 3863 | Moved to next CF | 15 | Not processed | Christoph Berg (myon) | Daniel Gustafsson (d_gustafsson) | Daniel Gustafsson (d_gustafsson) | 2 | 2 years ago | |
| Miscellaneous | ||||||||||
| Function to log backtrace of postgres processes | 2863 | Moved to next CF | Not processed | vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) | Christoph Berg (myon), Maciek Sakrejda (msakrejda) | 17 | 1 year ago | |||
| pgbench: add multiconnect support | 3227 | Moved to next CF | 16 | Not processed | David Christensen (davidchristensen) | Jelte Fennema-Nio (jeltef) | 9 | 2 years ago | ||
| building postgres with meson | 3395 | Committed | 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 next 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 next CF | 17 | Not processed | Nathan Bossart (bossartn) | Bharath Rupireddy (bharathrupireddy) | 9 | 1 year ago | ||
| more descriptive message for process termination due to max_slot_wal_keep_size | 3472 | Committed | 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 next CF | Not processed | Dinesh Kumar (dineshkumar) | 4 | 2 years ago | ||||
| Preventing indirection for IndexPageGetOpaque for known-size page special areas | 3543 | Moved to next CF | 16 | Not processed | Matthias van de Meent (mmeent) | 4 | 2 years ago | |||
| Add native windows on arm64 support | 3561 | Moved to next CF | Not processed | Niyas Sait (niyassait) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 4 | 1 year ago | ||
| 64-bit XIDs | 3594 | Moved to next 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 | 6 months ago | |||
| use has_privs_of_role() for pg_hba.conf | 3609 | Moved to next 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 next CF | 15 | Not processed | Przemysław Sztoch (psztoch) | 4 | 2 years ago | |||
| OAT_POST_CREATE object visibility | 3676 | Committed | 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 next 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 | Committed | 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 next CF | Not processed | Ibrar Ahmed (ibrar) | Amit Kapila (amitkapila), Hamid Akhtar (hamidakhtar), Naeem Akhter (naeem) | 5 | 1 week ago | |||
| making relfilenodes 56 bit | 3711 | Moved to next 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 | Returned with feedback | 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 next CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Joe Conway (jconway), Bharath Rupireddy (bharathrupireddy) | 5 | 1 year ago | ||
| Check consistency of GUC defaults between .sample.conf and pg_settings.boot_val | 3736 | Moved to next 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 | Returned with feedback | Not processed | Steve Chávez (steve-chavez) | Nathan Bossart (bossartn) | 2 | 2 years ago | |||
| Enables to call Unregister*XactCallback() in Call*XactCallback() | 3759 | Committed | 15 | Not processed | Hao Wu (hwu) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago | |
| allow granting VACUUM and ANALYZE privileges on relations | 3774 | Moved to next CF | 16 | Not processed | Nathan Bossart (bossartn) | Andrew Dunstan (adunstan) | Andrew Dunstan (adunstan) | 2 | 2 years ago | |
| Create subscription stats entry at CREATE SUBSCRIPTION | 3776 | Committed | Not processed | Masahiko Sawada (masahikosawada) | Andres Freund (andresfreund) | 2 | 2 years ago | |||
| Improve description of XLOG_RUNNING_XACTS | 3779 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila) | 3 | 2 years ago | ||
| Regression coverage for contrib/tcn | 3788 | Committed | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago | |||
| support COPY TO callback functions | 3795 | Committed | 16 | Not processed | Nathan Bossart (bossartn), Bilva Sanaba (bilvas) | Joe Conway (jconway) | Michael Paquier (michael-kun) | 1 | 2 years ago | |
| SI-read predicate locks on materialized views | 3804 | Moved to next CF | Not processed | Yugo Nagata (yugo.nagata) | Richard Guo (richardguo) | Michael Paquier (michael-kun) | 2 | 2 years ago | ||
| Renumber confusing value for GUC_UNIT_BYTE | 3812 | Committed | Not processed | Justin Pryzby (justinpryzby) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 2 years ago | ||
| identifying the backend that owns a temporary schema | 3816 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago | |
| make use of regular expressions for the username in pg_hba.conf | 3824 | Moved to next CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Jacob Champion (jchampion) | Michael Paquier (michael-kun) | 2 | 2 years ago | |
| Improve hints for missing-column and missing-table cases | 3829 | Moved to next CF | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 2 years ago | |||
| Tab completion for ALTER TABLE foo OF | NOT OF (was: Tab completion for SET COMPRESSION) | 3831 | Committed | 16 | Not processed | Aleksander Alekseev (a.alekseev) | Shinya Kato (shinyakato) | Michael Paquier (michael-kun) | 1 | 2 years ago | |
| improve large object handling in pg_upgrade | 3841 | Returned with feedback | 16 | Not processed | Nathan Bossart (bossartn), Jan Wieck (wieck) | 1 | 11 months ago | |||
| write/read support for raw parse trees | 3848 | Committed | Not processed | Peter Eisentraut (petere) | Tom Lane (tgl), Pavel Stehule (okbobcz) | Peter Eisentraut (petere) | 1 | 2 years ago | ||
| introduce bufmgr hooks | 3853 | Moved to next CF | 16 | Not processed | Nathan Bossart (bossartn) | 2 | 2 years ago | |||
| remove postgres_fdw hint messages | 3855 | Committed | Not processed | Peter Eisentraut (petere), Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | Peter Eisentraut (petere) | 1 | 2 years ago | ||
| Monitoring & Control | ||||||||||
| Add extra statistics to explain for Nested Loop | 2765 | Returned with feedback | Not processed | Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) | Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) | 10 | 2 years ago | |||
| pg_stat_statements and "IN" conditions | 2837 | Moved to next CF |
6/7
|
+945−23 | Dmitry Dolgov (erthalion) | Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih) | Álvaro Herrera (alvherre) | 22 | 2 days ago | |
| pg_stat_statements: Track statement entry timestamp | 3048 | Moved to next CF | 17 | Not processed | Andrei Zubkov (zubkov) | Alena Rybakina (a.rybakina) | Alexander Korotkov (smagen) | 13 | 1 year ago | |
| Logging plan of the currently running query | 3142 | Moved to next CF | 16 | Not processed | atsushi torikoshi (atorik) | Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) | 9 | 3 days ago | ||
| Add system view tracking shared buffer actions | 3272 | Moved to next CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Justin Pryzby (justinpryzby) | Andres Freund (andresfreund) | 9 | 1 year ago | |
| Extend postgres_fdw_get_connections() to print the user_name | 3388 | Moved to next CF | Not processed | Hayato Kuroda (ha-kun) | Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres), Shinya Kato (shinyakato), Yuta Katsuragi (katsuragiy) | Fujii Masao (masaofujii) | 15 | 6 months ago | ||
| Add pg_stat_session | 3405 | Moved to next CF | Needs rebase! | Rafia Sabih (rafia.sabih), Sergey Dudoladov (sdudoladov) | Bertrand Drouvot (bdrouvot), Atsushi Torikoshi (atsushitorikoshi), Andrei Zubkov (zubkov), Sadeq Dousti (msdousti) | 16 | 1 week ago | |||
| explain_regress, explain(MACHINE), and default to explain(BUFFERS) | 3409 | Moved to next 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 next 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 | 7 months ago | ||
| jit_warn_above_fraction parameter | 3573 | Returned with feedback | Not processed | Magnus Hagander (mha) | Julien Rouhaud (rjuju) | 3 | 2 years ago | |||
| Add description about using geqo to EXPLAIN or debug log. | 3680 | Returned with feedback | Not processed | masaya kawamoto (kawamoto) | 2 | 2 years ago | ||||
| Add JIT deform_counter | 3688 | Moved to next 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 next CF |
5/7
|
+1495−215 | Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) | José Villanova (azlev) | 15 | 3 weeks ago | ||
| Add last_vacuum_index_scans in pg_stat_all_tables | 3756 | Moved to next CF | Not processed | Ken Kato (kkato) | Kshetrapaldesi Tutika (kshetrapal) | 3 | 2 years ago | |||
| Add parallel counters to pg_stat_statements | 3787 | Returned with feedback | 16 | Not processed | Daymel Bonne (bonne), Anthony Sotolongo León (asotolongo) | Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby) | 1 | 2 years ago | ||
| Missing CFI in iterate_word_similarity() | 3799 | Committed | 16 | Not processed | Robins Tharakan (robins) | Daniel Gustafsson (d_gustafsson) | Daniel Gustafsson (d_gustafsson) | 1 | 2 years ago | |
| Making autovacuum logs indicate if insert-based threshold was the triggering condition | 3802 | Moved to next CF | Not processed | Peter Geoghegan (pgeoghegan) | 2 | 2 years ago | ||||
| Instrumented pages/tuples frozen in autovacuum's server log out (and VACUUM VERBOSE) | 3827 | Committed | Not processed | Peter Geoghegan (pgeoghegan) | Peter Geoghegan (pgeoghegan) | 1 | 2 years ago | |||
| Tracking last scan time | 3836 | Moved to next CF | 16 | Not processed | Dave Page (dpage) | Vik Fearing (xocolatl) | Andres Freund (andresfreund) | 2 | 2 years ago | |
| Summary function for pg_buffercache | 3839 | Moved to next CF | Not processed | Melih Mutlu (melihmutlu) | Aleksander Alekseev (a.alekseev), Mingli Zhang (zml) | Andres Freund (andresfreund) | 2 | 2 years ago | ||
| HOT chain validation in verify_heapam() | 3849 | Moved to next CF | Not processed | Himanshu Upadhyaya (himanshuu) | Robert Haas (rhaas), Aleksander Alekseev (a.alekseev) | Robert Haas (rhaas) | 4 | 1 year ago | ||
| Tracking the compression effect | 3851 | Moved to next CF | Not processed | Ken Kato (kkato) | 2 | 2 years ago | ||||
| Query Jumbling for CALL and SET utility statements | 3864 | Moved to next CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Michael Paquier (michael-kun), Fujii Masao (masaofujii), Julien Rouhaud (rjuju), Sami Imseih (simseih) | 2 | 2 years ago | ||
| Add tracking of backend memory allocated to pg_stat_activity | 3865 | Moved to next CF | Not processed | Reid Thompson (jreidthompsoncd) | Melanie Plageman (melanieplageman), Bertrand Drouvot (bdrouvot) | 3 | 1 year ago | |||
| Report checkpoint progress with pg_stat_progress_checkpoint | 3873 | Returned with feedback | Not processed | Nitin Jadhav (nitinjadhav11) | Julien Rouhaud (rjuju), Matthias van de Meent (mmeent) | 1 | 2 years ago | |||
| Performance | ||||||||||
| 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 | 3 days ago | ||
| Fast COPY FROM command for the foreign tables | 2601 | Moved to next CF | Not processed | Andrei Lepikhov (lepikhov) | Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) | Etsuro Fujita (efujita) | 13 | 2 years ago | ||
| More scalable multixacts buffers and locking | 2627 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | Álvaro Herrera (alvherre) | 20 | 11 months ago | |||
| fix spinlock contention in LogwrtResult | 2716 | Withdrawn | Not processed | Álvaro Herrera (alvherre) | 11 | 11 months ago | ||||
| Faster pglz compression | 2897 | Moved to next CF | Not processed | Andrey Borodin (x4m), Владимир Лесков (tinsane) | Mark Dilger (mark.dilger) | Tomas Vondra (fuzzycz) | 12 | 2 years ago | ||
| Parallel Hash Full Join | 2903 | Moved to next CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Thomas Munro (macdice) | Thomas Munro (macdice) | 12 | 1 year ago | |
| Lazy JIT IR code generation to increase JIT speed with partitions | 3071 | Moved to next CF | Not processed | David Geier (geidav), Luc Vlaming (luc.vlaming) | Dmitry Dolgov (erthalion) | 9 | 2 years ago | |||
| Add proper planner support for ORDER BY / DISTINCT aggregates | 3164 | Committed | 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 next CF | 16 | Not processed | Amit Langote (amitlan) | Álvaro Herrera (alvherre), Tom Lane (tgl) | Álvaro Herrera (alvherre) | 8 | 1 year ago | |
| Using each rel as both outer and inner for anti-joins | 3235 | Moved to next CF | Not processed | Richard Guo (richardguo) | Ronan Dunklau (rdunklau) | Tom Lane (tgl) | 9 | 1 year ago | ||
| Postgres picks suboptimal index after building extended statistics | 3245 | Moved to next CF | 14 | Not processed | Andrei Lepikhov (lepikhov) | 7 | 2 years ago | |||
| Cache tuple routing info during bulk loads into partitioned tables | 3270 | Committed | Not processed | David Rowley (davidrowley), Amit Langote (amitlan), Hou Zhijie (houzj) | Álvaro Herrera (alvherre), David Rowley (davidrowley) | David Rowley (davidrowley) | 6 | 2 years ago | ||
| KnownAssignedXidsGetAndSetXmin performance | 3271 | Moved to next CF | Not processed | Michail Nikolaev (nkey) | Kirill Reshke (reshke), Andrey Borodin (x4mmm) | 6 | 2 years ago | |||
| Asynchronous and "direct" IO support for PostgreSQL | 3316 | Returned with feedback | 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 next CF | 16 | Not processed | Etsuro Fujita (efujita) | Fujii Masao (masaofujii), David Zhang (david.z) | Etsuro Fujita (efujita) | 8 | 1 year ago | |
| partIndexlist for partitioned tables uniqueness | 3452 | Moved to next 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 next CF | Not processed | Kyotaro Horiguchi (horiguti) | Heikki Linnakangas (heikki), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom) | 16 | 2 months ago | |||
| AcquireExecutorLocks() and run-time pruning | 3478 | Moved to next CF | Needs rebase! | Amit Langote (amitlan) | Tom Lane (tgl) | Amit Langote (amitlan) | 17 | 1 month ago | ||
| BufferAlloc: don't take two simultaneous locks | 3483 | Returned with feedback | 16 | Not processed | Yura Sokolov (funny_falcon) | Michail Nikolaev (nkey) | 4 | 2 years ago | ||
| Speed up releasing of locks | 3501 | Moved to next CF | Not processed | Andres Freund (andresfreund), David Rowley (davidrowley) | Heikki Linnakangas (heikki) | 13 | 1 year ago | |||
| [PATCH] Equivalence Class Filters | 3524 | Moved to next 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 next 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 next 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 next CF | Not processed | Matthias van de Meent (mmeent) | 14 | 4 months ago | ||||
| Add sortsupport for range types and btree_gist | 3686 | Moved to next CF | Not processed | Christoph Heiss (christoph.heiss) | Tomas Vondra (fuzzycz), Bernd Helmle (psoo) | 12 | 1 week ago | |||
| Improve dead tuple storage for lazy vacuum | 3687 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada), John Naylor (john.naylor) | Masahiko Sawada (masahikosawada) | 10 | 11 months ago | |||
| Reducing planning time when tables have many partitions | 3701 | Moved to next CF |
7/7
|
+1246−212 | Yuya Watari (watari) | Tom Lane (tgl), Thom Brown (thom), Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), newtglobal postgresql_contributors (newtpostgrescontributors) | 15 | 13 hours ago | ||
| ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables | 3705 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Bertrand Drouvot (bertranddrouvot.pg) | 13 | 4 months ago | |||
| Use fadvise in wal replay | 3707 | Moved to next CF | Not processed | Kirill Reshke (reshke), Jakub Wartak (jakub.wartak.tomtom) | Andrey Borodin (x4m), Pavel Borisov (pborisov) | 5 | 1 year ago | |||
| Eliminating SPI from RI triggers | 3750 | Moved to next CF | Not processed | Amit Langote (amitlan) | 6 | 1 year ago | ||||
| Reduce timing overhead of EXPLAIN ANALYZE using rdtsc | 3751 | Moved to next CF | 16 | Not processed | Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) | Lukas Fittl (lfittl), Hannu Krosing (hannukrosing) | 8 | 1 year ago | ||
| remove_useless_groupby_columns is too enthusiastic | 3766 | Returned with feedback | Not processed | Tom Lane (tgl) | David Rowley (davidrowley) | 1 | 2 years ago | |||
| optimize lookups in snapshot [sub]xip arrays | 3768 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Mingli Zhang (zml) | John Naylor (john.naylor) | 1 | 2 years ago | |
| Hash index build performance tweak from sorting, part II | 3791 | Moved to next CF | Not processed | Simon Riggs (simon) | David Rowley (davidrowley) | David Rowley (davidrowley) | 2 | 2 years ago | ||
| Subtrans performance smoothing | 3792 | Withdrawn | Not processed | Simon Riggs (simon) | 1 | 2 years ago | ||||
| Parallel Aggregates for string_agg and array_agg | 3794 | Moved to next CF | Not processed | David Rowley (davidrowley) | Pavel Stehule (okbobcz) | David Rowley (davidrowley) | 3 | 2 years ago | ||
| Teach VACUUM to disregard long running transactions when determining XID cutoff for freezing | 3801 | Committed | Not processed | Peter Geoghegan (pgeoghegan) | Nathan Bossart (bossartn) | Peter Geoghegan (pgeoghegan) | 1 | 2 years ago | ||
| Minimizing calls to SubTransSetParent() | 3806 | Moved to next CF | Not processed | Simon Riggs (simon) | 4 | 2 years ago | ||||
| Reduce the chunk header sizes on all memory context types | 3810 | Committed | Not processed | Andres Freund (andresfreund), David Rowley (davidrowley) | David Rowley (davidrowley) | 1 | 2 years ago | |||
| asynchronous execution support for Custom Scan | 3813 | Moved to next CF | Not processed | KaiGai Kohei (kaigai), kazutaka onishi (onishi) | 8 | 1 year ago | ||||
| use ARM intrinsics in pg_lfind32() where available | 3826 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | John Naylor (john.naylor) | 1 | 2 years ago | ||
| Add semi-join pushdown to postgres_fdw | 3838 | Moved to next CF | 17 | Not processed | Alexander Pyhalov (a.pyhalov) | Yuki Fujii (fujiiyuki) | Alexander Korotkov (smagen) | 8 | 1 year ago | |
| New strategies for freezing, advancing relfrozenxid early | 3843 | Moved to next CF | Not processed | Peter Geoghegan (pgeoghegan) | Matthias van de Meent (mmeent) | 3 | 2 years ago | |||
| Small cleanups to tuplesort.c and a bonus small performance improvement | 3844 | Committed | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 1 | 2 years ago | |||
| num_sa_scans in genericcostestimate | 3871 | Returned with feedback | 16 | Not processed | Jeff Janes (jjanes) | Tom Lane (tgl) | 1 | 2 years ago | ||
| make additional use of optimized linear search routines | 3875 | Committed | 16 | Not processed | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 1 | 2 years ago | ||
| Procedural Languages | ||||||||||
| declarative session variables, LET command | 1608 | Moved to next CF |
6/7
|
+9964−65 | Pavel Stehule (okbobcz) | Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), newtglobal postgresql_contributors (newtpostgrescontributors) | 35 | 1 week ago | ||
| Documentation (mostly) of implementing TRANSFORM FOR TYPE in a PL | 3554 | Returned with feedback | 15 | Not processed | Chapman Flack (chap) | Pavel Stehule (okbobcz) | 3 | 2 years ago | ||
| Refactoring | ||||||||||
| psql - refactor echo code | 3140 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Pavel Stehule (okbobcz), Peter Eisentraut (petere) | 10 | 1 year ago | |||
| Move SLRU data into the regular buffer pool | 3514 | Moved to next CF | Not processed | Heikki Linnakangas (heikki), Thomas Munro (macdice) | Aleksander Alekseev (a.alekseev) | 8 | 1 year ago | |||
| New [relation] options engine | 3536 | Moved to next CF | Not processed | Nikolay Shaplov (nataraj) | 5 | 5 days ago | ||||
| Use "WAL segment" instead of "log segment" consistently in user-facing messages | 3584 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Tom Lane (tgl) | 2 | 2 years ago | ||
| Refactor add_path for clarity and extensibility | 3599 | Returned with feedback | Not processed | Nils Dijk (nilsdijk) | 2 | 2 years ago | ||||
| Add internal Numeric to Uint64 conversion function. | 3627 | Moved to next CF | 16 | Not processed | Amul Sul (sulamul) | 3 | 2 years ago | |||
| Refactoring MemSet/memset api usage | 3645 | Returned with feedback | 16 | Not processed | Ranier Vilela (raniervilela) | Peter Eisentraut (petere) | 2 | 2 years ago | ||
| Expand palloc/pg_malloc API | 3650 | Committed | Not processed | Peter Eisentraut (petere) | Tom Lane (tgl) | Peter Eisentraut (petere) | 2 | 2 years ago | ||
| Temporary file access API | 3722 | Returned with feedback | Not processed | Antonin Houska (a.houska) | 2 | 2 years ago | ||||
| Allow specification of custom slot for custom nodes | 3743 | Moved to next 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 | Returned with feedback | Not processed | Alexander Korotkov (smagen) | Aleksander Alekseev (a.alekseev), Pavel Borisov (pborisov) | 2 | 1 year ago | |||
| Making Vars outer-join aware | 3755 | Moved to next CF | Not processed | Tom Lane (tgl) | Richard Guo (richardguo) | Tom Lane (tgl) | 3 | 2 years ago | ||
| Cleaning up historical portability baggage | 3763 | Committed | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 1 | 2 years ago | |||
| Cygwin cleanup | 3781 | Moved to next CF | Not processed | Thomas Munro (macdice), Justin Pryzby (justinpryzby) | Justin Pryzby (justinpryzby) | 4 | 2 years ago | |||
| Refactoring postgres_fdw/connection.c | 3782 | Moved to next CF | Not processed | Fujii Masao (masaofujii) | Etsuro Fujita (efujita) | 5 | 2 years ago | |||
| Use pg_pwritev_with_retry() instead of write() in dir_open_for_write() to avoid partial writes | 3803 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 2 | 2 years ago | ||
| fix MSVC check for obsolete node support files | 3809 | Committed | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago | |||
| Use SetInstallXLogFileSegmentActive() for setting XLogCtl->InstallXLogFileSegmentActive | 3815 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 1 | 2 years ago | ||
| Provide sigaction() for Windows | 3818 | Moved to next CF | Not processed | Thomas Munro (macdice) | Thomas Munro (macdice) | 2 | 2 years ago | |||
| libpq error message refactoring | 3854 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Álvaro Herrera (alvherre) | Peter Eisentraut (petere) | 2 | 2 years ago | ||
| Remove dead code in pgcrypto | 3858 | Committed | Not processed | Daniel Gustafsson (d_gustafsson) | Aleksander Alekseev (a.alekseev) | Daniel Gustafsson (d_gustafsson) | 1 | 2 years ago | ||
| (DUPLICATE) Removing dead code in pgcrypto | 3860 | Withdrawn | 16 | Not processed | 1 | 2 years ago | ||||
| pg_upgrade check_ function state refactoring | 3861 | Committed | Not processed | Daniel Gustafsson (d_gustafsson) | Bruce Momjian (bmomjian), Nathan Bossart (bossartn) | Daniel Gustafsson (d_gustafsson) | 1 | 2 years ago | ||
| Replication & Recovery | ||||||||||
| Make message at end-of-recovery less scary | 2490 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti) | Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) | 20 | 1 year ago | |||
| PITR enhance getRecordTimestamp() | 3222 | Moved to next 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 next 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 | Withdrawn | 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 next 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 next 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 | Committed | 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 next CF | Not processed | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | 11 | 1 year ago | ||||
| Suppressing useless wakeups in walreceiver | 3520 | Moved to next 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 next CF | Not processed | Euler Taveira (eulerto) | vigneshwaran C (vignesh.postgres), Peter Smith (smithpb2250) | 6 | 1 year ago | |||
| Support logical replication of DDL commands | 3595 | Moved to next CF | Not processed | Zheng Li (zhengli), vigneshwaran C (vignesh.postgres), Ajin Cherian (ajinc), Hou Zhijie (houzj), Runqi Tian (runqitian) | Amit Kapila (amitkapila), Peter Smith (smithpb2250) | 10 | 11 months ago | |||
| Handle infinite recursion in logical replication setup | 3610 | Committed | 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 next CF | Not processed | Hou Zhijie (houzj) | Peter Smith (smithpb2250) | Amit Kapila (amitkapila) | 5 | 1 year ago | ||
| Skip replicating the tables specified in except table option | 3646 | Moved to next 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 next CF | Not processed | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | Nathan Bossart (bossartn) | 13 | 6 months ago | |||
| An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication | 3665 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | 6 | 1 year ago | ||||
| Add last failed connection error message to pg_stat_wal_receiver | 3666 | Withdrawn | Not processed | Bharath Rupireddy (bharathrupireddy) | 2 | 2 years ago | ||||
| Minimal logical decoding on standbys | 3740 | Moved to next CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Bharath Rupireddy (bharathrupireddy) | Andres Freund (andresfreund) | 5 | 1 year ago | |
| Use indexes on the subscriber when REPLICA IDENTITY is full on the publisher | 3765 | Moved to next CF | 16 | Not processed | Onder Kalaci (onderkalaci) | vigneshwaran C (vignesh.postgres) | Amit Kapila (amitkapila) | 4 | 2 years ago | |
| Reuse Workers and Replication Slots during Logical Replication | 3784 | Moved to next CF | Not processed | Melih Mutlu (melihmutlu) | Daniel Gustafsson (d_gustafsson) | 8 | 1 year ago | |||
| Avoid Copying WAL Segments Before Divergence to Speed Up pg_rewind | 3800 | Moved to next CF | 16 | Not processed | vignesh ravichandran (vigneshravichandran), Justin Kwan (justinpkwan.outlook.com) | Heikki Linnakangas (heikki), Michael Paquier (michael-kun) | 2 | 2 years ago | ||
| pg_receivewal, pg_recvlogical: Exit cleanly on SIGTERM | 3825 | Committed | stable | Not processed | Christoph Berg (myon) | Daniel Gustafsson (d_gustafsson) | Daniel Gustafsson (d_gustafsson) | 1 | 2 years ago | |
| Allow logical replication to copy tables in binary format | 3840 | Moved to next CF | Not processed | Melih Mutlu (melihmutlu) | vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila) | 4 | 2 years ago | ||
| Allow usage of archive .backup files as backup_label | 3862 | Moved to next CF | Not processed | Michael Banck (mbanck) | 2 | 2 years ago | ||||
| Security | ||||||||||
| Expose authenticated identity to extensions and triggers | 3563 | Committed | Not processed | Jacob Champion (jchampion) | Bertrand Drouvot (bdrouvot) | Michael Paquier (michael-kun) | 3 | 2 years ago | ||
| Kerberos delegation | 3582 | Returned with feedback | Not processed | Stephen Frost (sfrost), Peifeng Qiu (peifengq) | Jacob Champion (jchampion) | 3 | 1 year ago | |||
| USAGE privilege on PUBLICATION | 3641 | Moved to next CF | Not processed | Antonin Houska (a.houska) | 9 | 2 years ago | ||||
| Let libpq reject unexpected authentication requests | 3716 | Moved to next 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 next CF | Not processed | Peter Eisentraut (petere) | 6 | 11 months ago | ||||
| grant-level NOINHERIT option | 3744 | Committed | 16 | Not processed | Robert Haas (rhaas) | Nathan Bossart (bossartn) | Robert Haas (rhaas) | 2 | 2 years ago | |
| pg_auth_members.grantor is bunk | 3745 | Committed | 16 | Not processed | Robert Haas (rhaas) | Robert Haas (rhaas) | 2 | 2 years ago | ||
| allowing for control over SET ROLE | 3868 | Moved to next CF | 16 | Not processed | Robert Haas (rhaas) | Nathan Bossart (bossartn) | Robert Haas (rhaas) | 2 | 2 years ago | |
| Server Features | ||||||||||
| Extended statistics / estimate Var op Var clauses | 2831 | Returned with feedback | 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 | Returned with feedback | Not processed | Bharath Rupireddy (bharathrupireddy) | 9 | 4 months ago | ||||
| On client login event trigger | 2900 | Moved to next CF | 17 | Not processed | Konstantin Knizhnik (knizhnik), Greg Nancarrow (gregn1234), Mikhail Gribkov (youzhick) | Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234) | Alexander Korotkov (smagen) | 15 | 1 year ago | |
| Allow batched insert during cross-partition updates | 2992 | Moved to next CF | Not processed | Amit Langote (amitlan) | Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Hou Zhijie (houzj) | Etsuro Fujita (efujita) | 10 | 2 years ago | ||
| PROXY protocol support | 3032 | Returned with feedback | 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 | Returned with feedback | Not processed | Mats Kindahl (matski) | Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) | 7 | 2 years ago | |||
| Asymmetric partition-wise JOIN | 3099 | Returned with feedback | 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 next 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 next CF | Not processed | Victor Spirin (v.spirin) | 6 | 2 years ago | ||||
| Update relfrozenxmin when truncating temp tables | 3358 | Moved to next CF | 16 | Not processed | Greg Stark (stark) | 12 | 1 year ago | |||
| WIN32 pg_import_system_collations | 3450 | Moved to next 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 next CF | Not processed | Dag Lem (daglem) | Paul Ramsey (pramsey) | Tom Lane (tgl) | 7 | 1 year ago | ||
| Index SLRUs by 64-bit integers rather than by 32-bit integers | 3489 | Moved to next 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 next 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 next 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 next CF | Not processed | Simon Riggs (simon) | Thomas Munro (macdice) | 4 | 2 years ago | |||
| Compression dictionaries | 3626 | Moved to next 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 next CF | 16 | Not processed | Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | 5 | 2 years ago | |||
| Support % wildcard in extension upgrade scripts | 3654 | Moved to next 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 | Returned with feedback | 16 | Not processed | Kaiting Chen (ktchen14) | 2 | 2 years ago | |||
| ALTER TABLE SET ACCESS METHOD on partitioned tables | 3727 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) | Álvaro Herrera (alvherre) | Álvaro Herrera (alvherre) | 10 | 11 months ago | ||
| Support multiple password-based authentication tokens concurrently | 3748 | Returned with feedback | 17 | Not processed | Joshua Brindle (joshuab) | Gurjeet Singh (gurjeet) | 2 | 1 year ago | ||
| Push aggregation down to base relations and joins | 3764 | Moved to next CF | Not processed | Yuki Fujii (fujiiyuki) | Tomas Vondra (fuzzycz) | 8 | 1 year ago | |||
| BCP 47 locale names for Windows | 3772 | Moved to next CF | Not processed | Thomas Munro (macdice) | 8 | 7 months ago | ||||
| Provide the facility to set binary format output for specific OID's per session | 3777 | Moved to next CF | Not processed | Dave Cramer (dcramer) | Peter Eisentraut (petere), Gurjeet Singh (gurjeet) | 8 | 1 year ago | |||
| Page compression for OLTP | 3783 | Moved to next CF | 16 | Not processed | Chen huajun (chenhuajun) | 3 | 2 years ago | |||
| Generalize ereport_startup_progress infrastructure | 3807 | Withdrawn | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | 1 | 2 years ago | |||
| Refactor backup related code | 3808 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | Michael Paquier (michael-kun), Fujii Masao (masaofujii) | Michael Paquier (michael-kun) | 1 | 2 years ago | ||
| Patch to implement missing join selectivity estimation for range types | 3821 | Moved to next CF | Not processed | Mahmoud SAKR (mahmsakr), Diogo Repas (diogo.repas), Maxime Schoemans (mschoema), Zhicheng Luo (zcsysu.163.com) | Damir Belyalov (xhevx), Alena Rybakina (a.rybakina) | 10 | 1 year ago | |||
| logical decoding and replication of sequences, take 2 | 3823 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Dilip Kumar (dilip.kumar), Peter Eisentraut (petere), Ashutosh Bapat (ashutoshbapat) | 10 | 1 year ago | |||
| ALTER TABLE ... SET STORAGE default | 3830 | Moved to next CF | 16 | Not processed | Aleksander Alekseev (a.alekseev) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 2 years ago | |
| Support tls-exporter as channel binding for TLSv1.3 | 3850 | Moved to next CF | 16 | Not processed | Michael Paquier (michael-kun), Jacob Champion (jchampion) | 2 | 2 years ago | |||
| Enable jitlink as an alternative jit linker of legacy Rtdyld and add riscv jitting support | 3857 | Moved to next CF | Not processed | Alex Fan (alexfanqi) | 6 | 2 years ago | ||||
| Add the ability to limit the amount of memory that can be allocated to backends. | 3867 | Moved to next CF | Not processed | Reid Thompson (jreidthompsoncd), John Morris (coyotebush) | 11 | 1 year ago | ||||
| cataloguing NOT NULL constraints | 3869 | Moved to next CF | Not processed | Álvaro Herrera (alvherre) | Peter Eisentraut (petere) | Álvaro Herrera (alvherre) | 6 | 1 year ago | ||
| SQL Commands | ||||||||||
| Incremental Materialized View Maintenance | 2138 | Returned with feedback | 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 next CF | Not processed | Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) | Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) | 15 | 4 months ago | |||
| Support for grabbing multiple consecutive values with nextval() | 3577 | Returned with feedback | 15 | Not processed | Jille Timmermans (quis) | Ronan Dunklau (rdunklau) | 3 | 2 years ago | ||
| Summary Sort workers Stats in EXPLAIN ANALYZE | 3601 | Returned with feedback | Not processed | Jian Guo (jiang) | 2 | 2 years ago | ||||
| Add SPLIT PARTITION/MERGE PARTITIONS commands | 3659 | Moved to next CF | 18 |
7/7
|
+7090−39 | Dmitry Koval (d.koval) | stephane tachoires (sttachoires) | Alexander Korotkov (smagen) | 13 | 1 week ago |
| Add checks on search_path for IMMUTABLE and SECURITY DEFINER functions | 3684 | Returned with feedback | Not processed | Greg Stark (stark) | 2 | 2 years ago | ||||
| Add OR REPLACE option for CREATE OPERATOR | 3758 | Moved to next CF | 16 | Not processed | Svetlana Derevyanko (getsusun) | Nikita Malakhov (nmalakh) | 4 | 2 years ago | ||
| Two successive tabs in test case are causing syntax error in psql | 3761 | Rejected | Not processed | 1 | 2 years ago | |||||
| Introduce array_shuffle() and array_sample() functions | 3771 | Moved to next CF | Not processed | Martin Kalcher (mkalcher) | Tom Lane (tgl) | Tom Lane (tgl) | 4 | 1 year ago | ||
| COPY FROM IGNORE_ERRORS - ignores rows with errors while copying | 3817 | Moved to next CF | 17 | Not processed | Atsushi Torikoshi (atsushitorikoshi), Damir Belyalov (xhevx) | Daniel Gustafsson (d_gustafsson), Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) | Alexander Korotkov (smagen) | 8 | 1 year ago | |
| Add support for DEFAULT specification in COPY FROM | 3822 | Moved to next CF | Not processed | Israel Barth (barthisrael) | Andrew Dunstan (adunstan) | Andrew Dunstan (adunstan) | 4 | 2 years ago | ||
| System Administration | ||||||||||
| Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) | 2377 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Fabien Coelho (calvin) | 21 | 1 year ago | |||
| Fix pg_rewind race condition just after promotion | 2864 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) | Heikki Linnakangas (heikki) | 12 | 2 years ago | ||
| zstd compression for pg_dump | 2888 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Andreas Karlsson (kandreas), Jacob Champion (jchampion) | Tomas Vondra (fuzzycz) | 4 | 1 year ago | ||
| Allows database-specific role memberships | 3374 | Moved to next CF | 18 | Not processed | Denis Laxalde (dlax), Kenaniah Cerny (kenaniah) | Antonin Houska (a.houska) | Stephen Frost (sfrost) | 6 | 5 months ago | |
| warn if GUC set to an invalid shared library | 3482 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Christoph Berg (myon), cary huang (caryh), Maciek Sakrejda (msakrejda), Cary Huang (cary) | 14 | 4 months ago | |||
| Teach pg_waldump to extract FPIs from the WAL stream | 3628 | Moved to next 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 | Withdrawn | Not processed | Bharath Rupireddy (bharathrupireddy) | 2 | 2 years ago | ||||
| Compilation issue on Solaris. | 3762 | Rejected | Not processed | Ibrar Ahmed (ibrar) | Hamid Akhtar (hamidakhtar) | 1 | ||||
| Maximize page freezing | 3785 | Withdrawn | Not processed | Simon Riggs (simon) | 1 | 2 years ago | ||||
| pg_upgrade allows itself to be run twice (initdb) | 3872 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Peter Eisentraut (petere) | 2 | 2 years ago | |||
| Testing | ||||||||||
| Added Windows with MinGW environment in Cirrus CI | 3575 | Moved to next 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 next 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 | Committed | 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 | Rejected | Not processed | DongWook Lee (dongwooklee) | 2 | 2 years ago | ||||
| CI and test improvements | 3709 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | 14 | 4 months ago | ||||
| add test: pg_rowlocks extension | 3724 | Committed | Not processed | DongWook Lee (dongwooklee) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 2 years ago | ||
| Testing autovacuum wraparound | 3729 | Moved to next 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 | Committed | Not processed | Masahiko Sawada (masahikosawada) | Amit Kapila (amitkapila) | 2 | 2 years ago | |||
| pgstattuple: add test for coverage | 3793 | Moved to next CF | Not processed | DongWook Lee (dongwooklee) | 2 | 2 years ago | ||||
| old_snapshot: add test for coverage | 3805 | Moved to next CF | Not processed | DongWook Lee (dongwooklee) | 2 | 2 years ago | ||||
| xml2: add test for coverage | 3833 | Moved to next CF | Not processed | DongWook Lee (dongwooklee) | 3 | 2 years ago | ||||
| pg_waldump: add test for coverage | 3834 | Returned with feedback | Not processed | DongWook Lee (dongwooklee) | Peter Eisentraut (petere) | 1 | 1 year ago | |||
| pg_basebackup: add test about zstd compress option | 3835 | Moved to next CF | Not processed | DongWook Lee (dongwooklee) | 2 | 2 years ago | ||||
| TAP output format for pg_regress | 3837 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | Nikolay Shaplov (nataraj) | Daniel Gustafsson (d_gustafsson) | 4 | 1 year ago | ||
| Add peer authentication TAP test | 3845 | Committed | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Michael Paquier (michael-kun) | 1 | 2 years ago | ||
| pg_checksum: add test for coverage | 3852 | Returned with feedback | Not processed | DongWook Lee (dongwooklee) | Daniel Gustafsson (d_gustafsson) | 1 | 2 years ago | |||
| Better infrastructure for automated testing of concurrency issues | 3870 | Moved to next CF | 16 | Not processed | Alexander Korotkov (smagen) | 4 | 1 year ago | |||