| Bug Fixes |
|---|
| standby recovery fails when re-replaying due to missing directory which was removed in previous replay. | 2161 | Committed | stable | Not processed | | Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) | Michael Paquier (michael-kun) | Álvaro Herrera (alvherre) | 16 | 2 years ago |
| Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns | 3041 | Moved to next CF | | Not processed | | Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) | Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) | Amit Kapila (amitkapila) | 7 | 2 years ago |
| pgbench: using prepared BEGIN statement in a pipeline could cause an error | 3260 | Moved to 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 |
| Possible fails in pg_stat_statements test | 3518 | Committed | | Not processed | | Anton Melnikov (antonmel) | Robert Haas (rhaas) | Robert Haas (rhaas) | 2 | 2 years 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 |
| Panic due to incorrect missingContrecPtr after promotion | 3585 | Committed | stable | Not processed | | Sami Imseih (simseih) | | Álvaro Herrera (alvherre) | 1 | 2 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 |
| avoid multiple hard links to same WAL file after a crash | 3611 | Committed | 16 | Not processed | | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 2 years 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 | Moved to next CF | | Not processed | | Masahiko Sawada (masahikosawada) | Michael Paquier (michael-kun) | Tom Lane (tgl) | 2 | 2 years ago |
| Logical replication timeout problem | 3622 | Committed | | Not processed | | wei wang (wangwei) | Amit Kapila (amitkapila), Masahiko Sawada (masahikosawada), Euler Taveira (eulerto), Hayato Kuroda (ha-kun), Ajin Cherian (ajinc), Zhijie Hou (houzj), Yu Shi (shiy.fnst), Fabrice Chapuis (fabricec) | Amit Kapila (amitkapila) | 1 | 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), Zhijie Hou (houzj) | Amit Kapila (amitkapila) | 5 | 2 years ago |
| Fix file descriptor reuse bugs | 3625 | Committed | | Not processed | | Andres Freund (andresfreund), Thomas Munro (macdice) | | Thomas Munro (macdice) | 1 | 3 years ago |
| Fix controlfile inconsistency that can result in unrecoverable database | 3630 | Committed | | Not processed | | Kyotaro Horiguchi (horiguti) | Michael Paquier (michael-kun), Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 1 | 3 years ago |
| postgres_fdw versus regconfig and similar constants | 3638 | Committed | | Not processed | | Tom Lane (tgl) | Robert Haas (rhaas) | Tom Lane (tgl) | 1 | 2 years ago |
| Fixes wrong memset api usage | 3640 | Rejected | | Not processed | | Ranier Vilela (raniervilela) | | | 1 | 2 years ago |
| Implicitly created operator family not listed by pg_event_trigger_ddl_commands | 3642 | Committed | | Not processed | | Masahiko Sawada (masahikosawada) | | Álvaro Herrera (alvherre) | 1 | 2 years ago |
| bogus: logical replication rows/cols combinations | 3643 | Committed | | Not processed | | Zhijie Hou (houzj) | | Amit Kapila (amitkapila) | 1 | 2 years ago |
| De-reserve "STRING" | 3656 | Committed | 15 | Not processed | | Tom Lane (tgl) | | Tom Lane (tgl) | 1 | 2 years ago |
| Fix the statistics gathering in case of commit and chain | 3657 | Moved to next CF | | Not processed | | Lætitia AVROT (arkhena) | | | 2 | 2 years ago |
| Fix ECPG's handling of typedef names that match SQL keywords | 3658 | Committed | | Not processed | | Tom Lane (tgl) | Noah Misch (nmisch) | Tom Lane (tgl) | 1 | 2 years ago |
| ensure privilege checks in CREATE INDEX run as calling user | 3661 | Committed | stable | Not processed | | Noah Misch (nmisch), Nathan Bossart (bossartn) | | Noah Misch (nmisch) | 1 | 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 |
| BuildRelationExtStatistics should CHECK_FOR_INTERRUPTS | 3671 | Committed | 14 | Not processed | | Tom Lane (tgl), Justin Pryzby (justinpryzby) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago |
| [BUG] Panic due to incorrect missingContrecPtr after promotion | 3675 | Moved to next CF | | Not processed | | Sami Imseih (simseih) | | | 2 | 2 years ago |
| ENABLE/DISABLE broken for statement triggers on partitioned tables | 3728 | Moved to next CF | | Not processed | | Amit Langote (amitlan) | Dmitry Koval (d.koval) | Álvaro Herrera (alvherre) | 2 | 2 years ago |
| pg_visibility's pg_check_visible() yields false positive when working in parallel with autovacuum | 3739 | Moved to next CF | 17 | Not processed | | Daniel Shelepanov (dshelepanov) | | Alexander Korotkov (smagen) | 6 | 1 year ago |
| to address creation of PgStat* contexts with null parent context | 3746 | Moved to next CF | | Not processed | | Reid Thompson (jreidthompsoncd) | Bertrand Drouvot (bdrouvot), Mingli Zhang (zml) | Andres Freund (andresfreund) | 2 | 2 years ago |
| Clients |
|---|
| pg_dump - read data for some options from external file | 2573 | Moved to 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 |
| functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) | 3256 | Moved to next CF | | Not processed | | Justin Pryzby (justinpryzby) | David Christensen (davidchristensen) | | 16 | 11 months ago |
| psql: add xheader_width option to handle very long record lines | 3295 | Committed | | Not processed | | Platon Pronko (rogach) | Andrew Dunstan (adunstan) | Andrew Dunstan (adunstan) | 5 | 2 years ago |
| libpq compression | 3499 | Returned with feedback | | Not processed | | Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) | Justin Pryzby (justinpryzby) | | 3 | 3 years 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 | 4 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 |
| Add --schema and --exclude-schema options to vacuumdb | 3612 | Committed | 16 | Not processed | | Gilles Darold (darold), Justin Pryzby (justinpryzby) | Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) | Andrew Dunstan (adunstan) | 1 | 2 years ago |
| Add --{no-,}bypassrls flags to createuser | 3618 | Committed | 16 | Not processed | | Shinya Kato (shinyakato) | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 1 | 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 |
|---|
| Improve role attributes docs | 3516 | Moved to next CF | | Not processed | | Shinya Kato (shinyakato) | Fujii Masao (masaofujii), Swaha Miller (swaha) | Bruce Momjian (bmomjian) | 3 | 2 years ago |
| doc: PQexecParams binary handling example for REAL data type | 3568 | Moved to 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 | Moved to next CF | | Not processed | | Japin Li (japin) | Lætitia AVROT (arkhena) | Bruce Momjian (bmomjian) | 2 | 2 years ago |
| Harmonize "Hot Standby"<->"hot standby" in the documentation | 3588 | Committed | | Not processed | | Daniel Westermann (sukhadukkham) | Robert Treat (xzilla) | Michael Paquier (michael-kun) | 1 | 3 years ago |
| Specify that the shared locks in pg_dump are actually ACCESS SHARE | 3597 | Committed | | Not processed | | Florin Irion (irionr) | Nathan Bossart (bossartn), shuli yan (xmasteryanshuli) | John Naylor (john.naylor) | 1 | 3 years ago |
| Correct docs re: rewriting indexes when table rewrite is skipped | 3603 | Committed | | Not processed | | James Coleman (jcole1989) | Robert Haas (rhaas), Matthias van de Meent (mmeent) | Robert Haas (rhaas) | 1 | 3 years ago |
| Restructure ALTER TABLE notes to clarify table rewrites and verification scans | 3604 | Returned with feedback | | Not processed | | James Coleman (jcole1989) | Matthias van de Meent (mmeent) | | 1 | 2 years ago |
| PG DOCS - logical replication row filters | 3605 | Committed | | Not processed | | Peter Smith (smithpb2250) | Amit Kapila (amitkapila), Euler Taveira (eulerto) | Amit Kapila (amitkapila) | 1 | 3 years ago |
| I thought it would be better to add a POSIx_fadvise description for the recovery_prefetch parameter here, to distinguish it from the database functions. | 3689 | Withdrawn | 15 | Not processed | | | | | 1 | 3 years ago |
| I thought it would be better to add a POSIx_fadvise description for the recovery_prefetch parameter here, to distinguish it from the database functions. | 3690 | Withdrawn | 15 | Not processed | | | | | 1 | 3 years ago |
| Clarify Savepoint Behavior | 3691 | Committed | | Not processed | | David Johnston (polobo) | | Bruce Momjian (bmomjian) | 1 | 2 years ago |
| Clarify what "excluded" represents for INSERT ON CONFLICT | 3692 | Committed | | Not processed | | David Johnston (polobo) | | Bruce Momjian (bmomjian) | 1 | 2 years ago |
| Clarify Routines and Extension Membership | 3693 | Moved to next CF | | Not processed | | David Johnston (polobo) | | Bruce Momjian (bmomjian) | 2 | 2 years ago |
| Fix description of how the default user name is chosen | 3694 | Moved to 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 |
| Move enum storage commentary to top of section | 3696 | Returned with feedback | | Not processed | | David Johnston (polobo) | Matthias van de Meent (mmeent) | | 1 | 2 years ago |
| Bring mention of unique index forced transaction wait behavior outside of the internal section | 3697 | Committed | | Not processed | | David Johnston (polobo) | | Bruce Momjian (bmomjian) | 1 | 2 years ago |
| array_length produces null instead of 0 | 3698 | Committed | | Not processed | | David Johnston (polobo) | Daniel Shelepanov (dshelepanov) | Bruce Momjian (bmomjian) | 1 | 2 years ago |
| BRIN indexes and autosummarize | 3721 | Committed | 15 | Not processed | | Roberto Mello (rmello) | | Álvaro Herrera (alvherre) | 1 | 2 years ago |
| Select Reference Page - Make Join Syntax More Prominent | 3726 | Moved to next CF | | Not processed | | David Johnston (polobo) | | | 2 | 2 years ago |
| pg_prewarm add configuration example | 3732 | Committed | | Not processed | | DongWook Lee (dongwooklee) | | Bruce Momjian (bmomjian) | 1 | 2 years ago |
| document use of Table Access Methods with pgbench | 3741 | Committed | 16 | Not processed | | Alexander Korotkov (smagen), Michel Pelletier (michelp) | | Alexander Korotkov (smagen) | 1 | 2 years ago |
| doc phrase: "inheritance child" | 3753 | Committed | | Not processed | | Justin Pryzby (justinpryzby) | | Álvaro Herrera (alvherre) | 1 | 2 years ago |
| Miscellaneous |
|---|
| Fix behavior of geo_ops when NaN is involved | 2710 | Returned with feedback | | Not processed | | Kyotaro Horiguchi (horiguti) | Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) | | 10 | 3 years ago |
| 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 |
| Allow multiple recursive self-references | 3046 | Returned with feedback | | Not processed | | Denis Hirn (brainy) | Peter Eisentraut (petere) | | 6 | 3 years ago |
| Avoid orphaned dependencies | 3106 | Returned with feedback | 16 | Not processed | | Bertrand Drouvot (bdrouvot) | Ronan Dunklau (rdunklau) | | 6 | 3 years 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 | Moved to next CF | 16 | Not processed | | Andres Freund (andresfreund) | Peter Eisentraut (petere), Aleksander Alekseev (a.alekseev) | Andres Freund (andresfreund) | 5 | 2 years ago |
| Use -fvisibility=hidden for shared libraries | 3396 | Committed | | Not processed | | Andres Freund (andresfreund) | Tom Lane (tgl) | Andres Freund (andresfreund) | 4 | 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 | Moved to next CF | | Not processed | | Kyotaro Horiguchi (horiguti) | Bertrand Drouvot (bdrouvot) | Tom Lane (tgl) | 4 | 2 years ago |
| Add checkpoint and redo LSN to LogCheckpointEnd log message | 3474 | Committed | | Not processed | | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Fujii Masao (masaofujii) | 3 | 2 years ago |
| Extend compatibility of PostgreSQL::Test::Cluster | 3480 | Committed | 15 | Not processed | | Andrew Dunstan (adunstan) | Michael Paquier (michael-kun) | Andrew Dunstan (adunstan) | 3 | 3 years ago |
| Allow pg_upgrade to copy segments of the same relfilenode in parallel | 3525 | Returned with feedback | | Not processed | | Jaime Casanova (jcasanov) | | | 2 | 3 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 |
| TAP format output for pg_regress | 3559 | Returned with feedback | 16 | Not processed | | Daniel Gustafsson (d_gustafsson) | Peter Eisentraut (petere) | | 2 | 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 | 8 months ago |
| avoid extra logging with 'postgres -C' for runtime-computed parameters | 3596 | Committed | 15 | Not processed | | Nathan Bossart (bossartn) | | Michael Paquier (michael-kun) | 1 | 3 years 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 |
| make MaxBackends available in _PG_init | 3614 | Committed | 15 | Not processed | | Nathan Bossart (bossartn) | Anton Melnikov (antonmel), alex lan (alex-xxx) | Robert Haas (rhaas) | 1 | 3 years ago |
| Use outerPlanState macro instead of referring to lefttree | 3629 | Committed | | Not processed | | Richard Guo (richardguo) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 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 |
| REINDEX syntax usability | 3636 | Committed | | Not processed | | Simon Riggs (simon) | | Michael Paquier (michael-kun) | 1 | 2 years ago |
| Remove support for Visual Studio 2013 | 3637 | Committed | 16 | Not processed | | Michael Paquier (michael-kun) | | Michael Paquier (michael-kun) | 1 | 2 years ago |
| Add result_types column to pg_prepared_statements view | 3644 | Committed | 16 | Not processed | | Dagfinn Ilmari Mannsåker (ilmari) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 2 years ago |
| Bump MIN_WINNT to 0x0600 (Vista) as minimal runtime in 16~ | 3652 | Committed | | Not processed | | Michael Paquier (michael-kun) | | Michael Paquier (michael-kun) | 1 | 2 years ago |
| introduce pg_attribute_nonnull() | 3655 | Committed | 16 | Not processed | | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 2 years ago |
| pg_buffercache: add sql test | 3674 | Committed | | Not processed | | DongWook Lee (dongwooklee) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago |
| OAT_POST_CREATE object visibility | 3676 | Moved to next CF | | Not processed | | Mary Xu (maryxu-pg) | | Jeff Davis (jdavis) | 2 | 2 years ago |
| generate_series in selected timezone, date_add in selected timezone | 3699 | Moved to 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 |
| Autoconf update | 3702 | Returned with feedback | | Not processed | | Peter Eisentraut (petere) | Tom Lane (tgl) | | 1 | 2 years ago |
| SYSTEM_USER reserved word implementation | 3703 | Moved to next CF | 16 | Not processed | | Bertrand Drouvot (bdrouvot) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 2 | 2 years ago |
| explain analyze rows=%.0f | 3704 | Moved to next CF | | Not processed | | Ibrar Ahmed (ibrar) | Amit Kapila (amitkapila), Hamid Akhtar (hamidakhtar), Naeem Akhter (naeem) | | 5 | 1 month ago |
| making relfilenodes 56 bit | 3711 | Moved to next CF | | Not processed | | Dilip Kumar (dilip.kumar) | Robert Haas (rhaas) | | 4 | 2 years ago |
| Make an unique type name generation routine more resistant to name collisions | 3712 | Committed | 15 | Not processed | | Andrei Lepikhov (lepikhov), Dmitry Koval (d.koval) | Masahiko Sawada (masahikosawada) | Tom Lane (tgl) | 1 | 2 years ago |
| Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row | 3713 | Moved to next CF | 16 | Not processed | | Hamid Akhtar (hamidakhtar) | Ibrar Ahmed (ibrar), Asif Rehman (asifrana), Muhammad Usama (muhammad_usama), Bertrand Drouvot (bdrouvot), Naeem Akhter (naeem) | Tom Lane (tgl) | 2 | 2 years ago |
| Emit debug message when executing extension script. | 3720 | Committed | 16 | Not processed | | Jeff Davis (jdavis) | Nathan Bossart (bossartn) | Jeff Davis (jdavis) | 1 | 2 years ago |
| Add test of pg_prewarm extension | 3723 | Committed | | Not processed | | DongWook Lee (dongwooklee) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago |
| Minor change for create_list_bounds() | 3725 | Committed | | Not processed | | Ted Yu (tedyu) | Nathan Bossart (bossartn) | David Rowley (davidrowley) | 1 | 2 years ago |
| Reloption tests iprovement. Test resetting illegal option that was actually set for some reason | 3731 | Withdrawn | 15 | Not processed | | Nikolay Shaplov (nataraj) | | | 1 | 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 red-black tree missing comparison searches | 3742 | Committed | | Not processed | | Alexander Korotkov (smagen), Steve Chávez (steve-chavez) | | Alexander Korotkov (smagen) | 1 | 2 years ago |
| Reloption tests improvement. Test resetting illegal option that was actually set for some reason | 3747 | Returned with feedback | | Not processed | | Nikolay Shaplov (nataraj) | | | 1 | 2 years ago |
| Allow placeholders in ALTER ROLE w/o superuser | 3749 | Moved to next CF | | Not processed | | Steve Chávez (steve-chavez) | Nathan Bossart (bossartn) | | 2 | 2 years ago |
| Improve test coverage of gistbuild.c | 3754 | Committed | | Not processed | | Matheus Alcantara (msalcantara) | Aleksander Alekseev (a.alekseev) | Tom Lane (tgl) | 1 | 2 years ago |
| Create subscription stats entry at CREATE SUBSCRIPTION | 3776 | Moved to next CF | | 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 |
| Monitoring & Control |
|---|
| Add extra statistics to explain for Nested Loop | 2765 | Moved to next CF | | Not processed | | Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) | Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) | | 10 | 2 years ago |
| 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 | 1 month 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 | 2 weeks 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 | 7 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 | 2 months 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 |
| pg_stat_toast | 3457 | Withdrawn | | Not processed | | Gunnar "Nick" Bluth (bluthg) | Ibrar Ahmed (ibrar) | | 3 | 3 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 | 9 months ago |
| Add last commit LSN to pg_last_committed_xact() | 3515 | Returned with feedback | | Not processed | | James Coleman (jcole1989) | | | 2 | 3 years ago |
| jit_warn_above_fraction parameter | 3573 | Moved to next CF | | Not processed | | Magnus Hagander (mha) | Julien Rouhaud (rjuju) | | 3 | 2 years ago |
| Change the csv log to 'key:value' to facilitate the user to understanding and processing of log | 3591 | Rejected | | Not processed | | lu peng (lupeng89) | | | 1 | 3 years 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 |
| Log details for client certificate failures | 3632 | Committed | | Not processed | | Jacob Champion (jchampion) | Peter Eisentraut (petere) | Peter Eisentraut (petere) | 1 | 2 years ago |
| Log query parameters in auto_explain | 3660 | Committed | 16 | Not processed | | Dagfinn Ilmari Mannsåker (ilmari) | Michael Paquier (michael-kun) | Michael Paquier (michael-kun) | 1 | 2 years ago |
| Add description about using geqo to EXPLAIN or debug log. | 3680 | Moved to next CF | | Not processed | | masaya kawamoto (kawamoto) | | | 2 | 2 years ago |
| In logs, use microsecond rather than millisecond granularity for timestamps | 3683 | Returned with feedback | 16 | Not processed | | David Fetter (dfetter) | | | 1 | 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 | | 6/7 | +1508−215 | Heikki Linnakangas (heikki), Andrey Borodin (x4m), Grigory Kryachko (gskryachko) | José Villanova (azlev), Mark Dilger (mark.dilger) | Tomas Vondra (fuzzycz) | 15 | 1 month 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 month 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 |
| fix spinlock contention in LogwrtResult | 2716 | Moved to next CF | | Not processed | | Álvaro Herrera (alvherre) | | | 11 | 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 |
| Parallel INSERT SELECT take 2 | 3143 | Returned with feedback | | Not processed | | Greg Nancarrow (gregn1234), Zhijie Hou (houzj) | | | 6 | 2 years ago |
| pre-allocating WAL files | 3158 | Withdrawn | 16 | Not processed | | Nathan Bossart (bossartn) | Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | | 6 | 2 years ago |
| Add proper planner support for ORDER BY / DISTINCT aggregates | 3164 | Moved to next CF | | Not processed | | David Rowley (davidrowley) | Ronan Dunklau (rdunklau), Richard Guo (richardguo) | David Rowley (davidrowley) | 7 | 2 years ago |
| Map WAL segment files on PMEM as WAL buffers | 3181 | Returned with feedback | | Not processed | | Takashi Menjo (tmenjo) | | | 6 | 3 years ago |
| Write visibility map during CLUSTER/VACUUM FULL | 3206 | Returned with feedback | | Not processed | | Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva) | Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) | | 6 | 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 |
| Parallelize correlated subqueries that execute within each worker | 3246 | Moved to next CF | | Not processed | | James Coleman (jcole1989) | Akshat Jaimini (akshatj) | | 15 | 9 months ago |
| Cache tuple routing info during bulk loads into partitioned tables | 3270 | Moved to next CF | | Not processed | | David Rowley (davidrowley), Amit Langote (amitlan), Zhijie Hou (houzj) | Álvaro Herrera (alvherre), David Rowley (davidrowley) | David Rowley (davidrowley) | 6 | 2 years ago |
| KnownAssignedXidsGetAndSetXmin performance | 3271 | Moved to next CF | | Not processed | | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Kirill Reshke (reshke), Andrey Borodin (x4mmm) | | 6 | 2 years ago |
| Push down time-related SQLValue functions to foreign server | 3289 | Returned with feedback | 15 | Not processed | | Alexander Pyhalov (a.pyhalov) | | | 5 | 3 years ago |
| Asynchronous and "direct" IO support for PostgreSQL | 3316 | Moved to next CF | | Not processed | | Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice) | | | 6 | 2 years ago |
| postgres_fdw: commit remote (sub)transactions in parallel during pre-commit | 3392 | Moved to 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 | 4 months ago |
| AcquireExecutorLocks() and run-time pruning | 3478 | Moved to next CF | | Needs rebase! | | Amit Langote (amitlan) | Tom Lane (tgl) | Amit Langote (amitlan) | 17 | 2 months ago |
| BufferAlloc: don't take two simultaneous locks | 3483 | Moved to next CF | 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 |
| Avoid smgrimmedsync() during index build and add unbuffered IO API | 3508 | Returned with feedback | | Not processed | | Melanie Plageman (melanieplageman) | | | 2 | 2 years ago |
| [] 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 |
| reduce archiving overhead | 3555 | Committed | 16 | Not processed | | Nathan Bossart (bossartn) | | Fujii Masao (masaofujii) | 2 | 2 years ago |
| Declare PG_HAVE_8BYTE_SINGLE_COPY_ATOMICITY for aarch64 | 3593 | Committed | | Not processed | | Yura Sokolov (funny_falcon) | | Thomas Munro (macdice) | 1 | 3 years ago |
| Costing elided SubqueryScans more nearly correctly | 3633 | Committed | | Not processed | | Tom Lane (tgl) | Richard Guo (richardguo) | Tom Lane (tgl) | 1 | 2 years ago |
| Hash index sort performance | 3635 | Committed | | Not processed | | Simon Riggs (simon) | Amit Kapila (amitkapila) | Tom Lane (tgl) | 1 | 2 years ago |
| ecpglib: call newlocale() once per process | 3648 | Committed | stable | Not processed | | Noah Misch (nmisch) | Tom Lane (tgl) | Noah Misch (nmisch) | 1 | 2 years ago |
| Improving connection scalability | 3651 | Rejected | 16 | Not processed | | Ranier Vilela (raniervilela) | | | 1 | 2 years ago |
| nbtree performance improvements through specialization on key shape | 3672 | Moved to next CF | | Not processed | | Matthias van de Meent (mmeent) | | | 14 | 6 months ago |
| Reducing Memory Consumption (aset and generation) | 3673 | Rejected | 15 | Not processed | | Ranier Vilela (raniervilela) | | | 1 | 2 years 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 month 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 |
| Detecting plan changes with plan_id in pg_stat_activity | 3700 | Returned with feedback | | Not processed | | Sami Imseih (simseih) | Julien Rouhaud (rjuju) | | 1 | 2 years 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 month 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 | 5 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 |
| Optimize json_lex_string by batching character copying | 3710 | Committed | 16 | Not processed | | Jelte Fennema-Nio (jeltef) | John Naylor (john.naylor) | John Naylor (john.naylor) | 1 | 2 years ago |
| dual pivot quicksort | 3738 | Withdrawn | | Not processed | | John Naylor (john.naylor) | | | 1 | 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 |
| Procedural Languages |
|---|
| declarative session variables, LET command | 1608 | Moved to next CF | |  0/1 | +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 | 2 days ago |
| Documentation (mostly) of implementing TRANSFORM FOR TYPE in a PL | 3554 | Moved to next CF | 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 | 2 years ago |
| automatically generating node support functions | 3182 | Committed | | Not processed | | Peter Eisentraut (petere) | Tom Lane (tgl) | Peter Eisentraut (petere) | 6 | 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 |
| Teach WaitEventSets to grow automatically | 3533 | Returned with feedback | | Not processed | | Thomas Munro (macdice) | | | 2 | 3 years ago |
| New [relation] options engine | 3536 | Moved to next CF | | Not processed | | Nikolay Shaplov (nataraj) | | | 5 | 1 month ago |
| Use "WAL segment" instead of "log segment" consistently in user-facing messages | 3584 | Moved to next CF | | Not processed | | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Tom Lane (tgl) | 2 | 2 years ago |
| Refactor add_path for clarity and extensibility | 3599 | Moved to next CF | | Not processed | | Nils Dijk (nilsdijk) | | | 2 | 2 years ago |
| remove reset_shared() | 3606 | Committed | 16 | Not processed | | Nathan Bossart (bossartn) | Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Tom Lane (tgl) | 1 | 2 years ago |
| Make XLogRecGetBlockTag API more error-proof | 3613 | Committed | 15 | Not processed | | Tom Lane (tgl) | | Tom Lane (tgl) | 1 | 3 years ago |
| remove unused CalculateMaxmumSafeLSN | 3616 | Committed | | Not processed | | Sergei Kornilov (melkij) | | Tom Lane (tgl) | 1 | 2 years ago |
| Fix mechanism for reserving OIDs for template0 and postgres DBs | 3624 | Committed | 15 | Not processed | | Tom Lane (tgl) | | Tom Lane (tgl) | 1 | 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 | Moved to next CF | 16 | Not processed | | Ranier Vilela (raniervilela) | Peter Eisentraut (petere) | | 2 | 2 years ago |
| Expand palloc/pg_malloc API | 3650 | Moved to next CF | | Not processed | | Peter Eisentraut (petere) | Tom Lane (tgl) | Peter Eisentraut (petere) | 2 | 2 years ago |
| Fix unnecessary includes and comments in 019_replslot_limit.pl, 007_wal.pl and 004_timeline_switch.pl | 3669 | Committed | | Not processed | | Bharath Rupireddy (bharathrupireddy) | Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Michael Paquier (michael-kun) | 1 | 2 years ago |
| Remove trailing newlines from pg_upgrade's messages | 3685 | Committed | | Not processed | | Tom Lane (tgl) | Peter Eisentraut (petere) | Tom Lane (tgl) | 1 | 2 years ago |
| Custom tuplesorts for extensions | 3706 | Committed | 16 | Not processed | | Alexander Korotkov (smagen) | Maxim Orlov (m.orlov), Pavel Borisov (pborisov), Matthias van de Meent (mmeent) | Alexander Korotkov (smagen) | 1 | 2 years ago |
| refactor some protocol message sending in walsender and basebackup | 3715 | Committed | | Not processed | | Peter Eisentraut (petere) | Nathan Bossart (bossartn) | Peter Eisentraut (petere) | 1 | 2 years ago |
| Export log_line_prefix(); useful for emit_log_hook. | 3719 | Committed | 16 | Not processed | | Jeff Davis (jdavis) | | Jeff Davis (jdavis) | 1 | 2 years ago |
| Temporary file access API | 3722 | Moved to next CF | | Not processed | | Antonin Houska (a.houska) | | | 2 | 2 years ago |
| Remove useless param for create_groupingsets_path | 3734 | Committed | | Not processed | | xuejing zhao (zxuejing) | Richard Guo (richardguo) | Tom Lane (tgl) | 1 | 2 years ago |
| NLS: Put list of available languages into LINGUAS files | 3737 | Committed | | Not processed | | Peter Eisentraut (petere) | | Peter Eisentraut (petere) | 1 | 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 | Moved to next CF | | Not processed | | Alexander Korotkov (smagen) | Aleksander Alekseev (a.alekseev), Pavel Borisov (pborisov) | | 2 | 1 year ago |
| Replication & Recovery |
|---|
| Make message at end-of-recovery less scary | 2490 | Moved to 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 |
| tablesync early exit | 3062 | Withdrawn | 15 | Not processed | | Peter Smith (smithpb2250) | | | 6 | 3 years 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 | Moved to next CF | | Not processed | | Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | | 5 | 2 years ago |
| Logical insert/update/delete WAL records for custom table AMs | 3394 | Withdrawn | 15 | Not processed | | Jeff Davis (jdavis) | Simon Riggs (simon) | | 4 | 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 |
| Extensible RMgr | 3469 | Committed | 15 | Not processed | | Jeff Davis (jdavis) | Julien Rouhaud (rjuju) | Jeff Davis (jdavis) | 3 | 3 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 | Moved to next CF | 16 | Not processed | | Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) | Nathan Bossart (bossartn) | Michael Paquier (michael-kun) | 4 | 2 years ago |
| pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory | 3503 | Moved to 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 |
| speed up a logical replication setup (pg_subscriber) | 3556 | Returned with feedback | | Not processed | | Euler Taveira (eulerto) | Peter Eisentraut (petere) | | 2 | 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 |
| Handle infinite recursion in logical replication setup | 3610 | Moved to next CF | | Not processed | | vigneshwaran C (vignesh.postgres) | Amit Kapila (amitkapila), Ashutosh Bapat (ashutoshbapat), Hayato Kuroda (ha-kun), Peter Smith (smithpb2250) | Amit Kapila (amitkapila) | 2 | 2 years ago |
| Perform logical transactions by background workers | 3621 | Moved to next CF | | Not processed | | Zhijie Hou (houzj) | Peter Smith (smithpb2250) | Amit Kapila (amitkapila) | 5 | 2 years ago |
| Skip replicating the tables specified in except table option | 3646 | Moved to next CF | | Not processed | | vigneshwaran C (vignesh.postgres) | Takamichi Osumi (tatatappp), Peter Smith (smithpb) | | 9 | 1 year ago |
| Switching XLog source from archive to when primary available | 3663 | Moved to next CF | | Not processed | | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | Nathan Bossart (bossartn) | | 13 | 8 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 | Moved to next CF | | Not processed | | Bharath Rupireddy (bharathrupireddy) | | | 2 | 2 years ago |
| pg_receivewal fail to streams when the partial file to write is not fully initialized present in the wal receiver directory | 3668 | Withdrawn | | Not processed | | Bharath Rupireddy (bharathrupireddy), SATYANARAYANA NARLAPURAM (satyanarayanan) | | | 1 | 1 year ago |
| Replica Identity check of partition table on subscriber | 3681 | Committed | 15 | Not processed | | Zhijie Hou (houzj), Yu Shi (shiy.fnst) | Amit Langote (amitlan) | Amit Kapila (amitkapila) | 1 | 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 | 2 years ago |
| Security |
|---|
| Upgrade pgcrypto to crypt_blowfish 1.3 | 3338 | Returned with feedback | | Not processed | | Daniel Fone (daniel.fone) | Daniel Gustafsson (d_gustafsson) | | 4 | 3 years ago |
| CREATEROLE and role ownership hierarchies | 3506 | Returned with feedback | 15 | Not processed | | Mark Dilger (mark.dilger) | Joshua Brindle (joshuab) | | 2 | 2 years ago |
| Expose authenticated identity to extensions and triggers | 3563 | Moved to next CF | | Not processed | | Jacob Champion (jchampion) | Bertrand Drouvot (bdrouvot) | Michael Paquier (michael-kun) | 3 | 2 years ago |
| Kerberos delegation | 3582 | Moved to next CF | | Not processed | | Stephen Frost (sfrost), Peifeng Qiu (peifengq) | Jacob Champion (jchampion) | | 3 | 2 years 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 | 1 year ago |
| grant-level NOINHERIT option | 3744 | Moved to next CF | 16 | Not processed | | Robert Haas (rhaas) | Nathan Bossart (bossartn) | Robert Haas (rhaas) | 2 | 2 years ago |
| pg_auth_members.grantor is bunk | 3745 | Moved to next CF | 16 | Not processed | | Robert Haas (rhaas) | | Robert Haas (rhaas) | 2 | 2 years ago |
| Server Features |
|---|
| Fix partitionwise join with partially-redundant join clauses | 2266 | Moved to next CF | | Not processed | | Richard Guo (richardguo) | Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) | Richard Guo (richardguo) | 16 | 9 months ago |
| Global temporary table | 2349 | Returned with feedback | 16 | Not processed | | Wenjing Zeng (wenjing.zwj) | Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) | | 13 | 2 years ago |
| Extended statistics / estimate Var op Var clauses | 2831 | Moved to next CF | | Not processed | | Tomas Vondra (fuzzycz) | Dean Rasheed (deanr), Mark Dilger (mark.dilger) | | 9 | 2 years ago |
| New Table Access Methods for Multi and Single Inserts | 2871 | Moved to next CF | | Not processed | | Bharath Rupireddy (bharathrupireddy) | | | 9 | 6 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), Zhijie Hou (houzj) | Etsuro Fujita (efujita) | 10 | 2 years ago |
| PROXY protocol support | 3032 | Moved to next CF | | Not processed | | Magnus Hagander (mha) | Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) | | 7 | 2 years ago |
| Extended statistics in EXPLAIN | 3050 | Returned with feedback | | Not processed | | Tomas Vondra (fuzzycz) | Tatsuro Yamada (tatsuro_yamada) | | 6 | 3 years ago |
| Add callback table access method to reset filenode when dropping relation | 3073 | Moved to next CF | | Not processed | | Mats Kindahl (matski) | Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) | | 7 | 2 years ago |
| Asymmetric partition-wise JOIN | 3099 | Moved to next CF | 15 | Not processed | | KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) | Alexander Pyhalov (a.pyhalov) | | 7 | 3 years ago |
| pg_stats and range statistics | 3184 | Moved to next CF | 17 | Not processed | | Egor Rogov (egorius) | Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) | Alexander Korotkov (smagen) | 13 | 1 year ago |
| Gather partial paths for subproblem's topmost scan/join rel | 3274 | Committed | | Not processed | | Richard Guo (richardguo) | Antonin Houska (a.houska) | Tom Lane (tgl) | 5 | 2 years ago |
| Support pg_ident mapping for LDAP | 3314 | Withdrawn | | Not processed | | Jacob Champion (jchampion) | Magnus Hagander (mha) | | 5 | 3 years 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 |
| Per-table storage parameters for TableAM/IndexAM extensions | 3495 | Returned with feedback | | Not processed | | B Sadhu Prasad Patro (sadhuprasad) | Jelte Fennema-Nio (jeltef) | | 3 | 3 years ago |
| wal_sync_method=fdatasync for Windows | 3530 | Committed | | Not processed | | Thomas Munro (macdice) | | Thomas Munro (macdice) | 2 | 2 years ago |
| Support custom authentication methods using hooks | 3546 | Returned with feedback | 15 | Not processed | | Samay Sharma (samaysharma) | | | 2 | 3 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 |
| Zstandard support for toast compression | 3639 | Withdrawn | | Not processed | | Michael Paquier (michael-kun) | | | 1 | 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 |
| Deletion of the recycled future WAL files to free-up disk space if max_wal_size is reduced or wal_recycle is set to off | 3664 | Returned with feedback | | Not processed | | Bharath Rupireddy (bharathrupireddy) | | | 1 | 3 years ago |
| Allow foreign keys to reference a superset of unique columns | 3678 | Moved to next CF | 16 | Not processed | | Kaiting Chen (ktchen14) | | | 2 | 2 years ago |
| Parse dates that include CE and BCE | 3682 | Returned with feedback | 16 | Not processed | | David Fetter (dfetter) | | | 1 | 2 years ago |
| Make subquery alias optional in FROM clause | 3714 | Committed | 16 | Not processed | | Dean Rasheed (deanr) | Tom Lane (tgl) | Dean Rasheed (deanr) | 1 | 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 | 1 year ago |
| New argument variation f(filename, missing_ok) of pg_read_file/pg_read_binary_file | 3730 | Committed | | Not processed | | Kyotaro Horiguchi (horiguti) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 2 years ago |
| Support multiple password-based authentication tokens concurrently | 3748 | Moved to next CF | 17 | Not processed | | Joshua Brindle (joshuab) | Gurjeet Singh (gurjeet) | | 2 | 1 year ago |
| SQL Commands |
|---|
| Incremental Materialized View Maintenance | 2138 | Moved to next CF | 16 | Not processed | | Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) | Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) | | 17 | 2 years ago |
| Implement INSERT SET syntax | 2218 | Returned with feedback | | Not processed | | Gareth Palmer (gareth) | Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj) | | 15 | 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 | 6 months ago |
| Allow specifying STORAGE attribute for a new table | 3479 | Committed | 15 | Not processed | | Fedor Sigaev (sigaev), Aleksander Alekseev (aalekseev) | Kyotaro Horiguchi (horiguti), Peter Eisentraut (petere), Wenjing Zeng (wenjing.zwj), Matthias van de Meent (mmeent) | Peter Eisentraut (petere) | 3 | 2 years ago |
| support for MODULE | 3528 | Returned with feedback | 16 | Not processed | | Swaha Miller (swaha) | Nathan Bossart (bossartn) | | 2 | 2 years ago |
| Support for grabbing multiple consecutive values with nextval() | 3577 | Moved to next CF | 15 | Not processed | | Jille Timmermans (quis) | Ronan Dunklau (rdunklau) | | 3 | 2 years ago |
| Summary Sort workers Stats in EXPLAIN ANALYZE | 3601 | Moved to next CF | | Not processed | | Jian Guo (jiang) | | | 2 | 2 years ago |
| Allow makeaclitem() to accept multiple privileges | 3653 | Committed | 16 | Not processed | | Robins Tharakan (robins) | Tom Lane (tgl) | Tom Lane (tgl) | 1 | 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 | 2 months ago |
| Add checks on search_path for IMMUTABLE and SECURITY DEFINER functions | 3684 | Moved to next CF | | Not processed | | Greg Stark (stark) | | | 2 | 2 years ago |
| Make name optional in CREATE STATISTICS | 3708 | Committed | | Not processed | | Simon Riggs (simon) | Matthias van de Meent (mmeent) | Dean Rasheed (deanr) | 1 | 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 |
| New default role allowing to change per-role settings | 2918 | Returned with feedback | | Not processed | | Michael Banck (mbanck) | Stephen Frost (sfrost), Shinya Kato (kato-shinya) | | 8 | 3 years ago |
| add guc: hugepages_active | 3310 | Moved to next CF | | Not processed | | Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda) | Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun) | 7 | 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 | 7 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 | 6 months ago |
| allow specifying action when standby encounters incompatible parameter settings | 3619 | Withdrawn | 16 | Not processed | | Nathan Bossart (bossartn) | | | 1 | 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 |
| allow building trusted languages without the untrusted versions | 3647 | Returned with feedback | 16 | Not processed | | Nathan Bossart (bossartn) | | | 1 | 2 years ago |
| pg_walcleaner - new tool to detect, archive and delete the unneeded wal files | 3667 | Moved to next CF | | Not processed | | Bharath Rupireddy (bharathrupireddy) | | | 2 | 2 years ago |
| pg_upgrade: check for old polymorphics from pre-14 | 3717 | Committed | 14 | Not processed | | Justin Pryzby (justinpryzby) | Andrey Borodin (x4m) | Tom Lane (tgl) | 1 | 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 | Moved to next CF | | Not processed | | Michael Paquier (michael-kun) | Justin Pryzby (justinpryzby), Anton Melnikov (antonmel) | Michael Paquier (michael-kun) | 2 | 2 years ago |
| Add TAP test for auth_delay extension | 3677 | Moved to next CF | | Not processed | | DongWook Lee (dongwooklee) | | | 2 | 2 years ago |
| CI and test improvements | 3709 | Moved to next CF | | Not processed | | Justin Pryzby (justinpryzby) | | | 14 | 6 months ago |
| add test: pg_rowlocks extension | 3724 | Moved to next CF | | 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 | Moved to next CF | | Not processed | | Masahiko Sawada (masahikosawada) | | Amit Kapila (amitkapila) | 2 | 2 years ago |