Status summary: Committed: 122. Moved to next CF: 133. Withdrawn: 14. Rejected: 2. Returned with Feedback: 24. Total: 295.
| Status | Ver | Author | Reviewers | Committer | Num cfs | Latest activity | Latest mail | |
|---|---|---|---|---|---|---|---|---|
| Bug Fixes | ||||||||
| standby recovery fails when re-replaying due to missing directory which was removed in previous replay. | Moved to next CF | stable | Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) | Michael Paquier (michael-kun) | alvherre | 16 | 2022-07-28 06:42 |
2022-08-01 02:01 |
| pg_upgrade fails with non-standard ACL | Moved to next CF | Anastasia Lubennikova (lubennikovaav), Artur Zakirov (a.zakirov) | Grigory Smolkin (g.smolkin.postgrespro.ru) | nmisch | 12 | 2021-11-26 12:46 |
2021-11-26 12:46 |
|
| Corruption during WAL replay | Moved to next CF | stable | Teja Mupparti (tejam) | Robert Haas (rhaas), Daniel Shelepanov (dshelepanov) | rhaas | 10 | 2022-03-24 19:33 |
2022-03-29 17:04 |
| archive status ".ready" files may be created too early | Moved to next CF | stable | Nathan Bossart (bossartn) | Álvaro Herrera (alvherre) | alvherre | 7 | 2021-08-23 20:24 |
2021-09-01 02:15 |
| Problem with RETURNING and update tuple routing | Moved to next CF | Amit Langote (amitlan) | Etsuro Fujita (efujita) | tgl | 6 | 2021-04-22 15:47 |
2021-04-23 01:49 |
|
| DROP relation IF EXISTS Docs and Tests - Bug Fix | Moved to next CF | David Johnston (polobo) | Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com) | 7 | 2021-08-11 14:42 |
2021-08-11 14:41 |
||
| shared tempfile was not removed on statement_timeout | Committed | stable | Thomas Munro (macdice), Justin Pryzby (justinpryzby) | macdice | 4 | 2021-02-15 01:31 |
2021-02-15 01:33 |
|
| Fix collation handling in postgres_fdw | Moved to next CF | Tom Lane (tgl) | Etsuro Fujita (efujita) | 6 | 2021-09-25 14:57 |
2021-10-01 19:37 |
||
| Dumping/restoring fails on inherited generated column | Committed | Masahiko Sawada (masahikosawada) | Peter Eisentraut (petere) | petere | 4 | 2021-02-03 12:04 |
2021-02-05 14:18 |
|
| Fix checksum verification in base backups for zero page headers | Moved to next CF | Michael Banck (mbanck) | Anastasia Lubennikova (lubennikovaav), David Steele (dsteele) | 6 | 2021-09-13 11:45 |
2021-09-13 11:45 |
||
| pgbench stopped supporting large number of client connections on Windows | Returned with feedback | Marina Polyakova (whipping.top1991) | 2 | 2021-04-08 14:25 |
2021-03-29 14:32 |
|||
| brin: avoid errors processing work item following concurrent reindex | Moved to next CF | stable | Álvaro Herrera (alvherre), Justin Pryzby (justinpryzby) | Gurjeet Singh (gurjeet) | 5 | 2021-12-02 10:59 |
2021-12-02 10:59 |
|
| orphaned function | Returned with feedback | stable | Bertrand Drouvot (bdrouvot) | Gilles Darold (darold) | 2 | 2021-04-08 14:55 |
2021-04-08 14:55 |
|
| Fixes for phrase search with multi-lexeme tokens | Committed | 14 | Alexander Korotkov (smagen) | Ze Chen (carpenter.nail.cz.gmail.com) | smagen | 2 | 2021-02-01 12:11 |
2021-01-29 13:51 |
| ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently | Withdrawn | Takayuki Tsunakawa (maumau) | Bharath Rupireddy (bharathrupireddy) | 2 | 2021-04-07 00:20 |
2021-04-02 05:25 |
||
| Protect archive recovery from missing data | Committed | Takamichi Osumi (tatatappp) | Fujii Masao (masaofujii), Laurenz Albe (laurenz), David Steele (dsteele), Rajesh Kumar (rajeshmonk2509) | masaofujii | 2 | 2021-04-06 14:02 |
2021-04-07 05:22 |
|
| Fix firing of RI triggers during cross-partition updates of partitioned tables | Moved to next CF | Amit Langote (amitlan) | Masahiko Sawada (masahikosawada) | alvherre | 7 | 2022-03-20 17:58 |
2022-03-22 01:18 |
|
| has_column_privilege() issue with attnums and non-existent columns | Committed | stable | Ian Barwick (barwick) | Joe Conway (jconway), Chengxi Sun (martin-sun) | jconway | 1 | 2021-03-31 17:57 |
2021-03-31 17:56 |
| invalid data in file backup_label problem on windows | Withdrawn | Shenhao Wang (wangshenhao) | 1 | 2021-04-06 05:31 |
2021-04-02 18:09 |
|||
| Pg14, pg_dumpall and "password_encryption=true" | Withdrawn | 14 | Ian Barwick (barwick) | 1 | 2021-03-04 01:27 |
2021-03-03 17:17 |
||
| Error reporting for multi-line JSON | Committed | stable | Simon Riggs (simon), Hamid Akhtar (hamidakhtar) | Daniel Gustafsson (d_gustafsson) | tgl | 1 | 2021-03-01 21:44 |
2021-03-01 21:50 |
| System catalog accesses in error context callback | Moved to next CF | Masahiko Sawada (masahikosawada), Bharath Rupireddy (bharathrupireddy) | Tom Lane (tgl) | tgl | 2 | 2021-07-06 17:03 |
2021-07-06 16:37 |
|
| Fix DROP TABLESPACE on Windows with ProcSignalBarrier? | Moved to next CF | Thomas Munro (macdice) | Daniel Gustafsson (d_gustafsson) | macdice | 6 | 2022-02-11 23:27 |
2022-02-11 21:22 |
|
| Fix faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination | Committed | Julien Rouhaud (rjuju) | Dilip Kumar (dilip.kumar), Mahendra Singh Thalor (mahithalor) | alvherre | 1 | 2021-02-24 09:09 |
2021-02-23 20:47 |
|
| parse mistake in ecpg connect string | Committed | Kyotaro Horiguchi (horiguti) | Tom Lane (tgl), Hayato Kuroda (ha-kun), Shenhao Wang (wangshenhao) | tgl | 1 | 2021-02-12 02:22 |
2021-02-12 04:09 |
|
| Set default transactions to read-only at servers start in pg_upgrade | Moved to next CF | Denis Laxalde (dlax) | Julien Rouhaud (rjuju) | 4 | 2021-12-01 14:22 |
2022-03-14 21:12 |
||
| Fix detection of preadv/pwritev support for OSX. | Moved to next CF | James Hilliard (jameshilliard) | Cleysson Lima (cleyssonlima) | tgl | 2 | 2021-07-12 23:18 |
2021-07-12 22:03 |
|
| 64-bit XIDs in deleted nbtree pages | Committed | Peter Geoghegan (pgeoghegan) | Masahiko Sawada (masahikosawada) | pgeoghegan | 1 | 2021-03-21 22:28 |
2021-03-25 07:03 |
|
| Autovacuum dynamic cost_limit, cost_delay | Moved to next CF | Scott Mead (meads-amazon) | Masahiko Sawada (masahikosawada) | 3 | 2021-10-01 06:50 |
2021-05-26 08:00 |
||
| segfault with after trigger during delete or update | Committed | stable | Amit Langote (amitlan), Bertrand Drouvot (bdrouvot) | Amit Langote (amitlan) | alvherre | 1 | 2021-02-27 21:14 |
2021-03-04 07:17 |
| fix skipping FSM for large tuples and low fillfactors | Committed | 14 | John Naylor (john.naylor), Floris van Nee (fvannee) | Matthias van de Meent (mmeent) | nmisch | 1 | 2021-03-31 02:30 |
2021-03-27 20:32 |
| add DETAIL for wrong SCRAM password | Returned with feedback | Jeff Janes (jjanes) | Jacob Champion (jchampion) | 1 | 2021-04-08 10:58 |
2021-04-08 10:59 |
||
| Clients | ||||||||
| New libpq option to prefer standby for connection | Committed | Haribabu Kommi (haribabu), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) | Laurenz Albe (laurenz), Takayuki Tsunakawa (maumau), Peter Smith (smithpb) | tgl | 15 | 2021-03-03 01:18 |
2021-03-03 18:54 |
|
| pgbench - add pseudo-random permutation function | Committed | Fabien Coelho (calvin), Hironobu Suzuki (suzuki_hironobu) | Muhammad Usama (muhammad_usama) | deanr | 14 | 2021-04-06 12:34 |
2021-04-06 21:31 |
|
| psql - add SHOW_ALL_RESULTS option | Moved to next CF | Fabien Coelho (calvin) | Peter Eisentraut (petere) | petere | 13 | 2022-04-04 21:33 |
2022-04-06 17:05 |
|
| ECPG new statement: DECLARE STATEMENT | Committed | Hayato Kuroda (ha-kun) | Shawn Wang (shawnwang) | meskes | 8 | 2021-03-25 00:15 |
2021-01-27 09:18 |
|
| psql - possibility to specify where status row should be displayed | Rejected | Pavel Stehule (okbobcz) | 5 | 2021-04-08 14:47 |
2021-03-03 17:47 |
|||
| allow to set a pager for psql's watch command | Moved to next CF | Pavel Stehule (okbobcz) | Thomas Munro (macdice) | macdice | 6 | 2021-07-14 00:48 |
2021-07-13 18:05 |
|
| pgbench - add a synchronization barrier when starting | Committed | Fabien Coelho (calvin), Thomas Munro (macdice) | Marina Polyakova (whipping.top1991), Hayato Kuroda (ha-kun) | macdice | 5 | 2021-03-10 05:06 |
2021-03-13 11:09 |
|
| pg_dump - read data for some options from external file | Moved to next CF | Pavel Stehule (okbobcz) | Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju), Justin Pryzby (justinpryzby), Виктория Шепард (shepard-v) | d_gustafsson | 18 | 2023-11-29 14:44 |
2023-11-30 15:45 |
|
| libpq compression | Moved to next CF | 15 | Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) | Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag) | 6 | 2021-12-03 07:31 |
2021-12-03 07:31 |
|
| psql \df choose functions by their arguments | Committed | 14 | Greg Sabino Mullane (greg) | Ian Barwick (barwick), Hou Zhijie (houzj) | tgl | 3 | 2021-04-08 03:02 |
2021-04-08 02:00 |
| Improve \e, \ef and \ev if the editor is quit | Committed | 14 | Laurenz Albe (laurenz) | Jacob Champion (jchampion) | tgl | 2 | 2021-04-03 21:38 |
2021-04-06 09:17 |
| libpq trace log | Committed | 14 | Aya Iwata (iwata.aya) | Takayuki Tsunakawa (maumau), Kirk Jamison (kirkjamison) | alvherre | 2 | 2021-03-30 23:56 |
2021-04-02 23:07 |
| Support tab completion for upper character inputs in psql | Moved to next CF | Haiying Tang (tanghy) | Tom Lane (tgl), Peter Eisentraut (petere) | tgl | 5 | 2022-01-30 18:33 |
2022-02-04 23:41 |
|
| Feature improvement for TRUNCATE tab completion | Committed | Kota Miyake (ekayim) | Muhammad Usama (muhammad_usama) | masaofujii | 1 | 2021-02-25 13:18 |
2021-02-25 09:22 |
|
| Refactor ECPGconnect() and allow IPv6 connection | Moved to next CF | Hayato Kuroda (ha-kun) | 3 | 2021-10-01 07:14 |
2021-08-07 20:36 |
|||
| pgbench: Bug fix for the -d option | Committed | Kota Miyake (ekayim) | michael-kun | 1 | 2021-03-06 23:44 |
2021-03-06 23:45 |
||
| Add --tablespace option to reindexdb | Committed | 14 | Michael Paquier (michael-kun) | Daniel Gustafsson (d_gustafsson), Mark Dilger (mark.dilger) | michael-kun | 1 | 2021-03-03 02:12 |
2021-03-03 01:49 |
| pgbench: Remove ecnt, a member variable of CState | Committed | Kota Miyake (ekayim) | michael-kun | 1 | 2021-03-01 02:05 |
2021-03-01 02:32 |
||
| Code Comments | ||||||||
| Fix code comment typo | Committed | Peter Smith (smithpb2250) | amitkapila | 1 | 2021-01-05 11:18 |
2021-01-05 03:06 |
||
| Fix typo about WalSndPrepareWrite | Withdrawn | Japin Li (japin) | 1 | 2021-02-18 02:55 |
2021-02-18 02:55 |
|||
| Extend comments on signal handling and cross-reference comments on signal handling functions | Moved to next CF | Craig Ringer (ringerc) | Mark Dilger (mark.dilger) | 3 | 2021-09-27 12:21 |
2021-09-27 12:21 |
||
| Documentation | ||||||||
| Additional Chapter "Architecture" for Part "Tutorial" | Returned with feedback | Jürgen Purtz (juergen@purtz.de) | Peter Eisentraut (petere), David Johnston (polobo), Joshua Drake (linuxpoet) | 5 | 2021-04-07 12:59 |
2021-04-05 15:48 |
||
| Prefer explicit JOIN syntax over (old) implicit syntax in tutorial | Committed | Jürgen Purtz (juergen@purtz.de) | Peter Eisentraut (petere), David Johnston (polobo) | petere | 4 | 2021-04-08 08:58 |
2021-04-08 09:00 |
|
| Further note require activity aspect of automatic checkpoint and archiving | Moved to next CF | David Johnston (polobo) | 6 | 2021-11-04 09:36 |
2021-11-04 09:36 |
|||
| Introduce view updating options more succinctly | Committed | David Johnston (polobo) | mha | 3 | 2021-03-06 16:39 |
2021-03-06 16:40 |
||
| Minor variable related cleanup and rewording of plpgsql docs | Committed | David Johnston (polobo) | Pavel Stehule (okbobcz), David Steele (dsteele) | tgl | 3 | 2021-03-17 17:09 |
2021-03-17 17:11 |
|
| doc review for v14 | Committed | 14 | Justin Pryzby (justinpryzby) | michael-kun | 2 | 2021-03-08 10:29 |
2021-03-02 01:57 |
|
| document the hook system | Returned with feedback | 14 | David Fetter (dfetter) | 2 | 2021-03-10 14:39 |
2021-03-10 16:48 |
||
| Clarify that CREATEROLE roles can GRANT default roles | Committed | Michael Banck (mbanck) | Robert Treat (xzilla) | mha | 2 | 2021-03-06 17:13 |
2021-03-06 22:08 |
|
| Extend docs on how to write correct postgres-dialect C including extensions and bgworkers | Moved to next CF | Craig Ringer (ringerc) | Laurenz Albe (laurenz) | 4 | 2021-11-04 10:55 |
2021-11-04 10:55 |
||
| [DOC] add missing "[ NO ]" to various "DEPENDS ON" synopses | Committed | stable | Ian Barwick (barwick) | michael-kun | 1 | 2021-02-13 07:07 |
2021-02-17 03:00 |
|
| documentation fix for SET ROLE | Committed | stable | Nathan Bossart (bossartn) | Laurenz Albe (laurenz), Joe Conway (jconway), Gerdan Santos (gerdan) | jconway | 1 | 2021-04-02 17:52 |
2021-04-02 18:01 |
| archive_command / pg_stat_archiver & documentation | Committed | 14 | Benoit Lobréau (benoitl) | Julien Rouhaud (rjuju) | michael-kun | 1 | 2021-03-04 02:21 |
2021-03-04 02:21 |
| Miscellaneous | ||||||||
| parse-time support function for "any" datatype | Withdrawn | Pavel Stehule (okbobcz) | 10 | 2021-03-09 05:31 |
2021-03-03 17:25 |
|||
| unicode unescape function | Committed | Pavel Stehule (okbobcz) | Asif Rehman (asifrana) | petere | 5 | 2021-03-29 10:16 |
2021-03-29 10:22 |
|
| Add table expansion hook | Moved to next CF | Erik Nordström (enordstr) | Euler Taveira (eulerto), Aleksander Alekseev (aalekseev) | 7 | 2021-09-13 14:16 |
2021-09-09 18:26 |
||
| PATCH: Attempt to make dbsize a bit more consistent | Returned with feedback | Georgios Kokolatos (gkokolatos) | Daniel Gustafsson (d_gustafsson), David Zhang (david.z), Soumyadeep Chakraborty (soumyadeepc) | 4 | 2021-04-08 08:16 |
2021-04-08 08:04 |
||
| Allow CRL "directory" for crl_file | Committed | Kyotaro Horiguchi (horiguti) | Peter Eisentraut (petere) | petere | 4 | 2021-02-18 07:55 |
2021-02-18 08:06 |
|
| Fix behavior of geo_ops when NaN is involved | Moved to next CF | Kyotaro Horiguchi (horiguti) | Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) | 10 | 2022-08-01 20:29 |
2021-12-15 08:31 |
||
| Reloptions for table access methods | Withdrawn | Jeff Davis (jdavis) | Georgios Kokolatos (gkokolatos) | 4 | 2021-04-06 20:41 |
2021-03-18 14:37 |
||
| (ALTER SYSTEM) SET +=/-= operator support | Returned with feedback | 14 | Abhijit Menon-Sen (ams) | Ibrar Ahmed (ibrar) | 3 | 2021-03-12 17:31 |
2021-03-10 14:24 |
|
| Improve replay pause | Committed | Dilip Kumar (dilip.kumar) | Kyotaro Horiguchi (horiguti), Yugo Nagata (yugo.nagata), Bharath Rupireddy (bharathrupireddy) | rhaas | 3 | 2021-03-11 20:34 |
2021-03-12 00:51 |
|
| Reduce the number of special cases to build contrib modules on windows | Moved to next CF | David Rowley (davidrowley) | davidrowley | 5 | 2021-08-09 07:46 |
2021-08-09 07:55 |
||
| Functions for sorting GiST build of gist_btree types | Moved to next CF | Andrey Borodin (x4m) | Heikki Linnakangas (heikki), Emre Hasegeli (hasegeli) | heikki | 7 | 2022-04-08 15:16 |
2021-12-16 09:18 |
|
| move pg_upgrade test.sh kludges to a SQL script | Moved to next CF | Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun) | michael-kun | 6 | 2021-12-02 01:37 |
2021-12-02 01:49 |
|
| WIP: macOS SIP workaround | Returned with feedback | Peter Eisentraut (petere) | 2 | 2021-03-08 09:20 |
2021-03-08 09:20 |
|||
| Function to log backtrace of postgres processes | Moved to next CF | vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) | Christoph Berg (myon), Maciek Sakrejda (msakrejda) | 17 | 2024-04-01 03:32 |
2024-02-27 02:46 |
||
| Refactoring HMAC in the core code | Committed | 14 | Michael Paquier (michael-kun) | michael-kun | 2 | 2021-04-03 09:54 |
2021-04-03 10:02 |
|
| install path aware subclass of PostgresNode | Committed | 14 | Andrew Dunstan (adunstan) | Daniel Gustafsson (d_gustafsson) | adunstan | 2 | 2021-03-24 23:08 |
2021-03-29 02:04 |
| Move regression tablespace cleanup from makefiles pg_regress? (Occasional tablespace.sql failures in check-world -jnn) | Committed | 14 | Michael Paquier (michael-kun) | Peter Eisentraut (petere) | michael-kun | 2 | 2021-03-10 06:48 |
2021-03-10 20:17 |
| New IndexAM API controlling index vacuum strategies | Committed | Masahiko Sawada (masahikosawada) | Peter Geoghegan (pgeoghegan), Matthias van de Meent (mmeent) | pgeoghegan | 2 | 2021-04-07 23:16 |
2021-04-08 02:42 |
|
| Add OID allocation retry log to GetNewOidWithIndex() | Committed | 14 | tomohiro hiramitsu (hiramit) | Kasahara Tatsuhito (kasahara) | masaofujii | 2 | 2021-03-24 01:42 |
2021-03-24 02:31 |
| Adjust default wal_sync_method on FreeBSD | Committed | Thomas Munro (macdice) | macdice | 1 | 2021-02-15 03:28 |
2021-02-15 03:28 |
||
| some pointless HeapTupleHeaderIndicatesMovedPartitions calls | Committed | Álvaro Herrera (alvherre) | Michael Paquier (michael-kun), Anastasia Lubennikova (lubennikovaav) | alvherre | 1 | 2021-02-22 22:05 |
2021-03-25 18:52 |
|
| postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition) | Committed | 14 | Matthias van de Meent (mmeent) | Bernd Helmle (psoo) | masaofujii | 1 | 2021-04-06 17:36 |
2021-04-06 17:35 |
| Introduce ProcessInterrupts_hook for C extensions | Moved to next CF | Craig Ringer (ringerc) | 3 | 2021-10-06 13:11 |
2021-10-01 17:24 |
|||
| Record the system catalogs' FK relationships explicitly | Committed | Tom Lane (tgl) | Joel Jacobson (joeljacobson) | tgl | 1 | 2021-02-02 22:13 |
2021-02-04 02:37 |
|
| remove deprecated v8.2 containment operators | Committed | 14 | Justin Pryzby (justinpryzby) | Tom Lane (tgl) | tgl | 1 | 2021-03-05 15:46 |
2021-03-05 16:01 |
| Log authenticated identity from all auth methods | Committed | Jacob Champion (jchampion) | Magnus Hagander (mha) | michael-kun | 1 | 2021-04-07 02:56 |
2021-04-07 01:20 |
|
| Report text parameter values in errors during typinput | Committed | 14 | Justin Pryzby (justinpryzby) | Tom Lane (tgl) | tgl | 1 | 2021-03-16 15:17 |
2021-03-16 15:18 |
| pg_upgrade binary version checks | Committed | Daniel Gustafsson (d_gustafsson) | Peter Eisentraut (petere) | petere | 1 | 2021-03-03 08:58 |
2021-03-03 09:04 |
|
| Remove authtype environment variable | Committed | Daniel Gustafsson (d_gustafsson) | Peter Eisentraut (petere) | petere | 1 | 2021-03-09 14:51 |
2021-03-09 14:51 |
|
| Regex backref fixes | Committed | Tom Lane (tgl) | Joel Jacobson (joeljacobson) | tgl | 1 | 2021-03-02 17:15 |
2021-03-01 20:22 |
|
| Detect dropped connections while running queries | Committed | Thomas Munro (macdice), Sergey Cherkashin (cherkashins) | Takayuki Tsunakawa (maumau) | macdice | 1 | 2021-04-04 21:51 |
2022-02-14 04:15 |
|
| postgres_fdw: suppress explicit casts in text:text comparisons | Moved to next CF | Dian Fay (dmfay) | Tom Lane (tgl), Georgios Kokolatos (gkokolatos) | tgl | 4 | 2021-11-12 16:54 |
2021-11-12 16:54 |
|
| Monitoring & Control | ||||||||
| Shared-memory based stats collector | Moved to next CF | Kyotaro Horiguchi (horiguti) | Tomas Vondra (fuzzycz), Antonin Houska (a.houska) | 17 | 2021-10-01 17:20 |
2022-04-08 04:44 |
||
| Expose queryid in pg_stat_activity and log_line_prefix | Committed | Julien Rouhaud (rjuju) | atsushi torikoshi (atorik), Evgeny Efimkin (efimkine), Nitin Jadhav (nitinjadhav11) | bmomjian | 10 | 2021-04-08 08:34 |
2021-04-08 15:17 |
|
| Get memory contexts of an arbitrary backend process | Committed | 14 | Atsushi Torikoshi (atsushitorikoshi) | Fujii Masao (masaofujii), Kasahara Tatsuhito (kasahara), Shawn Wang (shawnwang) | masaofujii | 4 | 2021-04-06 05:12 |
2021-04-06 04:46 |
| Add information about generic/custom plan to pg_stat_statements | Withdrawn | 14 | Atsushi Torikoshi (atsushitorikoshi) | Fujii Masao (masaofujii), Tatsuro Yamada (tatsuro_yamada), PAscal L (pascall), Chengxi Sun (martin-sun) | 4 | 2021-04-05 04:27 |
2021-04-05 09:01 |
|
| Add extra statistics to explain for Nested Loop | Moved to next CF | Justin Pryzby (justinpryzby), Ekaterina Sokolova (e.sokolova) | Julien Rouhaud (rjuju), Greg Stark (stark), Lukas Fittl (lfittl), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) | 10 | 2022-10-12 06:05 |
2022-07-31 03:49 |
||
| Use posix fadvise to speed up analyze + improve automatic analyze with "avg read rate" log message | Committed | 14 | Stephen Frost (sfrost), Jakub Wartak (jakub.wartak.tomtom) | Heikki Linnakangas (heikki), Tomas Vondra (fuzzycz) | sfrost | 3 | 2021-03-16 19:38 |
2021-03-16 19:19 |
| pg_stat_statements and "IN" conditions | Moved to next CF | Dmitry Dolgov (erthalion) | Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun) | 21 | 2024-12-04 10:23 |
2024-12-03 15:58 |
||
| About to add WAL write/fsync statistics to pg_stat_wal view | Committed | 14 | Masahiro Ikeda (masahiro.ikeda) | masaofujii | 2 | 2021-04-06 11:34 |
2021-03-25 13:06 |
|
| Add wait_start column to pg_locks | Committed | 14 | Atsushi Torikoshi (atsushitorikoshi) | Ian Barwick (barwick) | masaofujii | 2 | 2021-02-09 09:14 |
2021-02-22 09:27 |
| Add is_toplevel flag in pg_stat_statements | Committed | Julien Rouhaud (rjuju) | Magnus Hagander (mha), Masahiro Ikeda (masahiro.ikeda) | mha | 2 | 2021-04-08 08:31 |
2021-04-08 14:54 |
|
| Report tranche ID and LWLock pointer in LWLock static tracepoints | Returned with feedback | Craig Ringer (ringerc) | Peter Eisentraut (petere) | 1 | 2021-04-07 12:04 |
2021-03-22 09:00 |
||
| Improve amcheck to check UNIQUE constraint in btree index | Returned with feedback | Anastasia Lubennikova (lubennikovaav), Pavel Borisov (pborisov) | Mark Dilger (mark.dilger) | 1 | 2021-04-08 14:36 |
2024-07-26 20:53 |
||
| Improvements and additions to COPY progress reporting | Committed | 14 | Matthias van de Meent (mmeent) | Josef Šimánek (retro), Bharath Rupireddy (bharathrupireddy) | michael-kun | 1 | 2021-03-16 01:35 |
2021-03-16 01:00 |
| progress reporting for partitioned REINDEX | Committed | Justin Pryzby (justinpryzby) | michael-kun | 1 | 2021-03-02 10:31 |
2021-02-20 02:40 |
||
| Track wal_level drop for backup management | Moved to next CF | Takamichi Osumi (tatatappp) | 3 | 2021-10-01 07:44 |
2021-07-14 11:58 |
|||
| Performance | ||||||||
| Protect syscache from bloating with negative cache entries | Moved to next CF | Kyotaro Horiguchi (horiguti) | Heikki Linnakangas (heikki), Jim Nasby (decibel), Takayuki Tsunakawa (maumau), Takeshi Ideriha (ideriha) | 23 | 2021-10-05 16:21 |
2021-03-24 05:26 |
||
| GROUP BY optimization | Moved to next CF | 15 | Fedor Sigaev (sigaev), Pavel Borisov (pborisov) | Tomas Vondra (fuzzycz) | fuzzycz | 12 | 2022-03-30 23:19 |
2024-01-26 15:41 |
| Remove self join on a unique column | Moved to next CF | Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrei Lepikhov (lepikhov) | Alena Rybakina (a.rybakina) | smagen | 27 | 2023-10-25 10:02 |
2025-01-10 03:13 |
|
| Using multicolumn statistics for more precise join selectivity estimatation | Moved to next CF | Konstantin Knizhnik (knizhnik) | Yugo Nagata (yugo.nagata) | 9 | 2021-10-01 07:13 |
2021-11-04 09:56 |
||
| Erase the distinctClause if the result is unique by definition | Moved to next CF | Andy Fan (andyf) | David Rowley (davidrowley), Dmitry Dolgov (erthalion), Ashutosh Bapat (ashutoshbapat), Hou Zhijie (houzj) | 11 | 2022-04-05 03:43 |
2022-03-31 20:33 |
||
| Asynchronous Append on postgres_fdw nodes. | Committed | 14 | Kyotaro Horiguchi (horiguti) | Andrei Lepikhov (lepikhov), movead li (movead.li), Muhammad Usama (muhammad_usama) | efujita | 6 | 2021-03-31 09:59 |
2021-04-06 10:25 |
| BRIN multi-minmax and bloom indexes | Committed | Tomas Vondra (fuzzycz) | John Naylor (john.naylor) | fuzzycz | 5 | 2021-03-26 13:09 |
2021-03-27 20:42 |
|
| Binary search in ScalarArrayOpExpr for OR'd constant arrays | Committed | David Rowley (davidrowley), James Coleman (jcole1989) | Heikki Linnakangas (heikki), David Rowley (davidrowley), Tomas Vondra (fuzzycz) | davidrowley | 3 | 2021-04-08 17:03 |
2020-09-11 21:11 |
|
| INSERT SELECT: BulkInsertState and table_multi_insert | Moved to next CF | 15 | Justin Pryzby (justinpryzby) | 8 | 2021-11-24 00:32 |
2021-11-04 12:24 |
||
| Hybrid Hash/Nested Loop joins and caching results from subplans | Committed | 14 | David Rowley (davidrowley) | Andy Fan (andyf) | davidrowley | 5 | 2021-04-02 22:21 |
2021-04-02 01:15 |
| Overhaul UPDATE/DELETE processing | Committed | Amit Langote (amitlan) | Tom Lane (tgl) | tgl | 5 | 2021-03-31 16:01 |
2021-04-02 07:41 |
|
| Fast COPY FROM command for the foreign tables | Moved to next CF | Andrei Lepikhov (lepikhov) | Etsuro Fujita (efujita), Ian Barwick (barwick), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) | efujita | 13 | 2022-10-31 08:40 |
2022-10-31 08:50 |
|
| Support parallelism for copy command | Withdrawn | vigneshwaran C (vignesh.postgres), Bharath Rupireddy (bharathrupireddy) | Amit Kapila (amitkapila), Greg Nancarrow (gregn1234), Hou Zhijie (houzj) | amitkapila | 5 | 2021-03-01 05:40 |
2020-12-28 09:44 |
|
| More scalable multixacts buffers and locking | Moved to next CF | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | alvherre | 20 | 2024-04-07 12:52 |
2024-04-07 19:13 |
||
| Covering SPGiST index | Committed | Pavel Borisov (pborisov) | Andrey Borodin (x4m) | tgl | 4 | 2021-04-05 22:42 |
2021-04-06 11:09 |
|
| Optimizing NULL check on pkey column | Moved to next CF | Surafel Temesgen (surafel) | Ashutosh Bapat (ashutoshbapat) | 6 | 2021-09-27 00:52 |
2021-09-27 00:52 |
||
| Boundary value check in lazy_tid_reaped() | Committed | Masahiko Sawada (masahikosawada) | Peter Eisentraut (petere) | petere | 4 | 2021-03-10 14:52 |
2021-03-16 21:59 |
|
| fix spinlock contention in LogwrtResult | Moved to next CF | Álvaro Herrera (alvherre) | 11 | 2022-09-23 08:50 |
2024-04-08 16:13 |
|||
| Pipelining/batch mode support for libpq | Committed | Álvaro Herrera (alvherre), Craig Ringer (ringerc), Matthieu Garrigues (matt-42) | Justin Pryzby (justinpryzby) | alvherre | 4 | 2021-03-15 21:35 |
2021-03-18 11:28 |
|
| Reduce PostmasterIsAlive() checks during recovery | Committed | Thomas Munro (macdice) | macdice | 3 | 2021-03-12 06:56 |
2021-07-12 12:18 |
||
| parallel distinct union and aggregate support patch | Moved to next CF | bucoo hsiao (bucoo) | 6 | 2021-11-08 22:19 |
2021-11-08 22:19 |
|||
| Replace polyphase merge with a simple k-way balanced merge | Moved to next CF | Heikki Linnakangas (heikki) | John Naylor (john.naylor) | heikki | 6 | 2021-10-18 12:15 |
2021-10-18 12:15 |
|
| allow partial union-all and improve parallel subquery costing | Returned with feedback | Luc Vlaming (luc.vlaming) | 3 | 2021-04-08 14:46 |
2021-12-02 14:10 |
|||
| New wal_level to disable WAL logging | Moved to next CF | Takamichi Osumi (tatatappp) | Takayuki Tsunakawa (maumau) | 4 | 2021-07-05 02:23 |
2021-07-05 13:57 |
||
| Make Append Cost aware of some run time partition prune case | Moved to next CF | Andy Fan (andyf) | 5 | 2021-11-04 10:10 |
2021-11-04 10:10 |
|||
| Add nullif case for eval_const_expressions | Committed | Hou Zhijie (houzj) | Peter Eisentraut (petere) | petere | 2 | 2021-04-02 09:08 |
2021-04-02 09:08 |
|
| Parallel Inserts in CREATE TABLE AS | Withdrawn | Bharath Rupireddy (bharathrupireddy) | vigneshwaran C (vignesh.postgres), Hou Zhijie (houzj), Luc Vlaming (luc.vlaming) | 2 | 2021-03-20 04:28 |
2021-03-19 12:19 |
||
| Parallel INSERT (INTO ... SELECT ...) | Returned with feedback | 14 | Greg Nancarrow (gregn1234) | Antonin Houska (a.houska), Takayuki Tsunakawa (maumau), vigneshwaran C (vignesh.postgres), Haiying Tang (tanghy), Hou Zhijie (houzj) | amitkapila | 2 | 2021-04-01 04:23 |
2021-04-01 04:26 |
| Consider parallel for LATERAL subqueries having LIMIT/OFFSET | Moved to next CF | James Coleman (jcole1989) | Greg Nancarrow (gregn1234) | 11 | 2023-03-23 18:43 |
2023-03-23 18:42 |
||
| Consider Parallelism While Planning For REFRESH MATERIALIZED VIEW | Committed | Bharath Rupireddy (bharathrupireddy) | Hou Zhijie (houzj), Luc Vlaming (luc.vlaming) | macdice | 2 | 2021-03-17 02:12 |
2021-03-17 02:08 |
|
| Update the default of checkpoint_completion_target to 0.9 | Committed | 14 | Stephen Frost (sfrost) | David Steele (dsteele) | sfrost | 2 | 2021-03-24 17:10 |
2021-03-24 17:09 |
| Perform COPY FROM encoding conversions in larger chunks | Committed | Heikki Linnakangas (heikki) | John Naylor (john.naylor) | heikki | 2 | 2021-04-01 11:56 |
2021-04-01 09:27 |
|
| Faster pglz compression | Moved to next CF | Andrey Borodin (x4m), Владимир Лесков (tinsane) | Mark Dilger (mark.dilger) | fuzzycz | 12 | 2023-02-28 18:55 |
2023-02-14 00:09 |
|
| Parallel Hash Full Join | Moved to next CF | 16 | Melanie Plageman (melanieplageman) | Thomas Munro (macdice) | macdice | 12 | 2023-03-30 23:01 |
2023-04-09 23:33 |
| Make popcount available to SQL | Committed | David Fetter (dfetter) | Peter Eisentraut (petere) | petere | 2 | 2021-03-23 09:51 |
2021-03-24 23:58 |
|
| Tid scan improvements | Committed | David Rowley (davidrowley), Edmund Horner (ejrh) | davidrowley | 2 | 2021-02-27 10:07 |
2021-02-27 10:05 |
||
| Fix memory bloat caused by foreign key checking involving partitions | Committed | Amit Langote (amitlan), keisuke kuroda (keisuke.kuroda.3862) | Amit Langote (amitlan) | tgl | 1 | 2021-03-10 19:23 |
2021-03-12 03:35 |
|
| WIP: Track relation size in shared memory | Moved to next CF | Thomas Munro (macdice) | 3 | 2021-10-01 07:21 |
2021-07-14 12:38 |
|||
| Reduce vacuum_cost_page_miss GUC's default to account for modern storage characteristics | Committed | Peter Geoghegan (pgeoghegan) | pgeoghegan | 1 | 2021-01-28 01:46 |
2021-01-28 17:57 |
||
| increase size of pg_commit_ts buffers | Moved to next CF | Álvaro Herrera (alvherre) | Noah Misch (nmisch) | alvherre | 4 | 2021-11-30 20:20 |
2021-12-01 15:57 |
|
| Full support for index LP_DEAD hint bits on standby | Moved to next CF | Michail Nikolaev (nkey) | Antonin Houska (a.houska) | 6 | 2022-04-07 22:00 |
2022-03-31 23:58 |
||
| Simplify some RI checks to reduce SPI overhead | Moved to next CF | Amit Langote (amitlan) | Tom Lane (tgl), Corey Huinker (coreyh) | alvherre | 6 | 2022-04-09 16:59 |
2022-04-07 01:05 |
|
| Extend more usecase for planning time partition pruning and init partition pruning. | Withdrawn | 14 | 1 | 2021-02-19 09:45 |
2021-03-27 06:19 |
|||
| Adaptive query optimization: create extented statistics using auto_explain extension | Moved to next CF | Konstantin Knizhnik (knizhnik) | 4 | 2021-11-04 09:56 |
2021-11-04 09:56 |
|||
| Improve join selectivity estimation using extended statistics | Moved to next CF | Konstantin Knizhnik (knizhnik) | 3 | 2021-10-01 10:14 |
2021-10-01 10:13 |
|||
| In psql \copy from, send data to server in larger chunks | Moved to next CF | Heikki Linnakangas (heikki) | Aleksander Alekseev (aalekseev) | heikki | 2 | 2021-07-14 10:12 |
2021-07-14 10:11 |
|
| Extend more usecase for planning time partition pruning and init partition pruning. | Returned with feedback | 1 | 2021-03-27 06:30 |
2021-03-27 06:19 |
||||
| partial heap only tuples | Moved to next CF | 15 | Nathan Bossart (bossartn) | 4 | 2021-11-04 10:23 |
2021-11-10 17:17 |
||
| Some regular-expression performance hacking | Committed | Tom Lane (tgl) | Joel Jacobson (joeljacobson) | tgl | 1 | 2021-02-21 00:38 |
2021-03-06 18:09 |
|
| Allow setting parallel_workers on partitioned tables | Moved to next CF | Seamus Abshere (seamusabshere) | Amit Langote (amitlan), Laurenz Albe (laurenz), Hou Zhijie (houzj) | 3 | 2021-09-04 06:14 |
2021-09-04 06:14 |
||
| speed up pg_rewind by using copy_file_range() and skipping some fsync | Moved to next CF | Paul Guo (paulguo-vmware) | Michael Paquier (michael-kun) | 3 | 2021-10-01 06:55 |
2021-08-20 05:23 |
||
| Freeze the inserted tuples during CTAS | Withdrawn | Paul Guo (paulguo-vmware) | Masahiko Sawada (masahikosawada) | 1 | 2021-03-12 05:37 |
2021-03-15 14:33 |
||
| Speed up verifying UTF-8 | Moved to next CF | John Naylor (john.naylor) | Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan) | john.naylor | 5 | 2021-12-20 14:26 |
2021-12-20 14:24 |
|
| wal_compression = pglz/zlib/lz4/zstd | Moved to next CF | 15 | Andrey Borodin (x4m), Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun), Justin Pryzby (justinpryzby) | michael-kun | 2 | 2021-06-29 02:30 |
2021-06-29 06:43 |
| Speeding up GIST index builds using popcount | Moved to next CF | Amit Khandekar (amitdkhan) | John Naylor (john.naylor) | 3 | 2021-10-01 07:19 |
2021-08-02 10:26 |
||
| Procedural Languages | ||||||||
| declarative session variables, LET command | Moved to next CF | 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) | 34 | 2024-12-11 06:58 |
2025-01-17 21:54 |
||
| UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR | Moved to next CF | John Dent (denty) | Daniel Vérité (danielverite) | 9 | 2021-10-01 10:20 |
2021-10-01 10:20 |
||
| enhancing plpgsql API for debugging and tracing | Moved to next CF | Pavel Stehule (okbobcz) | Aleksander Alekseev (aalekseev) | tgl | 9 | 2022-03-31 21:06 |
2022-04-01 04:51 |
|
| possibility to rename root namespace in plpgsql | Moved to next CF | Pavel Stehule (okbobcz) | Julien Rouhaud (rjuju) | 7 | 2022-03-07 05:49 |
2022-03-07 05:48 |
||
| Refactoring | ||||||||
| Remove page-read callback from XLogReaderState | Moved to next CF | Kyotaro Horiguchi (horiguti) | Heikki Linnakangas (heikki), Antonin Houska (a.houska), Takashi Menjo (tmenjo) | macdice | 13 | 2021-10-04 06:18 |
2021-10-07 08:28 |
|
| Split StdRdOptions into HeapOptions and ToastOptions | Moved to next CF | Nikolay Shaplov (nataraj) | 10 | 2021-10-04 07:11 |
2021-07-22 08:30 |
|||
| Reduce WaitEventSet system call spam | Committed | Thomas Munro (macdice) | macdice | 6 | 2021-03-04 21:42 |
2021-03-01 03:21 |
||
| Refactor nodeModifyTable.c to allow lazy opening of result relations | Committed | Amit Langote (amitlan) | Heikki Linnakangas (heikki), Tom Lane (tgl) | tgl | 5 | 2021-04-07 16:23 |
2021-04-08 05:33 |
|
| Some cosmetic improvements of partition pruning code | Committed | 14 | Amit Langote (amitlan) | Ryan Lambert (ryanlambert), Andy Fan (andyf) | davidrowley | 3 | 2021-04-08 11:55 |
2021-04-08 11:58 |
| ResourceOwner refactoring | Moved to next CF | Heikki Linnakangas (heikki) | Aleksander Alekseev (a.alekseev) | 4 | 2021-10-01 07:18 |
2023-11-17 20:52 |
||
| Optimising latch signals | Committed | Thomas Munro (macdice) | macdice | 2 | 2021-03-01 02:09 |
2021-03-09 22:18 |
||
| Printing LSN made easy | Committed | Ashutosh Bapat (ashutoshbapat) | Peter Eisentraut (petere) | petere | 2 | 2021-02-23 09:32 |
2021-02-19 06:10 |
|
| PoC Refactor AM analyse API | Moved to next CF | Denis Smirnov (darthunix) | Heikki Linnakangas (heikki) | 4 | 2021-10-01 06:57 |
2021-10-01 18:24 |
||
| pg_test_fsync should use pwrite( ) | Committed | Thomas Munro (macdice) | macdice | 1 | 2021-02-15 02:24 |
2021-02-15 02:24 |
||
| Infrastructure changes to make the code less sensitive to transaction id bit width | Moved to next CF | James Finnerty (jimfinnerty) | 3 | 2021-10-01 06:53 |
2021-10-01 06:53 |
|||
| Simplify COPY FROM parsing by forcing lookahead. | Returned with feedback | Heikki Linnakangas (heikki) | John Naylor (john.naylor) | 1 | 2021-04-06 18:28 |
2021-04-06 17:50 |
||
| Minor cleanup patches for collations | Committed | Thomas Munro (macdice) | macdice | 1 | 2021-02-22 11:31 |
2021-02-22 11:30 |
||
| A qsort template | Committed | Thomas Munro (macdice) | Daniel Gustafsson (d_gustafsson) | macdice | 1 | 2021-03-03 09:02 |
2022-04-06 10:31 |
|
| Replace buffer I/O locks with condition variables | Committed | Robert Haas (rhaas) | Julien Rouhaud (rjuju), Thomas Munro (macdice) | macdice | 1 | 2021-03-10 21:51 |
2021-03-11 03:11 |
|
| Replication & Recovery | ||||||||
| Make async slave to wait for lsn to be replayed | Moved to next CF | Ivan Kartyshov (fenimorkin) | Thomas Munro (macdice), Dmitry Ivanov (funbringer), Anna Akenteva (a.akenteva), Alexandra Pervushina (a.pervushina) | 14 | 2021-10-01 06:56 |
2021-03-22 05:05 |
||
| WAL prefetch (another approach) | Committed | Thomas Munro (macdice) | David Kimura (dgkimura) | macdice | 7 | 2021-04-08 14:21 |
2022-04-08 01:46 |
|
| Make message at end-of-recovery less scary | Moved to next CF | Kyotaro Horiguchi (horiguti) | Aleksander Alekseev (a.alekseev), Ashutosh Sharma (ashu_coek), Justin Pryzby (justinpryzby), Pavel Borisov (pborisov) | 20 | 2024-01-31 01:57 |
2024-01-23 04:13 |
||
| Improve standby connection denied error message | Committed | James Coleman (jcole1989) | David Zhang (david.z) | masaofujii | 5 | 2021-03-25 01:46 |
2021-03-25 01:43 |
|
| implement LogicalDecodeMessageCB for pgoutput | Committed | 13 | Dave Cramer (dcramer) | Euler Taveira (eulerto), Ashutosh Bapat (ashutoshbapat) | amitkapila | 4 | 2021-04-07 05:19 |
2021-04-07 12:09 |
| Background writer and checkpointer in crash recovery | Moved to next CF | Thomas Munro (macdice) | Aleksander Alekseev (aalekseev) | macdice | 6 | 2021-08-03 02:22 |
2021-08-03 02:19 |
|
| cleanup temporary files after crash | Committed | 14 | Euler Taveira (eulerto) | Anastasia Lubennikova (lubennikovaav), Gerdan Santos (gerdan) | fuzzycz | 3 | 2021-03-18 16:41 |
2021-03-19 17:51 |
| Row filtering for logical replication | Moved to next CF | 15 | Euler Taveira (eulerto), Peter Smith (smithpb), Ajin Cherian (ajinc), Hou Zhijie (houzj) | Dilip Kumar (dilip.kumar), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Hou Zhijie (houzj), Rahila Syed (rahila) | amitkapila | 7 | 2022-02-27 18:02 |
2022-03-07 02:31 |
| wal_sessioninfo | Moved to next CF | Simon Riggs (simon) | Cleysson Lima (cleyssonlima) | 4 | 2021-10-01 16:28 |
2021-07-31 12:30 |
||
| logical decoding of two-phase transactions | Moved to next CF | 15 | Stas Kelvich (kelvich), Nikhil Sontakke (nikkhils), Ajin Cherian (ajinc), Peter Smith (smithpb2250) | Amit Kapila (amitkapila), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234) | amitkapila | 4 | 2021-08-09 02:57 |
2021-08-09 03:00 |
| Reduce the time required for a database recovery from archive. | Moved to next CF | Anna Akenteva (a.akenteva), Dmitry Shulga (d.shulga), Ivan Taranov (i.taranov) | 3 | 2021-10-01 06:58 |
2021-03-19 12:50 |
|||
| Logical Replication - bug in behavior of ALTER PUBLICATION .. DROP TABLE | Committed | Japin Li (japin), Bharath Rupireddy (bharathrupireddy) | amitkapila | 1 | 2021-01-26 03:11 |
2021-01-25 03:17 |
||
| Identify missing publications from publisher while create/alter subscription. | Moved to next CF | vigneshwaran C (vignesh.postgres) | Dilip Kumar (dilip.kumar), Euler Taveira (eulerto), Ashutosh Sharma (ashu_coek), Japin Li (japin), Bharath Rupireddy (bharathrupireddy) | amitkapila | 6 | 2022-04-01 14:59 |
2022-03-31 09:45 |
|
| Minimal logical decoding on standbys (take 6) | Moved to next CF | Amit Khandekar (amitdkhan) | Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) | 5 | 2022-02-07 02:49 |
2023-04-08 17:12 |
||
| Security | ||||||||
| Support for NSS as TLS backend | Returned with feedback | Daniel Gustafsson (d_gustafsson) | Andres Freund (andresfreund), Jacob Champion (jchampion) | 5 | 2021-04-08 08:16 |
2022-02-04 20:18 |
||
| pg_read_all_data default role | Committed | 14 | Stephen Frost (sfrost) | Georgios Kokolatos (gkokolatos) | sfrost | 4 | 2021-04-05 17:46 |
2021-04-07 10:36 |
| OpenSSL 3.0.0 compatibility | Withdrawn | Daniel Gustafsson (d_gustafsson) | 3 | 2021-03-10 08:23 |
2021-03-23 10:52 |
|||
| Tying an object's ownership to datdba | Committed | 14 | Noah Misch (nmisch) | Daniel Gustafsson (d_gustafsson), John Naylor (john.naylor) | nmisch | 2 | 2021-03-27 07:54 |
2021-03-25 13:55 |
| Let people set host(no)ssl settings from initdb | Rejected | 14 | David Fetter (dfetter) | 2 | 2021-03-09 00:47 |
2021-03-09 00:47 |
||
| Deprecate SSL compression | Committed | Daniel Gustafsson (d_gustafsson) | Peter Eisentraut (petere) | michael-kun | 1 | 2021-03-09 02:20 |
2021-03-09 02:19 |
|
| Dump public schema ownership, seclabels and comments | Moved to next CF | Noah Misch (nmisch) | nmisch | 2 | 2021-06-29 01:38 |
2021-06-29 16:32 |
||
| public schema default ACL | Moved to next CF | Noah Misch (nmisch) | Peter Eisentraut (petere) | nmisch | 3 | 2021-09-10 07:03 |
2021-09-08 09:45 |
|
| Server Features | ||||||||
| Push aggregation down to base relations and joins | Withdrawn | Antonin Houska (a.houska) | Tom Lane (tgl), Ashutosh Bapat (ashutoshbapat), Richard Guo (richardguo), Andy Fan (andyf) | 19 | 2021-03-11 10:06 |
2021-03-11 13:34 |
||
| Transactions involving multiple postgres foreign servers | Moved to next CF | Masahiko Sawada (masahikosawada), Ashutosh Bapat (ashutoshbapat) | Takayuki Tsunakawa (maumau), Ashutosh Bapat (ashutoshbapat), Chris Travers (einhverfr), Muhammad Usama (muhammad_usama), Masahiro Ikeda (masahiro.ikeda) | 18 | 2021-10-04 01:00 |
2021-10-06 03:03 |
||
| Index Skip Scan | Moved to next CF | 16 | Dmitry Dolgov (erthalion), Thomas Munro (macdice), Jesper Pedersen (jpedersen) | Peter Geoghegan (pgeoghegan), Dilip Kumar (dilip.kumar), Thomas Munro (macdice), Chris Travers (einhverfr), James Coleman (jcole1989), Cristiano Duarte (cunha17), Andy Fan (andyf), Yuming Wang (yumwang), Jet Zhang (thinkj), Alexandre Felipe (bob.tpro) | 19 | 2022-03-24 11:32 |
2022-03-29 03:19 |
|
| A hook for path-removal decision on add_path | Moved to next CF | KaiGai Kohei (kaigai) | 11 | 2022-03-24 13:27 |
2022-10-02 16:59 |
|||
| Fix partitionwise join with partially-redundant join clauses | Moved to next CF | Richard Guo (richardguo) | Tom Lane (tgl), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) | richardguo | 16 | 2024-07-30 07:25 |
2024-07-30 07:36 |
|
| Global temporary table | Moved to next CF | 16 | Wenjing Zeng (wenjing.zwj) | Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) | 13 | 2022-06-30 20:54 |
2022-06-30 20:54 |
|
| GUC to disable cancellation of awaiting for synchronous replication | Moved to next CF | Andrey Borodin (x4m) | Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev) | 9 | 2021-10-06 13:13 |
2021-04-23 10:19 |
||
| truncating timestamps on arbitrary intervals | Committed | John Naylor (john.naylor) | Peter Eisentraut (petere) | petere | 6 | 2021-03-24 15:39 |
2021-04-01 16:08 |
|
| jsonpath syntax extensions | Moved to next CF | 15 | Nikita Glukhov (n.glukhov) | 12 | 2023-02-13 18:18 |
2022-03-31 19:21 |
||
| Auto-analyze on partitioned tables | Committed | Yuzuko Hosoya (yuzu) | Justin Pryzby (justinpryzby) | alvherre | 6 | 2021-04-08 05:54 |
2021-04-08 15:27 |
|
| ALTER SYSTEM READ { ONLY | WRITE } | Moved to next CF | Amul Sul (sulamul) | 9 | 2022-01-10 04:22 |
2021-12-01 04:59 |
|||
| Enabling data checksums in an online cluster | Withdrawn | Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) | 5 | 2021-03-09 19:10 |
2021-03-09 19:09 |
|||
| Non-volatile WAL buffer | Moved to next CF | Takashi Menjo (tmenjo) | 6 | 2021-06-18 06:46 |
2021-03-09 07:23 |
|||
| Implement <null treatment> for window functions | Returned with feedback | 15 | Vik Fearing (xocolatl) | David Fetter (dfetter), Krasiyan Andreev (krasiyan) | tgl | 4 | 2021-03-25 13:43 |
2021-03-18 16:36 |
| postgres_fdw connection caching enable/disable or timeout feature | Committed | Bharath Rupireddy (bharathrupireddy) | Fujii Masao (masaofujii), Alexey Kondratov (ololobus) | masaofujii | 4 | 2021-04-02 10:48 |
2021-04-02 10:47 |
|
| Add a feature that enables row-wise comparison partition pruning | Returned with feedback | sho kato (kato-sho) | Anastasia Lubennikova (lubennikovaav), ahsan hadi (ahsan.hadi) | 4 | 2021-04-08 15:04 |
2021-04-08 15:04 |
||
| ALTER TABLE .. DETACH PARTITION CONCURRENTLY | Committed | Álvaro Herrera (alvherre) | Anastasia Lubennikova (lubennikovaav), Justin Pryzby (justinpryzby) | alvherre | 4 | 2021-03-25 21:32 |
2021-03-31 18:30 |
|
| Wrong statistics for size of XLOG_SWITCH during pg_waldump | Committed | movead li (movead.li) | Shinya Kato (kato-shinya) | masaofujii | 3 | 2021-03-24 05:35 |
2021-03-23 01:01 |
|
| protocol default result formats setting | Returned with feedback | Peter Eisentraut (petere) | Emre Hasegeli (hasegeli) | 3 | 2021-04-07 13:37 |
2021-03-24 16:05 |
||
| custom compression methods for toast | Committed | 14 | Dilip Kumar (dilip.kumar), Ildus Kurbangaliev (ildus) | Justin Pryzby (justinpryzby) | rhaas | 3 | 2021-04-08 15:30 |
2021-03-30 14:30 |
| Extended statistics / estimate Var op Var clauses | Moved to next CF | Tomas Vondra (fuzzycz) | Dean Rasheed (deanr), Mark Dilger (mark.dilger) | 9 | 2022-10-12 08:03 |
2022-10-12 08:04 |
||
| Extended statistics on expressions | Committed | 14 | Tomas Vondra (fuzzycz) | Justin Pryzby (justinpryzby) | fuzzycz | 2 | 2021-03-27 00:21 |
2021-03-27 02:11 |
| Allow match a whole DN of a client certificate | Committed | 14 | Andrew Dunstan (adunstan) | Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) | adunstan | 2 | 2021-03-29 19:50 |
2021-03-30 01:08 |
| Initial mach based shared memory support. | Returned with feedback | James Hilliard (jameshilliard) | 2 | 2021-04-08 14:51 |
2021-03-25 12:24 |
|||
| Xact event callback at command start | Moved to next CF | Gilles Darold (darold) | Julien Rouhaud (rjuju) | 4 | 2021-09-01 14:23 |
2021-09-04 11:00 |
||
| autovacuum exit on postmaster death when sleeping | Committed | 14 | Stephen Frost (sfrost) | sfrost | 2 | 2021-03-30 16:56 |
2021-03-30 16:55 |
|
| New Table Access Methods for Multi and Single Inserts | Moved to next CF | Bharath Rupireddy (bharathrupireddy) | 9 | 2022-10-12 05:31 |
2024-10-31 04:17 |
|||
| On client login event trigger | Moved to next CF | 17 | Konstantin Knizhnik (knizhnik), Greg Nancarrow (gregn1234), Mikhail Gribkov (youzhick) | Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234) | smagen | 15 | 2023-10-18 10:31 |
2023-10-29 22:21 |
| SQL/JSON: functions | Moved to next CF | 15 | Nikita Glukhov (n.glukhov) | adunstan | 7 | 2022-04-08 03:47 |
2022-04-08 12:15 |
|
| SQL/JSON: JSON_TABLE | Moved to next CF | 15 | Nikita Glukhov (n.glukhov) | adunstan | 7 | 2022-04-08 03:48 |
2022-04-06 18:05 |
|
| Discarding DISCARD ALL | Moved to next CF | 15 | Simon Riggs (simon) | 3 | 2021-06-21 17:13 |
2021-06-21 16:50 |
||
| Table AM modifications to accept column projection lists | Moved to next CF | Jacob Champion (jchampion), Soumyadeep Chakraborty (soumyadeepc) | 3 | 2021-06-30 23:43 |
2021-06-30 23:42 |
|||
| Key management with tests | Moved to next CF | 15 | Stephen Frost (sfrost), Masahiko Sawada (masahikosawada), Bruce Momjian (bmomjian) | 3 | 2021-07-15 14:45 |
2022-06-16 23:24 |
||
| EXPLAIN/EXPLAIN ANALYZE REFRESH MATERIALIZED VIEW | Moved to next CF | Bharath Rupireddy (bharathrupireddy) | Japin Li (japin) | 2 | 2021-07-10 13:23 |
2021-07-10 13:23 |
||
| Teach VACUUM to ignore CIC / RC | Committed | Álvaro Herrera (alvherre) | Matthias van de Meent (mmeent) | alvherre | 1 | 2021-02-23 15:27 |
2021-02-23 15:26 |
|
| bitwise XOR aggregate functions | Committed | stable | Alexey Bashtanov (bashtanov) | Peter Eisentraut (petere) | petere | 1 | 2021-03-06 18:37 |
2021-03-07 21:08 |
| Fallback table AM for relkinds without storage | Returned with feedback | 14 | Michael Paquier (michael-kun) | 1 | 2021-03-14 11:56 |
2021-03-14 11:59 |
||
| Allow batched insert during cross-partition updates | Moved to next CF | Amit Langote (amitlan) | Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Hou Zhijie (houzj) | efujita | 10 | 2022-12-20 10:23 |
2022-12-20 11:19 |
|
| contrib/cube - binary send/recv handlers | Committed | KaiGai Kohei (kaigai) | Tom Lane (tgl) | tgl | 1 | 2021-03-06 17:04 |
2021-03-06 17:11 |
|
| Hooks and API to allow loadable wire protocol extensions | Moved to next CF | Jan Wieck (wieck) | 3 | 2021-10-01 06:56 |
2021-03-05 01:38 |
|||
| SQL Commands | ||||||||
| Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT | Returned with feedback | Matheus Oliveira (matheus.oliveira) | Gerdan Santos (gerdan), Ashutosh Bapat (ashutoshbapat), José Villanova (azlev), Lucas Viecelli (lucasviecelli), Cleysson Lima (cleyssonlima) | 15 | 2021-04-08 15:08 |
2021-04-08 15:07 |
||
| Incremental Materialized View Maintenance | Moved to next CF | 16 | Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) | Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) | 17 | 2022-10-12 07:49 |
2022-10-12 07:53 |
|
| Allow an alias to be attached directly to a JOIN ... USING | Committed | Peter Eisentraut (petere) | Tom Lane (tgl) | petere | 10 | 2021-03-31 15:41 |
2021-03-31 15:49 |
|
| FETCH FIRST clause PERCENT option | Moved to next CF | Surafel Temesgen (surafel) | 12 | 2021-10-03 16:16 |
2021-09-30 18:31 |
|||
| Implement INSERT SET syntax | Moved to next CF | Gareth Palmer (gareth) | Jaime Casanova (jcasanov), Ibrar Ahmed (ibrar), movead li (movead.li), Wenjing Zeng (wenjing.zwj) | 15 | 2022-08-01 20:18 |
2022-07-14 10:45 |
||
| Allow REINDEX, CLUSTER and VACUUM FULL to rebuild on new TABLESPACE/INDEX_TABLESPACE | Committed | Justin Pryzby (justinpryzby), Alexey Kondratov (ololobus) | Justin Pryzby (justinpryzby), Cleysson Lima (cleyssonlima) | michael-kun | 9 | 2021-02-04 06:39 |
2021-02-15 02:58 |
|
| WITH SYSTEM VERSIONING Temporal Tables | Moved to next CF | Surafel Temesgen (surafel) | Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre) | 11 | 2021-11-16 12:31 |
2021-11-16 12:31 |
||
| Return ERROR on COMMIT instead of silently ROLLBACK | Returned with feedback | Dave Cramer (dcramer) | Laurenz Albe (laurenz) | 5 | 2021-03-25 19:24 |
2021-03-25 19:23 |
||
| SEARCH and CYCLE clauses | Committed | Peter Eisentraut (petere) | Pavel Stehule (okbobcz), Vik Fearing (xocolatl) | petere | 5 | 2021-02-01 18:03 |
2021-02-27 07:16 |
|
| SQL-standard function body | Committed | Peter Eisentraut (petere) | Julien Rouhaud (rjuju) | petere | 5 | 2021-04-07 19:56 |
2021-04-08 11:19 |
|
| Change return type of EXTRACT to numeric | Committed | Peter Eisentraut (petere) | petere | 3 | 2021-04-06 05:46 |
2021-04-06 05:48 |
||
| Automatic HASH and LIST partition creation | Moved to next CF | Anastasia Lubennikova (lubennikovaav) | Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) | 7 | 2021-12-02 11:20 |
2021-12-02 11:20 |
||
| Extending the range operators so they can cope with range <op> element and element <op> range in addition to the existing range <op> range | Returned with feedback | Esteban Zimanyi (ezimanyi) | fuzzycz | 3 | 2021-04-08 15:12 |
2021-04-08 15:12 |
||
| Allow COPY "text" to output a header and add header matching mode to COPY FROM | Moved to next CF | Rémi Lapeyre (remilapeyre) | Peter Eisentraut (petere) | petere | 8 | 2022-03-30 07:11 |
2022-03-30 07:11 |
|
| CLUSTER on partitioned table | Moved to next CF | 15 | Justin Pryzby (justinpryzby) | Matthias van de Meent (mmeent) | alvherre | 8 | 2022-04-02 17:11 |
2022-04-04 12:59 |
| DROP INDEX CONCURRENTLY on partitioned index | Moved to next CF | 15 | Justin Pryzby (justinpryzby) | 4 | 2021-07-24 16:46 |
2021-07-24 16:46 |
||
| CREATE INDEX CONCURRENTLY on partitioned table | Moved to next CF | Justin Pryzby (justinpryzby), Alexander Pyhalov (a.pyhalov) | Anastasia Lubennikova (lubennikovaav), Alexander Pyhalov (a.pyhalov), Ilya Gladyshev (qoops) | 15 | 2023-09-18 14:48 |
2024-10-25 18:32 |
||
| create table like: ACCESS METHOD | Moved to next CF | 15 | Justin Pryzby (justinpryzby) | Simon Riggs (simon) | 4 | 2021-10-01 08:00 |
2021-10-01 08:01 |
|
| REINDEX backend filtering | Moved to next CF | Julien Rouhaud (rjuju) | 3 | 2021-05-08 03:31 |
2021-03-15 19:37 |
|||
| Dynamic result sets from procedures | Moved to next CF | Peter Eisentraut (petere) | 12 | 2023-10-30 09:26 |
2023-02-24 11:26 |
|||
| MERGE SQL command | Moved to next CF | 15 | Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) | 4 | 2021-09-01 12:58 |
2022-03-28 15:06 |
||
| Partial foreign key updates in referential integrity triggers | Moved to next CF | 15 | Paul Martinez (pauljulius) | Peter Eisentraut (petere) | petere | 5 | 2021-12-08 10:29 |
2021-12-08 10:29 |
| NOT VALID for Unique Indexes | Moved to next CF | Simon Riggs (simon) | 3 | 2021-10-01 07:21 |
2021-09-01 11:02 |
|||
| Rename of triggers for partitioned tables | Moved to next CF | Arne Roland (harks) | Álvaro Herrera (alvherre) | alvherre | 2 | 2021-07-22 22:35 |
2021-07-26 18:11 |
|
| Feature improvement for CLOSE, FETCH, MOVE tab completion | Committed | Shinya Kato (kato-shinya) | masaofujii | 1 | 2021-03-03 14:46 |
2021-01-14 06:43 |
||
| Add PROCESS_TOAST option to VACUUM | Committed | Nathan Bossart (bossartn) | Justin Pryzby (justinpryzby) | michael-kun | 1 | 2021-02-09 05:24 |
2021-02-09 17:43 |
|
| Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax | Committed | Japin Li (japin) | Bharath Rupireddy (bharathrupireddy) | petere | 1 | 2021-04-06 09:56 |
2021-04-07 02:49 |
|
| Foreign Key Arrays | Moved to next CF | Mark Rofail (markmoheb) | Joel Jacobson (joeljacobson), Justin Pryzby (justinpryzby) | 3 | 2021-09-14 18:59 |
2021-10-05 19:15 |
||
| TRUNCATE on foreign table | Committed | 14 | KaiGai Kohei (kaigai), kazutaka onishi (onishi) | Fujii Masao (masaofujii), Bharath Rupireddy (bharathrupireddy) | masaofujii | 1 | 2021-04-08 12:42 |
2021-04-08 15:25 |
| TRIM_ARRAY | Committed | 14 | Vik Fearing (xocolatl) | Dian Fay (dmfay) | tgl | 1 | 2021-03-03 21:52 |
2021-03-03 22:03 |
| GROUP BY DISTINCT | Committed | 14 | Vik Fearing (xocolatl) | Georgios Kokolatos (gkokolatos) | fuzzycz | 1 | 2021-03-18 17:53 |
2021-03-18 23:55 |
| Fix use of cursor sensitivity terminology | Committed | Peter Eisentraut (petere) | petere | 1 | 2021-04-07 06:14 |
2021-03-11 22:02 |
||
| alter table set TABLE ACCESS METHOD | Moved to next CF | Justin Pryzby (justinpryzby) | Jeff Davis (jdavis) | 2 | 2021-06-08 21:49 |
2021-07-30 21:18 |
||
| System Administration | ||||||||
| Avoid hiding shared filesets in pg_ls_tmpdir (pg_ls_* functions for showing metadata ...) | Moved to next CF | Justin Pryzby (justinpryzby) | Fabien Coelho (calvin) | 21 | 2024-01-22 01:15 |
2024-01-22 01:16 |
||
| extend amcheck module to check heaps | Committed | 14 | Mark Dilger (mark.dilger) | Robert Haas (rhaas) | rhaas | 4 | 2021-03-15 14:26 |
2021-04-07 20:16 |
| remove pg_standby | Committed | 14 | Justin Pryzby (justinpryzby) | macdice | 3 | 2021-02-10 04:06 |
2021-01-29 01:19 |
|
| pg_wait_backend() and pg_terminate_backend_and_wait() functions with wait and timeout capability | Committed | Bharath Rupireddy (bharathrupireddy) | Muhammad Usama (muhammad_usama), Hou Zhijie (houzj) | mha | 2 | 2021-04-08 09:41 |
2021-04-08 09:41 |
|
| Fix pg_rewind race condition just after promotion | Moved to next CF | Heikki Linnakangas (heikki) | Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) | heikki | 12 | 2023-02-23 13:43 |
2023-02-23 13:43 |
|
| Mitigate pg_rewind race condition, if config file is enlarged concurrently. | Moved to next CF | Heikki Linnakangas (heikki) | Daniel Gustafsson (d_gustafsson), Cary Huang (cary) | d_gustafsson | 7 | 2022-04-05 13:03 |
2022-04-05 08:11 |
|
| zstd compression for pg_dump | Moved to next CF | Justin Pryzby (justinpryzby) | Andreas Karlsson (kandreas), Jacob Champion (jchampion) | fuzzycz | 4 | 2023-04-07 02:45 |
2023-04-07 02:09 |
|
| VACUUM (FAST_FREEZE ) | Returned with feedback | Simon Riggs (simon) | Masahiko Sawada (masahikosawada) | 2 | 2021-04-08 15:23 |
2021-07-15 07:00 |
||
| Maximize page freezing | Moved to next CF | Simon Riggs (simon) | Álvaro Herrera (alvherre) | 3 | 2021-07-15 06:58 |
2021-07-15 07:00 |
||
| New default role allowing to change per-role settings | Moved to next CF | Michael Banck (mbanck) | Stephen Frost (sfrost), Shinya Kato (kato-shinya) | 8 | 2022-08-01 20:31 |
2022-01-29 11:10 |
||
| Add pg_dump --extension to dump specific extensions | Committed | Guillaume Lelarge (gleu) | Asif Rehman (asifrana) | michael-kun | 1 | 2021-03-31 00:16 |
2021-04-08 03:12 |
|
| Catalog version access | Moved to next CF | Vik Fearing (xocolatl), Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 5 | 2022-01-31 07:57 |
2022-01-31 18:10 |
||
| SSL SNI | Committed | Peter Eisentraut (petere) | petere | 1 | 2021-04-07 13:37 |
2021-04-07 13:32 |
||
| Add --create-only option to pg_dump/pg_dumpall | Moved to next CF | Michael Banck (mbanck) | Cary Huang (cary), Nitin Jadhav (nitinjadhav11) | 3 | 2021-09-13 13:26 |
2021-09-13 13:26 |
||