Commitfest 2022-11
Status summary: Committed: 94. Moved to next CF: 174. Withdrawn: 13. Rejected: 4. Returned with Feedback: 22. Total: 307.
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 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 | ||
| 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 | |
| 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 | ||
| Make ON_ERROR_STOP stop on shell script failure | 3936 | Moved to next CF | Not processed | Tatsuhiro Nakamori (tatsu) | Fujii Masao (masaofujii) | 4 | 1 year ago | |||
| Fix bogus error emitted by pg_recvlogical when interrupted | 3966 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Michael Paquier (michael-kun), Tristan Partin (tristan957) | Michael Paquier (michael-kun) | 4 | 1 year ago | ||
| Fix order of checking ICU options in initdb and create database | 3976 | Moved to next CF | 15 | Not processed | Marina Polyakova (whipping.top1991) | José Villanova (azlev) | 4 | 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 | 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 | |
| Use the system CA pool for certificate verification | 3990 | Moved to next CF | 16 | Not processed | Jacob Champion (jchampion), Thomas Habets (habets) | Jelte Fennema-Nio (jeltef) | Daniel Gustafsson (d_gustafsson) | 3 | 2 years ago | |
| Code Comments | ||||||||||
| Add more comments on PreventInTransactionBlock | 3921 | Moved to next CF | Not processed | Yugo Nagata (yugo.nagata) | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 2 years ago | ||
| Fix GetWALAvailability function code comments for WALAVAIL_REMOVED return value | 3971 | Moved to next CF | Not processed | sirisha chamarthi (sirishac) | Tom Lane (tgl) | 2 | 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 | ||||
| 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 | |
| Add document is_superuser | 3889 | Moved to next CF | 16 | Not processed | Kotaro Kawamoto (kawamochi) | Shinya Kato (kato-shinya), Masao Fujii (fujiimso) | Fujii Masao (masaofujii) | 6 | 1 year ago | |
| PGDOCS - Stats views and functions not in order? | 3904 | Moved to next CF | 16 | Not processed | Peter Smith (smithpb) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 2 | 2 years ago | |
| Improve doc for autovacuum on partitioned tables | 3963 | Moved to next CF | 16 | Not processed | Laurenz Albe (laurenz) | Nathan Bossart (bossartn) | 4 | 1 year 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 | ||
| 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 | |||
| 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 | |||
| Add LSN to error messages reported for WAL file read/write/validate header failures and a new function pg_walfile_offset_lsn() | 3909 | Moved to next CF | 16 | Not processed | Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) | Maxim Orlov (m.orlov) | Michael Paquier (michael-kun) | 2 | 2 years ago | |
| CF App: add "Returned: Needs more interest" close status | 3991 | Moved to next CF | Not processed | Jacob Champion (jchampion) | 3 | 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 index scan progress to pg_stat_progress_vacuum | 3617 | Moved to next CF | Not processed | Sami Imseih (simseih) | Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn) | Masahiko Sawada (masahikosawada) | 5 | 1 year 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 | |||
| 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 | ||
| 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 | |||
| Periodic burst growth of the checkpoint_req counter on replica. | 3961 | Moved to next CF | 17 | Not processed | Anton Melnikov (antonmel) | Alexander Korotkov (smagen) | Alexander Korotkov (smagen) | 7 | 1 year ago | |
| Add EXPLAIN option GENERIC_PLAN for parameterized queries | 3962 | Moved to next CF | 16 | Not processed | Laurenz Albe (laurenz) | Julien Rouhaud (rjuju), Christoph Berg (myon), Michel Pelletier (michelp), Jim Jones (jimus) | Tom Lane (tgl) | 3 | 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 | 1 week 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 | |||
| Consider parallel for LATERAL subqueries having LIMIT/OFFSET | 2851 | Moved to next CF | Not processed | James Coleman (jcole1989) | Greg Nancarrow (gregn1234) | 11 | 2 years 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 | |||
| 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 | ||
| Parallelize correlated subqueries that execute within each worker | 3246 | Moved to next CF | Not processed | James Coleman (jcole1989) | Akshat Jaimini (akshatj) | 15 | 8 months 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 | |||
| 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 | |
| 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 | ||||
| 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 | |||
| Pulling up direct-correlated ANY_SUBLINK | 3941 | Moved to next CF | Not processed | Andy Fan (andyf) | 2 | 1 year ago | ||||
| BRIN Sort - sorting using BRIN indexes | 3949 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Greg Stark (stark), Matthias van de Meent (mmeent) | 7 | 1 year ago | |||
| Prefetch the next tuple's memory during seqscans | 3978 | Moved to next CF | Not processed | David Rowley (davidrowley), Thomas Munro (macdice) | 7 | 1 year ago | ||||
| Lockless queue of waiters based on atomic operations for LWLock | 3983 | Moved to next CF | Not processed | Alexander Korotkov (smagen), Pavel Borisov (pborisov) | 7 | 1 year ago | ||||
| Refactor relation extension, faster COPY | 3993 | Moved to next CF | Not processed | Andres Freund (andresfreund) | Heikki Linnakangas (heikki), Melanie Plageman (melanieplageman) | Andres Freund (andresfreund) | 3 | 2 years ago | ||
| Allow WindowFuncs prosupport function to use more optimal WindowClause options | 3994 | Moved to next CF | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 2 | 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 | ||||
| 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 | |||
| Simplify find_my_exec by using realpath(3) | 3878 | Moved to next CF | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 3 | 2 years ago | |||
| Avoid use deprecated Windows Memory API | 3893 | Moved to next CF | 16 | Not processed | Ranier Vilela (raniervilela) | Aleksander Alekseev (a.alekseev) | 3 | 2 years ago | ||
| Remove dead macro exec_subplan_get_plan | 3894 | Moved to next CF | 16 | Not processed | Mingli Zhang (zml) | Richard Guo (richardguo) | 3 | 2 years ago | ||
| Move backup-related code to xlogbackup.c/.h | 3919 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | 3 | 2 years ago | |||
| Simple code cleanup in tuplesort.c. | 3924 | Moved to next CF | Not processed | Xing Guo (higuoxing) | Richard Guo (richardguo) | John Naylor (john.naylor) | 2 | 2 years ago | ||
| Rework collation code | 3935 | Moved to next CF | 16 | Not processed | Jeff Davis (jdavis), Thomas Munro (macdice) | Peter Eisentraut (petere) | Jeff Davis (jdavis) | 3 | 2 years ago | |
| Windows filesystem support improvements | 3951 | Moved to next CF | Not processed | Thomas Munro (macdice) | 3 | 2 years ago | ||||
| Simplify standby state machine a bit in WaitForWALToBecomeAvailable() | 3965 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 3 | 2 years ago | ||
| ResourceOwner refactoring | 3982 | Moved to next CF | Not processed | Heikki Linnakangas (heikki) | Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) | Heikki Linnakangas (heikki) | 6 | 1 year ago | ||
| Split index and table statistics into different types of stats | 3984 | Moved to next CF | 17 | Not processed | Bertrand Drouvot (bertranddrouvot.pg) | Melanie Plageman (melanieplageman) | 4 | 1 year ago | ||
| heapgettup() refactoring | 3987 | Moved to next CF | 17 | Not processed | Melanie Plageman (melanieplageman) | David Rowley (davidrowley), Peter Eisentraut (petere) | David Rowley (davidrowley) | 3 | 2 years ago | |
| SetLatches() | 3998 | Moved to next CF | Not processed | Thomas Munro (macdice) | 12 | 5 months 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 | |||
| 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 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 | ||||
| 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 | |||
| 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 | ||
| Adding CommandID to heap xlog records | 3882 | Moved to next CF | Not processed | Anastasia Lubennikova (lubennikovaav), Matthias van de Meent (mmeent) | 2 | 1 year 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 | ||||
| User functions for building SCRAM secrets | 3988 | Moved to next CF | Not processed | Jonathan Katz (jkatz05) | 7 | 1 year 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 | |
| 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 | |||
| 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 | |||
| 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 | ||
| Expand character set for ltree labels | 3929 | Moved to next CF | 16 | Not processed | Garen Torikian (gjtorikian) | Nathan Bossart (bossartn) | Andrew Dunstan (adunstan) | 2 | 2 years ago | |
| Multi-version ICU | 3956 | Moved to next CF | Not processed | Thomas Munro (macdice) | 10 | 1 year ago | ||||
| Code checks for App Devs, using new options for transaction behavior | 3970 | Moved to next CF | Not processed | Simon Riggs (simon) | Greg Stark (stark) | 3 | 2 years ago | |||
| TDE key management patches | 3985 | Moved to next CF | Not processed | David Christensen (davidchristensen) | Chris Travers (einhverfr) | 7 | 1 year ago | |||
| Post-special Page Storage TDE support (aka Reserved Page Size) | 3986 | Moved to next CF | Not processed | David Christensen (davidchristensen) | 12 | 3 months ago | ||||
| Direct I/O (developer-only feature) | 3996 | Moved to next CF | Not processed | Andres Freund (andresfreund), Thomas Munro (macdice) | Bharath Rupireddy (bharathrupireddy) | Thomas Munro (macdice) | 3 | 2 years ago | ||
| Add palloc_aligned() to allow arbitrary power of 2 memory alignment | 3999 | Moved to next CF | Not processed | Andres Freund (andresfreund), David Rowley (davidrowley) | David Rowley (davidrowley) | 2 | 2 years 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 | |||
| Dynamic result sets from procedures | 2911 | Moved to next CF | Not processed | Peter Eisentraut (petere) | 12 | 2 years ago | ||||
| Non-decimal integer literals | 3292 | Moved to next CF | Not processed | Peter Eisentraut (petere) | John Naylor (john.naylor) | Peter Eisentraut (petere) | 6 | 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 | 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 | ||
| Fix tab completion MERGE | 3890 | Moved to next CF | Not processed | Kotaro Kawamoto (kawamochi) | Dean Rasheed (deanr), Shinya Kato (kato-shinya), Masao Fujii (fujiimso) | 4 | 1 year ago | |||
| COPY FROM enable FORCE_NULL/FORCE_NOT_NULL on all columns | 3896 | Moved to next CF | 17 | Not processed | Mingli Zhang (zml) | Andrew Dunstan (adunstan), Amit Langote (amitlan), Damir Belyalov (xhevx) | Andrew Dunstan (adunstan) | 5 | 1 year 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 | ||
| 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 | |
| Testing | ||||||||||
| 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 | |||
| xml2: add test for coverage | 3833 | Moved to next CF | Not processed | DongWook Lee (dongwooklee) | 3 | 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 | |||
| vacuumlo: add test to vacuumlo for test coverage | 3877 | Moved to next CF | Not processed | DongWook Lee (dongwooklee) | Daniel Gustafsson (d_gustafsson) | 2 | 2 years ago | |||
| Fix database creation during installchecks for ICU cluster | 3975 | Moved to next CF | 15 | Not processed | Marina Polyakova (whipping.top1991) | 2 | 2 years ago | |||
| Backport perl tests for pg_upgrade | 3997 | Moved to next CF | Not processed | Anton Melnikov (antonmel) | 2 | 2 years ago | ||||