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 | ||||||||||
| 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 | 2 years 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 | ||
| 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), Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 5 | 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 | ||
| 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 | ||
| 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 | ||
| 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 | |||
| [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 | 2 years ago | ||
| Fix alter subscription concurrency errors | 3842 | Moved to next CF | 16 | Not processed | Jelte Fennema-Nio (jeltef) | 4 | 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 | 2 years 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 | 2 years 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 | 2 years ago | |
| Documentation | ||||||||||
| doc: PQexecParams binary handling example for REAL data type | 3568 | Moved to next CF | Not processed | Mark Wong (markwkm) | 6 | 1 year 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 | |||
| 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 | |
| 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 | ||
| 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 | ||
| 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 | 7 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 | |||
| 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 | |
| explain analyze rows=%.0f | 3704 | Moved to next CF | Not processed | Ibrar Ahmed (ibrar) | Amit Kapila (amitkapila), Hamid Akhtar (hamidakhtar), Naeem Akhter (naeem) | 5 | 2 weeks ago | |||
| making relfilenodes 56 bit | 3711 | Moved to next CF | Not processed | Dilip Kumar (dilip.kumar) | Robert Haas (rhaas) | 4 | 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 | 2 years 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 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 | |
| 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 | ||
| 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 | ||
| 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 | |||
| introduce bufmgr hooks | 3853 | Moved to next CF | 16 | Not processed | Nathan Bossart (bossartn) | 2 | 2 years ago | |||
| Monitoring & Control | ||||||||||
| pg_stat_statements and "IN" conditions | 2837 | Moved to next CF |
6/7
|
+945−23 | Dmitry Dolgov (erthalion) | Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun), Sami Imseih (simseih) | Álvaro Herrera (alvherre) | 22 | 3 weeks ago | |
| pg_stat_statements: Track statement entry timestamp | 3048 | Moved to next CF | 17 | Not processed | Andrei Zubkov (zubkov) | Alena Rybakina (a.rybakina) | Alexander Korotkov (smagen) | 13 | 1 year ago | |
| Logging plan of the currently running query | 3142 | Moved to next CF | 16 | Not processed | atsushi torikoshi (atorik) | Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) | 9 | 1 week ago | ||
| Add system view tracking shared buffer actions | 3272 | Moved to next CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Justin Pryzby (justinpryzby) | Andres Freund (andresfreund) | 9 | 2 years ago | |
| 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 month 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 | 8 months 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 |
6/7
|
+1508−215 | Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) | José Villanova (azlev), Mark Dilger (mark.dilger) | Tomas Vondra (fuzzycz) | 15 | 2 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 | |||
| 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 | ||||
| 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 | 2 years 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 | |||
| 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 | 1 week ago | ||
| Fast COPY FROM command for the foreign tables | 2601 | Moved to next CF | Not processed | Andrei Lepikhov (lepikhov) | Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) | Etsuro Fujita (efujita) | 13 | 2 years ago | ||
| More scalable multixacts buffers and locking | 2627 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | Álvaro Herrera (alvherre) | 20 | 1 year ago | |||
| Faster pglz compression | 2897 | Moved to next CF | Not processed | Andrey Borodin (x4m), Владимир Лесков (tinsane) | Mark Dilger (mark.dilger) | Tomas Vondra (fuzzycz) | 12 | 2 years ago | ||
| Parallel Hash Full Join | 2903 | Moved to next CF | 16 | Not processed | Melanie Plageman (melanieplageman) | Thomas Munro (macdice) | Thomas Munro (macdice) | 12 | 2 years ago | |
| 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 | |||
| 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 | 2 years ago | ||
| Postgres picks suboptimal index after building extended statistics | 3245 | Moved to next CF | 14 | Not processed | Andrei Lepikhov (lepikhov) | 7 | 2 years ago | |||
| KnownAssignedXidsGetAndSetXmin performance | 3271 | Moved to next CF | Not processed | Michail Nikolaev (nkey) | Kirill Reshke (reshke), Andrey Borodin (x4mmm) | 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 | 2 years 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 | 3 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 | ||
| 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 | 5 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 | 1 year ago | |||
| Reducing planning time when tables have many partitions | 3701 | Moved to next 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 | 1 week 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 | 2 years 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 | ||
| 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 | ||
| 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 | ||
| Minimizing calls to SubTransSetParent() | 3806 | Moved to next CF | Not processed | Simon Riggs (simon) | 4 | 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 | ||||
| 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 | |||
| Procedural Languages | ||||||||||
| declarative session variables, LET command | 1608 | Moved to next CF |
6/7
|
+9966−64 | Pavel Stehule (okbobcz) | Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), newtglobal postgresql_contributors (newtpostgrescontributors) | 36 | 1 week ago | ||
| Refactoring | ||||||||||
| psql - refactor echo code | 3140 | Moved to next 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 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 | 4 weeks ago | ||||
| Add internal Numeric to Uint64 conversion function. | 3627 | Moved to next CF | 16 | Not processed | Amul Sul (sulamul) | 3 | 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 | |
| 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 | ||
| 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 | ||
| 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 | ||
| 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 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 | |||
| 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 | 2 years ago | |||
| Support logical replication of DDL commands | 3595 | Moved to next 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 | |||
| Perform streaming logical transactions by background workers | 3621 | Moved to next CF | Not processed | Zhijie Hou (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 | 7 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 | ||||
| Minimal logical decoding on standbys | 3740 | Moved to next CF | 16 | Not processed | Bertrand Drouvot (bdrouvot) | Bharath Rupireddy (bharathrupireddy) | Andres Freund (andresfreund) | 5 | 2 years 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 | ||
| 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 | ||||||||||
| 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 | ||||
| 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 | ||||||||||
| 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), Zhijie Hou (houzj) | Etsuro Fujita (efujita) | 10 | 2 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 | 2 years 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 | ||
| 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 | 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 | 8 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 | |||
| 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 | ||||||||||
| CREATE INDEX CONCURRENTLY on partitioned table | 2815 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) | Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) | 15 | 5 months ago | |||
| 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 | 4 weeks 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 | ||
| Introduce array_shuffle() and array_sample() functions | 3771 | Moved to next CF | Not processed | Martin Kalcher (mkalcher) | Tom Lane (tgl) | Tom Lane (tgl) | 4 | 2 years 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 | 2 years ago | ||
| Allows database-specific role memberships | 3374 | Moved to next CF | 18 | Not processed | Denis Laxalde (dlax), Kenaniah Cerny (kenaniah) | Antonin Houska (a.houska) | Stephen Frost (sfrost) | 6 | 6 months ago | |
| 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 | 5 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_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 | |
| CI and test improvements | 3709 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | 14 | 4 months ago | ||||
| Testing autovacuum wraparound | 3729 | Moved to next CF | Not processed | Andres Freund (andresfreund), Masahiko Sawada (masahikosawada) | Masahiko Sawada (masahikosawada) | 8 | 1 year 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_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 | 2 years ago | ||
| Better infrastructure for automated testing of concurrency issues | 3870 | Moved to next CF | 16 | Not processed | Alexander Korotkov (smagen) | 4 | 2 years ago | |||