Commitfest 2021-07

Shortcuts
Text Status Target version Author Reviewer
Clear


Status summary: Committed: 81. Moved to next CF: 233. Withdrawn: 20. Returned with Feedback: 2. Rejected: 6. Total: 342.

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) 13 2021-10-01
06:45
2021-09-24
18:14
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-10-01
17:57
2021-03-09
07:25
Corruption during WAL replay Moved to next CF stable Teja Mupparti (tejam) 8 2021-10-04
20:14
2021-09-27
08:30
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
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
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
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
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-10-04
14:48
2021-09-24
14:22
Fix firing of RI triggers during cross-partition updates of partitioned tables Moved to next CF Amit Langote (amitlan) Masahiko Sawada (masahikosawada) 5 2021-10-04
20:14
2021-10-14
09:00
Fix DROP TABLESPACE on Windows with ProcSignalBarrier? Moved to next CF Thomas Munro (macdice) Daniel Gustafsson (d_gustafsson) 4 2021-10-01
11:14
2021-06-14
00:24
Set default transactions to read-only at servers start in pg_upgrade Moved to next CF Denis Laxalde (dlax) Julien Rouhaud (rjuju) 4 2021-10-04
20:14
2021-08-28
01:43
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
Removing unused trailing linepointers from heap pages Moved to next CF Matthias van de Meent (mmeent) 3 2021-10-01
17:58
2021-08-05
16:14
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) 3 2021-10-04
16:24
2021-10-19
06:43
Eliminating "Permission denied" errors on stat() (on Windows) Moved to next CF Alexander Lakhin (law) Michael Paquier (michael-kun) michael-kun 3 2021-10-01
17:59
2021-07-13
18:00
generate fractional cheapest paths in generate_orderedappend_paths Moved to next CF Tomas Vondra (fuzzycz) Arne Roland (harks) 3 2021-10-04
16:28
2021-06-26
15:50
badly calculated width of emoji in psql Moved to next CF Jacob Champion (jchampion) Pavel Stehule (okbobcz) john.naylor 2 2021-08-26
15:07
2021-08-26
15:47
pg_upgrade: copy the source oldestXid Moved to next CF stable Bertrand Drouvot (bdrouvot) bmomjian 2 2021-08-03
12:49
2021-08-15
14:44
Bug fix for tab completion of ALTER TABLE Moved to next CF David Fetter (dfetter) Aleksander Alekseev (aalekseev) 3 2021-10-05
15:55
2021-09-24
13:51
Support of time zone patterns - of, tzh and tzm Moved to next CF Nitin Jadhav (nitinjadhav11) David Zhang (david.z) 3 2021-10-04
20:14
2021-07-09
19:17
Parallel scan with SubTransGetTopmostTransaction assert coredump Moved to next CF Robert Haas (rhaas), Greg Nancarrow (gregn1234), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) Pavel Borisov (pborisov) rhaas 2 2021-08-25
23:25
2021-08-25
13:39
Bug in query rewriter - hasModifyingCTE not getting set Moved to next CF 15 Takayuki Tsunakawa (maumau) Tom Lane (tgl) 2 2021-09-08
14:42
2021-09-08
14:28
Incorrect snapshots while promoting hot standby node when 2PC is used Moved to next CF stable Michael Paquier (michael-kun) michael-kun 3 2021-10-04
05:09
2021-10-06
06:09
Update Toast data failure in logical replication Moved to next CF Dilip Kumar (dilip.kumar) Euler Taveira (eulerto), Haiying Tang (tanghy) 3 2021-10-04
16:24
2021-09-08
06:28
Fix around conn_duration in pgbench Moved to next CF 14 Yugo Nagata (yugo.nagata) Asif Rehman (asifrana) masaofujii 2 2021-09-01
08:08
2021-09-01
09:33
Avoid stuck of pgbench due to skipped transactions Moved to next CF stable Yugo Nagata (yugo.nagata) Greg Sabino Mullane (greg) masaofujii 2 2021-09-09
16:31
2021-09-09
16:30
Extended protocol COPY FROM STDIN fix Moved to next CF Jeff Davis (jdavis) 3 2021-10-04
16:28
2021-07-31
00:09
Fix pkg-config file for static linking Moved to next CF Filip Gospodinov (fil) Peter Eisentraut (petere) petere 2 2021-09-06
07:59
2021-09-06
08:30
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-10-05
15:47
2021-10-08
15:41
ECPG bug fix: allow using connection-associated prepared_name Moved to next CF Hayato Kuroda (ha-kun) meskes 2 2021-09-01
01:25
2021-08-25
05:34
Clients
psql - add SHOW_ALL_RESULTS option Moved to next CF Fabien Coelho (calvin) Peter Eisentraut (petere) petere 11 2021-10-08
12:16
2021-10-08
12:15
pg_dump - read data for some options from external file Moved to next CF 15 Pavel Stehule (okbobcz) Daniel Gustafsson (d_gustafsson), Justin Pryzby (justinpryzby) 8 2021-10-01
07:22
2021-10-05
14:39
libpq compression Moved to next CF 15 Konstantin Knizhnik (knizhnik), Daniil Zakhlystov (usernamedt) Justin Pryzby (justinpryzby), Daniil Zakhlystov (usernamedt), Ian Zagorskikh (ianzag) 6 2021-10-01
21:20
2021-10-08
05:46
Support tab completion for upper character inputs in psql Moved to next CF Haiying Tang (tanghy) Peter Eisentraut (petere) 4 2021-10-02
05:53
2021-09-10
13:50
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
Using COPY FREEZE in pgbench Moved to next CF 15 Tatsuo Ishii (ishii) Fabien Coelho (calvin) ishii 2 2021-09-02
02:00
2021-09-02
01:56
pg_dump new feature: exporting functions only Moved to next CF 15 Lætitia AVROT (arkhena) ahsan hadi (ahsan.hadi), Ryan Lambert (ryanlambert) 3 2021-10-02
05:54
2021-07-30
10:55
Add option --drop-cascade for pg_dump/restore Moved to next CF Wu Haotian (whtsky) Greg Sabino Mullane (greg) 3 2021-10-04
14:49
2021-09-08
14:41
pgbench - allow retries on some errors Moved to next CF 15 Yugo Nagata (yugo.nagata), Marina Polyakova (whipping.top1991) Fabien Coelho (calvin) 2 2021-10-01
07:59
2021-07-19
18:04
Emit namespace in post-copy output Moved to next CF Mike Fiedler (miketheman) Daniel Gustafsson (d_gustafsson), Corey Huinker (coreyh) d_gustafsson 2 2021-08-16
18:14
2021-08-16
18:13
Code Comments
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
Further note require activity aspect of automatic checkpoint and archiving Moved to next CF David Johnston (polobo) 6 2021-10-02
12:18
2021-03-18
15: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-10-02
06:01
2021-08-30
02:20
fix ICU explorer link in locale documentation Moved to next CF Anton Voloshin (a.voloshin) Laurenz Albe (laurenz) 3 2021-10-02
06:02
2021-10-04
21:11
Improve documentation for pg_upgrade, standbys and rsync Moved to next CF 15 Laurenz Albe (laurenz) David Fetter (dfetter) 3 2021-10-04
16:30
2021-08-18
12:24
Clarify how triggers relate to transactions Moved to next CF 15 Laurenz Albe (laurenz) Simon Riggs (simon) tgl 2 2021-09-01
21:27
2021-09-01
21:25
Document the 1GB memory limit for VACUUM Moved to next CF 15 David Rowley (davidrowley), Laurenz Albe (laurenz) Greg Sabino Mullane (greg) davidrowley 2 2021-08-09
04:51
2021-08-09
04:53
Consistent use of SSL/TLS in docs Moved to next CF Daniel Gustafsson (d_gustafsson) 3 2021-10-01
21:21
2021-09-15
12:47
Fix documentation for COPY protocol flow Moved to next CF Jeff Davis (jdavis) 3 2021-10-04
16:31
2021-07-31
00:09
Miscellaneous
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
Fix behavior of geo_ops when NaN is involved Moved to next CF Kyotaro Horiguchi (horiguti) Julien Rouhaud (rjuju), Georgios Kokolatos (gkokolatos) 7 2021-10-06
13:11
2021-03-15
12:34
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 5 2021-10-06
13:14
2021-07-05
06:27
pg_upgrade test for binary compatibility of core data types Moved to next CF Justin Pryzby (justinpryzby) 5 2021-10-01
07:58
2021-10-13
01:36
Printing backtrace of postgres processes Moved to next CF vignesh C (vignesh.postgres) Bharath Rupireddy (bharathrupireddy), Atsushi Torikoshi (atsushitorikoshi), Koyu Tanigawa (tripkt) 5 2021-10-12
08:36
2021-08-26
14:56
Introduce ProcessInterrupts_hook for C extensions Moved to next CF Craig Ringer (ringerc) 3 2021-10-06
13:11
2021-10-01
17:24
postgres_fdw: suppress explicit casts in text:text comparisons Moved to next CF Dian Fay (dmfay) Tom Lane (tgl), Georgios Kokolatos (gkokolatos) 4 2021-10-02
06:04
2021-09-05
22:43
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) 3 2021-10-02
06:05
2021-09-21
11:35
use AV work items infrastructure for GIN pending list's cleanup Moved to next CF 15 Jaime Casanova (jcasanov) Masahiko Sawada (masahikosawada) 2 2021-09-08
14:08
2021-09-08
14:07
Avoid orphaned dependencies Moved to next CF 15 Bertrand Drouvot (bdrouvot) Ronan Dunklau (rdunklau) 3 2021-10-04
16:25
2021-09-20
10:50
Extending amcheck to check toast size and compression Moved to next CF Mark Dilger (mark.dilger) Greg Stark (stark), Aleksander Alekseev (aalekseev) 3 2021-10-05
15:52
2021-10-20
19:06
Rewriting the test of pg_upgrade as a TAP test - take three Moved to next CF Michael Paquier (michael-kun) 3 2021-10-01
06:20
2021-10-12
04:48
TAP test for contrib/sslinfo Moved to next CF Daniel Gustafsson (d_gustafsson) 3 2021-10-19
12:32
2021-06-23
14:25
Change internal PRNG (from rand48 to something better, with a cleaner interface) Moved to next CF 15 Fabien Coelho (calvin) Aleksander Alekseev (aalekseev) 3 2021-10-06
11:47
2021-09-30
10:36
btree_gist: Support bool Moved to next CF Emre Hasegeli (hasegeli) 3 2021-10-01
07:30
2021-06-14
09:33
Use tuple-level SIREAD locks for index-only scans Moved to next CF Thomas Munro (macdice) 3 2021-10-04
16:26
2021-06-14
06:11
Fully WAL logged CREATE DATABASE - No Checkpoints Moved to next CF Dilip Kumar (dilip.kumar) 3 2021-10-04
16:31
2021-10-05
08:06
Deparsing a rewritten query Moved to next CF Julien Rouhaud (rjuju) 3 2021-10-04
16:28
2021-06-28
17:30
pgbench: add multiconnect support Moved to next CF 15 David Christensen (dwc-pgguru) 3 2021-10-06
13:14
2021-08-28
09:01
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
2021-10-01
15:24
Add extra statistics to explain for Nested Loop Moved to next CF 15 Ekaterina Sokolova (e.sokolova) Julien Rouhaud (rjuju), Yugo Nagata (yugo.nagata), Justin Pryzby (justinpryzby) 6 2021-10-06
13:15
2021-08-17
12:30
pg_stat_statements and "IN" conditions Moved to next CF Dmitry Dolgov (erthalion) Chengxi Sun (martin-sun) 5 2021-10-06
13:15
2021-09-30
15:09
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
Add system views pg_permissions and pg_ownerships Moved to next CF Joel Jacobson (joeljacobson) 3 2021-10-04
16:23
2021-08-31
16:52
pg_stat_statements: Track statement entry timestamp Moved to next CF Andrei Zubkov (zubkov) Hayato Kuroda (ha-kun), Yuki Seino (seinoyu), Chengxi Sun (martin-sun), Anton Melnikov (antonmel) 3 2021-10-06
17:18
2021-10-18
19:11
Logging plan of the currently running query Moved to next CF 15 atsushi torikoshi (atorik) Fujii Masao (masaofujii), Ekaterina Sokolova (e.sokolova) 3 2021-10-06
13:15
2021-10-15
10:12
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 Fedor Sigaev (sigaev), Pavel Borisov (pborisov) Tomas Vondra (fuzzycz) 10 2021-10-06
03:08
2021-07-21
22:58
Remove self join on a unique column Moved to next CF Konstantin Knizhnik (knizhnik), Alexander Kuzmenkov (akuzmenkov), Andrey Lepikhov (lepikhov) David Rowley (davidrowley), Jaime Casanova (jcasanov) 17 2021-10-05
16:30
2021-07-27
05:34
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-07-14
11:13
Erase the distinctClause if the result is unique by definition Moved to next CF Andy Fan (andyf) David Rowley (davidrowley), Ashutosh Bapat (ashutoshbapat), Hou Zhijie (houzj) 9 2021-10-06
13:16
2021-08-30
08:59
INSERT SELECT: BulkInsertState and table_multi_insert Moved to next CF 15 Justin Pryzby (justinpryzby) 8 2021-10-02
15:49
2021-09-27
00:08
Fast COPY FROM command for the foreign tables Moved to next CF 15 Andrey Lepikhov (lepikhov) Etsuro Fujita (efujita), Amit Langote (amitlan), Takayuki Tsunakawa (maumau), Justin Pryzby (justinpryzby) efujita 8 2021-10-05
14:29
2021-06-07
11:16
More scalable multixacts buffers and locking Moved to next CF Kyotaro Horiguchi (horiguti), Andrey Borodin (x4m) Gilles Darold (darold) 8 2021-10-06
13:16
2021-06-14
17:40
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
fix spinlock contention in LogwrtResult Moved to next CF Álvaro Herrera (alvherre) 7 2021-10-02
06:09
2021-09-08
15:14
parallel distinct union and aggregate support patch Moved to next CF bucoo hsiao (bucoo) 6 2021-10-06
13:16
2021-09-15
10:34
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-10-02
15:50
2021-07-14
15:55
Consider parallel for LATERAL subqueries having LIMIT/OFFSET Moved to next CF James Coleman (jcole1989) Greg Nancarrow (gregn1234) 5 2021-10-06
13:16
2021-07-16
19:16
Faster pglz compression Moved to next CF Andrey Borodin (x4m), Владимир Лесков (tinsane) Mark Dilger (mark.dilger) 5 2021-10-03
15:56
2021-06-28
16:33
Parallel Hash Full Join Moved to next CF Melanie Plageman (melanieplageman) Thomas Munro (macdice) 5 2021-10-05
17:39
2021-09-30
22:57
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
increase size of pg_commit_ts buffers Moved to next CF Álvaro Herrera (alvherre) Noah Misch (nmisch) 4 2021-10-03
15:56
2021-03-26
04:14
Full support for index LP_DEAD hint bits on standby Moved to next CF Michail Nikolaev (nkey) Antonin Houska (a.houska) 4 2021-10-03
19:25
2021-09-29
22:09
Simplify some RI checks to reduce SPI overhead Moved to next CF Amit Langote (amitlan) Peter Eisentraut (petere), Corey Huinker (coreyh) 4 2021-10-05
15:53
2021-08-30
04:36
Adaptive query optimization: create extented statistics using auto_explain extension Moved to next CF Konstantin Knizhnik (knizhnik) 4 2021-10-03
15:58
2021-07-14
11:13
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
partial heap only tuples Moved to next CF 15 Nathan Bossart (bossartn) 4 2021-10-03
15:58
2021-07-14
11:34
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
Speed up verifying UTF-8 Moved to next CF John Naylor (john.naylor) Heikki Linnakangas (heikki), Amit Khandekar (amitdkhan) 4 2021-10-19
21:43
2021-10-19
21:42
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
Make relfile tombstone files conditional on WAL level Moved to next CF Thomas Munro (macdice) 3 2021-10-01
11:23
2021-10-05
03:21
More sort-related specialisation Moved to next CF Thomas Munro (macdice) John Naylor (john.naylor) 3 2021-10-04
16:26
2021-08-05
23:18
Built-in connection pooler Moved to next CF Konstantin Knizhnik (knizhnik) Antonin Houska (a.houska) 2 2021-10-01
06:51
2021-04-28
10:14
add explicit partial union-all and improve parallel subquery costing Moved to next CF Luc Vlaming (luc.vlaming) Ronan Dunklau (rdunklau) 3 2021-10-06
13:16
2021-07-23
11:46
Lazy JIT IR code generation to increase JIT speed with partitions Moved to next CF Luc Vlaming (luc.vlaming) 3 2021-10-06
13:16
2021-04-12
12:11
Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation Moved to next CF 15 Matthias van de Meent (mmeent) 3 2021-10-03
15:59
2021-06-24
16:21
Use simplehash.h instead of dynahash in SMgr Moved to next CF David Rowley (davidrowley) Yura Sokolov (funny_falcon) 3 2021-10-04
22:11
2021-10-06
16:15
Toast compression method options Moved to next CF Dilip Kumar (dilip.kumar) 3 2021-10-01
09:12
2021-10-01
09:11
Reducing memory consumption for pending inval messages Moved to next CF Tom Lane (tgl) Nathan Bossart (bossartn) tgl 2 2021-08-16
20:49
2021-08-16
20:18
Parallel INSERT SELECT take 2 Moved to next CF Greg Nancarrow (gregn1234), Hou Zhijie (houzj) 3 2021-10-06
13:17
2021-09-09
02:12
pre-allocating WAL files Moved to next CF 15 Nathan Bossart (bossartn) Maxim Orlov (m.orlov), Pavel Borisov (pborisov) 3 2021-10-08
20:50
2021-10-08
20:48
Add proper planner support for ORDER BY / DISTINCT aggregates Moved to next CF David Rowley (davidrowley) Ronan Dunklau (rdunklau) 3 2021-10-04
14:49
2021-07-22
08:42
Map WAL segment files on PMEM as WAL buffers Moved to next CF Takashi Menjo (tmenjo) 3 2021-10-01
07:28
2021-10-08
08:07
Using indexUnchanged with nbtree Moved to next CF 15 Simon Riggs (simon) 2 2021-10-01
14:21
2021-10-01
14:21
Write visibility map during CLUSTER/VACUUM FULL Moved to next CF 15 Alexander Korotkov (smagen) Justin Pryzby (justinpryzby), Anna Akenteva (anna.akenteva) 3 2021-10-03
16:00
2021-08-30
00:26
Don't block HOT update by BRIN index Moved to next CF Josef Šimánek (retro) Tomas Vondra (fuzzycz) 3 2021-10-04
16:20
2021-10-10
21:36
Speed up LockReleaseAll Moved to next CF David Rowley (davidrowley) 3 2021-10-04
16:27
2021-10-06
16:20
Fix ExecRTCheckPerms() inefficiency with many prunable partitions Moved to next CF 15 Amit Langote (amitlan) Álvaro Herrera (alvherre) 3 2021-10-04
16:22
2021-09-10
03:22
Window function run conditions Moved to next CF David Rowley (davidrowley) 3 2021-10-04
16:32
2021-08-26
02:54
Procedural Languages
schema variables, LET command Moved to next CF Pavel Stehule (okbobcz) Fabien Coelho (calvin), Gilles Darold (darold), Brian Faherty (scrummyin), Philippe BEAUDOIN (beaud76), Asif Rehman (asifrana), remi duval (remduv) 18 2021-10-03
16:17
2021-09-16
05:15
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) 7 2021-10-05
17:39
2021-08-23
05:15
possibility to rename root namespace in plpgsql Moved to next CF Pavel Stehule (okbobcz) Julien Rouhaud (rjuju) 5 2021-10-06
13:17
2021-03-28
16:00
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
ResourceOwner refactoring Moved to next CF Heikki Linnakangas (heikki) Aleksander Alekseev (a.alekseev) 4 2021-10-01
07:18
2021-10-01
07:18
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
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
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) 3 2021-10-04
16:32
2021-10-11
14:10
psql - refactor echo code Moved to next CF Fabien Coelho (calvin) Shinya Kato (kato-shinya) 3 2021-10-06
11:47
2021-07-14
07:57
A micro-optimisation for ProcSendSignal() Moved to next CF Thomas Munro (macdice) Soumyadeep Chakraborty (soumyadeepc) 3 2021-10-03
16:03
2021-08-03
02:56
procarray.c: two refactorings Moved to next CF Ranier Vilela (raniervilela) Aleksander Alekseev (aalekseev) masaofujii 2 2021-09-16
04:14
2021-09-16
11:03
Split xlog.c Moved to next CF Heikki Linnakangas (heikki) 3 2021-10-05
01:10
2021-10-20
19:06
automatically generating node support functions Moved to next CF Peter Eisentraut (petere) petere 3 2021-10-11
14:27
2021-10-12
13:52
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) 3 2021-10-04
16:27
2021-06-30
02:36
Remove redundant initializations Moved to next CF Peter Eisentraut (petere) Noah Misch (nmisch) 2 2021-10-01
07:17
2021-10-01
07:17
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
Make message at end-of-recovery less scary Moved to next CF Kyotaro Horiguchi (horiguti) Pavel Borisov (pborisov) 9 2021-10-06
03:07
2021-03-04
06:50
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
Row filtering for logical replication Moved to next CF Euler Taveira (eulerto) Greg Nancarrow (gregn1234), Peter Smith (smithpb2250), Hou Zhijie (houzj), Rahila Syed (rahila) 5 2021-10-03
16:03
2021-10-22
04:37
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), vignesh 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
Identify missing publications from publisher while create/alter subscription. Moved to next CF vignesh C (vignesh.postgres) Dilip Kumar (dilip.kumar), Euler Taveira (eulerto), Japin Li (japin), Bharath Rupireddy (bharathrupireddy) 4 2021-10-05
17:40
2021-09-28
02:19
Minimal logical decoding on standbys (take 6) Moved to next CF Amit Khandekar (amitdkhan) Fabrízio Mello (fabriziomello), Bertrand Drouvot (bdrouvot) 4 2021-10-05
17:40
2021-09-20
10:17
Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation Moved to next CF Bharath Rupireddy (bharathrupireddy) vignesh C (vignesh.postgres) 3 2021-10-06
13:17
2021-07-26
07:33
tablesync early exit Moved to next CF 15 Peter Smith (smithpb2250) 3 2021-10-06
13:17
2021-08-30
03:20
A test for replay of regression tests Moved to next CF Thomas Munro (macdice) Anastasia Lubennikova (lubennikovaav) 3 2021-10-03
16:04
2021-10-06
06:10
avoid logical replication empty transactions Moved to next CF 15 Euler Taveira (eulerto), Ajin Cherian (ajinc) vignesh C (vignesh.postgres), Peter Smith (smithpb), Greg Nancarrow (gregn1234) 3 2021-10-04
16:32
2021-09-01
10:57
Diagnostic comment in LogicalIncreaseXminForSlot Moved to next CF Ashutosh Bapat (ashutoshbapat) Masahiko Sawada (masahikosawada) amitkapila 2 2021-10-01
02:24
2021-10-01
02:25
Replicates changes for all tables in schema Moved to next CF 15 vignesh C (vignesh.postgres) Haiying Tang (tanghy), Mark Dilger (mark.dilger), Hou Zhijie (houzj), Rahila Syed (rahila) 3 2021-10-06
13:18
2021-10-22
07:32
Detectable crashes and unlogged table resets Moved to next CF Jeff Davis (jdavis) 3 2021-10-04
16:32
2021-06-08
21:29
Skipping logical replication transactions on subscriber side Moved to next CF Masahiko Sawada (masahikosawada) Mark Dilger (mark.dilger), Hou Zhijie (houzj) 3 2021-10-04
16:33
2021-10-21
04:59
Allow providing restore_command as a command line option to pg_rewind Moved to next CF Alexey Kondratov (ololobus) Andrey Borodin (x4m) 3 2021-10-05
17:40
2021-09-14
14:05
PITR enhance getRecordTimestamp() Moved to next CF Simon Riggs (simon) 3 2021-10-04
16:33
2021-06-30
09:59
Column filtering in logical replication Moved to next CF Rahila Syed (rahila.syed) Álvaro Herrera (alvherre) 3 2021-10-01
06:54
2021-09-30
11:09
Teach pg_receivewal to use lz4 compression Moved to next CF 15 Georgios Kokolatos (gkokolatos) Michael Paquier (michael-kun) 3 2021-09-21
10:39
2021-09-18
06:18
Security
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
Convert contrib SQL functions to new style Moved to next CF Tom Lane (tgl) 2 2021-09-01
17:28
2021-09-01
17:27
Improve sepgsql logging so it follows the behaviour of selinux's logging. Moved to next CF Dave Page (dpage) 3 2021-10-04
14:46
2021-04-14
13:49
Support for NSS as a libpq TLS backend Moved to next CF Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) 3 2021-10-01
07:20
2021-10-05
15:05
Delegating superuser tasks to new security roles Moved to next CF 15 Mark Dilger (mark.dilger) Andrew Dunstan (adunstan), Nathan Bossart (bossartn) 3 2021-10-01
06:56
2021-10-20
21:55
Server Features
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 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) 17 2021-10-05
14:29
2021-05-21
15:31
A hook for path-removal decision on add_path Moved to next CF KaiGai Kohei (kaigai) 11 2021-10-05
17:20
2021-10-05
17:24
Fix up partitionwise join on how equi-join conditions between the partition keys are identified Moved to next CF Richard Guo (richardguo) Tom Lane (tgl), Etsuro Fujita (efujita), Dilip Kumar (dilip.kumar), Ashutosh Bapat (ashutoshbapat) 11 2021-10-05
17:19
2021-10-05
17:19
global temporary table Moved to next CF stable wenjing zeng (wenjing.zwj) Pavel Stehule (okbobcz), Shawn Wang (shawnwang), Tony Zhu (zhuxw) 10 2021-10-09
08:57
2021-10-21
09:25
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
jsonpath syntax extensions Moved to next CF 15 Nikita Glukhov (n.glukhov) 9 2021-10-06
13:18
2021-03-15
12:25
ALTER SYSTEM READ { ONLY | WRITE } Moved to next CF Amul Sul (sulamul) 8 2021-10-06
13:12
2021-10-18
22:20
Extended statistics / estimate Var op Var clauses Moved to next CF Tomas Vondra (fuzzycz) Dean Rasheed (deanr), Mark Dilger (mark.dilger) 5 2021-10-03
16:05
2021-08-30
22:14
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
New Table Access Methods for Multi and Single Inserts Moved to next CF Bharath Rupireddy (bharathrupireddy) 5 2021-10-06
13:18
2021-04-19
04:51
On client connection event trigger Moved to next CF Konstantin Knizhnik (knizhnik) Pavel Stehule (okbobcz), Daniel Gustafsson (d_gustafsson), Ivan Panchenko (wao), Greg Nancarrow (gregn1234) 5 2021-10-05
06:38
2021-10-05
04:25
SQL/JSON: functions Moved to next CF Nikita Glukhov (n.glukhov) 5 2021-10-04
14:45
2021-09-16
14:52
SQL/JSON: JSON_TABLE Moved to next CF Nikita Glukhov (n.glukhov) 5 2021-10-04
14:45
2021-09-16
14:55
Allow batched insert during cross-partition updates Moved to next CF Amit Langote (amitlan) Etsuro Fujita (efujita), Georgios Kokolatos (gkokolatos), Hou Zhijie (houzj) 4 2021-10-04
16:31
2021-08-24
03:03
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
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-10-03
16:06
2021-09-21
17:55
PROXY protocol support Moved to next CF Magnus Hagander (mha) Jacob Champion (jchampion) 3 2021-10-04
16:35
2021-09-28
13:23
Add common functions regexp_like, regexp_count, regexp_instr, regexp_substr and regexp_replace Moved to next CF Gilles Darold (darold) Tom Lane (tgl) tgl 2 2021-08-03
17:09
2021-08-03
17:10
Extended statistics in EXPLAIN Moved to next CF Tomas Vondra (fuzzycz) 3 2021-10-04
16:35
2021-07-29
14:09
Merging statistics from children instead of re-sampling everything Moved to next CF Tomas Vondra (fuzzycz) 3 2021-10-06
13:18
2021-06-30
15:15
Add missing function abs (interval) Moved to next CF Isaac Morland (ijmorlan) Tom Lane (tgl) 3 2021-10-03
16:07
2021-09-26
17:58
estimating joins using extended statistics Moved to next CF Tomas Vondra (fuzzycz) 3 2021-10-04
16:35
2021-10-06
22:05
Remove 64K hard limit on rangetable size Moved to next CF Tom Lane (tgl) Aleksander Alekseev (a.alekseev) tgl 2 2021-09-15
18:12
2021-09-15
08:01
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) 3 2021-10-06
13:18
2021-09-27
11:59
Addition of authenticated ID to pg_stat_activity Moved to next CF 15 Michael Paquier (michael-kun) Aleksander Alekseev (aalekseev) 2 2021-10-01
01:08
2021-10-01
01:08
Asymmetric partition-wise JOIN Moved to next CF 15 KaiGai Kohei (kaigai), Andrey Lepikhov (lepikhov) 3 2021-10-06
13:19
2021-09-15
06:31
Extensible parsing Moved to next CF 15 Julien Rouhaud (rjuju) 3 2021-10-04
16:28
2021-09-24
06:33
postgres_fdw: Handle boolean comparison predicates Moved to next CF Emre Hasegeli (hasegeli) Etsuro Fujita (efujita), Ashutosh Bapat (ashutoshbapat), Cary Huang (cary) 2 2021-10-01
07:10
2021-10-01
07:10
logical decoding and replication of sequences Moved to next CF Tomas Vondra (fuzzycz) Peter Eisentraut (petere) 3 2021-10-04
07:37
2021-09-25
20:05
Range Merge Join Moved to next CF 15 Thomas Mannhart (thomasmannhart97) 3 2021-10-05
00:31
2021-10-05
00:30
unnesting multirange data types Moved to next CF 14 Alexander Korotkov (smagen) Justin Pryzby (justinpryzby), Jonathan Katz (jkatz05) smagen 2 2021-10-01
07:13
2021-09-08
20:30
pg_stats and range statistics Moved to next CF Egor Rogov (egorius) Soumyadeep Chakraborty (soumyadeepc) 3 2021-10-06
13:19
2021-07-23
18:05
Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands Moved to next CF Yuzuko Hosoya (yuzu) 2 2021-10-01
06:49
2021-10-01
06:50
PoC: improving join estimates using sampling Moved to next CF Tomas Vondra (fuzzycz) 3 2021-10-04
16:33
2021-06-27
17:55
Cleaning up orphaned files using undo logs Moved to next CF Antonin Houska (a.houska) 3 2021-10-06
13:19
2021-09-29
11:07
Automatic notification of top transaction IDs Moved to next CF Gurjeet Singh (gurjeet) Cary Huang (cary) 3 2021-10-04
16:33
2021-09-17
20:40
SQL Commands
SQL:2011 application time Moved to next CF Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) Peter Eisentraut (petere) 11 2021-10-01
07:01
2021-10-01
20:47
Incremental Materialized View Maintenance Moved to next CF 15 Yugo Nagata (yugo.nagata), takuma hoshiai (hoshiai) Tatsuo Ishii (ishii), Toshi Harada (nuko-yokohama), yonghua jian (yonghua) 13 2021-10-04
05:00
2021-09-30
06:37
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) 12 2021-10-05
16:54
2021-09-22
11:49
WITH SYSTEM VERSIONING Temporal Tables Moved to next CF Surafel Temesgen (surafel) Simon Riggs (simon), Vik Fearing (xocolatl), Rémi Lapeyre (remilapeyre) 11 2021-10-01
07:46
2021-09-20
09:49
Automatic HASH and LIST partition creation Moved to next CF Anastasia Lubennikova (lubennikovaav) Nitin Jadhav (nitinjadhav11), Pavel Borisov (pborisov) 7 2021-10-06
13:19
2021-07-20
19:34
Allow COPY "text" to output a header and add header matching mode to COPY FROM Moved to next CF Rémi Lapeyre (remilapeyre) 6 2021-10-06
13:19
2021-04-11
14:35
CLUSTER on partitioned table Moved to next CF 15 Justin Pryzby (justinpryzby) Matthias van de Meent (mmeent) 6 2021-10-06
13:20
2021-09-23
23:56
CREATE INDEX CONCURRENTLY on partitioned table Moved to next CF 15 Justin Pryzby (justinpryzby) Anastasia Lubennikova (lubennikovaav) 6 2021-10-06
13:19
2021-02-26
18:20
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
Dynamic result sets from procedures Moved to next CF Peter Eisentraut (petere) 5 2021-10-04
11:16
2021-08-30
21:11
MERGE SQL command Moved to next CF 15 Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) 4 2021-09-01
12:58
2021-09-01
12:58
Partial foreign key updates in referential integrity triggers Moved to next CF Paul Martinez (pauljulius) Peter Eisentraut (petere) 4 2021-10-03
16:07
2021-09-02
20:54
NOT VALID for Unique Indexes Moved to next CF Simon Riggs (simon) 3 2021-10-01
07:21
2021-09-01
11:02
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
Release SPI plans for referential integrity with DISCARD Moved to next CF Yuzuko Hosoya (yuzu) 2 2021-10-01
07:15
2021-09-26
19:05
rename column if exists Moved to next CF David Oksman (oks) Yagiz Nizipli (yagiznizipli) 3 2021-10-03
16:08
2021-06-16
10:48
Allow queries in WHEN expression of FOR EACH STATEMENT triggers Moved to next CF Joe Wildish (joewildish) 2 2021-10-03
22:18
2021-09-23
20:02
DELETE CASCADE Moved to next CF 15 David Christensen (dwc-pgguru) 3 2021-10-06
13:20
2021-09-29
20:55
System Administration
pg_ls_* functions for showing metadata and recurse (pg_ls_tmpdir to show shared filesets) Moved to next CF 15 Justin Pryzby (justinpryzby) Fabien Coelho (calvin) 10 2021-10-06
13:20
2021-07-02
19:16
Fix pg_rewind race condition just after promotion Moved to next CF Heikki Linnakangas (heikki) Kyotaro Horiguchi (horiguti), Aleksander Alekseev (aalekseev) 5 2021-10-05
17:40
2021-07-14
12:03
Mitigate pg_rewind race condition, if config file is enlarged concurrently. Moved to next CF Heikki Linnakangas (heikki) Cary Huang (cary) 5 2021-10-06
13:20
2021-03-25
13:32
New default role allowing to change per-role/database settings Moved to next CF Michael Banck (mbanck) Stephen Frost (sfrost), Shinya Kato (kato-shinya) 5 2021-10-03
16:09
2021-09-08
07:38
Catalog version access Moved to next CF Vik Fearing (xocolatl) Nathan Bossart (bossartn) 4 2021-10-06
13:20
2021-08-16
18:12
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
Reduce lock level for ALTER TABLE ... ADD CHECK Moved to next CF 15 Simon Riggs (simon) Greg Sabino Mullane (greg) 3 2021-10-03
16:10
2021-10-03
16:51
add pg_ctl option that returns amount of shmem required Moved to next CF Nathan Bossart (bossartn) Michael Paquier (michael-kun) michael-kun 2 2021-09-21
02:11
2021-09-23
16:57