Commitfest 2021-09

Shortcuts
Text Status Target version Author Reviewer
Clear


Status summary: Committed: 54. Moved to next CF: 209. Withdrawn: 2. Rejected: 3. Returned with Feedback: 49. Total: 317.

Closed patches

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
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
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
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
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
Removing unused trailing linepointers from heap pages Moved to next CF Matthias van de Meent (mmeent) 3 2021-12-02
10:18
2022-04-08
11:38
Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Moved to next CF Bertrand Drouvot (bdrouvot), Minsoo (Mike) Oh (minsoo1) Masahiko Sawada (masahikosawada), ahsan hadi (ahsan.hadi) amitkapila 7 2022-08-12
13:35
2022-08-29
06:17
Eliminating "Permission denied" errors on stat() (on Windows) Moved to next CF Alexander Lakhin (law) 4 2021-12-03
12:51
2021-12-03
03:00
generate fractional cheapest paths in generate_orderedappend_paths Moved to next CF Tomas Vondra (fuzzycz) Arne Roland (harks) fuzzycz 4 2022-01-12
23:16
2022-03-22
00:33
psql: exclude valid constraints in tab-complete for ALTER TABLE .. VALIDATE CONSTRAINT Moved to next CF David Fetter (dfetter) Aleksander Alekseev (aalekseev) tgl 4 2022-01-03
23:14
2022-01-03
23:15
Support of time zone patterns - of, tzh and tzm Moved to next CF Nitin Jadhav (nitinjadhav11) David Zhang (david.z) rhaas 5 2022-03-14
20:52
2022-03-15
09:32
Incorrect snapshots while promoting hot standby node when 2PC is used Moved to next CF stable Michael Paquier (michael-kun) michael-kun 3 2021-11-23
13:08
2021-11-22
16:50
Update Toast data failure in logical replication Moved to next CF Dilip Kumar (dilip.kumar) Euler Taveira (eulerto), Haiying Tang (tanghy) amitkapila 5 2022-02-16
02:55
2022-02-15
03:20
Extended protocol COPY FROM STDIN fix Moved to next CF Jeff Davis (jdavis) 3 2021-12-01
10:59
2021-12-01
10:59
Fix numeric power for negative bases and other corner cases Moved to next CF Dean Rasheed (deanr) Yugo Nagata (yugo.nagata) deanr 3 2021-10-06
12:40
2021-10-01
14:25
Fix pgbench's exit status and log messages for connection failures Moved to next CF stable Fabien Coelho (calvin), Yugo Nagata (yugo.nagata) masaofujii 3 2021-11-02
14:12
2021-11-04
00:31
Fix uninitialized variable access (freepages) Moved to next CF 15 Ranier Vilela (raniervilela) Greg Nancarrow (gregn1234), David Zhang (david.z) 4 2022-03-14
19:15
2022-03-14
19:30
Fix handling of outer GroupingFunc within subqueries Moved to next CF Richard Guo (richardguo) Tom Lane (tgl), Platon Pronko (rogach) tgl 4 2022-03-21
21:45
2022-03-21
21:09
corruption of WAL page header is never reported Moved to next CF stable Yugo Nagata (yugo.nagata) Fujii Masao (masaofujii) masaofujii 2 2021-10-05
15:19
2021-10-05
15:18
pgbench: using prepared BEGIN statement in a pipeline could cause an error Moved to next CF 15 Yugo Nagata (yugo.nagata) Kyotaro Horiguchi (horiguti), Fabien Coelho (calvin), Daniel Gustafsson (dege) alvherre 9 2023-02-21
15:39
2023-02-21
16:32
Fix postgres_fdw's ORDER BY pushdown handling Moved to next CF Ronan Dunklau (rdunklau) Tom Lane (tgl), David Zhang (david.z) tgl 4 2022-03-31
18:51
2022-03-31
18:51
Error out if SKIP LOCKED and WITH TIES are both specified Moved to next CF stable David Christensen (davidchristensen) alvherre 2 2023-03-06
15:41
2021-10-02
17:24
pg_dump handling of ALTER DEFAULT PRIVILEGES IN SCHEMA Moved to next CF stable Masahiko Sawada (masahikosawada), Nathan Bossart (bossartn) Muhammad Usama (muhammad_usama) tgl 2 2021-10-22
19:23
2021-10-22
20:14
Do not start bgworker processes during binary upgrade Moved to next CF Denis Laxalde (dlax) Daniel Gustafsson (d_gustafsson), Julien Rouhaud (rjuju) 4 2022-03-14
21:13
2022-03-14
21:12
Fix ATTACH/DETACH PARTITION to invalidate partitions of table being attached/detached Moved to next CF stable Álvaro Herrera (alvherre), Amit Langote (amitlan) Maxim Orlov (m.orlov), Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) alvherre 2 2021-10-19
23:17
2021-10-19
01:23
Check for STATUS_DELETE_PENDING on Windows Moved to next CF Thomas Munro (macdice) macdice 3 2021-12-10
03:34
2021-12-10
03:25
Clients
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
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
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
pg_dump new feature: exporting functions only Moved to next CF 15 Lætitia AVROT (arkhena) ahsan hadi (ahsan.hadi), Ryan Lambert (ryanlambert) 5 2022-04-07
05:43
2022-04-08
06:36
Add option --drop-cascade for pg_dump/restore Moved to next CF Wu Haotian (whtsky) Greg Sabino Mullane (greg) 3 2021-12-01
10:46
2021-12-01
10:45
test pgbench time-related features Moved to next CF 15 Fabien Coelho (calvin) 2 2021-12-02
12:40
2021-12-02
12:40
Tab completion for CREATE SCHEMA AUTHORIZATION Moved to next CF Dagfinn Ilmari Mannsåker (ilmari) Suraj Khamkar (suraj.khamkar) 2 2021-12-03
01:18
2023-06-30
09:33
functions to compute size of schemas/AMs (and maybe \dn++ and \dA++) Moved to next CF Justin Pryzby (justinpryzby) 13 2024-04-08
14:06
2024-01-22
00:10
improve tab-completion behavior when parse text in single quote Moved to next CF Haiying Tang (tanghy) 2 2021-12-03
06:17
2021-12-03
06:16
Allow escape sequence in application_name Moved to next CF Hayato Kuroda (ha-kun) Fujii Masao (masaofujii) masaofujii 3 2021-12-24
08:03
2022-01-04
05:03
psql: add xheader_width option to handle very long record lines Moved to next CF Platon Pronko (rogach) Andrew Dunstan (adunstan) adunstan 5 2022-07-25
18:27
2022-07-25
18:27
psql: \dl+ to list large objects privileges Moved to next CF Pavel Luzanov (pluzanov) Daniel Gustafsson (d_gustafsson), Georgios Kokolatos (gkokolatos) tgl 3 2022-01-06
18:09
2022-01-06
20:50
Documentation
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
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
fix ICU explorer link in locale documentation Moved to next CF Anton Voloshin (a.voloshin) Laurenz Albe (laurenz) bmomjian 3 2021-11-02
19:44
2021-11-03
00:33
Improve documentation for pg_upgrade, standbys and rsync Moved to next CF 15 Laurenz Albe (laurenz) David Fetter (dfetter) 5 2022-04-08
05:15
2022-04-08
05:14
Consistent use of SSL/TLS in docs Moved to next CF Daniel Gustafsson (d_gustafsson) Robert Haas (rhaas), Lætitia AVROT (arkhena) d_gustafsson 5 2022-03-30
11:44
2022-03-30
11:43
Fix documentation for COPY protocol flow Moved to next CF Jeff Davis (jdavis) 3 2021-12-01
14:18
2021-12-01
10:59
Document pg_encoding_to_char() and pg_char_to_encoding() Moved to next CF 15 Ian Barwick (barwick) Fujii Masao (masaofujii) masaofujii 2 2021-10-05
04:00
2021-10-05
03:55
Miscellaneous
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
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
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
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
Add some tests for pg_stat_statements compatibility verification Moved to next CF Erica Zhang (zerica) Julien Rouhaud (rjuju) michael-kun 3 2021-10-02
08:44
2021-10-04
05:08
Allow multiple recursive self-references Moved to next CF Denis Hirn (brainy) Peter Eisentraut (petere) 6 2022-08-02
21:01
2022-04-23
15:14
Avoid orphaned dependencies Moved to next CF 16 Bertrand Drouvot (bdrouvot) Ronan Dunklau (rdunklau) 6 2022-08-02
21:03
2022-03-30
19:18
Extending amcheck to check toast size and compression Moved to next CF Mark Dilger (mark.dilger) Greg Stark (stark), Aleksander Alekseev (aalekseev) michael-kun 3 2021-11-18
04:43
2021-11-06
08:04
Rewriting the test of pg_upgrade as a TAP test - take three Moved to next CF Michael Paquier (michael-kun) 3 2021-11-18
07:49
2022-04-02
03:10
TAP test for contrib/sslinfo Moved to next CF Daniel Gustafsson (d_gustafsson) Tom Lane (tgl) d_gustafsson 3 2021-11-30
10:53
2021-11-30
10:52
Change internal PRNG (from rand48 to something better, with a cleaner interface) Moved to next CF 15 Fabien Coelho (calvin) Aleksander Alekseev (aalekseev) tgl 3 2021-11-29
02:34
2021-11-30
07:37
btree_gist: Support bool Moved to next CF Emre Hasegeli (hasegeli) fuzzycz 3 2021-11-06
16:07
2021-11-08
01:24
Use tuple-level SIREAD locks for index-only scans Moved to next CF Thomas Munro (macdice) 3 2021-12-02
10:37
2021-12-02
10:37
Fully WAL logged CREATE DATABASE - No Checkpoints Moved to next CF Dilip Kumar (dilip.kumar) Ashutosh Sharma (ashu_coek) rhaas 5 2022-03-29
17:10
2022-04-04
10:24
Expose get_query_def() Moved to next CF Julien Rouhaud (rjuju) Pavel Stehule (okbobcz), Gilles Darold (darold) tgl 5 2022-03-28
15:20
2022-03-28
15:48
pgbench: add multiconnect support Moved to next CF 16 David Christensen (davidchristensen) Jelte Fennema-Nio (jeltef) 9 2023-03-06
15:38
2023-01-31
17:30
disallow external access to MaxBackends Moved to next CF Nathan Bossart (bossartn) Greg Sabino Mullane (greg) michael-kun 4 2022-02-10
19:29
2022-05-16
13:25
Allow special values in GUC configurations Moved to next CF 16 David Christensen (davidchristensen) Cary Huang (cary) 4 2023-03-06
15:40
2022-03-22
19:04
Add PGDLLIMPORT to all direct or indirect GUC variables Moved to next CF 15 Robert Haas (rhaas), Julien Rouhaud (rjuju) rhaas 4 2022-04-08
12:43
2022-04-06
23:56
Showing I/O timings spent reading/writing temp buffers in EXPLAIN Moved to next CF 15 Masahiko Sawada (masahikosawada) Julien Rouhaud (rjuju), Melanie Plageman (melanieplageman), Georgios Kokolatos (gkokolatos) michael-kun 4 2022-04-08
04:20
2022-04-08
05:19
Monitoring & Control
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
pg_stat_statements and "IN" conditions Moved to next CF Dmitry Dolgov (erthalion) Nathan Bossart (bossartn), David Geier (geidav), Chengxi Sun (martin-sun) 18 2024-04-09
06:28
2024-04-23
08:18
Add system views pg_permissions and pg_ownerships Moved to next CF Joel Jacobson (joeljacobson) 5 2022-04-08
13:38
2022-03-10
21:02
pg_stat_statements: Track statement entry timestamp Moved to next CF 17 Andrei Zubkov (zubkov) Alena Rybakina (a.rybakina) smagen 13 2023-11-27
00:53
2023-11-29
07:00
Logging plan of the currently running query Moved to next CF 16 atsushi torikoshi (atorik) Fujii Masao (masaofujii), Justin Pryzby (justinpryzby), James Coleman (jcole1989), Ekaterina Sokolova (e.sokolova), Alena Rybakina (a.rybakina) 9 2023-06-06
06:47
2024-03-26
02:34
Log the activity of startup process Moved to next CF 15 Nitin Jadhav (nitinjadhav) Justin Pryzby (justinpryzby), Bharath Rupireddy (bharathrupireddy) rhaas 2 2021-11-06
15:48
2023-02-10
23:25
Add system view tracking shared buffer actions Moved to next CF 16 Melanie Plageman (melanieplageman) Justin Pryzby (justinpryzby) andresfreund 9 2023-02-12
17:27
2023-04-05
00:41
Trap SIGCHLD in pg_basebackup to exit early on stream child failure Moved to next CF Daniel Gustafsson (d_gustafsson) Magnus Hagander (mha), Bharath Rupireddy (bharathrupireddy) d_gustafsson 4 2022-02-23
19:58
2022-02-23
19:58
Performance
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
2023-10-23
11:29
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
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
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
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
fix spinlock contention in LogwrtResult Moved to next CF Álvaro Herrera (alvherre) 11 2022-09-23
08:50
2024-04-08
16:13
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
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
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
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
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
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
partial heap only tuples Moved to next CF 15 Nathan Bossart (bossartn) 4 2021-11-04
10:23
2021-11-10
17:17
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
Make relfile tombstone files conditional on WAL level Moved to next CF Thomas Munro (macdice) 3 2021-10-29
03:56
2023-01-06
06:13
More sort-related specialisation Moved to next CF Thomas Munro (macdice) John Naylor (john.naylor) john.naylor 5 2022-04-04
02:14
2022-04-06
10:31
add explicit partial union-all and improve parallel subquery costing Moved to next CF Luc Vlaming (luc.vlaming) Ronan Dunklau (rdunklau) 3 2021-12-02
14:10
2021-12-02
14:10
Lazy JIT IR code generation to increase JIT speed with partitions Moved to next CF David Geier (geidav), Luc Vlaming (luc.vlaming) Dmitry Dolgov (erthalion) 9 2023-01-27
09:03
2023-01-30
09:13
Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation Moved to next CF 15 Matthias van de Meent (mmeent) 4 2022-02-07
02:41
2021-12-02
10:21
Use simplehash.h instead of dynahash in SMgr Moved to next CF David Rowley (davidrowley) Yura Sokolov (funny_falcon) 3 2021-12-03
06:55
2021-12-03
06:55
Toast compression method options Moved to next CF Dilip Kumar (dilip.kumar) 3 2021-10-01
09:12
2021-10-01
09:11
Parallel INSERT SELECT take 2 Moved to next CF Greg Nancarrow (gregn1234), Hou Zhijie (houzj) 6 2022-07-28
15:51
2022-07-28
15:51
pre-allocating WAL files Moved to next CF 16 Nathan Bossart (bossartn) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) 6 2022-07-25
16:24
2022-07-25
16:24
Add proper planner support for ORDER BY / DISTINCT aggregates Moved to next CF David Rowley (davidrowley) Ronan Dunklau (rdunklau), Richard Guo (richardguo) davidrowley 7 2022-08-02
12:47
2022-08-17
23:38
Map WAL segment files on PMEM as WAL buffers Moved to next CF Takashi Menjo (tmenjo) 6 2022-08-01
20:40
2022-03-23
08:58
Write visibility map during CLUSTER/VACUUM FULL Moved to next CF Alexander Korotkov (smagen), Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva), Anna Akenteva (a.akenteva) Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) 6 2022-06-30
18:24
2022-06-30
18:25
Don't block HOT update by BRIN index Moved to next CF Josef Šimánek (retro) Tomas Vondra (fuzzycz) fuzzycz 3 2021-11-30
19:14
2021-12-01
10:31
Speed up LockReleaseAll Moved to next CF David Rowley (davidrowley) 3 2021-12-03
07:36
2024-01-09
06:24
Fix ExecRTCheckPerms() inefficiency with many prunable partitions Moved to next CF 16 Amit Langote (amitlan) Álvaro Herrera (alvherre), Tom Lane (tgl) alvherre 8 2022-12-06
19:34
2023-06-30
06:54
Window function run conditions Moved to next CF David Rowley (davidrowley) davidrowley 5 2022-04-07
23:16
2022-04-07
22:40
Using each rel as both outer and inner for anti-joins Moved to next CF Richard Guo (richardguo) Ronan Dunklau (rdunklau) tgl 9 2023-04-05
20:59
2023-04-07
07:28
Postgres picks suboptimal index after building extended statistics Moved to next CF 14 Andrei Lepikhov (lepikhov) 7 2022-11-24
04:38
2022-11-22
17:14
Parallelize correlated subqueries that execute within each worker Moved to next CF James Coleman (jcole1989) Akshat Jaimini (akshatj) 14 2024-04-08
14:18
2024-02-01
02:11
Cache tuple routing info during bulk loads into partitioned tables Moved to next CF David Rowley (davidrowley), Amit Langote (amitlan), Hou Zhijie (houzj) Álvaro Herrera (alvherre), David Rowley (davidrowley) davidrowley 6 2022-08-01
22:00
2022-08-02
07:19
KnownAssignedXidsGetAndSetXmin performance Moved to next CF Michail Nikolaev (nkey) Kirill Reshke (reshke), Andrey Borodin (x4mmm) 6 2022-11-15
17:19
2022-11-30
06:53
Push down time-related SQLValue functions to foreign server Moved to next CF 15 Alexander Pyhalov (a.pyhalov) 5 2022-08-02
20:59
2022-01-21
19:57
mitigate O(n^2) behavior of WAL archiver process Moved to next CF 15 Nathan Bossart (bossartn), Dipesh Pandit (dpandit) Nathan Bossart (bossartn) rhaas 2 2021-11-11
21:05
2021-11-11
21:12
Optimize parallel tuple queue Moved to next CF Dilip Kumar (dilip.kumar) rhaas 2 2021-10-26
09:02
2021-10-26
09:03
Asynchronous and "direct" IO support for PostgreSQL Moved to next CF Andres Freund (andresfreund), David Rowley (davidrowley), Thomas Munro (macdice) 6 2022-10-12
05:45
2022-10-12
05:45
Procedural Languages
session variables, LET command Moved to next CF Pavel Stehule (okbobcz) Fabien Coelho (calvin), Julien Rouhaud (rjuju), Gilles Darold (darold), Dmitry Dolgov (erthalion), Justin Pryzby (justinpryzby), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv) 31 2024-04-09
06:30
2024-04-11
05:34
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
proposal of adding 2 new diag items related to parsing the dynamic sql statement Moved to next CF Dinesh Chemuduru (dineshc) Pavel Stehule (okbobcz) 2 2021-12-03
07:39
2022-08-02
22:55
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
Rework the sslfiles Makefile target Moved to next CF Jacob Champion (jchampion) Michael Paquier (michael-kun), Daniel Gustafsson (d_gustafsson) d_gustafsson 3 2021-10-19
18:22
2021-10-19
18:25
Extend portability of client_connection_check_interval Moved to next CF Thomas Munro (macdice) Maksim Milyutin (maksm90) macdice 5 2022-02-14
04:16
2022-02-14
04:15
psql - refactor echo code Moved to next CF Fabien Coelho (calvin) Pavel Stehule (okbobcz), Peter Eisentraut (petere) 10 2023-04-03
20:03
2023-04-03
20:03
A micro-optimisation for ProcSendSignal() Moved to next CF Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) macdice 4 2021-12-16
03:02
2021-12-16
03:00
Split xlog.c Moved to next CF Heikki Linnakangas (heikki) 3 2021-11-15
10:11
2021-11-24
19:44
automatically generating node support functions Moved to next CF Peter Eisentraut (petere) Tom Lane (tgl) petere 6 2022-07-09
14:37
2022-08-09
13:16
improvements in Unicode tables generation code Moved to next CF Peter Eisentraut (petere) petere 3 2021-10-04
18:32
2021-10-04
18:36
Extensible storage manager API - smgr hooks Moved to next CF Anastasia Lubennikova (lubennikovaav) 5 2022-03-22
00:20
2022-03-22
00:20
Some RELKIND macro refactoring Moved to next CF Peter Eisentraut (petere) Michael Paquier (michael-kun) petere 3 2021-12-03
13:13
2021-12-03
13:12
Replication & Recovery
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
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
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
Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation Moved to next CF Bharath Rupireddy (bharathrupireddy) Daniel Gustafsson (d_gustafsson), vigneshwaran C (vignesh.postgres) d_gustafsson 3 2021-11-17
13:43
2021-11-17
13:43
tablesync early exit Moved to next CF 15 Peter Smith (smithpb2250) 6 2022-04-05
04:09
2022-04-05
05:55
A test for replay of regression tests Moved to next CF Thomas Munro (macdice) Anastasia Lubennikova (lubennikovaav) macdice 4 2022-01-19
22:47
2022-02-02
03:14
avoid logical replication empty transactions Moved to next CF 15 Euler Taveira (eulerto), Ajin Cherian (ajinc) vigneshwaran C (vignesh.postgres), Peter Smith (smithpb), Greg Nancarrow (gregn1234) amitkapila 5 2022-03-31
19:19
2022-03-30
08:30
Replicates changes for all tables in schema Moved to next CF 15 vigneshwaran C (vignesh.postgres) Greg Nancarrow (gregn1234), Haiying Tang (tanghy), Mark Dilger (mark.dilger), Hou Zhijie (houzj), Rahila Syed (rahila) amitkapila 3 2021-11-16
04:40
2021-11-16
04:44
Detectable crashes and unlogged table resets Moved to next CF Jeff Davis (jdavis) 5 2022-03-07
01:41
2022-03-05
10:33
Skipping logical replication transactions on subscriber side Moved to next CF Masahiko Sawada (masahikosawada) vigneshwaran C (vignesh.postgres), Greg Nancarrow (gregn1234), Mark Dilger (mark.dilger), Hou Zhijie (houzj) amitkapila 5 2022-03-29
05:10
2022-04-07
11:39
Allow providing restore_command as a command line option to pg_rewind Moved to next CF Alexey Kondratov (ololobus) Andrey Borodin (x4m) 5 2022-04-07
05:52
2022-04-07
05:53
PITR enhance getRecordTimestamp() Moved to next CF Simon Riggs (simon) 8 2022-09-16
12:37
2022-01-31
19:11
Column filtering in logical replication Moved to next CF 15 Álvaro Herrera (alvherre), Rahila Syed (rahila.syed), Tomas Vondra (fuzzycz) Álvaro Herrera (alvherre), Peter Eisentraut (petere), vigneshwaran C (vignesh.postgres) fuzzycz 5 2022-03-26
18:21
2022-03-30
12:01
Teach pg_receivewal to use lz4 compression Moved to next CF 15 Georgios Kokolatos (gkokolatos) Michael Paquier (michael-kun) michael-kun 3 2021-11-05
04:39
2021-11-24
11:54
parse_subscription_options - some suggested improvements Moved to next CF 15 Peter Smith (smithpb2250) Nathan Bossart (bossartn) michael-kun 3 2021-12-08
17:34
2021-12-08
04:09
schema change not getting invalidated, both renamed table and new table data were getting replicated Moved to next CF vigneshwaran C (vignesh.postgres) Tom Lane (tgl) tgl 8 2023-01-06
16:12
2023-01-06
16:21
Security
Improve sepgsql logging so it follows the behaviour of selinux's logging. Moved to next CF Dave Page (dpage) Jacob Champion (jchampion) tgl 4 2022-01-12
19:24
2022-01-12
19:24
Support for NSS as a libpq TLS backend Moved to next CF Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) Joshua Brindle (joshuab) 5 2022-02-23
10:32
2022-02-04
20:18
Delegating superuser tasks to new security roles Moved to next CF 15 Mark Dilger (mark.dilger) Andrew Dunstan (adunstan), Nathan Bossart (bossartn) 3 2021-11-15
20:47
2021-11-01
22:42
Kerberos delegation support in libpq and postgres_fdw Moved to next CF Peifeng Qiu (pqiu) 2 2021-11-26
13:42
2023-04-08
02:00
Server Features
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
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) 16 2024-04-09
06:21
2024-03-25
11:09
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
jsonpath syntax extensions Moved to next CF 15 Nikita Glukhov (n.glukhov) 12 2023-02-13
18:18
2022-03-31
19:21
ALTER SYSTEM READ { ONLY | WRITE } Moved to next CF Amul Sul (sulamul) 9 2022-01-10
04:22
2021-12-01
04:59
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
New Table Access Methods for Multi and Single Inserts Moved to next CF Bharath Rupireddy (bharathrupireddy) 9 2022-10-12
05:31
2024-04-25
16:41
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
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
Add regexp_positions(string text, pattern text, flags text) → setof record (starts integer[], lengths integer[]) Moved to next CF Joel Jacobson (joeljacobson) Tom Lane (tgl) 3 2021-12-03
08:46
2021-09-21
17:55
PROXY protocol support Moved to next CF Magnus Hagander (mha) Jacob Champion (jchampion), wilfried roset (wilfriedroset), Julien Riou (riouj) 7 2022-10-12
05:27
2022-07-28
20:05
Extended statistics in EXPLAIN Moved to next CF Tomas Vondra (fuzzycz) Tatsuro Yamada (tatsuro_yamada) 6 2022-08-01
20:38
2022-01-18
11:31
Merging statistics from children instead of re-sampling everything Moved to next CF Tomas Vondra (fuzzycz) 5 2022-04-08
13:24
2022-02-18
11:50
Add missing function abs (interval) Moved to next CF Isaac Morland (ijmorlan) Tom Lane (tgl) 3 2021-12-03
07:41
2021-12-03
07:41
estimating joins using extended statistics Moved to next CF Tomas Vondra (fuzzycz) Andy Fan (andyf) 4 2022-02-07
03:20
2022-01-19
10:18
Add callback table access method to reset filenode when dropping relation Moved to next CF Mats Kindahl (matski) Aleksander Alekseev (a.alekseev), Alexander Kuzmenkov (akuzmenkov) 7 2022-10-12
07:38
2022-10-12
07:39
Asymmetric partition-wise JOIN Moved to next CF 15 KaiGai Kohei (kaigai), Andrei Lepikhov (lepikhov) Alexander Pyhalov (a.pyhalov) 7 2022-10-12
05:27
2022-01-17
10:42
Extensible parsing Moved to next CF 15 Julien Rouhaud (rjuju) 4 2022-01-17
00:33
2022-01-17
00:33
logical decoding and replication of sequences Moved to next CF Tomas Vondra (fuzzycz) Peter Eisentraut (petere) fuzzycz 5 2022-03-24
22:07
2022-08-29
21:42
Range Merge Join Moved to next CF 15 Thomas Mannhart (thomasmannhart97) 4 2022-02-07
03:12
2022-01-17
07:39
pg_stats and range statistics Moved to next CF 17 Egor Rogov (egorius) Tomas Vondra (fuzzycz), Soumyadeep Chakraborty (soumyadeepc) smagen 13 2023-11-27
00:54
2023-11-25
16:57
PoC: improving join estimates using sampling Moved to next CF Tomas Vondra (fuzzycz) 5 2022-03-22
00:25
2022-03-22
00:17
Cleaning up orphaned files using undo logs Moved to next CF Antonin Houska (a.houska) Dmitry Dolgov (erthalion) 4 2022-02-07
03:08
2022-01-12
08:27
Automatic notification of top transaction IDs Moved to next CF Gurjeet Singh (gurjeet) Cary Huang (cary) 3 2021-11-04
13:05
2021-11-04
15:01
Gather partial paths for subproblem's topmost scan/join rel Moved to next CF Richard Guo (richardguo) Antonin Houska (a.houska) tgl 5 2022-07-30
17:05
2022-07-30
17:15
Tags in errordata Moved to next CF 15 Ronan Dunklau (rdunklau) Greg Stark (stark), Justin Pryzby (justinpryzby) 4 2022-04-07
06:44
2022-04-07
06:44
Preserving db/ts/relfilenode OIDs across pg_upgrade Moved to next CF Antonin Houska (a.houska), Shruthi Gowda (shruthi) Robert Haas (rhaas), Rushabh Lathia (rlathia) rhaas 4 2022-03-22
15:38
2022-06-16
23:24
Support pg_ident mapping for LDAP Moved to next CF Jacob Champion (jchampion) Magnus Hagander (mha) 5 2022-08-17
17:16
2022-02-17
19:15
SQL Commands
SQL:2011 application time Moved to next CF Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) Peter Eisentraut (petere) 12 2022-02-07
03:18
2024-04-26
19:41
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
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
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
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
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
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
2023-07-13
06:49
Dynamic result sets from procedures Moved to next CF Peter Eisentraut (petere) 12 2023-10-30
09:26
2023-02-24
11:26
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
rename column if exists Moved to next CF David Oksman (oks) Yagiz Nizipli (yagiznizipli) 4 2022-01-17
00:30
2022-01-17
00:29
DELETE CASCADE Moved to next CF 15 David Christensen (davidchristensen) 4 2023-03-06
15:40
2022-01-31
16:30
Non-decimal integer literals Moved to next CF Peter Eisentraut (petere) John Naylor (john.naylor) petere 6 2022-12-14
06:13
2023-01-23
21:20
UNIQUE null treatment option Moved to next CF Peter Eisentraut (petere) Vik Fearing (xocolatl), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) petere 4 2022-02-03
10:54
2022-02-03
10:54
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
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
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
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
Reduce lock level for ALTER TABLE ... ADD CHECK Moved to next CF 15 Simon Riggs (simon) Greg Sabino Mullane (greg) 3 2021-11-21
21:05
2021-10-03
16:51
add guc: hugepages_active Moved to next CF Justin Pryzby (justinpryzby), Noriyoshi Shinoda (shinoda) Fujii Masao (masaofujii), Nathan Bossart (bossartn), Justin Pryzby (justinpryzby) michael-kun 7 2023-07-06
06:05
2023-07-06
06:20
Add JSON logging via jsonlog log_destination Moved to next CF 15 Michael Paquier (michael-kun), Sehrope Sarkuni (sehrope) michael-kun 3 2022-01-17
01:22
2022-01-17
02:12