Commitfest 2021-07

Shortcuts
Text Status Target version Author Reviewer
Clear


Status summary: Needs review: 149. Waiting on Author: 64. Ready for Committer: 23. Committed: 75. Moved to next CF: 3. Returned with Feedback: 2. Rejected: 6. Withdrawn: 20. Total: 342.

Active patches

Patch
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. Waiting on Author stable Kyotaro Horiguchi (horiguti), Paul Guo (paulguo) 11 2021-07-09
19:38
2021-07-09
19:37
Corruption during WAL replay Needs review stable Teja Mupparti (tejam) 6 2021-04-08
15:37
2021-03-05
03:01
Fix collation handling in postgres_fdw Waiting on Author Tom Lane (tgl) 5 2021-07-15
12:59
2021-07-15
13:02
Removing unused trailing linepointers from heap pages Needs review Matthias van de Meent (mmeent) 1 2021-05-19
12:57
2021-05-18
19:33
pg_upgrade: copy the source oldestXid Needs review stable Bertrand Drouvot (bdrouvot) 1 2021-07-16
00:22
2021-07-27
12:50
Bug in query rewriter - hasModifyingCTE not getting set Needs review 15 Takayuki Tsunakawa (maumau) 1 2021-05-26
04:27
2021-05-21
06:41
Incorrect snapshots while promoting hot standby node when 2PC is used Needs review stable Michael Paquier (michael-kun) 1 2021-05-31
12:40
2021-05-31
12:37
Extended protocol COPY FROM STDIN fix Needs review Jeff Davis (jdavis) 1 2021-06-18
01:30
2021-07-02
12:44
Fix pgbench's exit status and log messages for connection failures Needs review stable Fabien Coelho (calvin), Yugo Nagata (yugo.nagata) 1 2021-07-18
14:38
2021-06-18
15:46
ECPG bug fix: allow using connection-associated prepared_name Needs review Hayato Kuroda (ha-kun) 1 2021-07-01
03:25
2021-07-21
08:22
Clients
Refactor ECPGconnect() and allow IPv6 connection Needs review Hayato Kuroda (ha-kun) 2 2021-04-08
15:38
2021-06-21
10:46
Documentation
Improve documentation for pg_upgrade, standbys and rsync Needs review 15 Laurenz Albe (laurenz) 1 2021-05-20
12:44
2021-07-26
19:11
Consistent use of SSL/TLS in docs Needs review Daniel Gustafsson (d_gustafsson) 1 2021-06-16
06:39
2021-07-01
21:40
Fix documentation for COPY protocol flow Needs review Jeff Davis (jdavis) 1 2021-06-18
18:50
2021-07-02
12:44
Fix documentation and logging for START_REPLICATION Needs review Jeff Davis (jdavis) 1 2021-06-18
18:50
2021-06-19
10:00
Miscellaneous
Reduce the number of special cases to build contrib modules on windows Needs review David Rowley (davidrowley) 4 2021-07-27
12:26
2021-07-28
12:05
pg_upgrade test for binary compatibility of core data types Needs review Justin Pryzby (justinpryzby) 3 2021-04-08
15:31
2021-07-16
18:02
Introduce ProcessInterrupts_hook for C extensions Needs review Craig Ringer (ringerc) 2 2021-04-08
15:40
2021-06-29
05:32
Add some tests for pg_stat_statements compatibility verification Needs review Erica Zhang (zerica) 1 2021-03-15
02:39
2021-03-15
07:05
Allow multiple recursive self-references Waiting on Author Denis Hirn (brainy) 1 2021-07-14
15:46
2021-07-20
11:15
Avoid orphaned dependencies Needs review 15 Bertrand Drouvot (bdrouvot) 1 2021-05-04
09:57
2021-05-04
09:55
Rewriting the test of pg_upgrade as a TAP test - take three Needs review Michael Paquier (michael-kun) 1 2021-06-25
07:27
2021-05-20
06:07
TAP test for contrib/sslinfo Needs review Daniel Gustafsson (d_gustafsson) 1 2021-05-20
18:49
2021-06-23
14:25
btree_gist: Support bool Needs review Emre Hasegeli (hasegeli) 1 2021-06-08
10:51
2021-06-14
09:33
Use tuple-level SIREAD locks for index-only scans Needs review Thomas Munro (macdice) 1 2021-06-12
02:42
2021-06-14
06:11
Fully WAL logged CREATE DATABASE - No Checkpoints Needs review Dilip Kumar (dilip.kumar) 1 2021-06-22
06:06
2021-07-06
09:30
Deparsing a rewritten query Needs review Julien Rouhaud (rjuju) 1 2021-06-27
04:12
2021-06-28
17:30
pgbench: add multiconnect support Needs review 15 David Christensen (dwc-pgguru) 1 2021-06-30
17:02
2021-07-01
10:22
Monitoring & Control
Track wal_level drop for backup management Waiting on Author Takamichi Osumi (tatatappp) 2 2021-07-14
16:07
2021-07-14
11:58
Add system views pg_permissions and pg_ownerships Needs review Joel Jacobson (joeljacobson) 1 2021-03-08
06:33
2021-03-27
20:47
Performance
INSERT SELECT: BulkInsertState and table_multi_insert Waiting on Author 15 Justin Pryzby (justinpryzby) 6 2021-04-08
14:41
2021-03-22
09:44
fix spinlock contention in LogwrtResult Waiting on Author Álvaro Herrera (alvherre) 5 2021-04-08
14:41
2021-02-03
00:32
parallel distinct union and aggregate support patch Waiting on Author bucoo hsiao (bucoo) 4 2021-03-29
13:36
2021-07-21
07:36
WIP: Track relation size in shared memory Waiting on Author Thomas Munro (macdice) 2 2021-07-14
13:41
2021-07-14
12:38
Adaptive query optimization: create extented statistics using auto_explain extension Waiting on Author Konstantin Knizhnik (knizhnik) 2 2021-07-14
11:13
2021-07-14
11:13
Improve join selectivity estimation using extended statistics Waiting on Author Konstantin Knizhnik (knizhnik) 2 2021-07-19
10:53
2021-07-19
10:52
partial heap only tuples Waiting on Author 15 Nathan Bossart (bossartn) 2 2021-07-14
11:33
2021-07-14
11:34
speed up pg_rewind by using copy_file_range() and skipping some fsync Waiting on Author Paul Guo (paulguo-vmware) 2 2021-06-17
07:20
2021-06-22
03:08
Make relfile tombstone files conditional on WAL level Needs review Thomas Munro (macdice) 1 2021-03-04
22:03
2021-06-10
10:47
Lazy JIT IR code generation to increase JIT speed with partitions Needs review Luc Vlaming (luc.vlaming) 1 2021-04-12
12:12
2021-04-12
12:11
Iterating on IndexTuple attributes and nbtree page-level dynamic prefix truncation Needs review 15 Matthias van de Meent (mmeent) 1 2021-04-15
18:48
2021-06-24
16:21
Toast compression method options Needs review Dilip Kumar (dilip.kumar) 1 2021-07-19
11:53
2021-07-19
07:54
Reducing memory consumption for pending inval messages Needs review Tom Lane (tgl) 1 2021-05-30
17:34
2021-07-13
20:21
Parallel INSERT SELECT take 2 Needs review Greg Nancarrow (gregn1234), hou zhijie (houzj) 1 2021-05-31
05:32
2021-07-23
05:00
pre-allocating WAL files Needs review 15 Nathan Bossart (bossartn) 1 2021-06-08
17:41
2021-07-09
21:08
Map WAL segment files on PMEM as WAL buffers Needs review Takashi Menjo (tmenjo) 1 2021-07-08
08:28
2021-06-30
04:52
Write visibility map during CLUSTER/VACUUM FULL Waiting on Author Alexander Korotkov (smagen) 1 2021-07-14
11:46
2021-07-14
11:46
Speed up LockReleaseAll Needs review David Rowley (davidrowley) 1 2021-06-30
06:14
2021-07-20
05:04
Fix ExecRTCheckPerms() inefficiency with many prunable partitions Waiting on Author 15 Amit Langote (amitlan) 1 2021-07-07
04:40
2021-07-07
07:12
Record a Bitmapset of non-pruned partitions Needs review David Rowley (davidrowley) 1 2021-06-30
14:05
2021-07-12
02:47
Window function run conditions Needs review David Rowley (davidrowley) 1 2021-07-01
09:12
2021-07-01
09:17
Refactoring
Split StdRdOptions into HeapOptions and ToastOptions Waiting on Author Nikolay Shaplov (nataraj) 8 2021-07-15
12:20
2021-07-22
08:30
ResourceOwner refactoring Needs review Heikki Linnakangas (heikki) 3 2021-07-14
14:41
2021-07-14
15:41
Infrastructure changes to make the code less sensitive to transaction id bit width Waiting on Author James Finnerty (jimfinnerty) 2 2021-03-26
13:55
2021-03-26
13:54
Extend portability of client_connection_check_interval Needs review Thomas Munro (macdice) 1 2021-04-30
02:38
2021-06-12
08:35
Split xlog.c Waiting on Author Heikki Linnakangas (heikki) 1 2021-07-15
12:19
2021-07-15
12:19
automatically generating node support functions Needs review Peter Eisentraut (petere) 1 2021-06-18
10:13
2021-07-26
21:25
improvements in Unicode tables generation code Needs review Peter Eisentraut (petere) 1 2021-07-20
11:59
2021-07-20
11:57
Extensible storage manager API - smgr hooks Needs review Anastasia Lubennikova (lubennikovaav) 1 2021-06-29
21:50
2021-06-30
02:36
Remove redundant initializations Waiting on Author Peter Eisentraut (petere) 1 2021-07-15
12:03
2021-07-15
12:03
Replication & Recovery
Background writer and checkpointer in crash recovery Needs review Thomas Munro (macdice) 5 2021-04-08
08:42
2021-03-12
22:16
Reduce the time required for a database recovery from archive. Needs review Anna Akenteva (a.akenteva), Dmitry Shulga (d.shulga), Ivan Taranov (i.taranov) 2 2021-04-08
15:45
2021-03-19
12:50
tablesync early exit Needs review 15 Peter Smith (smithpb2250) 1 2021-04-07
02:06
2021-03-09
05:56
Detectable crashes and unlogged table resets Needs review Jeff Davis (jdavis) 1 2021-06-18
18:49
2021-06-08
21:29
PITR enhance getRecordTimestamp() Needs review Simon Riggs (simon) 1 2021-06-30
10:01
2021-06-30
09:59
Column filtering in logical replication Waiting on Author Rahila Syed (rahila.syed) 1 2021-07-19
10:21
2021-07-22
18:48
Security
public schema default ACL Needs review Noah Misch (nmisch) 2 2021-04-08
15:46
2021-06-30
01:37
Convert contrib SQL functions to new style Needs review Tom Lane (tgl) 1 2021-04-15
02:08
2021-04-16
01:40
Improve sepgsql logging so it follows the behaviour of selinux's logging. Needs review Dave Page (dpage) 1 2021-04-15
14:08
2021-04-14
13:49
Support for NSS as a libpq TLS backend Needs review Daniel Gustafsson (d_gustafsson), Jacob Champion (jchampion) 1 2021-05-28
09:11
2021-07-26
13:26
Delegating superuser tasks to new security roles Needs review 15 Mark Dilger (mark.dilger) 1 2021-06-30
12:56
2021-07-27
15:36
Server Features
A hook for path-removal decision on add_path Needs review KaiGai Kohei (kaigai) 10 2021-04-08
15:46
2021-03-06
09:50
jsonpath syntax extensions Needs review 15 Nikita Glukhov (n.glukhov) 7 2021-04-08
15:47
2021-03-15
12:25
ALTER SYSTEM READ { ONLY | WRITE } Needs review Amul Sul (sulamul) 6 2021-04-08
15:47
2021-07-28
11:32
New Table Access Methods for Multi and Single Inserts Needs review Bharath Rupireddy (bharathrupireddy) 3 2021-04-08
15:47
2021-04-19
04:51
SQL/JSON: functions Needs review Nikita Glukhov (n.glukhov) 3 2021-04-08
15:48
2021-05-18
19:22
SQL/JSON: JSON_TABLE Needs review Nikita Glukhov (n.glukhov) 3 2021-04-08
15:48
2021-07-26
14:12
Hooks and API to allow loadable wire protocol extensions Needs review Jan Wieck (wieck) 2 2021-04-08
15:49
2021-03-05
01:38
Add regexp_positions(string text, pattern text, flags text) → setof record (starts integer[], lengths integer[]) Needs review Joel Jacobson (joeljacobson) 1 2021-03-15
14:34
2021-03-09
19:30
Extended statistics in EXPLAIN Needs review Tomas Vondra (fuzzycz) 1 2021-03-27
00:51
2021-07-28
13:23
Merging statistics from children instead of re-sampling everything Needs review Tomas Vondra (fuzzycz) 1 2021-03-29
15:56
2021-06-30
15:15
Add missing function abs (interval) Needs review Isaac Morland (ijmorlan) 1 2021-03-31
03:20
2021-07-14
23:29
estimating joins using extended statistics Needs review Tomas Vondra (fuzzycz) 1 2021-03-31
17:40
2021-06-14
17:34
Remove 64K hard limit on rangetable size Needs review Tom Lane (tgl) 1 2021-07-02
18:47
2021-07-05
07:51
Add callback table access method to reset filenode when dropping relation Needs review Mats Kindahl (matski) 1 2021-04-13
21:37
2021-04-05
19:57
Asymmetric partition-wise JOIN Needs review 15 KaiGai Kohei (kaigai), Andrey Lepikhov (lepikhov) 1 2021-04-30
03:11
2021-07-15
13:16
Extensible parsing Needs review 15 Julien Rouhaud (rjuju) 1 2021-05-02
04:32
2021-07-22
07:04
logical decoding and replication of sequences Waiting on Author Tomas Vondra (fuzzycz) 1 2021-07-22
11:37
2021-07-20
21:41
Range Merge Join Needs review 15 Thomas Mannhart (thomasmannhart97) 1 2021-06-10
09:17
2021-06-11
02:14
Autovacuum (analyze) on partitioned tables for ATTACH/DETACH/DROP commands Needs review Yuzuko Hosoya (yuzu) 1 2021-06-21
08:25
2021-06-21
08:21
PoC: improving join estimates using sampling Needs review Tomas Vondra (fuzzycz) 1 2021-06-28
21:54
2021-06-27
17:55
Cleaning up orphaned files using undo logs Waiting on Author Antonin Houska (a.houska) 1 2021-07-15
11:50
2021-07-15
11:37
Automatic notification of top transaction IDs Needs review Gurjeet Singh (gurjeet) 1 2021-07-01
01:02
2021-07-27
09:18
SQL Commands
SQL:2011 application time Needs review Paul Jungwirth (pjungwir), Ibrar Ahmed (ibrar) 9 2021-07-19
17:53
2021-07-03
17:46
FETCH FIRST clause PERCENT option Needs review Surafel Temesgen (surafel) 11 2021-04-08
15:49
2021-03-25
15:15
Allow COPY "text" to output a header and add header matching mode to COPY FROM Needs review Rémi Lapeyre (remilapeyre) 4 2021-04-08
15:49
2021-04-11
14:35
CLUSTER on partitioned table Waiting on Author 15 Justin Pryzby (justinpryzby) 4 2021-04-08
21:45
2021-07-21
11:01
Dynamic result sets from procedures Waiting on Author Peter Eisentraut (petere) 3 2021-07-26
12:04
2021-07-22
06:06
Release SPI plans for referential integrity with DISCARD Waiting on Author Yuzuko Hosoya (yuzu) 1 2021-07-14
16:03
2021-07-14
16:03
Allow queries in WHEN expression of FOR EACH STATEMENT triggers Needs review Joe Wildish (joewildish) 1 2021-06-02
12:27
2021-06-02
12:19
DELETE CASCADE Needs review 15 David Christensen (dwc-pgguru) 1 2021-06-22
18:38
2021-07-07
18:16
System Administration
Catalog version access Needs review Vik Fearing (xocolatl) 2 2021-04-08
15:50
2021-04-08
09:58
add pg_ctl option that returns amount of shmem required Needs review Nathan Bossart (bossartn) 1 2021-06-10
17:06
2021-06-14
14:16

Closed patches

Status Ver Author Reviewers Committer Num cfs Latest activity Latest mail
Bug Fixes
Fix race condition in parallel hash join batch cleanup Committed Thomas Munro (macdice) macdice 1 2021-03-17
05:16
2021-03-31
22:41
In psql \?, add [+] annotation where appropriate Committed stable Matthijs van der Vleuten (zr40) michael-kun 1 2021-06-09
07:30
2021-06-09
07:29
Fix broken Ctr-C in psql after 3a51306722 Returned with feedback 1 2021-04-16
03:10
2021-07-23
07:56
Truncate in synchronous logical replication failed Committed Takamichi Osumi (tatatappp) amitkapila 1 2021-04-27
07:02
2021-04-27
06:31
AlterSubscription_refresh using wrong "wrconn" variable Committed stable Peter Smith (smithpb) alvherre 1 2021-05-12
23:20
2021-05-12
23:19
Issue with some calls to GetMultiXactIdMembers() Committed Greg Nancarrow (gregn1234) heikki 1 2021-06-18
00:59
2021-06-17
12:57
Fix PITR msg for Abort Prepared Committed Simon Riggs (simon) michael-kun 1 2021-06-30
12:26
2021-06-30
01:12
pgbench logging fixes Committed 14 Fabien Coelho (calvin) macdice 1 2021-07-11
13:12
2021-07-11
08:16
Clients
Fix pg_checksums progress report Committed Shinya Kato (kato-shinya) masaofujii 1 2021-04-05
17:33
2021-04-02
15:09
pg_dumpall misses --no-toast-compression Committed 15 Michael Paquier (michael-kun) michael-kun 1 2021-05-21
05:39
2021-05-19
00:44
Fix around conn_duration in pgbench Withdrawn 1 2021-06-15
08:49
2021-07-28
17:23
Preventing abort() and exit() calls in libpq Committed Tom Lane (tgl) tgl 1 2021-06-29
20:01
2021-07-09
20:29
Code Comments
Clarify ItemPointers for Table AM API Withdrawn 15 Jeff Davis (jdavis) jdavis 1 2021-06-18
01:26
2021-05-19
01:59
Documentation
Specify ACCESS EXCLUSIVE lock explicitly Committed Greg Rychlewski (grychlewski) michael-kun 1 2021-04-01
23:54
2021-04-01
23:54
Fix documentation and logging for START_REPLICATION Withdrawn 15 Jeff Davis (jdavis) 1 2021-06-16
23:06
2021-06-19
10:00
add argument type to postgres_fdw docs Committed Shinya Kato (kato-shinya) masaofujii 1 2021-06-30
10:40
2021-06-30
10:37
Doc chapter for Hash Indexes Committed stable Simon Riggs (simon) amitkapila 1 2021-07-07
03:25
2021-07-05
09:51
Miscellaneous
force_parallel_mode and GUC categories Committed stable Justin Pryzby (justinpryzby) michael-kun 1 2021-04-15
04:23
2021-05-08
16:39
Move tablespace path re-creation from the makefiles to pg_regress (test for mkdir function in the backend) Withdrawn 14 Michael Paquier (michael-kun) 1 2021-04-16
03:15
2021-05-18
01:01
Fix missed parallel safety checks and wrong parallel safety Withdrawn hou zhijie (houzj) 1 2021-06-21
01:14
2021-07-28
03:20
Add ZSON extension to /contrib/ Rejected Aleksander Alekseev (aalekseev) 1 2021-07-12
18:52
2021-07-10
18:47
Improving the isolationtester Committed Tom Lane (tgl) tgl 1 2021-06-25
20:01
2021-06-16
19:47
test invalidation of obsolete replslots with active walsender Committed Álvaro Herrera (alvherre) alvherre 1 2021-07-05
17:09
2021-07-05
17:10
Make jsonapi usable from libpq Withdrawn Jacob Champion (jchampion) 1 2021-07-07
15:08
2021-07-07
14:57
trivial improvement to system_or_bail Committed Álvaro Herrera (alvherre) alvherre 1 2021-07-06
21:59
2021-07-07
07:13
Monitoring & Control
Fix oversights in query_id calculation Committed 15 Julien Rouhaud (rjuju) bmomjian 1 2021-05-05
14:08
2021-05-05
00:33
Performance
Optionally sync data directory with syncfs() Committed Thomas Munro (macdice) macdice 1 2021-03-19
23:17
2021-06-28
03:51
Using indexUnchanged with nbtree Moved to next CF 15 Simon Riggs (simon) 2 2021-06-29
22:06
2021-07-01
16:22
pgbench using COPY FREEZE Withdrawn 15 Simon Riggs (simon) 1 2021-07-01
16:03
2021-07-04
01:53
Refactoring
Remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit Committed Bharath Rupireddy (bharathrupireddy) michael-kun 1 2021-04-08
10:35
2021-04-08
08:00
Use SIGIO to detect postmaster death Withdrawn Thomas Munro (macdice) 1 2021-07-13
21:40
2021-07-12
12:18
Remove redundant variable from transformCreateStmt Committed 14 Amul Sul (sulamul) alvherre 1 2021-05-07
04:01
2021-05-06
21:32
MAXALIGN sizeof(BTPageOpaqueData) in PageGetItemIdCareful Committed Bharath Rupireddy (bharathrupireddy) pgeoghegan 1 2021-04-26
05:23
2021-04-26
03:11
postgres_fdw - make cached connection functions tests meaningful with debug_invalidate_system_caches_always Rejected Bharath Rupireddy (bharathrupireddy) 1 2021-07-21
10:08
2021-07-21
10:11
O_DIRECT on macOS Committed Thomas Munro (macdice) macdice 1 2021-07-19
10:57
2021-07-20
05:01
Refactor parse_subscription_options Committed Bharath Rupireddy (bharathrupireddy) amitkapila 1 2021-07-08
03:00
2021-07-08
03:03
wrong relkind error messages Committed Peter Eisentraut (petere) petere 1 2021-07-08
08:03
2021-07-21
06:03
Replication & Recovery
Fix for START_REPLICATION without IDENTIFY_SYSTEM Committed Jeff Davis (jdavis) jdavis 1 2021-07-09
18:52
2021-07-09
01:12
GUC to prevent cancellation while waiting for sync rep Withdrawn 15 Jeff Davis (jdavis) 1 2021-07-13
02:22
2021-07-13
02:22
Security
Dump public schema ownership, seclabels and comments Committed Noah Misch (nmisch) nmisch 2 2021-06-29
01:38
2021-06-29
16:32
Server Features
Non-volatile WAL buffer Withdrawn Takashi Menjo (tmenjo) 6 2021-06-18
06:46
2021-03-09
07:23
Discarding DISCARD ALL Withdrawn 15 Simon Riggs (simon) 3 2021-06-21
17:13
2021-06-21
16:50
Table AM modifications to accept column projection lists Withdrawn Jacob Champion (jchampion), Soumyadeep Chakraborty (soumyadeepc) 3 2021-06-30
23:43
2021-06-30
23:42
Key management with tests Withdrawn 15 Stephen Frost (sfrost), Masahiko Sawada (masahikosawada), Bruce Momjian (bmomjian) 3 2021-07-15
14:45
2021-07-15
14:45
Support empty ranges with bounds information Rejected 14 Joel Jacobson (joeljacobson) 1 2021-03-03
03:56
2021-03-04
18:05
Automatic notification for top transaction IDs Withdrawn Gurjeet Singh (gurjeet) 1 2021-07-01
00:49
2021-06-23
04:37
SQL Commands
DROP INDEX CONCURRENTLY on partitioned index Withdrawn 15 Justin Pryzby (justinpryzby) 4 2021-07-24
16:46
2021-07-24
16:46
REINDEX backend filtering Withdrawn Julien Rouhaud (rjuju) 3 2021-05-08
03:31
2021-03-15
19:37
MERGE SQL command Moved to next CF 15 Álvaro Herrera (alvherre), Simon Riggs (simon), Pavan Deolasee (pavan) 4 2021-06-30
15:27
2021-03-21
14:30
NOT VALID for Unique Indexes Moved to next CF Simon Riggs (simon) 3 2021-06-21
17:01
2021-02-28
06:36