| Index Prefetching |
4351 |
Needs review |
Performance
|
|
9/10
|
+7315−2977
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Jerry Zhang (xingtanzjr) |
|
15 |
6 days ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Needs review |
Performance
DDL
|
19 |
3/10
|
+3060−484
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
10 |
2 months ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
10/10
|
+1427−744
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
9 |
2 months ago |
| Function scan FDW pushdown |
5470 |
Needs review |
Performance
|
18 |
10/10
|
+1416−44
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
Ashutosh Bapat (ashutoshbapat), Solaimurugan V (solaimurugan) |
|
3 |
1 month 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 |
1 month ago |
| starjoin join order planning |
5553 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Tomas Vondra (fuzzycz) |
|
|
4 |
2 weeks ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Waiting on Author |
Performance
|
19 |
Needs rebase!
|
|
Greg Burd (gregburd) |
Nathan Bossart (bossartn) |
|
6 |
2 months ago |
| Produce LLVM bitcode files on meson builds |
5671 |
Needs review |
Performance
|
19 |
10/10
|
+928−58
|
Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) |
|
|
5 |
2 months 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) |
|
|
5 |
5 months ago |
| Improve the performance of Unicode Normalization Forms. |
5802 |
Ready for Committer |
Performance
|
|
10/10
|
+0−0
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov), Henson Choi (assam258.gmail.com) |
|
6 |
1 month ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Needs review |
Performance
System Administration
|
stable |
8/10
|
+947−101
|
Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) |
Dilip Kumar (dilip.kumar), solai v (solaiv) |
|
4 |
1 week ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Needs review |
Performance
PGConf.dev
|
|
10/10
|
+0−0
|
Lukas Fittl (lfittl) |
|
|
5 |
2 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 week 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 |
3 weeks ago |
| Optimization of the is_normalized() function. |
6152 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Alexander Borisov (lexborisov) |
|
|
4 |
2 months 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) |
Thom Brown (thom) |
|
3 |
2 months 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) |
|
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 |
2 months ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Needs review |
postgres_fdw
Performance
|
19 |
Needs rebase!
|
|
Rafia Sabih (rafia.sabih) |
|
|
2 |
5 days ago |
| parallel pgbench -i |
6242 |
Needs review |
Performance
|
|
10/10
|
+269−27
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
3 |
1 month 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) |
Fujii Masao (masaofujii), Egor Madyshev (emadyshev) |
|
3 |
3 months ago |
| Add a greedy join search algorithm to handle large join problems |
6274 |
Waiting on Author |
Performance
|
|
10/10
|
+0−0
|
Chengpeng Yan (chengpeng.yan) |
lakshmi g (lakshmi) |
|
3 |
1 month ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Needs review |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
3 |
1 month ago |
| Hash-based MCV matching for large IN-lists |
6356 |
Ready for Committer |
Performance
|
stable |
Needs rebase!
|
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
3 |
2 months ago |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
19 |
10/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
2 |
3 months ago |
| Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY |
6401 |
Needs review |
Performance
DDL
|
19 |
9/10
|
+1347−152
|
Mihail Nikalayeu (mihailnikalayeu) |
|
|
2 |
2 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 |
1 month ago |
| LLVMJIT: introduce force-inlined functions |
6437 |
Needs review |
Performance
|
19 |
10/10
|
+103−4
|
Pierre Ducroquet (pinaraf) |
|
|
2 |
2 months ago |
| Unfortunate pushing down of expressions below sort |
6467 |
Waiting on Author |
Performance
|
|
10/10
|
+318−56
|
Chengpeng Yan (chengpeng.yan) |
|
|
2 |
2 months ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
9/10
|
+2815−250
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
2 |
2 weeks ago |
| Pipelined Recovery |
6487 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Imran Zaheer (imranzaheer) |
|
|
2 |
1 month ago |
| Change the default wal_blocksize to 4KB |
6490 |
Needs review |
Performance
|
|
9/10
|
+12−12
|
Andy Pogrebnoi (birdofdada) |
|
|
2 |
2 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 |
2 days ago |
| Decorrelate nested tuple hash tables |
6553 |
Needs review |
Performance
|
19 |
9/10
|
+13−7
|
Ants Aasma (ants) |
|
|
2 |
3 months ago |
| Compress prune/freeze records with Delta Frame of Reference algorithm |
6574 |
Needs review |
Performance
|
|
10/10
|
+5238−60
|
Evgeny Voropaev (evoro) |
|
|
1 |
2 months ago |
| Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6580 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Surya Poondla (spoondla) |
|
|
1 |
1 month 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 |
2 months ago |
| A stack allocation API |
6591 |
Needs review |
Refactoring Only
Performance
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
3 months ago |
| This adds a new GUC parameter that automatically rolls back prepared transactions that have remained unresolved beyond the configured timeout. The cleanup is performed by the checkpointer process. |
6611 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Nikhil Chawla (nchawla) |
|
|
1 |
2 months ago |
| Make \d tablename fast again, regression introduced by 85b7efa1cdd |
6615 |
Needs review |
Bugfix
Performance
|
18 |
10/10
|
+31−1
|
Jelte Fennema-Nio (jeltef) |
|
|
1 |
2 months ago |
| Get rid of redundant StringInfo accumulation |
6622 |
Needs review |
Performance
|
19 |
10/10
|
+15−5
|
Daniil Davydov (dddaniil) |
|
|
1 |
2 months ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Needs review |
Performance
|
|
10/10
|
+422−9
|
Richard Guo (richardguo) |
|
|
1 |
2 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 |
10/10
|
+28−6
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
Ethan Mertz (ethanmertz) |
|
1 |
2 weeks ago |
| Extract numeric filed in JSONB more effectively |
6644 |
Needs review |
Performance
|
|
10/10
|
+3155−10
|
Andy Fan (andyf), Haibo Yan (billyean) |
|
|
1 |
1 month ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6653 |
Needs review |
Performance
|
19 |
9/10
|
+2815−250
|
Alexandre Felipe (afelipe) |
|
|
1 |
2 weeks ago |
| pg_dump: eliminate tmpfile double-write in tar format output |
6686 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Josh Kupershmidt (schmiddy) |
|
|
1 |
2 months ago |
| Prevent repeated deadlock-check signals in standby buffer pin waits |
6690 |
Ready for Committer |
Performance
|
19 |
10/10
|
+198−12
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii), Ilmar Yunusov (tanswis42.gmail.com) |
Fujii Masao (masaofujii) |
1 |
2 weeks ago |
| Extend MXactCache lifetime from per-transaction to per-session |
6693 |
Needs review |
Performance
|
19 |
10/10
|
+47−20
|
JoongHyuk Shin (shin) |
|
|
1 |
2 months ago |
| Remove dead code in ExecForPortionOfLeftovers() |
6697 |
Needs review |
Good First Review
Performance
|
19 |
10/10
|
+0−14
|
Aleksander Alekseev (a.alekseev) |
|
|
1 |
1 month ago |
| Logical Replication - revisit `is_table_publication` function implementation |
6705 |
Needs review |
Refactoring Only
Performance
|
stable |
10/10
|
+28−27
|
Peter Smith (smithpb2250) |
|
|
1 |
1 month 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 |
1 month ago |
| Improve HASH overflow page reuse by preferring recently freed pages to enhance locality. |
6718 |
Needs review |
Performance
|
|
Needs rebase!
|
|
lakshmi g (lakshmi) |
|
|
1 |
1 month ago |
| Propagate stadistinct through GROUP BY/DISTINCT in subqueries and CTEs |
6721 |
Needs review |
Performance
|
|
10/10
|
+221−14
|
Richard Guo (richardguo) |
|
|
1 |
2 months ago |
| Add join MCV statistics for selectivity estimation |
6724 |
Needs review |
DDL
PGConf.dev
Performance
|
|
10/10
|
+5487−218
|
Alexandra Wang (alexandrawang) |
Tom Lane (tgl) |
|
1 |
3 weeks ago |
| Skip prefetch for block references that follow a FPW or WILL_INIT of the same block |
6730 |
Needs review |
Performance
|
19 |
10/10
|
+28−6
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
1 |
2 weeks ago |
| Improve pg_stat_statements scalability |
6763 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Sami Imseih (simseih) |
Tristan Partin (tristan957) |
|
1 |
1 week ago |
| [SQL/PGQ] Early pruning for GRAPH_TABLE path generation |
6771 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Zhao Junwang (zhjwpku) |
|
|
1 |
1 month ago |
| Improving index selection for logical replication apply with replica identity full |
6814 |
Needs review |
Performance
Logical Replication
|
20 |
10/10
|
+103−10
|
Ethan Mertz (ethanmertz) |
|
|
1 |
4 days ago |
| hashjoins vs. Bloom filters |
6818 |
Needs review |
Performance
|
|
4/10
|
+1566−6
|
Tomas Vondra (fuzzycz) |
|
|
1 |
2 weeks ago |
| Make printtup a bit faster |
6829 |
Needs review |
Performance
|
20 |
9/10
|
+453−88
|
Andres Freund (andresfreund), Andy Fan (andy2) |
|
|
1 |
2 weeks 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 |
2 weeks ago |
| Add per-backend lock statistics |
6838 |
Needs review |
Performance
Monitoring
|
20 |
10/10
|
+191−17
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
1 |
2 weeks ago |
| Use ssup_datum_*_cmp for int2, oid, and oid8 sort support |
6851 |
Needs review |
Performance
|
|
10/10
|
+3−40
|
Baji Shaik (bajishaik) |
|
John Naylor (john.naylor) |
1 |
2 weeks ago |
| btree_gist: add cross-type integer operator support for GiST |
6854 |
Needs review |
Performance
My First Patch
|
20 |
10/10
|
+1305−36
|
Alexander Nestorov (alexandernst) |
|
|
1 |
1 week 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 week ago |
| Remove redundant DISTINCT when GROUP BY already guarantees uniqueness |
6869 |
Needs review |
Performance
|
stable |
10/10
|
+237−1
|
Ilia Evdokimov (ilidock95) |
|
|
1 |
1 week ago |
| Reduce outer joins in more cases |
6886 |
Needs review |
Performance
|
20 |
10/10
|
+1082−61
|
Richard Guo (richardguo) |
|
|
1 |
6 days ago |
| Unexpected reindex when altering column types for partitioned tables |
6887 |
Needs review |
DDL
Performance
|
|
10/10
|
+157−42
|
Álvaro Rodríguez (arodrgr) |
|
|
1 |
5 days ago |
| Randomize B-Tree page split location to avoid oscillating patterns |
6892 |
Needs review |
Performance
|
stable |
9/10
|
+65−4
|
Dmitry Dolgov (erthalion) |
|
|
1 |
5 days ago |
| Fold NOT IN / <> ALL expressions containing NULL to FALSE |
6901 |
Needs review |
Performance
|
stable |
10/10
|
+96−16
|
Ilia Evdokimov (ilidock95) |
|
|
1 |
4 days ago |