| Index Prefetching |
4351 |
Needs review |
Performance
|
|
10/10
|
+8438−3394
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Jerry Zhang (xingtanzjr) |
|
16 |
4 days ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Needs review |
Performance
DDL
|
19 |
Needs rebase!
|
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
11 |
2 weeks ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
10 |
2 weeks ago |
| Function scan FDW pushdown |
5470 |
Needs review |
Performance
|
18 |
10/10
|
+0−0
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
Ashutosh Bapat (ashutoshbapat), Solaimurugan V (solaimurugan) |
|
4 |
4 days ago |
| Compress big WAL records |
5621 |
Waiting on Author |
Performance
|
|
10/10
|
+1949−124
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii), Zsolt Parragi (zsolt.parragi) |
|
6 |
4 days ago |
| Produce LLVM bitcode files on meson builds |
5671 |
Needs review |
Performance
|
19 |
10/10
|
+380−25
|
Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) |
Christoph Berg (myon) |
|
6 |
1 month ago |
| Extend skipping FK checks on replicas to include ADD FK and TRUNCATE |
5774 |
Needs review |
Performance
Help - Stuck Rebasing
Logical Replication
|
19 |
9/10
|
+96−3
|
Hannu Krosing (hannukrosing) |
Rafia Sabih (rafia.sabih), Murali Natti (murali.natti) |
|
6 |
2 weeks ago |
| Improve the performance of Unicode Normalization Forms. |
5802 |
Waiting on Author |
Performance
|
|
Needs rebase!
|
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov), Henson Choi (assam258.gmail.com) |
|
7 |
1 month ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Needs review |
Performance
System Administration
|
stable |
10/10
|
+926−89
|
Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) |
Dilip Kumar (dilip.kumar), solai v (solaiv) |
|
5 |
1 week ago |
| Adding basic NUMA awareness |
6049 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Tomas Vondra (fuzzycz) |
Jakub Wartak (jakub.wartak.tomtom) |
|
2 |
1 month ago |
| MPTCP - multiplexing many TCP connections through one socket to get better bandwidth |
6061 |
Needs review |
Performance
|
20 |
10/10
|
+118−2
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
4 |
4 days ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Needs review |
Performance
|
|
10/10
|
+649−33
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada), solai v (solaiv) |
|
5 |
2 weeks ago |
| Batching in executor, part 1: add batch variant of table AM scan API |
6176 |
Needs review |
Help - Benchmarks
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
Antonin Houska (a.houska), Thom Brown (thom), Denis Smirnov (darthunix) |
|
4 |
5 days ago |
| Reduce unnecessary locking of pruned partitions when reusing cached plans |
6216 |
Waiting on Author |
Performance
|
19 |
10/10
|
+1049−92
|
Amit Langote (amitlan) |
Ilmar Yunusov (tanswis42.gmail.com) |
|
3 |
1 month ago |
| pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized |
6219 |
Needs review |
Performance
libpq
|
stable |
10/10
|
+420−64
|
Hannu Krosing (hannukrosing) |
Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) |
|
4 |
2 weeks ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Needs review |
postgres_fdw
Performance
|
19 |
10/10
|
+2253−116
|
Rafia Sabih (rafia.sabih) |
|
|
3 |
2 days ago |
| Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) |
6245 |
Ready for Committer |
Performance
My First Patch
Refactoring Only
|
19 |
10/10
|
+978−150
|
Boris Mironov (bmironov) |
Egor Madyshev (emadyshev) |
|
4 |
5 months ago |
| Hash-based MCV matching for large IN-lists |
6356 |
Ready for Committer |
Performance
|
stable |
10/10
|
+543−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
4 |
2 months ago |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
20 |
10/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
3 |
5 months ago |
| Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY |
6401 |
Needs review |
Performance
DDL
|
19 |
10/10
|
+1347−152
|
Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
3 |
2 weeks ago |
| LLVMJIT: introduce force-inlined functions |
6437 |
Needs review |
Performance
|
20 |
10/10
|
+103−4
|
Pierre Ducroquet (pinaraf) |
|
|
3 |
5 months ago |
| Remove no-op PlaceHolderVars |
6457 |
Needs review |
Performance
|
19 |
10/10
|
+357−240
|
Richard Guo (richardguo) |
|
|
2 |
7 months ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
1/2
|
+3855−247
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
3 |
2 hours ago |
| Pipelined Recovery |
6487 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Imran Zaheer (imranzaheer) |
Nitin Jadhav (nitinjadhav11) |
|
3 |
5 days ago |
| Change the default wal_blocksize to 4KB |
6490 |
Needs review |
Performance
|
|
10/10
|
+12−12
|
Andy Pogrebnoi (birdofdada) |
|
|
3 |
1 month ago |
| Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6580 |
Needs review |
Performance
|
19 |
10/10
|
+246−43
|
Surya Poondla (spoondla) |
|
|
2 |
3 weeks ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Needs review |
Performance
|
|
10/10
|
+422−9
|
Richard Guo (richardguo) |
|
|
2 |
4 months ago |
| Prevent repeated deadlock-check signals in standby buffer pin waits |
6690 |
Ready for Committer |
Performance
|
19 |
Needs rebase!
|
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii), Henson Choi (assam258.gmail.com), Ilmar Yunusov (tanswis42.gmail.com) |
Fujii Masao (masaofujii) |
2 |
1 month ago |
| Logical Replication - revisit `is_table_publication` function implementation |
6705 |
Ready for Committer |
Refactoring Only
Performance
|
stable |
10/10
|
+29−29
|
Peter Smith (smithpb2250) |
bingshuai li (kid1019) |
|
2 |
3 days ago |
| Add join MCV statistics for selectivity estimation |
6724 |
Needs review |
DDL
PGConf.dev
Performance
|
|
Needs rebase!
|
|
Alexandra Wang (alexandrawang) |
Tom Lane (tgl) |
|
2 |
2 weeks ago |
| Improve pg_stat_statements scalability |
6763 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Sami Imseih (simseih) |
Tristan Partin (tristan957) |
|
2 |
3 weeks ago |
| hashjoins vs. Bloom filters |
6818 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Tomas Vondra (fuzzycz) |
Rui Zhao (zhaorui) |
|
2 |
2 days ago |
| btree_gist: add cross-type integer operator support for GiST |
6854 |
Ready for Committer |
Performance
My First Patch
|
20 |
10/10
|
+1391−51
|
Alexander Nestorov (alexandernst) |
Maxime Schoemans (mschoema) |
Tom Lane (tgl) |
2 |
3 weeks ago |
| Unexpected reindex when altering column types for partitioned tables |
6887 |
Needs review |
DDL
Performance
|
|
Needs rebase!
|
|
Álvaro Rodríguez (arodrgr) |
|
|
2 |
2 months ago |
| Randomize B-Tree page split location to avoid oscillating patterns |
6892 |
Needs review |
Performance
|
stable |
9/10
|
+65−4
|
Dmitry Dolgov (erthalion) |
|
|
2 |
2 months ago |
| Fold NOT IN / <> ALL expressions containing NULL to FALSE |
6901 |
Needs review |
Performance
|
stable |
10/10
|
+96−16
|
Ilia Evdokimov (ilidock95) |
|
|
2 |
2 weeks ago |
| Improve row estimation with multi-column unique indexes |
6932 |
Needs review |
Performance
|
20 |
10/10
|
+669−284
|
Anthonin Bonnefoy (bonnefoa) |
|
|
2 |
1 month ago |
| Reduce reorder buffer spill from O(N²) to O(N) during vacuum storms |
6933 |
Needs review |
Performance
Logical Replication
|
20 |
10/10
|
+764−61
|
Rui Zhao (zhaorui) |
|
|
2 |
3 months 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 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Nathan Bossart (bossartn), Greg Burd (gregburd) |
Bharath Rupireddy (bharathrupireddy) |
|
1 |
3 weeks ago |
| replacing join_collapse_limit with a join hardness estimate |
6973 |
Needs review |
Performance
|
|
1/2
|
+1403−3
|
Tomas Vondra (fuzzycz) |
|
|
1 |
1 month ago |
| json/jsonb cleanup + FmgrInfo caching |
6975 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Robert Haas (rhaas) |
|
|
1 |
1 month ago |
| Lazy LEFT NestLoop JOIN: gate rescanning of the inner side by outer-side-only join clauses |
6981 |
Needs review |
Performance
|
20 |
9/10
|
+469−252
|
Andrei Lepikhov (lepikhov), Mikhail Zhilin (mizhka-at-pgpro), Peter Petrov (pspetrov) |
|
|
1 |
3 weeks ago |
| [PATCH v1 0/7] Wait event timing and tracing instrumentation |
6984 |
Needs review |
Performance
Monitoring
|
|
10/10
|
+5607−9
|
Dmitry Fomin (dmitryf) |
|
|
1 |
3 weeks ago |
| lazy_scan_heap: avoid vacuum block, already vacuumed (src/backend/access/heap/vacuumlazy.c) |
6993 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Ranier Vilela (raniervilela) |
shihao zhong (zhong950419) |
|
1 |
3 weeks ago |
| Batched clock sweep to reduce cross-socket atomic contention |
7000 |
Needs review |
Performance
|
20 |
10/10
|
+333−115
|
Jim Mlodgenski (jimmy76), Greg Burd (gregburd) |
|
|
1 |
3 weeks ago |
| Use Boyer-Moore-Horspool for simple LIKE contains patterns |
7013 |
Needs review |
Performance
|
20 |
10/10
|
+721−2
|
Atsushi Ogawa (atsushio) |
|
|
1 |
1 month ago |
| Do not flush BufFile for regular temp files on close |
7020 |
Ready for Committer |
Performance
|
stable |
10/10
|
+3−2
|
Sergey Solovev (ashblade) |
Pierre Forstmann (pifor) |
|
1 |
6 days ago |
| Caching a partition index's parent OID in the relcache? |
7030 |
Needs review |
Performance
|
20 |
10/10
|
+229−6
|
Ayush Tiwari (aytiwari) |
|
|
1 |
1 month ago |
| Rewrite undirected edge patterns in GRAPH_TABLE using UNION ALL |
7034 |
Needs review |
Performance
|
20 |
10/10
|
+307−26
|
Ayoub Kazar (kaz) |
|
|
1 |
3 weeks ago |
| read stream: Backward I/O combining |
7035 |
Needs review |
Performance
|
|
9/10
|
+951−123
|
Nazir Bilal Yavuz (nbyavuz) |
|
|
1 |
4 weeks ago |
| Tracking per-RelOptInfo uniqueness during planning |
7045 |
Needs review |
Performance
|
20 |
10/10
|
+3214−169
|
Richard Guo (richardguo) |
Antonin Houska (a.houska) |
|
1 |
5 days ago |
| Add a pg_wal_preallocate() SQL function to eagerly create future WAL segments |
7052 |
Ready for Committer |
Help - Benchmarks
Performance
|
20 |
10/10
|
+257−0
|
Ayush Tiwari (aytiwari) |
Bharath Rupireddy (bharathrupireddy), solai v (solaiv) |
|
1 |
1 week ago |
| Speed up repeat() for larger counts |
7060 |
Needs review |
Performance
|
20 |
10/10
|
+26−2
|
Chenhui Mo (littleganyu) |
Jan Nidzwetzki (jnidzwetzki) |
|
1 |
6 days ago |
| psql: filter system functions before visibility checks |
7061 |
Needs review |
Bugfix
Performance
|
20 |
10/10
|
+34−4
|
xiaoyu liu (raindrop) |
Jan Nidzwetzki (jnidzwetzki) |
|
1 |
2 days ago |
| Add planner support function to two-argument regexp_like() |
7069 |
Ready for Committer |
Good First Review
Performance
|
stable |
10/10
|
+79−1
|
shihao zhong (zhong950419) |
Pierre Forstmann (pifor) |
|
1 |
4 days ago |
| Extending Self-Join Elimination to partitioned tables |
7073 |
Needs review |
Performance
|
|
10/10
|
+579−1
|
Quan Truong (quant0) |
|
|
1 |
2 weeks ago |
| add SQL type INT16 based on int128 |
7077 |
Needs review |
Performance
|
20 |
9/10
|
+8802−0
|
Vladlen Popolitov (vladlenpopolitov) |
|
|
1 |
3 weeks ago |
| a large LIMIT makes some sorts slower |
7084 |
Needs review |
Bugfix
Performance
|
20 |
10/10
|
+54−14
|
Chengpeng Yan (chengpeng.yan) |
|
|
1 |
2 weeks ago |
| Batch fsyncs when recycling WAL segments |
7088 |
Needs review |
Performance
|
20 |
9/10
|
+408−23
|
Ayush Tiwari (aytiwari) |
Bharath Rupireddy (bharathrupireddy) |
|
1 |
5 days ago |
| Parallel heap vacuum |
7102 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Masahiko Sawada (masahikosawada), Bharath Rupireddy (bharathrupireddy) |
|
|
1 |
1 month ago |
| Multi-insert for logical replication apply |
7104 |
Needs review |
Performance
Logical Replication
|
20 |
3/10
|
+378−2
|
Bharath Rupireddy (bharathrupireddy) |
|
|
1 |
6 days ago |
| Index skip-merge scan |
7116 |
Needs review |
Performance
|
20 |
4/10
|
+1275−4
|
Alexandre Felipe (afelipe) |
|
|
1 |
2 weeks ago |
| Support specialized B-tree page searches |
7119 |
Needs review |
Performance
|
|
10/10
|
+695−8
|
Andrey Borodin (x4m) |
|
|
1 |
2 weeks ago |
| Avoid streaming zero-filled WAL switch padding |
7123 |
Needs review |
Performance
Physical Replication
|
|
10/10
|
+445−8
|
Andrey Borodin (x4m) |
|
|
1 |
2 weeks ago |
| Reduce cost of ProcArrayRemove/ProcArrayAdd |
7139 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Maksim Melnikov (manaldush) |
Matthias van de Meent (mmeent) |
|
1 |
1 week ago |
| Refactor remaining zero-fill relation extensions to use smgrzeroextend() |
7141 |
Needs review |
Performance
|
20 |
10/10
|
+13−20
|
peipei yin (yinpeipei) |
|
|
1 |
1 week ago |
| enhancing pg_basebackup speeds up to ~23Gbps (small fixes + io_uring/Direct I/O) |
7142 |
Needs review |
Performance
|
20 |
5/10
|
+965−91
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
1 |
1 week ago |
| [PATCH] Consider window functions when reordering GROUP BY items |
7150 |
Needs review |
Performance
|
20 |
2/10
|
+250−20
|
Zhenglong Li (smartkeyerror.gmail.com) |
|
|
1 |
1 week ago |
| Pull up sublinks that reference both sides of a new semijoin |
7155 |
Needs review |
Performance
|
20 |
3/10
|
+756−8
|
Richard Guo (richardguo) |
|
|
1 |
1 week ago |
| Apply extended statistics to join clause during parameterized path costing |
7161 |
Needs review |
Performance
|
stable |
10/10
|
+42−3
|
Ilia Evdokimov (ilidock95) |
|
|
1 |
2 days ago |
| Write Combining |
7171 |
Needs review |
Performance
|
|
10/10
|
+2212−420
|
Melanie Plageman (melanieplageman) |
|
|
1 |
2 days ago |