| Index Prefetching |
4351 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Jerry Zhang (xingtanzjr) |
|
15 |
1 month 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 |
1 month ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
10/10
|
+1427−744
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
9 |
1 month 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 |
2 days 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 week ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Waiting on Author |
Performance
|
19 |
Needs rebase!
|
|
Greg Burd (gregburd) |
Nathan Bossart (bossartn) |
|
6 |
1 month 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 |
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 |
10/10
|
+96−3
|
Hannu Krosing (hannukrosing) |
|
|
5 |
4 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 |
2 weeks ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Needs review |
Performance
System Administration
|
stable |
9/10
|
+871−101
|
Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) |
Dilip Kumar (dilip.kumar), solai v (solaiv) |
|
4 |
21 hours ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Needs review |
Performance
PGConf.dev
|
|
0/1
|
+0−0
|
Lukas Fittl (lfittl) |
|
|
5 |
1 month 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) |
|
|
4 |
3 months 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), solai v (solaiv) |
|
4 |
2 weeks ago |
| Optimization of the is_normalized() function. |
6152 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Alexander Borisov (lexborisov) |
|
|
4 |
1 month 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 |
1 month ago |
| Reduce unnecessary locking of pruned partitions when reusing cached plans |
6216 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
|
|
2 |
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 |
Waiting on Author |
Performance
libpq
|
stable |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) |
|
3 |
1 month ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Needs review |
postgres_fdw
Performance
|
19 |
10/10
|
+1833−56
|
Rafia Sabih (rafia.sabih) |
|
|
2 |
2 days ago |
| parallel pgbench -i |
6242 |
Needs review |
Performance
|
|
9/10
|
+269−27
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
3 |
1 week 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 |
2 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 week ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Needs review |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
3 |
1 week ago |
| Hash-based MCV matching for large IN-lists |
6356 |
Ready for Committer |
Performance
|
stable |
10/10
|
+542−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
3 |
1 month ago |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
19 |
10/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
2 |
2 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 |
1 month 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 |
9/10
|
+103−4
|
Pierre Ducroquet (pinaraf) |
|
|
2 |
1 month ago |
| Unfortunate pushing down of expressions below sort |
6467 |
Waiting on Author |
Performance
|
|
10/10
|
+318−56
|
Chengpeng Yan (chengpeng.yan) |
|
|
2 |
1 month ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
10/10
|
+2484−252
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
2 |
1 week ago |
| Pipelined Recovery |
6487 |
Needs review |
Performance
|
19 |
10/10
|
+1988−40
|
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 |
1 month ago |
| Optional skipping of unchanged relations during ANALYZE? |
6516 |
Waiting on Author |
psql
Performance
SQL Commands
|
19 |
Needs rebase!
|
|
Vasu M (vasu01) |
Ilia Evdokimov (ilidock95) |
|
2 |
2 months ago |
| synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
6543 |
Needs review |
Performance
Logical Replication
|
|
3/10
|
+952−134
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
2 |
yesterday |
| Decorrelate nested tuple hash tables |
6553 |
Needs review |
Performance
|
19 |
9/10
|
+13−7
|
Ants Aasma (ants) |
|
|
2 |
2 months ago |
| Compress prune/freeze records with Delta Frame of Reference algorithm |
6574 |
Needs review |
Performance
|
|
10/10
|
+5238−60
|
Evgeny Voropaev (evoro) |
|
|
1 |
1 month ago |
| Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6580 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Surya Poondla (spoondla) |
|
|
1 |
4 days 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 month ago |
| A stack allocation API |
6591 |
Needs review |
Refactoring Only
Performance
|
|
Needs rebase!
|
|
Thomas Munro (macdice) |
|
|
1 |
2 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 |
1 month 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 |
1 month ago |
| Get rid of redundant StringInfo accumulation |
6622 |
Needs review |
Performance
|
19 |
10/10
|
+15−5
|
Daniil Davydov (dddaniil) |
|
|
1 |
1 month ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Needs review |
Performance
|
|
10/10
|
+422−9
|
Richard Guo (richardguo) |
|
|
1 |
1 month ago |
| Skip prefetch for block references that follow a FPW or WILL_INIT of the same block |
6634 |
Needs review |
Performance
Physical Replication
|
19 |
10/10
|
+28−6
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
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 |
3 weeks ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6653 |
Needs review |
Performance
|
19 |
10/10
|
+2484−252
|
Alexandre Felipe (afelipe) |
|
|
1 |
1 week ago |
| pg_dump: eliminate tmpfile double-write in tar format output |
6686 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Josh Kupershmidt (schmiddy) |
|
|
1 |
1 month ago |
| Prevent repeated deadlock-check signals in standby buffer pin waits |
6690 |
Needs review |
Performance
|
19 |
10/10
|
+12−9
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii) |
Fujii Masao (masaofujii) |
1 |
23 hours ago |
| Extend MXactCache lifetime from per-transaction to per-session |
6693 |
Needs review |
Performance
|
19 |
0/1
|
+47−20
|
JoongHyuk Shin (shin) |
|
|
1 |
1 month 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 |
5 days 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 weeks ago |
| Improve HASH overflow page reuse by preferring recently freed pages to enhance locality. |
6718 |
Needs review |
Performance
|
|
Needs rebase!
|
|
lakshmi g (lakshmi) |
|
|
1 |
3 weeks ago |
| Propagate stadistinct through GROUP BY/DISTINCT in subqueries and CTEs |
6721 |
Needs review |
Performance
|
|
10/10
|
+221−14
|
Richard Guo (richardguo) |
|
|
1 |
1 month 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 |
yesterday |
| 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
|
|
9/10
|
+1741−838
|
Sami Imseih (simseih) |
|
|
1 |
6 hours ago |
| [SQL/PGQ] Early pruning for GRAPH_TABLE path generation |
6771 |
Needs review |
Performance
|
19 |
9/10
|
+289−1
|
Zhao Junwang (zhjwpku) |
|
|
1 |
1 week ago |