| Index Prefetching |
4351 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
|
|
15 |
5 days ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Needs review |
Performance
DDL
|
19 |
10/10
|
+3060−484
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
10 |
16 hours ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
10/10
|
+1427−744
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
9 |
4 days ago |
| Function scan FDW pushdown |
5470 |
Needs review |
Performance
|
18 |
10/10
|
+1348−104
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
Ashutosh Bapat (ashutoshbapat) |
|
3 |
3 weeks ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Needs review |
Performance
|
19 |
9/10
|
+1508−58
|
Alena Rybakina (a.rybakina) |
Ilia Evdokimov (ilidock95) |
|
7 |
1 week ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Greg Burd (gregburd) |
Nathan Bossart (bossartn) |
|
6 |
2 weeks 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 |
5 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) |
|
|
5 |
3 months ago |
| Improve the performance of Unicode Normalization Forms. |
5802 |
Ready for Committer |
Performance
|
|
10/10
|
+7706−12726
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov) |
|
6 |
2 weeks 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) |
|
4 |
4 weeks ago |
| Automatically sizing the IO worker pool |
5913 |
Needs review |
Performance
|
19 |
9/10
|
+348−0
|
Thomas Munro (macdice) |
|
|
4 |
yesterday |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Needs review |
Performance
|
19 |
10/10
|
+0−0
|
Lukas Fittl (lfittl) |
Zsolt Parragi (zsolt.parragi) |
|
5 |
4 days ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Needs review |
Performance
|
|
10/10
|
+417−9
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada) |
|
4 |
4 days ago |
| Optimization of the is_normalized() function. |
6152 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Alexander Borisov (lexborisov) |
|
|
4 |
4 days 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) |
|
|
3 |
5 days ago |
| Optimize SnapBuild by maintaining committed.xip in sorted order |
6187 |
Needs review |
Performance
Logical Replication
|
19 |
9/10
|
+151−25
|
Xuneng Zhou (dylanzhou) |
Yogesh Sharma (sharmay), Aditya Gollamudi (adigoll) |
|
4 |
3 days ago |
| Reduce unnecessary locking of pruned partitions when reusing cached plans |
6216 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
|
|
2 |
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 |
Waiting on Author |
Performance
libpq
|
stable |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) |
|
3 |
1 week ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Needs review |
postgres_fdw
Performance
|
19 |
10/10
|
+627−51
|
Rafia Sabih (rafia.sabih) |
|
|
2 |
2 days ago |
| parallel pgbench -i |
6242 |
Needs review |
Performance
|
|
10/10
|
+134−4
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
3 |
yesterday |
| 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 weeks ago |
| Add a greedy join search algorithm to handle large join problems |
6274 |
Waiting on Author |
Performance
|
|
3/10
|
+1922−4
|
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 |
4 months ago |
| Hash-based MCV matching for large IN-lists |
6356 |
Needs review |
Performance
|
stable |
10/10
|
+542−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
3 |
3 days ago |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
19 |
9/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
2 |
1 month ago |
| Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY |
6401 |
Needs review |
Performance
DDL
|
19 |
9/10
|
+1349−152
|
Mihail Nikalayeu (mihailnikalayeu) |
|
|
2 |
15 hours ago |
| Reduce build times of pg_trgm GIN indexes |
6418 |
Needs review |
Performance
|
19 |
10/10
|
+2−1
|
David Geier (geidav) |
Heikki Linnakangas (heikki) |
Heikki Linnakangas (heikki) |
2 |
2 days ago |
| ANALYZE: hash-accelerate MCV tracking for equality-only types |
6422 |
Waiting on Author |
Performance
|
|
10/10
|
+227−24
|
Chengpeng Yan (chengpeng.yan) |
Ilia Evdokimov (ilidock95), Tatsuya Kawata (croissant) |
|
2 |
1 month ago |
| LLVMJIT: introduce force-inlined functions |
6437 |
Needs review |
Performance
|
19 |
10/10
|
+103−4
|
Pierre Ducroquet (pinaraf) |
|
|
2 |
2 weeks ago |
| Unfortunate pushing down of expressions below sort |
6467 |
Waiting on Author |
Performance
|
|
10/10
|
+318−56
|
Chengpeng Yan (chengpeng.yan) |
|
|
2 |
4 days ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
10/10
|
+1523−127
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
2 |
5 days ago |
| Pipelined Recovery |
6487 |
Needs review |
Performance
|
19 |
9/10
|
+1988−40
|
Imran Zaheer (imranzaheer) |
|
|
2 |
3 days ago |
| Change the default wal_blocksize to 4KB |
6490 |
Needs review |
Performance
|
|
10/10
|
+12−12
|
Andy Pogrebnoi (birdofdada) |
|
|
2 |
2 weeks ago |
| synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
6543 |
Needs review |
Performance
Logical Replication
|
|
3/10
|
+1036−126
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
2 |
yesterday |
| Decorrelate nested tuple hash tables |
6553 |
Needs review |
Performance
|
19 |
9/10
|
+13−7
|
Ants Aasma (ants) |
|
|
2 |
1 month ago |
| Compress prune/freeze records with Delta Frame of Reference algorithm |
6574 |
Needs review |
Performance
|
|
8/10
|
+4868−35
|
Evgeny Voropaev (evoro) |
|
|
1 |
2 days ago |
| Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6580 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Surya Poondla (spoondla) |
|
|
1 |
2 weeks 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 |
1 week ago |
| A stack allocation API |
6591 |
Needs review |
Refactoring Only
Performance
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
3 weeks 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 |
1 week 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 weeks ago |
| Get rid of redundant StringInfo accumulation |
6622 |
Needs review |
Performance
|
19 |
10/10
|
+15−5
|
Daniil Davydov (dddaniil) |
|
|
1 |
1 week ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Needs review |
Performance
|
|
9/10
|
+422−9
|
Richard Guo (richardguo) |
|
|
1 |
2 weeks ago |
| Skip prefetch for block references that follow a FPW or WILL_INIT of the same block |
6634 |
Needs review |
Performance
Physical Replication
|
19 |
Needs rebase!
|
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
1 |
2 weeks ago |
| Extract numeric filed in JSONB more effectively |
6644 |
Needs review |
Performance
|
|
2/10
|
+1539−14
|
Andy Fan (andyf), Haibo Yan (billyean) |
|
|
1 |
yesterday |
| Optimize numeric comparison and aggregation via packed-datum extraction |
6651 |
Needs review |
Performance
|
|
10/10
|
+246−28
|
Chenhui Mo (littleganyu) |
|
|
1 |
1 week ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6653 |
Needs review |
Performance
|
19 |
10/10
|
+1523−127
|
Alexandre Felipe (afelipe) |
|
|
1 |
5 days ago |