| Index Prefetching |
4351 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Jerry Zhang (xingtanzjr), Rui Zhao (zhaorui), GURU PRASAD GANGIREDLA (gangguru788) |
|
17 |
1 week ago |
| Asynchronous MergeAppend Execution |
5129 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara), solai v (solaiv) |
|
11 |
18 hours ago |
| Function scan FDW pushdown |
5470 |
Committed |
Performance
|
18 |
10/10
|
+0−0
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
Ashutosh Bapat (ashutoshbapat), Solaimurugan V (solaimurugan) |
Alexander Korotkov (smagen) |
4 |
1 month ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Moved to different CF |
Performance
|
19 |
10/10
|
+1038−20
|
Alena Rybakina (a.rybakina) |
Ilia Evdokimov (ilidock95), Solaimurugan V (solaimurugan) |
|
10 |
1 week ago |
| Compress big WAL records |
5621 |
Moved to different CF |
Performance
|
|
9/10
|
+2059−137
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii), Zsolt Parragi (zsolt.parragi) |
|
7 |
yesterday |
| Produce LLVM bitcode files on meson builds |
5671 |
Moved to different CF |
Performance
|
19 |
10/10
|
+380−25
|
Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) |
Christoph Berg (myon) |
|
7 |
3 weeks ago |
| Extend skipping FK checks on replicas to include ADD FK and TRUNCATE |
5774 |
Moved to different CF |
Performance
Help - Stuck Rebasing
Logical Replication
|
19 |
10/10
|
+96−3
|
Hannu Krosing (hannukrosing) |
Rafia Sabih (rafia.sabih), Murali Natti (murali.natti) |
|
7 |
2 months ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Moved to different CF |
Performance
System Administration
|
stable |
10/10
|
+926−89
|
Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) |
Dilip Kumar (dilip.kumar), solai v (solaiv) |
|
6 |
1 month ago |
| MPTCP - multiplexing many TCP connections through one socket to get better bandwidth |
6061 |
Moved to different CF |
Performance
|
20 |
10/10
|
+118−2
|
Jakub Wartak (jakub.wartak.tomtom) |
Greg Sabino Mullane (greg) |
|
5 |
1 month ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada), solai v (solaiv) |
|
6 |
1 month ago |
| Reduce unnecessary locking of pruned partitions when reusing cached plans |
6216 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
Ilmar Yunusov (tanswis42.gmail.com), Rui Zhao (zhaorui), Manuel Reyes Bravo (manu15) |
|
4 |
1 week ago |
| pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized |
6219 |
Moved to different CF |
Performance
libpq
|
stable |
10/10
|
+420−64
|
Hannu Krosing (hannukrosing) |
Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) |
|
5 |
2 months ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Moved to different CF |
postgres_fdw
Performance
|
19 |
10/10
|
+2421−131
|
Rafia Sabih (rafia.sabih) |
|
|
4 |
2 hours ago |
| Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) |
6245 |
Moved to different CF |
Performance
My First Patch
Refactoring Only
|
19 |
10/10
|
+978−150
|
Boris Mironov (bmironov) |
Egor Madyshev (emadyshev) |
|
5 |
yesterday |
| Hash-based MCV matching for large IN-lists |
6356 |
Moved to different CF |
Performance
|
stable |
10/10
|
+543−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
5 |
3 months ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Moved to different CF |
Performance
|
|
10/10
|
+4528−281
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
4 |
2 weeks ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Moved to different CF |
Performance
|
|
10/10
|
+422−9
|
Richard Guo (richardguo) |
solai v (solaiv) |
|
3 |
3 weeks ago |
| Prevent repeated deadlock-check signals in standby buffer pin waits |
6690 |
Moved to different CF |
Performance
|
20 |
Needs rebase!
|
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii), Henson Choi (assam258.gmail.com), Ilmar Yunusov (tanswis42.gmail.com) |
Fujii Masao (masaofujii) |
3 |
1 month ago |
| Logical Replication - revisit `is_table_publication` function implementation |
6705 |
Moved to different CF |
Refactoring Only
Performance
|
stable |
10/10
|
+29−29
|
Peter Smith (smithpb2250) |
bingshuai li (kid1019) |
|
3 |
1 month ago |
| Improve pg_stat_statements scalability |
6763 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Sami Imseih (simseih) |
Tristan Partin (tristan957) |
|
3 |
2 months ago |
| btree_gist: add cross-type integer operator support for GiST |
6854 |
Moved to different CF |
Performance
My First Patch
|
20 |
10/10
|
+1650−51
|
Alexander Nestorov (alexandernst) |
Maxime Schoemans (mschoema) |
Tom Lane (tgl) |
3 |
2 weeks ago |
| Reduce outer joins in more cases |
6886 |
Committed |
Performance
|
20 |
10/10
|
+45−71
|
Richard Guo (richardguo) |
|
Richard Guo (richardguo) |
2 |
1 month ago |
| Unexpected reindex when altering column types for partitioned tables |
6887 |
Moved to different CF |
DDL
Performance
|
|
4/10
|
+257−48
|
Álvaro Rodríguez (arodrgr) |
Alberto Piai (albe) |
|
3 |
3 days ago |
| Randomize B-Tree page split location to avoid oscillating patterns |
6892 |
Moved to different CF |
Performance
|
stable |
Needs rebase!
|
|
Dmitry Dolgov (erthalion) |
Andrey Borodin (x4m) |
|
3 |
1 month ago |
| Fold NOT IN / <> ALL expressions containing NULL to FALSE |
6901 |
Moved to different CF |
Performance
|
stable |
Needs rebase!
|
|
Ilia Evdokimov (ilidock95) |
Denis Smirnov (darthunix), Rustam ALLAKOV (rustam.allakov) |
|
3 |
1 week ago |
| Improve row estimation with multi-column unique indexes |
6932 |
Moved to different CF |
Performance
|
20 |
10/10
|
+669−284
|
Anthonin Bonnefoy (bonnefoa) |
|
|
3 |
3 months ago |
| Reduce reorder buffer spill from O(N²) to O(N) during vacuum storms |
6933 |
Moved to different CF |
Performance
Logical Replication
|
20 |
Needs rebase!
|
|
Rui Zhao (zhaorui) |
shihao zhong (zhong950419) |
|
3 |
1 month ago |
| Tepid: extend the heap-only tuple (HOT) update optimization model such that only those indexes directly impacted by the update need be updated |
6968 |
Moved to different CF |
Performance
|
20 |
9/10
|
+13273−817
|
Greg Burd (gregburd) |
Bharath Rupireddy (bharathrupireddy) |
|
2 |
3 days ago |
| Lazy LEFT NestLoop JOIN: gate rescanning of the inner side by outer-side-only join clauses |
6981 |
Moved to different CF |
Performance
|
20 |
3/10
|
+446−230
|
Andrei Lepikhov (lepikhov), Mikhail Zhilin (mizhka-at-pgpro), Peter Petrov (pspetrov) |
|
|
2 |
3 weeks ago |
| [PATCH v1 0/7] Wait event timing and tracing instrumentation |
6984 |
Moved to different CF |
Performance
Monitoring
|
|
10/10
|
+10103−206
|
Dmitry Fomin (dmitryf) |
|
|
2 |
2 weeks ago |
| Batched clock sweep to reduce cross-socket atomic contention |
7000 |
Withdrawn |
Performance
|
20 |
10/10
|
+333−115
|
Jim Mlodgenski (jimmy76), Greg Burd (gregburd) |
|
|
1 |
4 weeks ago |
| Use Boyer-Moore-Horspool for simple LIKE contains patterns |
7013 |
Moved to different CF |
Performance
|
20 |
10/10
|
+859−2
|
Atsushi Ogawa (atsushio) |
Bryan Green (lispyone) |
|
2 |
5 days ago |
| Caching a partition index's parent OID in the relcache? |
7030 |
Moved to different CF |
Performance
|
20 |
10/10
|
+229−6
|
Ayush Tiwari (aytiwari) |
|
|
2 |
2 months ago |
| Rewrite undirected edge patterns in GRAPH_TABLE using UNION ALL |
7034 |
Returned with feedback |
Performance
|
20 |
Needs rebase!
|
|
Ayoub Kazar (kaz) |
|
|
1 |
4 weeks ago |
| Tracking per-RelOptInfo uniqueness during planning |
7045 |
Moved to different CF |
Performance
|
20 |
3/10
|
+3249−145
|
Richard Guo (richardguo) |
Antonin Houska (a.houska), Ilia Evdokimov (ilidock95) |
|
2 |
1 month ago |
| Add a pg_wal_preallocate() SQL function to eagerly create future WAL segments |
7052 |
Moved to different CF |
Help - Benchmarks
Performance
|
20 |
Needs rebase!
|
|
Ayush Tiwari (aytiwari) |
Bharath Rupireddy (bharathrupireddy), solai v (solaiv) |
|
2 |
2 weeks ago |
| Speed up repeat() for larger counts |
7060 |
Moved to different CF |
Performance
|
20 |
10/10
|
+32−0
|
Chenhui Mo (littleganyu) |
Nathan Bossart (bossartn), Jan Nidzwetzki (jnidzwetzki) |
|
2 |
2 weeks ago |
| psql: filter system functions before visibility checks |
7061 |
Moved to different CF |
Bugfix
Performance
|
20 |
10/10
|
+64−52
|
xiaoyu liu (raindrop) |
Jan Nidzwetzki (jnidzwetzki) |
|
2 |
1 month ago |
| Add planner support function to two-argument regexp_like() |
7069 |
Moved to different CF |
Good First Review
Performance
|
stable |
10/10
|
+30−1
|
shihao zhong (zhong950419) |
Pierre Forstmann (pifor) |
|
2 |
19 hours ago |
| Batch fsyncs when recycling WAL segments |
7088 |
Moved to different CF |
Performance
|
20 |
10/10
|
+40−9
|
Ayush Tiwari (aytiwari) |
Bharath Rupireddy (bharathrupireddy) |
|
2 |
1 week ago |
| Support specialized B-tree page searches |
7119 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
2 |
4 days ago |
| Avoid streaming zero-filled WAL switch padding |
7123 |
Moved to different CF |
Performance
Physical Replication
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
Sehrope Sarkuni (sehrope) |
|
2 |
4 weeks ago |
| Redundant qualifier elimination |
7127 |
Returned with feedback |
Performance
|
|
10/10
|
+50−9
|
Matheus Alcantara (matheus.alcantara) |
|
|
1 |
1 month ago |
| Reduce cost of ProcArrayRemove/ProcArrayAdd |
7139 |
Moved to different CF |
Performance
|
|
10/10
|
+11−9
|
Maksim Melnikov (manaldush) |
Matthias van de Meent (mmeent) |
|
2 |
3 weeks ago |
| Refactor remaining zero-fill relation extensions to use smgrzeroextend() |
7141 |
Moved to different CF |
Performance
|
20 |
10/10
|
+12−20
|
peipei yin (yinpeipei) |
Bharath Rupireddy (bharathrupireddy), shihao zhong (zhong950419) |
|
2 |
1 week ago |
| enhancing pg_basebackup speeds up to ~23Gbps (small fixes + io_uring/Direct I/O) |
7142 |
Moved to different CF |
Performance
|
20 |
8/10
|
+240−63
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
2 |
2 days ago |
| Apply extended statistics to join clause during parameterized path costing |
7161 |
Moved to different CF |
Performance
|
stable |
10/10
|
+42−3
|
Ilia Evdokimov (ilidock95) |
|
|
2 |
3 weeks ago |
| Write Combining |
7171 |
Moved to different CF |
Performance
|
|
10/10
|
+2212−420
|
Melanie Plageman (melanieplageman) |
Andrey Borodin (x4m) |
|
2 |
5 days ago |
| aio: Async fsyncs for crash recovery and checkpointer |
7190 |
Moved to different CF |
AIO
Performance
|
20 |
10/10
|
+1706−311
|
Nazir Bilal Yavuz (nbyavuz) |
Srinath Reddy (srinath-reddy-sadipiralla), Salma El-Sayed (salmae) |
|
2 |
1 week ago |
| Improve cube GiST page splits |
7196 |
Moved to different CF |
Performance
|
|
10/10
|
+498−123
|
Andrey Borodin (x4m) |
Rustam ALLAKOV (rustam.allakov) |
|
2 |
1 week ago |
| Honor fillfactor in sorted GiST builds |
7198 |
Moved to different CF |
Performance
|
|
9/10
|
+103−20
|
Andrey Borodin (x4m) |
|
|
2 |
1 month ago |
| Delete GIN posting-tree pages without excessive locking |
7199 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
2 |
2 months ago |
| GiST intrapage indexing |
7200 |
Moved to different CF |
Performance
|
|
7/10
|
+813−37
|
Andrey Borodin (x4m) |
|
|
2 |
2 months ago |
| Plan a filtering inner join as a semijoin |
7202 |
Withdrawn |
Performance
|
20 |
10/10
|
+1902−4
|
William Bernbaum (wjb-fwx) |
|
|
1 |
1 month ago |
| Optimize UUID parse using SIMD |
7205 |
Committed |
Performance
|
|
10/10
|
+196−5
|
Masahiko Sawada (masahikosawada) |
Bharath Rupireddy (bharathrupireddy) |
Masahiko Sawada (masahikosawada) |
1 |
3 weeks ago |
| re-add redundant filter clause to stats query |
7222 |
Committed |
Performance
|
stable |
10/10
|
+7−5
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
1 |
1 month ago |
| Planner support function for generate_subscripts() |
7226 |
Moved to different CF |
Good First Review
Performance
|
|
10/10
|
+398−2
|
shihao zhong (zhong950419) |
Andrew Krylosov (krylosov-aa), Priyanka Sangam (arcticwolf) |
|
2 |
1 week ago |
| Protocol compression: a fourth design |
7232 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
2 |
1 month ago |
| Reducing relcache memory usage: deduping index shapes |
7237 |
Moved to different CF |
Performance
|
|
10/10
|
+1445−233
|
Matthias van de Meent (mmeent) |
|
|
2 |
3 days ago |
| auto-vectorize varbit bitwise operators |
7251 |
Committed |
Performance
|
20 |
10/10
|
+23−14
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
2 |
1 month ago |
| REPACK (CONCURRENTLY) decoding worker is canceled by lock_timeout |
7270 |
Committed |
Good First Review
Performance
|
20 |
10/10
|
+89−0
|
shihao zhong (zhong950419) |
|
Álvaro Herrera (alvherre) |
2 |
2 weeks ago |