| Index Prefetching |
4351 |
Needs review |
Performance
|
|
10/10
|
+8440−3390
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Jerry Zhang (xingtanzjr) |
|
15 |
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) |
|
10 |
3 weeks ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
3/10
|
+1695−874
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
9 |
2 weeks ago |
| Function scan FDW pushdown |
5470 |
Needs review |
Performance
|
18 |
9/10
|
+1626−57
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
Ashutosh Bapat (ashutoshbapat), Solaimurugan V (solaimurugan) |
|
3 |
2 weeks ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Needs review |
Performance
|
19 |
10/10
|
+1508−58
|
Alena Rybakina (a.rybakina) |
Ilia Evdokimov (ilidock95), Solaimurugan V (solaimurugan) |
|
7 |
2 months ago |
| starjoin join order planning |
5553 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Tomas Vondra (fuzzycz) |
|
|
4 |
1 month ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Waiting on Author |
Performance
|
19 |
Needs rebase!
|
|
Greg Burd (gregburd) |
Nathan Bossart (bossartn) |
|
6 |
3 months 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) |
|
5 |
4 days ago |
| Extend skipping FK checks on replicas to include ADD FK and TRUNCATE |
5774 |
Needs review |
Performance
Help - Stuck Rebasing
Logical Replication
|
19 |
10/10
|
+96−3
|
Hannu Krosing (hannukrosing) |
Rafia Sabih (rafia.sabih) |
|
5 |
2 days 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) |
|
6 |
1 week ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Needs review |
Performance
System Administration
|
stable |
Needs rebase!
|
|
Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) |
Dilip Kumar (dilip.kumar), solai v (solaiv) |
|
4 |
1 month ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Needs review |
Performance
PGConf.dev
|
|
10/10
|
+0−0
|
Lukas Fittl (lfittl) |
|
|
5 |
3 months ago |
| Improve read_local_xlog_page_guts by replacing polling with latch-based waiting |
6024 |
Needs review |
Performance
Logical Replication
|
19 |
10/10
|
+40−11
|
Xuneng Zhou (dylanzhou) |
Rui Zhao (zhaorui) |
|
4 |
1 month ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Needs review |
Performance
|
|
10/10
|
+478−29
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada), solai v (solaiv) |
|
4 |
1 month ago |
| Optimization of the is_normalized() function. |
6152 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Alexander Borisov (lexborisov) |
|
|
4 |
3 months ago |
| Batching in executor, part 1: add batch variant of table AM scan API |
6176 |
Needs review |
Help - Benchmarks
Performance
|
19 |
10/10
|
+891−4
|
Amit Langote (amitlan) |
Antonin Houska (a.houska), Thom Brown (thom), Denis Smirnov (darthunix) |
|
3 |
yesterday |
| 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) |
|
2 |
2 weeks ago |
| pg_dump flag for dumping tables data in multiple chunks, for huge tables can often give near-linear speedup when parallelized |
6219 |
Waiting on Author |
Performance
libpq
|
stable |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) |
|
3 |
3 months ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Needs review |
postgres_fdw
Performance
|
19 |
10/10
|
+1866−58
|
Rafia Sabih (rafia.sabih) |
|
|
2 |
22 hours ago |
| parallel pgbench -i |
6242 |
Needs review |
Performance
|
|
9/10
|
+269−27
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
3 |
2 months 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) |
|
3 |
4 months ago |
| Add a greedy join search algorithm to handle large join problems |
6274 |
Waiting on Author |
Performance
|
|
3/10
|
+1921−3
|
Chengpeng Yan (chengpeng.yan) |
lakshmi g (lakshmi) |
|
3 |
4 weeks ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Needs review |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
3 |
2 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) |
|
3 |
4 weeks ago |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
19 |
10/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
2 |
4 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) |
|
|
2 |
3 months ago |
| Reduce build times of pg_trgm GIN indexes |
6418 |
Needs review |
Performance
|
19 |
10/10
|
+225−209
|
David Geier (geidav) |
Heikki Linnakangas (heikki) |
Heikki Linnakangas (heikki) |
2 |
2 months ago |
| LLVMJIT: introduce force-inlined functions |
6437 |
Needs review |
Performance
|
19 |
10/10
|
+103−4
|
Pierre Ducroquet (pinaraf) |
|
|
2 |
3 months ago |
| Unfortunate pushing down of expressions below sort |
6467 |
Waiting on Author |
Performance
|
|
10/10
|
+318−56
|
Chengpeng Yan (chengpeng.yan) |
|
|
2 |
3 months ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
10/10
|
+3121−249
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
2 |
13 hours ago |
| Pipelined Recovery |
6487 |
Needs review |
Performance
|
20 |
10/10
|
+2339−45
|
Imran Zaheer (imranzaheer) |
|
|
2 |
yesterday |
| Change the default wal_blocksize to 4KB |
6490 |
Needs review |
Performance
|
|
9/10
|
+12−12
|
Andy Pogrebnoi (birdofdada) |
|
|
2 |
3 months ago |
| synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
6543 |
Needs review |
Performance
Logical Replication
|
|
10/10
|
+1084−142
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
2 |
3 weeks ago |
| Decorrelate nested tuple hash tables |
6553 |
Needs review |
Performance
|
19 |
9/10
|
+13−7
|
Ants Aasma (ants) |
|
|
2 |
4 months ago |
| Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6580 |
Needs review |
Performance
|
19 |
10/10
|
+246−43
|
Surya Poondla (spoondla) |
|
|
1 |
17 hours ago |
| Speed up COPY TO text/CSV parsing using SIMD |
6588 |
Needs review |
Performance
|
19 |
9/10
|
+262−18
|
Ayoub Kazar (kaz) |
Nathan Bossart (bossartn) |
Nathan Bossart (bossartn) |
1 |
3 months ago |
| A stack allocation API |
6591 |
Needs review |
Refactoring Only
Performance
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
4 months ago |
| Get rid of redundant StringInfo accumulation |
6622 |
Needs review |
Performance
|
19 |
10/10
|
+15−5
|
Daniil Davydov (dddaniil) |
|
|
1 |
3 months ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Needs review |
Performance
|
|
10/10
|
+422−9
|
Richard Guo (richardguo) |
|
|
1 |
3 months ago |
| Skip prefetch for block references that follow a FPW or WILL_INIT of the same block |
6634 |
Ready for Committer |
Performance
Physical Replication
|
19 |
9/10
|
+28−6
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
Ethan Mertz (ethanmertz) |
|
1 |
1 month ago |
| Extract numeric filed in JSONB more effectively |
6644 |
Needs review |
Performance
|
|
10/10
|
+3155−10
|
Andy Fan (andyf), Haibo Yan (billyean) |
|
|
1 |
2 months ago |
| pg_dump: eliminate tmpfile double-write in tar format output |
6686 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Josh Kupershmidt (schmiddy) |
|
|
1 |
3 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) |
1 |
3 weeks ago |
| Extend MXactCache lifetime from per-transaction to per-session |
6693 |
Needs review |
Performance
|
19 |
10/10
|
+47−20
|
JoongHyuk Shin (shin) |
Henson Choi (assam258.gmail.com) |
|
1 |
3 months ago |
| Remove dead code in ExecForPortionOfLeftovers() |
6697 |
Needs review |
Good First Review
Performance
|
19 |
10/10
|
+0−14
|
Aleksander Alekseev (a.alekseev) |
|
|
1 |
3 months ago |
| Logical Replication - revisit `is_table_publication` function implementation |
6705 |
Needs review |
Refactoring Only
Performance
|
stable |
10/10
|
+28−27
|
Peter Smith (smithpb2250) |
|
|
1 |
9 hours ago |
| Cleanup: Replace sscanf with strtol/strtoul in snapmgr |
6709 |
Ready for Committer |
Refactoring Only
Performance
|
|
10/10
|
+37−10
|
Amul Sul (sulamul) |
Andreas Karlsson (kandreas) |
|
1 |
2 months ago |
| Improve HASH overflow page reuse by preferring recently freed pages to enhance locality. |
6718 |
Needs review |
Performance
|
|
Needs rebase!
|
|
lakshmi g (lakshmi) |
|
|
1 |
2 months ago |
| Add join MCV statistics for selectivity estimation |
6724 |
Needs review |
DDL
PGConf.dev
Performance
|
|
9/10
|
+6634−764
|
Alexandra Wang (alexandrawang) |
Tom Lane (tgl) |
|
1 |
6 days ago |
| Skip prefetch for block references that follow a FPW or WILL_INIT of the same block |
6730 |
Needs review |
Performance
|
19 |
2/10
|
+28−6
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
1 |
1 month ago |
| Improve pg_stat_statements scalability |
6763 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Sami Imseih (simseih) |
Tristan Partin (tristan957) |
|
1 |
5 days ago |
| [SQL/PGQ] Early pruning for GRAPH_TABLE path generation |
6771 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Zhao Junwang (zhjwpku) |
|
|
1 |
2 months ago |
| Improving index selection for logical replication apply with replica identity full |
6814 |
Needs review |
Performance
Logical Replication
|
20 |
10/10
|
+87−3
|
Ethan Mertz (ethanmertz) |
|
|
1 |
3 weeks ago |
| hashjoins vs. Bloom filters |
6818 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Tomas Vondra (fuzzycz) |
|
|
1 |
14 hours ago |
| Make printtup a bit faster |
6829 |
Needs review |
Performance
|
20 |
10/10
|
+453−88
|
Andres Freund (andresfreund), Andy Fan (andy2) |
|
|
1 |
1 month ago |
| RFC / proof-of-concept for Umbra, an smgr-layer prototype that decouples logical block identity from physical page placement. For eligible ordinary updates after checkpoint, the prototype preserves the old physical page as the redo baseline and records the old/new physical mapping in WAL, reducing reliance on inline full-page images for those paths. The performance motivation is to reduce checkpoint-boundary WAL volume and recover part of the throughput lost to full-page writes on write-he |
6832 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Mingwei Jia (nayishan) |
|
|
1 |
1 month ago |
| btree_gist: add cross-type integer operator support for GiST |
6854 |
Needs review |
Performance
My First Patch
|
20 |
10/10
|
+1391−51
|
Alexander Nestorov (alexandernst) |
Maxime Schoemans (mschoema) |
Tom Lane (tgl) |
1 |
2 weeks ago |
| Add support for SAOP in the optimizer for partial index paths |
6858 |
Needs review |
Performance
|
20 |
9/10
|
+563−0
|
Jim Vanns (jimv) |
|
|
1 |
1 month ago |
| Remove redundant DISTINCT when GROUP BY already guarantees uniqueness |
6869 |
Waiting on Author |
Performance
|
stable |
9/10
|
+237−1
|
Ilia Evdokimov (ilidock95) |
Andrés Taylor (systay) |
|
1 |
1 month ago |
| Reduce outer joins in more cases |
6886 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Richard Guo (richardguo) |
|
|
1 |
4 weeks ago |
| Unexpected reindex when altering column types for partitioned tables |
6887 |
Needs review |
DDL
Performance
|
|
10/10
|
+157−42
|
Álvaro Rodríguez (arodrgr) |
|
|
1 |
1 month ago |
| Randomize B-Tree page split location to avoid oscillating patterns |
6892 |
Needs review |
Performance
|
stable |
9/10
|
+65−4
|
Dmitry Dolgov (erthalion) |
|
|
1 |
1 month ago |
| Fold NOT IN / <> ALL expressions containing NULL to FALSE |
6901 |
Needs review |
Performance
|
stable |
10/10
|
+96−16
|
Ilia Evdokimov (ilidock95) |
|
|
1 |
1 month ago |
| Adding a { LOCK ROWS | LOCK KEY INDEX } clause to FK definitions |
6923 |
Needs review |
Performance
SQL Commands
|
|
2/10
|
+578−41
|
Matthias van de Meent (mmeent) |
|
|
1 |
4 weeks ago |
| Improve row estimation with multi-column unique indexes |
6932 |
Needs review |
Performance
|
20 |
10/10
|
+669−284
|
Anthonin Bonnefoy (bonnefoa) |
|
|
1 |
2 weeks 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) |
|
|
1 |
2 months ago |
| Optimize UUID parse using SIMD |
6944 |
Needs review |
Performance
|
|
10/10
|
+167−5
|
Masahiko Sawada (masahikosawada) |
Haibo Yan (billyean) |
|
1 |
3 weeks ago |
| hash joins vs. bitmap filters |
6964 |
Needs review |
Performance
|
20 |
3/10
|
+713−3
|
Ben Mejia (benmejia) |
|
|
1 |
2 weeks ago |