Commitfest 2020-09
Status summary: Committed: 48. Moved to next CF: 152. Withdrawn: 4. Rejected: 3. Returned with Feedback: 28. Total: 235.
Closed patches
| Patch | ID | Status | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest activity | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bug Fixes | |||||||||||
| COPY FREEZE, PD_VISIBLE_ALL and VM status | 2009 | Moved to next CF | Not processed | Pavan Deolasee (pavan), Ibrar Ahmed (ibrar) | Darafei Praliaskouski (komzpa), Hamid Akhtar (hamidakhtar) | fuzzycz | 6 | 2021-01-17 21:33 |
2021-01-24 00:54 |
||
| Spurious "apparent wraparound" via SimpleLruTruncate() rounding (data loss) | 2026 | Moved to next CF | stable | Not processed | Noah Misch (nmisch) | Andrey Borodin (x4m) | nmisch | 10 | 2021-01-17 23:42 |
2021-01-12 16:41 |
|
| Fix unique join costings | 2050 | Moved to next CF | stable | Not processed | David Rowley (davidrowley) | Tom Lane (tgl) | 9 | 2020-12-03 09:54 |
2020-10-30 16:33 |
||
| standby recovery fails when re-replaying due to missing directory which was removed in previous replay. | 2161 | Moved to next CF | stable | Not processed | Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) | Michael Paquier (michael-kun) | alvherre | 16 | 2022-07-28 06:42 |
2022-08-01 02:01 |
|
| Windows could not stat file - over 4GB | 2189 | Moved to next CF | Not processed | Juanjo Santamaria Flecha (juanjo.santamaria.gmail.com) | Emil Iggland (emiliggland) | tgl | 8 | 2020-10-09 20:22 |
2020-10-13 00:25 |
||
| pg_upgrade fails with non-standard ACL | 2215 | Moved to next CF | Not processed | 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 |
||
| Btree BackwardScan race condition on Standby during VACUUM | 2511 | Committed | stable | Not processed | Michail Nikolaev (nkey) | Andrey Borodin (x4m) | pgeoghegan | 2 | 2020-08-03 22:56 |
2020-08-03 22:55 |
|
| Corruption during WAL replay | 2518 | Moved to next CF | stable | Not processed | 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 | 2520 | Moved to next CF | stable | Not processed | Nathan Bossart (bossartn) | Álvaro Herrera (alvherre) | alvherre | 7 | 2021-08-23 20:24 |
2021-09-01 02:15 |
|
| reduce memory requirements of PLpgSQL CALL statement | 2559 | Committed | Not processed | Pavel Stehule (okbobcz) | Tom Lane (tgl) | tgl | 2 | 2020-09-29 15:19 |
2020-09-29 16:39 |
||
| SyncRepLock acquired exclusively in default configuration | 2585 | Committed | Not processed | Fujii Masao (masaofujii), Masahiko Sawada (masahikosawada) | Asim Rama Praveen (apraveen) | masaofujii | 2 | 2020-09-02 02:00 |
2020-09-02 02:12 |
||
| Problem with RETURNING and update tuple routing | 2597 | Moved to next CF | Not processed | 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 | 2603 | Moved to next CF | Not processed | David Johnston (polobo) | Pavel Stehule (okbobcz), Cindy Quintana (quintanacindy063.gmail.com) | 7 | 2021-08-11 14:42 |
2021-08-11 14:41 |
|||
| fix (partially) pgbench :variable substitution for -M extended and prepared | 2624 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Tom Lane (tgl) | tgl | 4 | 2021-01-13 19:53 |
2021-01-13 19:55 |
||
| Parallel worker hangs while handling errors | 2636 | Committed | Not processed | vigneshwaran C (vignesh.postgres) | Bharath Rupireddy (bharathrupireddy) | tgl | 1 | 2020-09-17 01:55 |
2020-09-12 17:57 |
||
| Switch pg_test_fsync to use binary mode on Windows | 2640 | Committed | stable | Not processed | Michael Paquier (michael-kun) | michael-kun | 1 | 2020-07-17 05:04 |
2020-07-16 07:19 |
||
| Bug 16419 Doc and Test Adds | 2645 | Moved to next CF | Not processed | David Johnston (polobo) | tgl | 2 | 2020-09-30 19:41 |
2020-10-01 00:40 |
|||
| Issue with cancel_before_shmem_exit while searching to remove a particular registered exit callbacks | 2649 | Committed | Not processed | Bharath Rupireddy (bharathrupireddy) | tgl | 1 | 2020-09-08 19:55 |
2020-09-08 19:56 |
|||
| Detect the null type correctly in setop case by peeking the later exprs. | 2653 | Withdrawn | 14 | Not processed | 1 | 2020-07-23 03:32 |
2020-07-26 09:41 |
||||
| Error in brin_summarize_new_values | 2655 | Committed | Not processed | Anastasia Lubennikova (lubennikovaav) | alvherre | 1 | 2020-08-14 18:43 |
2020-08-17 20:21 |
|||
| shared tempfile was not removed on statement_timeout | 2657 | Moved to next CF | stable | Not processed | Thomas Munro (macdice), Justin Pryzby (justinpryzby) | macdice | 4 | 2021-02-15 01:31 |
2021-02-15 01:33 |
||
| Fix autovac for large number of tables | 2658 | Moved to next CF | Not processed | Kasahara Tatsuhito (kasahara) | Fujii Masao (masaofujii) | masaofujii | 3 | 2020-12-08 15:02 |
2020-12-09 00:47 |
||
| pg_dump bug for extension owned tables | 2671 | Committed | Not processed | Fabrízio Mello (fabriziomello) | Andrew Dunstan (adunstan) | adunstan | 1 | 2020-09-04 17:57 |
2020-09-04 19:10 |
||
| ICU bug with ucol_strcollUTF8/ucol_strcoll | 2672 | Committed | 14 | Not processed | Jehan-Guillaume de Rorthais (ioguix) | Peter Eisentraut (petere) | petere | 1 | 2020-09-10 13:46 |
2020-07-15 13:52 |
|
| REINDEX SCHEMA/DATABASE/SYSTEM weak with dropped relations | 2680 | Committed | stable | Not processed | Michael Paquier (michael-kun) | Anastasia Lubennikova (lubennikovaav) | michael-kun | 1 | 2020-09-02 00:14 |
2020-09-02 05:58 |
|
| Inserting DEFAULT into generated columns from VALUES RTE | 2681 | Moved to next CF | Not processed | Dean Rasheed (deanr), Mikhail Titov (mlt) | Tom Lane (tgl) | tgl | 2 | 2020-11-23 16:17 |
2020-11-23 16:16 |
||
| Various fixes for snapshot-too-old feature | 2682 | Moved to next CF | Not processed | Robert Haas (rhaas), Thomas Munro (macdice) | Hamid Akhtar (hamidakhtar) | rhaas | 2 | 2020-12-03 09:53 |
2020-11-26 10:03 |
||
| Fix collation handling in postgres_fdw | 2685 | Moved to next CF | Not processed | Tom Lane (tgl) | Etsuro Fujita (efujita) | 6 | 2021-09-25 14:57 |
2021-10-01 19:37 |
|||
| Dumping/restoring fails on inherited generated column | 2698 | Moved to next CF | Not processed | 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 | 2719 | Moved to next CF | Not processed | Michael Banck (mbanck) | Anastasia Lubennikova (lubennikovaav), David Steele (dsteele) | 6 | 2021-09-13 11:45 |
2021-09-13 11:45 |
|||
| Clients | |||||||||||
| New libpq option to prefer standby for connection | 1677 | Moved to next CF | Not processed | 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 | 1736 | Moved to next CF | Not processed | 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 | 2096 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Peter Eisentraut (petere) | petere | 13 | 2022-04-04 21:33 |
2022-04-06 17:05 |
||
| ECPG new statement: DECLARE STATEMENT | 2334 | Moved to next CF | Not processed | Hayato Kuroda (ha-kun) | Shawn Wang (shawnwang) | meskes | 8 | 2021-03-25 00:15 |
2021-01-27 09:18 |
||
| pgbench - allow to test whether a variable exists (2) | 2535 | Moved to next CF | Not processed | Fabien Coelho (calvin) | Ibrar Ahmed (ibrar) | 3 | 2020-12-01 13:47 |
2020-11-30 14:48 |
|||
| psql - possibility to specify where status row should be displayed | 2536 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 5 | 2021-04-08 14:47 |
2021-03-03 17:47 |
||||
| allow to set a pager for psql's watch command | 2539 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Thomas Munro (macdice) | macdice | 6 | 2021-07-14 00:48 |
2021-07-13 18:05 |
||
| Confusing list foreign table options in psql - Fixing slash usage text | 2545 | Moved to next CF | Not processed | Hamid Akhtar (hamidakhtar) | ahsan hadi (ahsan.hadi) | 3 | 2020-11-29 19:28 |
2020-11-29 19:28 |
|||
| pgbench - add a synchronization barrier when starting | 2557 | Moved to next CF | Not processed | 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 | 2573 | Moved to next CF | Not processed | 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 |
||
| psql: Include access method in listTables output | 2586 | Committed | Not processed | Georgios Kokolatos (gkokolatos) | vigneshwaran C (vignesh.postgres) | michael-kun | 2 | 2020-09-02 08:07 |
2020-09-02 08:06 |
||
| pg_dump --where option | 2600 | Returned with feedback | Not processed | Surafel Temesgen (surafel), Carter Thaxton (carter.thaxton) | Cary Huang (cary) | 2 | 2020-09-30 06:18 |
2020-09-30 06:18 |
|||
| Added tab completion for the missing options in copy statement | 2633 | Committed | Not processed | vigneshwaran C (vignesh.postgres) | ahsan hadi (ahsan.hadi) | michael-kun | 1 | 2020-07-21 03:24 |
2020-07-21 03:21 |
||
| Avoid useless retrieval of defaults and check constraints in pg_dump -a | 2643 | Committed | Not processed | Julien Rouhaud (rjuju) | Daniel Gustafsson (d_gustafsson) | michael-kun | 1 | 2020-09-16 08:10 |
2020-09-16 13:34 |
||
| Tab completion for VACUUM of partitioned tables | 2659 | Committed | Not processed | Justin Pryzby (justinpryzby) | michael-kun | 1 | 2020-07-30 14:46 |
2020-07-30 09:08 |
|||
| Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration | 2674 | Committed | 14 | Not processed | Michael Paquier (michael-kun) | Peter Eisentraut (petere) | michael-kun | 1 | 2020-09-28 01:15 |
2020-09-28 01:19 |
|
| tab completion of IMPORT FOREIGN SCHEMA | 2677 | Committed | Not processed | Jeff Janes (jjanes) | Michael Paquier (michael-kun) | michael-kun | 1 | 2020-09-17 03:00 |
2020-09-17 02:58 |
||
| list of extended statistics on psql | 2692 | Returned with feedback | 14 | Not processed | Tatsuro Yamada (tatsuro_yamada) | Julien Rouhaud (rjuju) | 1 | 2020-09-30 06:19 |
2021-01-20 23:53 |
||
| show extended stats target in \d | 2712 | Committed | 13 | Not processed | Justin Pryzby (justinpryzby) | Georgios Kokolatos (gkokolatos), Tatsuro Yamada (yamatattsu) | alvherre | 1 | 2020-09-11 19:40 |
2020-09-11 19:26 |
|
| Documentation | |||||||||||
| document that psql's FETCH_COUNT does not work with combined (\;) queries | 2219 | Returned with feedback | Not processed | Fabien Coelho (calvin) | Gerdan Santos (gerdan), David Johnston (polobo) | 6 | 2020-09-30 06:26 |
2020-09-30 06:27 |
|||
| Document concurrent index builds waiting on each other | 2454 | Moved to next CF | stable | Not processed | James Coleman (jcole1989) | David Johnston (polobo) | alvherre | 5 | 2021-01-13 21:17 |
2021-01-13 23:49 |
|
| Additional Chapter "Architecture" for Part "Tutorial" | 2541 | Moved to next CF | Not processed | 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 |
|||
| Add missing cross-links in system catalog documentation | 2599 | Committed | Not processed | Dagfinn Ilmari Mannsåker (ilmari) | Peter Eisentraut (petere) | petere | 2 | 2020-09-03 11:38 |
2020-09-10 14:04 |
||
| Add <command> and <application> annotation to <refentrytitle> tags | 2608 | Moved to next CF | Not processed | Dagfinn Ilmari Mannsåker (ilmari) | Peter Eisentraut (petere) | petere | 3 | 2020-10-03 14:57 |
2020-10-03 16:33 |
||
| Improve Managing Databases doc page | 2647 | Committed | Not processed | David Johnston (polobo) | bmomjian | 1 | 2020-08-22 00:23 |
2020-08-22 01:00 |
|||
| Prefer explicit JOIN syntax over (old) implicit syntax in tutorial | 2652 | Moved to next CF | Not processed | Jürgen Purtz (juergen@purtz.de) | Peter Eisentraut (petere), David Johnston (polobo) | petere | 4 | 2021-04-08 08:58 |
2021-04-08 09:00 |
||
| Add section headings to index types doc | 2665 | Moved to next CF | Not processed | Dagfinn Ilmari Mannsåker (ilmari) | David Johnston (polobo), Jürgen Purtz (juergen@purtz.de) | tgl | 2 | 2020-11-25 19:04 |
2020-11-25 19:08 |
||
| initdb: creating clusters | 2695 | Committed | Not processed | Tom Lane (tgl) | Daniel Gustafsson (d_gustafsson) | tgl | 1 | 2020-09-03 15:49 |
2020-09-03 15:46 |
||
| Miscellaneous | |||||||||||
| parse-time support function for "any" datatype | 2081 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 10 | 2021-03-09 05:31 |
2021-03-03 17:25 |
||||
| Add missing libraries to Libs.private of libpq.pc | 2525 | Committed | Not processed | Sandro Mani (sandrom) | Peter Eisentraut (petere) | petere | 2 | 2020-09-10 13:56 |
2020-09-10 13:56 |
||
| Report error position for CREATE/ATTACH PARTITION bounds check | 2533 | Committed | 14 | Not processed | Amit Langote (amitlan), Ashwin Agrawal (ashwinstar), Alexandra Wang (l-wang) | Ashutosh Bapat (ashutoshbapat) | tgl | 2 | 2020-09-23 22:05 |
2020-09-29 01:14 |
|
| split string to table | 2538 | Committed | Not processed | Pavel Stehule (okbobcz) | Peter Smith (smithpb) | tgl | 2 | 2020-09-02 22:24 |
2020-09-03 03:01 |
||
| More tests with USING INDEX replident and dropped indexes | 2565 | Committed | 14 | Not processed | Michael Paquier (michael-kun) | Rahila Syed (rahila.syed), Euler Taveira (eulerto) | michael-kun | 2 | 2020-09-05 02:32 |
2020-09-05 02:36 |
|
| Compatible defaults for LEAD/LAG | 2574 | Moved to next CF | 14 | Not processed | Vik Fearing (xocolatl) | Pavel Stehule (okbobcz) | tgl | 3 | 2020-11-04 21:12 |
2020-11-04 22:00 |
|
| unicode unescape function | 2613 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Asif Rehman (asifrana) | petere | 5 | 2021-03-29 10:16 |
2021-03-29 10:22 |
||
| Add table expansion hook | 2614 | Moved to next CF | Not processed | Erik Nordström (enordstr) | Euler Taveira (eulerto), Aleksander Alekseev (aalekseev) | 7 | 2021-09-13 14:16 |
2021-09-09 18:26 |
|||
| Allow terminating the idle sessions | 2646 | Moved to next CF | Not processed | Japin Li (japin) | David Johnston (polobo), Hayato Kuroda (ha-kun) | tgl | 3 | 2021-01-06 23:29 |
2021-01-13 04:11 |
||
| display offset along with block number in vacuum error context | 2662 | Committed | Not processed | Mahendra Singh Thalor (mahithalor) | Justin Pryzby (justinpryzby) | amitkapila | 1 | 2020-08-26 06:05 |
2020-08-26 06:54 |
||
| Remove special case which avoided %*s format strings.. | 2666 | Returned with feedback | Not processed | Justin Pryzby (justinpryzby) | 1 | 2020-09-17 05:30 |
2020-08-05 08:22 |
||||
| add plsample to test/modules - procedural language skeleton and test coverage | 2678 | Committed | Not processed | Mark Wong (markwkm) | Michael Paquier (michael-kun) | michael-kun | 1 | 2020-08-18 03:36 |
2020-08-18 02:14 |
||
| Provide robust alternatives for replace_string | 2696 | Committed | stable | Not processed | Asim Rama Praveen (apraveen), Georgios Kokolatos (gkokolatos) | Tom Lane (tgl) | tgl | 1 | 2020-09-06 18:14 |
2020-09-06 18:15 |
|
| PATCH: Attempt to make dbsize a bit more consistent | 2701 | Moved to next CF | Not processed | 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 | 2709 | Moved to next CF | Not processed | 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 | 2710 | Moved to next CF | Not processed | 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 | 2717 | Moved to next CF | Not processed | Jeff Davis (jdavis) | Georgios Kokolatos (gkokolatos) | 4 | 2021-04-06 20:41 |
2021-03-18 14:37 |
|||
| Rationalize password length limits | 2721 | Committed | Not processed | Tom Lane (tgl), Nathan Bossart (bossartn) | tgl | 1 | 2020-09-04 00:10 |
2020-09-03 22:46 |
|||
| Monitoring & Control | |||||||||||
| SQL statements statistics counter view (pg_stat_sql) | 790 | Returned with feedback | Not processed | Haribabu Kommi (haribabu) | Dilip Kumar (dilip.kumar), Vinayak Pokale (vinpokale), Mark Dilger (mark.dilger) | 8 | 2020-09-17 05:01 |
2020-09-23 02:12 |
|||
| Shared-memory based stats collector | 1708 | Moved to next CF | Not processed | 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 | 2069 | Moved to next CF | Not processed | Julien Rouhaud (rjuju) | atsushi torikoshi (atorik), Evgeny Efimkin (efimkine), Nitin Jadhav (nitinjadhav11) | bmomjian | 10 | 2021-04-08 08:34 |
2021-04-08 15:17 |
||
| Amcheck: check B-tree leftlink-rightlink invariant on standby | 2254 | Committed | Not processed | Andrey Borodin (x4m) | Georgy Rylov (godjan) | pgeoghegan | 4 | 2020-08-08 18:19 |
2020-08-09 06:08 |
||
| vacuum verbose: show pages marked allvisible/frozen/hintbits | 2430 | Returned with feedback | Not processed | Justin Pryzby (justinpryzby) | Masahiko Sawada (masahikosawada) | 3 | 2020-09-07 03:05 |
2020-09-07 03:05 |
|||
| expose parallel leader in CSV and log_line_prefix | 2514 | Committed | 14 | Not processed | Justin Pryzby (justinpryzby) | Julien Rouhaud (rjuju) | michael-kun | 2 | 2020-08-03 04:42 |
2020-08-03 04:41 |
|
| Add LWLock blocker(s) information | 2576 | Moved to next CF | 14 | Not processed | Bertrand Drouvot (bdrouvot) | Julien Rouhaud (rjuju), David Zhang (david.z) | 3 | 2020-11-18 09:25 |
2020-11-19 10:33 |
||
| Command statistics system | 2578 | Returned with feedback | Not processed | Haribabu Kommi (haribabu), Mark Dilger (mark.dilger) | 2 | 2020-09-17 04:51 |
2020-09-23 02:12 |
||||
| Add Information during standby recovery conflicts | 2604 | Moved to next CF | 14 | Not processed | Bertrand Drouvot (bdrouvot) | Masahiko Sawada (masahikosawada) | masaofujii | 4 | 2021-01-07 15:53 |
2021-01-13 14:14 |
|
| Progress reporting for COPY command | 2607 | Returned with feedback | Not processed | Josef Šimánek (retro) | Fujii Masao (masaofujii), vigneshwaran C (vignesh.postgres) | 2 | 2020-09-17 05:09 |
2020-09-17 15:08 |
|||
| Function for exposing memory usage of local backend process | 2622 | Committed | 14 | Not processed | Fujii Masao (masaofujii), atsushi torikoshi (atorik) | Kasahara Tatsuhito (kasahara) | masaofujii | 2 | 2020-08-19 06:49 |
2020-08-26 01:54 |
|
| Add session statistics to pg_stat_database | 2639 | Moved to next CF | 14 | Not processed | Laurenz Albe (laurenz) | Magnus Hagander (mha), ahsan hadi (ahsan.hadi), Masahiro Ikeda (masahiro.ikeda), Soumyadeep Chakraborty (soumyadeepc) | mha | 3 | 2021-01-17 13:08 |
2021-01-18 16:52 |
|
| Display individual query in pg_stat_activity | 2656 | Moved to next CF | 13 | Not processed | Bertrand Drouvot (bdrouvot) | Cleysson Lima (cleyssonlima) | 2 | 2020-12-01 09:10 |
2020-12-01 09:10 |
||
| Amcheck: check B-tree leftlink-rightlink invariant on standby | 2667 | Committed | Not processed | Andrey Borodin (x4m) | pgeoghegan | 1 | 2020-08-08 18:19 |
2020-08-09 06:08 |
|||
| Add information to rm_redo_error_callback() | 2668 | Moved to next CF | 14 | Not processed | Bertrand Drouvot (bdrouvot) | Masahiko Sawada (masahikosawada) | michael-kun | 2 | 2020-10-02 00:48 |
2020-10-02 05:33 |
|
| update ps display for recovery checkpoint | 2688 | Moved to next CF | Not processed | Justin Pryzby (justinpryzby) | Nathan Bossart (bossartn), Kirk Jamison (kirkjamison) | michael-kun | 3 | 2020-12-14 03:39 |
2020-12-14 03:52 |
||
| New statistics for tuning WAL buffer size | 2693 | Moved to next CF | Not processed | Masahiro Ikeda (masahiro.ikeda) | Fujii Masao (masaofujii) | masaofujii | 2 | 2020-10-02 01:27 |
2020-10-16 10:58 |
||
| Get memory contexts of an arbitrary backend process | 2711 | Moved to next CF | 14 | Not processed | 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 | 2713 | Moved to next CF | 14 | Not processed | 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 |
||
| Performance | |||||||||||
| Protect syscache from bloating with negative cache entries | 931 | Moved to next CF | Not processed | 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 |
|||
| 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) | smagen | 27 | 2023-10-25 10:02 |
2025-02-18 07:24 |
||
| Built-in connection proxy | 2067 | Returned with feedback | Not processed | Konstantin Knizhnik (knizhnik) | Koichi Suzuki (koichi) | 7 | 2020-09-17 05:07 |
2021-04-28 10:14 |
|||
| de-TOAST'ing using a iterator | 2194 | Moved to next CF | Not processed | Xiao Bao (djydewang) | 8 | 2020-11-27 08:31 |
2020-11-27 08:31 |
||||
| bitmap cost should account for correlated indexes | 2310 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby) | 7 | 2021-02-01 13:32 |
2021-01-28 12:51 |
|||
| Optimize dropping of relation buffers during recovery | 2319 | Moved to next CF | Not processed | Kirk Jamison (kirkjamison) | Takayuki Tsunakawa (maumau), Haiying Tang (tanghy) | amitkapila | 7 | 2021-01-14 02:48 |
2021-01-13 05:25 |
||
| Reducing memory usage of creating foreign key between partitioned tables | 2330 | Rejected | Not processed | sho kato (kato-sho) | Tom Lane (tgl) | 5 | 2020-09-12 21:28 |
2020-09-04 11:34 |
|||
| Using multicolumn statistics for more precise join selectivity estimatation | 2386 | Moved to next CF | Not processed | Konstantin Knizhnik (knizhnik) | Yugo Nagata (yugo.nagata) | 9 | 2021-10-01 07:13 |
2021-11-04 09:56 |
|||
| Delaying/avoiding BTreeTupleGetNAtts() call within _bt_compare() | 2429 | Moved to next CF | Not processed | Peter Geoghegan (pgeoghegan) | Mark Dilger (mark.dilger) | 4 | 2020-11-09 18:46 |
2020-11-09 18:47 |
|||
| Erase the distinctClause if the result is unique by definition | 2433 | Moved to next CF | Not processed | 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. | 2491 | Moved to next CF | 14 | Not processed | 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 |
|
| Improving connection scalability: GetSnapshotData() | 2500 | Committed | Not processed | Andres Freund (andresfreund) | andresfreund | 3 | 2020-09-04 17:35 |
2020-09-30 22:43 |
|||
| JIT expression evaluation improvements | 2501 | Returned with feedback | Not processed | Andres Freund (andresfreund) | 3 | 2020-09-30 06:53 |
2020-09-30 06:54 |
||||
| BRIN multi-minmax and bloom indexes | 2523 | Moved to next CF | Not processed | 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 | 2542 | Returned with feedback | Not processed | 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 | 2553 | Moved to next CF | 15 | Not processed | Justin Pryzby (justinpryzby) | 8 | 2021-11-24 00:32 |
2021-11-04 12:24 |
|||
| speed up unicode normalization quick check | 2562 | Moved to next CF | 14 | Not processed | John Naylor (john.naylor) | Mark Dilger (mark.dilger) | michael-kun | 3 | 2020-10-11 10:59 |
2020-10-21 00:24 |
|
| Hybrid Hash/Nested Loop joins and caching results from subplans | 2569 | Moved to next CF | 14 | Not processed | David Rowley (davidrowley) | Andy Fan (andyf) | davidrowley | 5 | 2021-04-02 22:21 |
2021-04-02 01:15 |
|
| Overhaul UPDATE/DELETE processing | 2575 | Moved to next CF | Not processed | Amit Langote (amitlan) | Tom Lane (tgl) | tgl | 5 | 2021-03-31 16:01 |
2021-04-02 07:41 |
||
| Batch processing of RI checks | 2581 | Returned with feedback | Not processed | Antonin Houska (a.houska), Corey Huinker (coreyh) | 2 | 2020-09-30 06:56 |
2020-09-30 06:57 |
||||
| Improve planner cost estimations for alternative subplans | 2582 | Moved to next CF | 14 | Not processed | Alexey Bashtanov (bashtanov) | 3 | 2020-11-13 14:16 |
2020-08-28 22:38 |
|||
| Hashjoin fall back to block nested hashloop join | 2588 | Moved to next CF | 14 | Not processed | Melanie Plageman (melanieplageman), Soumyadeep Chakraborty (soumyadeep2007), Jesse Zhang (essej), David Kimura (dgkimura) | Thomas Munro (macdice) | 3 | 2020-11-10 21:44 |
2020-09-24 03:39 |
||
| Auto-vectorization speeds up multiplication of large-precision numerics | 2591 | Committed | Not processed | Amit Khandekar (amitdkhan) | Tom Lane (tgl) | tgl | 2 | 2020-09-07 01:41 |
2020-09-08 13:49 |
||
| 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) | efujita | 13 | 2022-10-31 08:40 |
2022-10-31 08:50 |
||
| Support parallelism for copy command | 2610 | Moved to next CF | Not processed | 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 |
||
| Keep elog(ERROR) and ereport(ERROR) calls in the cold path | 2616 | Moved to next CF | Not processed | David Rowley (davidrowley) | Peter Eisentraut (petere) | davidrowley | 3 | 2020-11-23 23:07 |
2020-11-25 01:59 |
||
| postgres_fdw insert batching | 2620 | Moved to next CF | 14 | Not processed | Takayuki Tsunakawa (maumau) | fuzzycz | 4 | 2021-01-20 23:00 |
2021-01-25 04:21 |
||
| More scalable multixacts buffers and locking | 2627 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m), Ivan Lazarev (avaness) | alvherre | 20 | 2024-04-07 12:52 |
2024-04-07 19:13 |
|||
| Replace spinlock with lwlock in pg_stat_statements | 2634 | Returned with feedback | Not processed | Fujii Masao (masaofujii) | Hamid Akhtar (hamidakhtar) | 1 | 2020-09-30 07:10 |
2020-09-30 07:11 |
|||
| audo-detect and use -moutline-atomics compilation flag for aarch64 | 2637 | Rejected | Not processed | Tsahi Zidenberg (tsahee) | Heikki Linnakangas (heikki) | 1 | 2020-09-29 07:21 |
2020-09-30 18:08 |
|||
| Use incremental sort paths for window functions | 2638 | Committed | Not processed | David Rowley (davidrowley) | Daniel Gustafsson (d_gustafsson) | davidrowley | 1 | 2020-09-15 11:45 |
2020-09-15 11:46 |
||
| avoid bitmapOR-ing indexes for scan conditions implied by partition constraint | 2644 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby), Soumyadeep Chakraborty (soumyadeep2007), Soumyadeep Chakraborty (soumyadeepc) | Konstantin Knizhnik (knizhnik), Justin Pryzby (justinpryzby) | tgl | 3 | 2021-02-01 13:39 |
2021-02-01 03:09 |
|
| Remove useless distinct clauses | 2663 | Returned with feedback | 14 | Not processed | Pierre Ducroquet (pinaraf) | 1 | 2020-09-30 07:06 |
2020-09-30 07:07 |
|||
| Handing SLRU sync work over to the checkpointer | 2669 | Committed | Not processed | Thomas Munro (macdice) | macdice | 1 | 2020-09-25 07:12 |
2020-09-25 07:09 |
|||
| Covering SPGiST index | 2675 | Moved to next CF | Not processed | Pavel Borisov (pborisov) | Andrey Borodin (x4m) | tgl | 4 | 2021-04-05 22:42 |
2021-04-06 11:09 |
||
| Faster compactify_tuples() | 2687 | Committed | Not processed | David Rowley (davidrowley) | Thomas Munro (macdice) | davidrowley | 1 | 2020-09-16 01:30 |
2020-09-16 23:21 |
||
| Improve row estimates for empty tables | 2691 | Committed | Not processed | Tom Lane (tgl) | Pavel Stehule (okbobcz) | tgl | 1 | 2020-08-30 16:22 |
2020-08-30 17:13 |
||
| Optimizing NULL check on pkey column | 2699 | Moved to next CF | Not processed | Surafel Temesgen (surafel) | Ashutosh Bapat (ashutoshbapat) | 6 | 2021-09-27 00:52 |
2021-09-27 00:52 |
|||
| Boundary value check in lazy_tid_reaped() | 2707 | Moved to next CF | Not processed | Masahiko Sawada (masahikosawada) | Peter Eisentraut (petere) | petere | 4 | 2021-03-10 14:52 |
2021-03-16 21:59 |
||
| remove spurious CREATE INDEX CONCURRENTLY wait | 2715 | Moved to next CF | Not processed | Álvaro Herrera (alvherre) | alvherre | 2 | 2020-11-30 19:55 |
2020-12-01 01:00 |
|||
| fix spinlock contention in LogwrtResult | 2716 | Moved to next CF | Not processed | Álvaro Herrera (alvherre) | 11 | 2022-09-23 08:50 |
2024-04-08 16:13 |
||||
| Pipelining/batch mode support for libpq | 2724 | Moved to next CF | Not processed | Á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 |
||
| Procedural Languages | |||||||||||
| declarative session variables, LET command | 1608 | Moved to next CF |
7/7
|
+12704−163 | Pavel Stehule (okbobcz) | Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Laurenz Albe (laurenz), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv), newtglobal postgresql_contributors (newtpostgrescontributors) | 35 | 2025-02-04 05:51 |
2025-02-16 09:13 |
||
| UNNEST(REFCURSOR): allowing SELECT to consume data from a REFCURSOR | 2376 | Moved to next CF | Not processed | John Dent (denty) | Daniel Vérité (danielverite) | 9 | 2021-10-01 10:20 |
2021-10-01 10:20 |
|||
| loop over unbound cursor | 2558 | Withdrawn | Not processed | Pavel Stehule (okbobcz) | Asif Rehman (asifrana) | 2 | 2020-08-10 04:47 |
2020-07-01 20:26 |
|||
| enhancing plpgsql API for debugging and tracing | 2684 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | Aleksander Alekseev (aalekseev) | tgl | 9 | 2022-03-31 21:06 |
2022-04-01 04:51 |
||
| possibility to write window function in PL languages (like PLpgSQL) | 2697 | Moved to next CF | Not processed | Pavel Stehule (okbobcz) | 3 | 2021-01-27 10:00 |
2021-01-27 09:58 |
||||
| Refactoring | |||||||||||
| Remove page-read callback from XLogReaderState | 2113 | Moved to next CF | Not processed | 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 |
||
| pgbench - improve variable management performance | 2236 | Returned with feedback | Not processed | Fabien Coelho (calvin) | 6 | 2020-09-17 05:31 |
2020-09-19 07:17 |
||||
| Executor code refactoring around result relations | 2277 | Moved to next CF | Not processed | Amit Langote (amitlan) | Heikki Linnakangas (heikki) | heikki | 6 | 2020-10-19 11:56 |
2020-10-30 06:06 |
||
| pgbench - refactor init functions with buffers | 2313 | Committed | Not processed | Fabien Coelho (calvin) | heikki | 5 | 2020-09-30 08:00 |
2020-09-30 07:59 |
|||
| Split StdRdOptions into HeapOptions and ToastOptions | 2370 | Moved to next CF | Not processed | Nikolay Shaplov (nataraj) | 10 | 2021-10-04 07:11 |
2021-07-22 08:30 |
||||
| Reduce WaitEventSet system call spam | 2452 | Moved to next CF | Not processed | Thomas Munro (macdice) | macdice | 6 | 2021-03-04 21:42 |
2021-03-01 03:21 |
|||
| Startup Centralization | 2498 | Returned with feedback | Not processed | Mike Palmiotto (mpalmiotto), Yulian Khodorkovskiy (ykhodo) | Andres Freund (andresfreund) | 3 | 2020-09-17 05:26 |
2020-09-17 05:26 |
|||
| Removal of currtid()/currtid2() and some table AM cleanup | 2579 | Moved to next CF | 14 | Not processed | Michael Paquier (michael-kun) | Peter Eisentraut (petere) | michael-kun | 3 | 2020-11-25 03:48 |
2020-11-25 03:21 |
|
| Refactor nodeModifyTable.c to allow lazy opening of result relations | 2621 | Moved to next CF | Not processed | Amit Langote (amitlan) | Heikki Linnakangas (heikki), Tom Lane (tgl) | tgl | 5 | 2021-04-07 16:23 |
2021-04-08 05:33 |
||
| Improvements in Copy From | 2642 | Withdrawn | Not processed | vigneshwaran C (vignesh.postgres) | 1 | 2020-09-27 02:49 |
2020-09-11 09:04 |
||||
| Choose AlternativeSubPlan alternative within the planner | 2705 | Committed | Not processed | Tom Lane (tgl) | David Rowley (davidrowley) | tgl | 1 | 2020-09-27 16:56 |
2020-09-27 15:59 |
||
| Replication & Recovery | |||||||||||
| Make async slave to wait for lsn to be replayed | 772 | Moved to next CF | Not processed | 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 |
|||
| Add timeline to partial WAL segments | 1919 | Returned with feedback | Not processed | David Steele (dsteele) | 9 | 2020-09-30 07:17 |
2020-09-30 07:17 |
||||
| logical streaming for large in-progress transactions | 1927 | Committed | Not processed | Amit Kapila (amitkapila), Tomas Vondra (fuzzycz), Petr Jelínek (pjmodos), Dilip Kumar (dilip.kumar) | Dilip Kumar (dilip.kumar), Masahiko Sawada (masahikosawada), vigneshwaran C (vignesh.postgres) | amitkapila | 9 | 2020-09-09 03:10 |
2020-09-16 06:01 |
||
| skip empty transactions for logical replication | 2384 | Returned with feedback | Not processed | Euler Taveira (eulerto) | 4 | 2020-09-17 05:29 |
2022-03-30 08:30 |
||||
| WAL prefetch (another approach) | 2410 | Moved to next CF | Not processed | Thomas Munro (macdice) | David Kimura (dgkimura) | macdice | 7 | 2021-04-08 14:21 |
2022-04-08 01:46 |
||
| Improve logging around restore_command | 2449 | Moved to next CF | Not processed | Jeff Janes (jjanes) | Fujii Masao (masaofujii), Pavel Borisov (pborisov) | masaofujii | 4 | 2020-11-20 06:46 |
2020-11-20 06:45 |
||
| Improve handling of parameter differences in physical replication | 2489 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Sergei Kornilov (melkij) | petere | 5 | 2021-01-18 08:33 |
2021-01-18 08:33 |
||
| 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 | 2024-01-31 01:57 |
2024-01-23 04:13 |
|||
| Improve standby connection denied error message | 2509 | Moved to next CF | Not processed | James Coleman (jcole1989) | David Zhang (david.z) | masaofujii | 5 | 2021-03-25 01:46 |
2021-03-25 01:43 |
||
| deferred primary key and logical replication | 2631 | Moved to next CF | 14 | Not processed | Euler Taveira (eulerto) | Ajin Cherian (ajinc) | 3 | 2020-11-29 19:05 |
2020-11-24 01:42 |
||
| implement LogicalDecodeMessageCB for pgoutput | 2661 | Moved to next CF | 13 | Not processed | Dave Cramer (dcramer) | Euler Taveira (eulerto), Ashutosh Bapat (ashutoshbapat) | amitkapila | 4 | 2021-04-07 05:19 |
2021-04-07 12:09 |
|
| Start WAL streaming as early as possible, without waiting for startup process to finish replaying existing WAL. This helps synchronous replication to resume quickly when significant replay lag has been built up. | 2676 | Moved to next CF | 14 | Not processed | Asim Rama Praveen (apraveen), Hao Wu (hwu) | 2 | 2020-12-01 14:21 |
2021-12-16 10:05 |
|||
| Minimal logical decoding on standbys | 2683 | Returned with feedback | Not processed | Andres Freund (andresfreund), Craig Ringer (ringerc), Amit Khandekar (amitdkhan), Ibrar Ahmed (ibrar) | 1 | 2020-09-17 05:57 |
2023-04-08 17:12 |
||||
| Refactor pg_rewind code and make it work against a standby | 2686 | Moved to next CF | 14 | Not processed | Heikki Linnakangas (heikki) | Soumyadeep Chakraborty (soumyadeepc) | heikki | 2 | 2020-11-12 12:59 |
2020-11-20 21:09 |
|
| Print logical WAL message content | 2690 | Committed | Not processed | Ashutosh Bapat (ashutoshbapat) | Álvaro Herrera (alvherre) | alvherre | 1 | 2020-09-11 14:38 |
2020-09-14 04:48 |
||
| Add contrib module pg_surgery for fixing damaged heap pages | 2700 | Committed | Not processed | Ashutosh Sharma (ashutosh.sharma88) | Andrey Borodin (x4m), Mark Dilger (mark.dilger) | rhaas | 1 | 2020-09-10 17:53 |
2020-09-21 21:20 |
||
| Background writer and checkpointer in crash recovery | 2706 | Moved to next CF | Not processed | Thomas Munro (macdice) | Aleksander Alekseev (aalekseev) | macdice | 6 | 2021-08-03 02:22 |
2021-08-03 02:19 |
||
| Security | |||||||||||
| Support for NSS as TLS backend | 2592 | Moved to next CF | Not processed | 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 | 2702 | Moved to next CF | 14 | Not processed | Stephen Frost (sfrost) | Georgios Kokolatos (gkokolatos) | sfrost | 4 | 2021-04-05 17:46 |
2021-04-07 10:36 |
|
| Use USE_OPENSSL_RANDOM for OpenSSL random | 2718 | Moved to next CF | Not processed | Daniel Gustafsson (d_gustafsson) | Magnus Hagander (mha) | mha | 2 | 2020-11-06 12:32 |
2020-11-20 12:59 |
||
| Server Features | |||||||||||
| Generic type subscripting | 1062 | Moved to next CF | 14 | Not processed | Dmitry Dolgov (erthalion) | Tom Lane (tgl), Pavel Stehule (okbobcz), Artur Zakirov (a.zakirov) | smagen | 19 | 2021-02-01 12:12 |
2021-02-01 08:39 |
|
| Push aggregation down to base relations and joins | 1247 | Moved to next CF | Not processed | 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 | 1574 | Moved to next CF | Not processed | 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 | 1741 | Moved to next CF | 16 | Not processed | 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 |
||
| Ltree syntax improvement | 1977 | Returned with feedback | Not processed | Dmitry Belyavsky (beldmit) | Nikolay Shaplov (nataraj), Nikita Glukhov (n.glukhov), Aleksandr Sorokin (mustiks) | 8 | 2020-09-30 07:48 |
2020-09-30 07:48 |
|||
| KMS - Internal key management system | 2196 | Returned with feedback | Not processed | Masahiko Sawada (masahikosawada), Ibrar Ahmed (ibrar), Insung Moon (tsukiwamoon) | Cary Huang (cary) | 6 | 2020-12-10 06:48 |
2020-09-08 08:23 |
|||
| A hook for path-removal decision on add_path | 2234 | Moved to next CF | Not processed | KaiGai Kohei (kaigai) | 11 | 2022-03-24 13:27 |
2022-10-02 16:59 |
||||
| Asymmetric partition-wise JOIN | 2249 | Moved to next CF | Not processed | KaiGai Kohei (kaigai) | Andrei Lepikhov (lepikhov) | 7 | 2021-04-30 03:11 |
2022-01-17 10:42 |
|||
| 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) | richardguo | 16 | 2024-07-30 07:25 |
2024-07-30 07:36 |
||
| GiST sorting build | 2276 | Committed | Not processed | Andrey Borodin (x4m) | Heikki Linnakangas (heikki), Pavel Borisov (pborisov) | heikki | 5 | 2020-11-05 16:15 |
2021-12-16 09:18 |
||
| Global temporary table | 2349 | Moved to next CF | 16 | Not processed | Wenjing Zeng (wenjing.zwj) | Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) | 13 | 2022-06-30 20:54 |
2022-06-30 20:54 |
||
| per-database-object collation version tracking | 2367 | Moved to next CF | Not processed | Julien Rouhaud (rjuju), Thomas Munro (macdice) | Peter Eisentraut (petere) | macdice | 5 | 2020-11-02 12:54 |
2020-11-08 10:06 |
||
| Online checksums verification | 2369 | Moved to next CF | Not processed | Julien Rouhaud (rjuju) | Masahiko Sawada (masahikosawada) | michael-kun | 5 | 2020-11-05 01:20 |
2020-11-04 01:32 |
||
| GUC to disable cancellation of awaiting for synchronous replication | 2402 | Moved to next CF | Not processed | Andrey Borodin (x4m) | Maksim Milyutin (maksm90), Michail Nikolaev (nkey), Aleksander Alekseev (aalekseev) | 9 | 2021-10-06 13:13 |
2021-04-23 10:19 |
|||
| Extended statistics improvements | 2421 | Moved to next CF | Not processed | Tomas Vondra (fuzzycz) | Dean Rasheed (deanr) | deanr | 5 | 2020-12-03 10:09 |
2020-12-08 12:46 |
||
| truncating timestamps on arbitrary intervals | 2474 | Moved to next CF | Not processed | John Naylor (john.naylor) | Peter Eisentraut (petere) | petere | 6 | 2021-03-24 15:39 |
2021-04-01 16:08 |
||
| jsonpath syntax extensions | 2482 | Moved to next CF | 15 | Not processed | Nikita Glukhov (n.glukhov) | 12 | 2023-02-13 18:18 |
2022-03-31 19:21 |
|||
| Auto-analyze on partitioned tables | 2492 | Moved to next CF | Not processed | Yuzuko Hosoya (yuzu) | Justin Pryzby (justinpryzby) | alvherre | 6 | 2021-04-08 05:54 |
2021-04-08 15:27 |
||
| ALTER SYSTEM READ { ONLY | WRITE } | 2602 | Moved to next CF | Not processed | Amul Sul (sulamul) | 9 | 2022-01-10 04:22 |
2021-12-01 04:59 |
||||
| Enabling data checksums in an online cluster | 2611 | Moved to next CF | Not processed | Magnus Hagander (mha), Daniel Gustafsson (d_gustafsson) | 5 | 2021-03-09 19:10 |
2021-03-09 19:09 |
||||
| Non-volatile WAL buffer | 2615 | Moved to next CF | Not processed | Takashi Menjo (tmenjo) | 6 | 2021-06-18 06:46 |
2021-03-09 07:23 |
||||
| Implement <null treatment> for window functions | 2628 | Moved to next CF | 15 | Not processed | 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 | 2650 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Fujii Masao (masaofujii), Alexey Kondratov (ololobus) | masaofujii | 4 | 2021-04-02 10:48 |
2021-04-02 10:47 |
||
| Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away | 2651 | Moved to next CF | Not processed | Bharath Rupireddy (bharathrupireddy) | Fujii Masao (masaofujii), Ashutosh Bapat (ashutoshbapat) | masaofujii | 2 | 2020-10-06 01:55 |
2020-10-06 01:54 |
||
| Add a feature that enables row-wise comparison partition pruning | 2654 | Moved to next CF | Not processed | sho kato (kato-sho) | Anastasia Lubennikova (lubennikovaav), ahsan hadi (ahsan.hadi) | 4 | 2021-04-08 15:04 |
2021-04-08 15:04 |
|||
| Adding Support for Copy callback functionality on COPY TO api | 2660 | Returned with feedback | Not processed | Bilva Sanaba (bilvas) | Soumyadeep Chakraborty (soumyadeepc) | 1 | 2020-09-30 07:41 |
2022-10-11 02:55 |
|||
| Switch to multi-inserts for pg_depend | 2673 | Committed | 14 | Not processed | Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson) | Álvaro Herrera (alvherre) | michael-kun | 1 | 2020-09-11 14:38 |
2020-09-05 13:21 |
|
| Rename >^ and <^ operators for points to |>> and <<| to be consistent with the same operators for boxes | 2689 | Moved to next CF | Not processed | Emre Hasegeli (hasegeli) | Pavel Borisov (pborisov) | tgl | 2 | 2020-11-23 16:39 |
2020-11-23 16:39 |
||
| Prepare for deprecate clientcert=no-verify in pg_hba.conf | 2708 | Moved to next CF | Not processed | Kyotaro Horiguchi (horiguti) | bmomjian | 2 | 2020-10-05 20:34 |
2020-10-06 02:31 |
|||
| ALTER TABLE .. DETACH PARTITION CONCURRENTLY | 2714 | Moved to next CF | Not processed | Álvaro Herrera (alvherre) | Anastasia Lubennikova (lubennikovaav), Justin Pryzby (justinpryzby) | alvherre | 4 | 2021-03-25 21:32 |
2021-03-31 18:30 |
||
| remove spurious CREATE INDEX CONCURRENTLY wait | 2720 | Withdrawn | Not processed | Álvaro Herrera (alvherre) | 1 | 2020-09-01 17:56 |
2020-12-01 01:00 |
||||
| SQL Commands | |||||||||||
| SQL/JSON: functions | 1472 | Returned with feedback | Not processed | Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Nikita Glukhov (n.glukhov), Oleg Bartunov (oleg) | Pavel Stehule (okbobcz), Andrew Dunstan (adunstan), Gerdan Santos (gerdan), Andrew Alsup (ahalsup) | 13 | 2020-09-17 05:41 |
2022-04-08 12:15 |
|||
| Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT | 1533 | Moved to next CF | Not processed | 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 |
|||
| SQL:2011 application time | 2048 | Moved to next CF | Not processed | Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) | Peter Eisentraut (petere) | 12 | 2022-02-07 03:18 |
2025-02-17 06:42 |
|||
| range_agg / multiranges | 2112 | Moved to next CF | 14 | Not processed | Paul Jungwirth (pjungwir) | Pavel Stehule (okbobcz), Jeff Davis (jdavis) | smagen | 9 | 2020-12-21 00:29 |
2020-12-27 19:38 |
|
| 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 | 2022-10-12 07:49 |
2022-10-12 07:53 |
||
| Allow an alias to be attached directly to a JOIN ... USING | 2158 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Tom Lane (tgl) | petere | 10 | 2021-03-31 15:41 |
2021-03-31 15:49 |
||
| FETCH FIRST clause PERCENT option | 2176 | Moved to next CF | Not processed | Surafel Temesgen (surafel) | 12 | 2021-10-03 16:16 |
2021-09-30 18:31 |
||||
| Implement INSERT SET syntax | 2218 | Moved to next CF | Not processed | 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 | 2269 | Moved to next CF | Not processed | 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 |
||
| extension patch of CREATE OR REPLACE TRIGGER | 2307 | Moved to next CF | Not processed | Takamichi Osumi (tatatappp) | Surafel Temesgen (surafel), Philippe BEAUDOIN (beaud76), Peter Smith (smithpb2250) | tgl | 6 | 2020-11-14 22:05 |
2020-11-14 22:07 |
||
| WITH SYSTEM VERSIONING Temporal Tables | 2316 | Moved to next CF | Not processed | Surafel Temesgen (surafel) | Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre) | 11 | 2021-11-16 12:31 |
2021-11-16 12:31 |
|||
| window function improvements WIP | 2419 | Returned with feedback | Not processed | Krasiyan Andreev (krasiyan) | Cleysson Lima (cleyssonlima) | 3 | 2020-09-17 05:38 |
2020-09-17 05:38 |
|||
| Add MAIN_RELATION_CLEANUP and TOAST_TABLE_CLEANUP options to VACUUM | 2426 | Returned with feedback | Not processed | Nathan Bossart (bossartn) | Kirk Jamison (kirkjamison) | 3 | 2020-09-17 05:04 |
2021-02-09 17:43 |
|||
| Rational number type (fractions) | 2441 | Rejected | 14 | Not processed | Joe Nelson (begriffs) | 3 | 2020-09-04 08:13 |
2020-09-04 08:12 |
|||
| Allow COPY "text" to output a header and add header matching mode to COPY FROM | 2504 | Returned with feedback | Not processed | Rémi Lapeyre (remilapeyre) | Daniel Vérité (danielverite), vigneshwaran C (vignesh.postgres) | 2 | 2020-09-29 06:17 |
2022-03-30 07:11 |
|||
| Return ERROR on COMMIT instead of silently ROLLBACK | 2522 | Moved to next CF | Not processed | Dave Cramer (dcramer) | Laurenz Albe (laurenz) | 5 | 2021-03-25 19:24 |
2021-03-25 19:23 |
|||
| SEARCH and CYCLE clauses | 2570 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Pavel Stehule (okbobcz), Vik Fearing (xocolatl) | petere | 5 | 2021-02-01 18:03 |
2021-02-27 07:16 |
||
| REINDEX of partitioned tables | 2584 | Moved to next CF | 14 | Not processed | Justin Pryzby (justinpryzby) | Michael Paquier (michael-kun), Anastasia Lubennikova (lubennikovaav), Jie Li (adger) | michael-kun | 3 | 2020-10-06 04:44 |
2020-10-06 04:38 |
|
| SQL-standard function body | 2630 | Moved to next CF | Not processed | Peter Eisentraut (petere) | Julien Rouhaud (rjuju) | petere | 5 | 2021-04-07 19:56 |
2021-04-08 11:19 |
||
| Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... | 2635 | Returned with feedback | Not processed | Marina Polyakova (whipping.top1991), Anna Akenteva (a.akenteva) | Laurenz Albe (laurenz) | 1 | 2020-09-30 07:26 |
2020-09-30 11:33 |
|||
| Keywords as column aliases without explicit preceding AS | 2641 | Committed | Not processed | Mark Dilger (mark.dilger) | John Naylor (john.naylor) | tgl | 1 | 2020-09-18 20:47 |
2020-09-19 19:20 |
||
| Allow queries in WHEN expression of FOR EACH STATEMENT triggers | 2648 | Moved to next CF | Not processed | Joe Wildish (joewildish) | 2 | 2021-01-13 20:57 |
2021-09-23 20:02 |
||||
| psql: add \si, \sm, \st and \sr functions to show CREATE commands for indexes, matviews, triggers and tables | 2664 | Moved to next CF | Not processed | Alexandra Pervushina (a.pervushina) | Anna Akenteva (a.akenteva) | 2 | 2020-11-24 10:05 |
2020-11-24 10:04 |
|||
| Change return type of EXTRACT to numeric | 2679 | Moved to next CF | Not processed | Peter Eisentraut (petere) | petere | 3 | 2021-04-06 05:46 |
2021-04-06 05:48 |
|||
| Automatic HASH and LIST partition creation | 2694 | Moved to next CF | Not processed | Anastasia Lubennikova (lubennikovaav) | Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) | 7 | 2021-12-02 11:20 |
2021-12-02 11:20 |
|||
| Support for OUT parameters in procedures | 2703 | Moved to next CF | Not processed | Peter Eisentraut (petere) | petere | 2 | 2020-10-05 18:28 |
2020-10-05 22:21 |
|||
| Allow CURRENT_ROLE in GRANTED BY | 2704 | Committed | Not processed | Peter Eisentraut (petere) | petere | 1 | 2020-09-17 10:24 |
2021-01-30 08:51 |
|||
| 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 | 2024-01-22 01:15 |
2024-01-22 01:16 |
|||
| Set host(no)ssl settings from initdb | 2378 | Returned with feedback | Not processed | David Fetter (dfetter) | Vik Fearing (xocolatl), Takayuki Tsunakawa (maumau), Cary Huang (cary) | 4 | 2020-09-07 02:58 |
2021-03-09 00:47 |
|||
| Allow backslash continuations in "pg_hba.conf' files | 2519 | Committed | Not processed | Fabien Coelho (calvin) | Justin Pryzby (justinpryzby), David Zhang (david.z) | tgl | 2 | 2020-09-03 16:17 |
2020-09-04 15:00 |
||
| extend amcheck module to check heaps | 2670 | Moved to next CF | 14 | Not processed | Mark Dilger (mark.dilger) | Robert Haas (rhaas) | rhaas | 4 | 2021-03-15 14:26 |
2021-04-07 20:16 |
|