| Index Prefetching |
4351 |
Needs review |
Performance
|
|
10/10
|
+8200−3085
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Jerry Zhang (xingtanzjr), Rui Zhao (zhaorui), GURU PRASAD GANGIREDLA (gangguru788) |
|
17 |
1 week 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) |
|
12 |
2 weeks ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara), solai v (solaiv) |
|
11 |
3 days ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Needs review |
Performance
|
19 |
10/10
|
+2131−82
|
Alena Rybakina (a.rybakina) |
Ilia Evdokimov (ilidock95), Solaimurugan V (solaimurugan) |
|
10 |
2 weeks ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Needs review |
Performance
|
20 |
10/10
|
+6339−227
|
Greg Burd (gregburd) |
|
|
7 |
6 days ago |
| Compress big WAL records |
5621 |
Needs review |
Performance
|
|
10/10
|
+2399−172
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii), Zsolt Parragi (zsolt.parragi) |
|
7 |
1 week ago |
| Produce LLVM bitcode files on meson builds |
5671 |
Needs review |
Performance
|
19 |
10/10
|
+397−25
|
Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) |
Christoph Berg (myon) |
|
7 |
yesterday |
| 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), Murali Natti (murali.natti) |
|
7 |
3 months 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) |
|
6 |
2 months ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Needs review |
Performance
|
|
10/10
|
+3575−433
|
Lukas Fittl (lfittl) |
|
|
6 |
6 days ago |
| Improve read_local_xlog_page_guts by replacing polling with latch-based waiting |
6024 |
Needs review |
Performance
Logical Replication
|
19 |
10/10
|
+163−13
|
Xuneng Zhou (dylanzhou) |
Rui Zhao (zhaorui) |
|
5 |
2 weeks ago |
| Adding basic NUMA awareness |
6049 |
Needs review |
Performance
|
19 |
10/10
|
+2245−198
|
Tomas Vondra (fuzzycz), Greg Burd (gregburd) |
Jakub Wartak (jakub.wartak.tomtom), Greg Burd (gregburd) |
|
3 |
2 weeks 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) |
Greg Sabino Mullane (greg) |
|
5 |
2 months ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada), solai v (solaiv) |
|
6 |
1 month ago |
| Reduce unnecessary locking of pruned partitions when reusing cached plans |
6216 |
Waiting on Author |
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
Ilmar Yunusov (tanswis42.gmail.com), Rui Zhao (zhaorui), Manuel Reyes Bravo (manu15) |
|
4 |
3 weeks 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) |
|
5 |
3 months ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Needs review |
postgres_fdw
Performance
|
19 |
10/10
|
+1869−97
|
Rafia Sabih (rafia.sabih) |
|
|
4 |
3 days ago |
| parallel pgbench -i |
6242 |
Needs review |
Performance
|
|
10/10
|
+227−10
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi), Koshi Shibagaki (k-zshiba) |
|
4 |
3 weeks 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), solai v (solaiv) |
|
5 |
3 weeks ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Needs review |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
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) |
|
5 |
4 months ago |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
20 |
10/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
4 |
7 months ago |
| Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY |
6401 |
Needs review |
Performance
DDL
|
19 |
Needs rebase!
|
|
Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
4 |
2 weeks ago |
| Reduce build times of pg_trgm GIN indexes |
6418 |
Ready for Committer |
Performance
|
20 |
10/10
|
+237−230
|
David Geier (geidav) |
Heikki Linnakangas (heikki), Japin Li (japin), Matthias van de Meent (mmeent) |
Heikki Linnakangas (heikki) |
3 |
yesterday |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
9/10
|
+4528−281
|
Alexandre Felipe (afelipe) |
Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) |
|
4 |
5 hours ago |
| Fix performance of REFRESH MATERIALIZED VIEW CONCURRENTLY |
6580 |
Needs review |
Performance
|
20 |
10/10
|
+246−43
|
Surya Poondla (spoondla) |
|
|
3 |
3 months ago |
| Convert ALL SubLinks to ANY SubLinks |
6627 |
Needs review |
Performance
|
|
10/10
|
+422−9
|
Richard Guo (richardguo) |
solai v (solaiv) |
|
3 |
1 month ago |
| Extract numeric filed in JSONB more effectively |
6644 |
Needs review |
Performance
|
|
8/10
|
+3155−10
|
Andy Fan (andyf), Haibo Yan (billyean) |
|
|
2 |
6 months ago |
| Prevent repeated deadlock-check signals in standby buffer pin waits |
6690 |
Waiting on Author |
Performance
|
20 |
Needs rebase!
|
|
JoongHyuk Shin (shin) |
Fujii Masao (masaofujii), Henson Choi (assam258.gmail.com), Ilmar Yunusov (tanswis42.gmail.com) |
Fujii Masao (masaofujii) |
3 |
2 months 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) |
|
3 |
2 months ago |
| Skip prefetch for block references that follow a FPW or WILL_INIT of the same block |
6730 |
Needs review |
Performance
|
19 |
10/10
|
+27−6
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
Bharath Rupireddy (bharathrupireddy) |
|
2 |
1 week ago |
| Improve pg_stat_statements scalability |
6763 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Sami Imseih (simseih) |
Tristan Partin (tristan957) |
|
3 |
3 months ago |
| btree_gist: add cross-type integer operator support for GiST |
6854 |
Ready for Committer |
Performance
My First Patch
|
20 |
10/10
|
+1650−51
|
Alexander Nestorov (alexandernst) |
Maxime Schoemans (mschoema) |
Tom Lane (tgl) |
3 |
1 month ago |
| Unexpected reindex when altering column types for partitioned tables |
6887 |
Waiting on Author |
DDL
Performance
|
|
4/10
|
+257−48
|
Álvaro Rodríguez (arodrgr) |
Alberto Piai (albe) |
|
3 |
1 month ago |
| Randomize B-Tree page split location to avoid oscillating patterns |
6892 |
Needs review |
Performance
|
stable |
7/10
|
+187−12
|
Dmitry Dolgov (erthalion) |
Andrey Borodin (x4m) |
|
3 |
3 weeks ago |
| Fold NOT IN / <> ALL expressions containing NULL to FALSE |
6901 |
Waiting on Author |
Performance
|
stable |
10/10
|
+1260−38
|
Ilia Evdokimov (ilidock95) |
Denis Smirnov (darthunix), Rustam ALLAKOV (rustam.allakov) |
|
3 |
yesterday |
| Improve row estimation with multi-column unique indexes |
6932 |
Needs review |
Performance
|
20 |
10/10
|
+669−284
|
Anthonin Bonnefoy (bonnefoa) |
|
|
3 |
4 months ago |
| Reduce reorder buffer spill from O(N²) to O(N) during vacuum storms |
6933 |
Waiting on Author |
Performance
Logical Replication
|
20 |
Needs rebase!
|
|
Rui Zhao (zhaorui) |
shihao zhong (zhong950419) |
|
3 |
2 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 |
10/10
|
+17598−1021
|
Greg Burd (gregburd) |
Bharath Rupireddy (bharathrupireddy) |
|
2 |
1 week ago |
| Lazy LEFT NestLoop JOIN: gate rescanning of the inner side by outer-side-only join clauses |
6981 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Andrei Lepikhov (lepikhov), Mikhail Zhilin (mizhka-at-pgpro), Peter Petrov (pspetrov) |
|
|
2 |
1 month ago |
| [PATCH v1 0/7] Wait event timing and tracing instrumentation |
6984 |
Needs review |
Performance
Monitoring
|
|
10/10
|
+11665−209
|
Dmitry Fomin (dmitryf) |
|
|
2 |
3 days ago |
| Use Boyer-Moore-Horspool for simple LIKE contains patterns |
7013 |
Needs review |
Performance
|
20 |
10/10
|
+859−2
|
Atsushi Ogawa (atsushio) |
Bryan Green (lispyone) |
|
2 |
1 month ago |
| Caching a partition index's parent OID in the relcache? |
7030 |
Needs review |
Performance
|
20 |
10/10
|
+229−6
|
Ayush Tiwari (aytiwari) |
|
|
2 |
3 months ago |
| Tracking per-RelOptInfo uniqueness during planning |
7045 |
Waiting on Author |
Performance
|
20 |
3/10
|
+3249−145
|
Richard Guo (richardguo) |
Antonin Houska (a.houska), Ilia Evdokimov (ilidock95) |
|
2 |
3 weeks 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) |
|
2 |
3 weeks ago |
| Speed up repeat() for larger counts |
7060 |
Ready for Committer |
Performance
|
20 |
10/10
|
+32−0
|
Chenhui Mo (littleganyu) |
Nathan Bossart (bossartn), Jan Nidzwetzki (jnidzwetzki) |
|
2 |
1 month ago |
| psql: filter system functions before visibility checks |
7061 |
Ready for Committer |
Bugfix
Performance
|
20 |
10/10
|
+64−52
|
xiaoyu liu (raindrop) |
Jan Nidzwetzki (jnidzwetzki) |
|
2 |
2 months ago |
| Add planner support function to two-argument regexp_like() |
7069 |
Ready for Committer |
Good First Review
Performance
|
stable |
10/10
|
+30−1
|
shihao zhong (zhong950419) |
Pierre Forstmann (pifor) |
|
2 |
4 weeks ago |
| Batch fsyncs when recycling WAL segments |
7088 |
Needs review |
Performance
|
20 |
10/10
|
+40−9
|
Ayush Tiwari (aytiwari) |
Bharath Rupireddy (bharathrupireddy), Ritesh Kumar (rtshkmr) |
|
2 |
1 month ago |
| Parallel heap vacuum |
7102 |
Waiting on Author |
Performance
|
20 |
Needs rebase!
|
|
Masahiko Sawada (masahikosawada), Bharath Rupireddy (bharathrupireddy) |
|
|
2 |
3 months ago |
| Multi-insert for logical replication apply |
7104 |
Waiting on Author |
Performance
Logical Replication
|
20 |
1/2
|
+378−2
|
Bharath Rupireddy (bharathrupireddy) |
|
|
2 |
2 months ago |
| Support specialized B-tree page searches |
7119 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
2 |
1 month ago |
| Avoid streaming zero-filled WAL switch padding |
7123 |
Ready for Committer |
Performance
Physical Replication
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
Sehrope Sarkuni (sehrope) |
|
2 |
1 month ago |
| Reduce cost of ProcArrayRemove/ProcArrayAdd |
7139 |
Waiting on Author |
Performance
|
|
10/10
|
+11−9
|
Maksim Melnikov (manaldush) |
Matthias van de Meent (mmeent) |
|
2 |
1 month ago |
| Refactor remaining zero-fill relation extensions to use smgrzeroextend() |
7141 |
Ready for Committer |
Performance
|
20 |
10/10
|
+12−20
|
peipei yin (yinpeipei) |
Bharath Rupireddy (bharathrupireddy), shihao zhong (zhong950419) |
|
2 |
1 month ago |
| enhancing pg_basebackup speeds up to ~23Gbps (small fixes + io_uring/Direct I/O) |
7142 |
Needs review |
Performance
|
20 |
10/10
|
+1333−267
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
2 |
6 hours ago |
| [PATCH] Consider window functions when reordering GROUP BY items |
7150 |
Waiting on Author |
Performance
|
20 |
9/10
|
+890−47
|
Zhenglong Li (smartkeyerror.gmail.com) |
Henson Choi (assam258.gmail.com) |
|
2 |
5 days ago |
| Apply extended statistics to join clause during parameterized path costing |
7161 |
Needs review |
Performance
|
stable |
10/10
|
+42−3
|
Ilia Evdokimov (ilidock95) |
|
|
2 |
1 month ago |
| Write Combining |
7171 |
Needs review |
Performance
|
|
1/2
|
+2212−420
|
Melanie Plageman (melanieplageman) |
Andrey Borodin (x4m) |
|
2 |
1 month ago |
| aio: Async fsyncs for crash recovery and checkpointer |
7190 |
Needs review |
AIO
Performance
|
20 |
10/10
|
+1706−311
|
Nazir Bilal Yavuz (nbyavuz) |
Srinath Reddy (srinath-reddy-sadipiralla), Ayush Tiwari (aytiwari), Salma El-Sayed (salmae) |
|
2 |
1 month ago |
| Improve cube GiST page splits |
7196 |
Needs review |
Performance
|
|
10/10
|
+634−123
|
Andrey Borodin (x4m) |
Rustam ALLAKOV (rustam.allakov) |
|
2 |
3 days ago |
| Honor fillfactor in sorted GiST builds |
7198 |
Needs review |
Performance
|
|
10/10
|
+103−20
|
Andrey Borodin (x4m) |
|
|
2 |
2 months ago |
| Delete GIN posting-tree pages without excessive locking |
7199 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
2 |
3 months ago |
| GiST intrapage indexing |
7200 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
2 |
3 months ago |
| pg_rewind: Remove recovery at the start of rewind |
7220 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Srinath Reddy (srinath-reddy-sadipiralla) |
|
|
2 |
2 months ago |
| Planner support function for generate_subscripts() |
7226 |
Ready for Committer |
Good First Review
Performance
|
|
10/10
|
+398−2
|
shihao zhong (zhong950419) |
Andrew Krylosov (krylosov-aa), Priyanka Sangam (arcticwolf) |
|
2 |
1 month ago |
| Protocol compression: a fourth design |
7232 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
|
|
2 |
2 months ago |
| Reducing relcache memory usage: deduping index shapes |
7237 |
Needs review |
Performance
|
|
10/10
|
+1467−236
|
Matthias van de Meent (mmeent) |
|
|
2 |
3 weeks ago |
| Price hashed aggregation for hash tables that exceed CPU cache capacity |
7244 |
Waiting on Author |
Bugfix
Performance
|
20 |
10/10
|
+87−0
|
William Bernbaum (wjb-fwx) |
Ethan Tran (quwin) |
|
1 |
1 week ago |
| [PATCH v1 0/1] Avoid carrying self lock-only xmax to updated tuple |
7253 |
Needs review |
Bugfix
Performance
|
20 |
10/10
|
+57−6
|
Chee Wooson (chee.wooson) |
|
|
1 |
2 months ago |
| logical decoding: skip unnecessary snapshot distribution. |
7265 |
Waiting on Author |
Performance
|
|
Needs rebase!
|
|
boyu yang (mobilephone724) |
shihao zhong (zhong950419) |
|
1 |
yesterday |
| Direct TOAST v2, faster, smaller and no migration needed |
7267 |
Needs review |
Help - User Testing
Help - Bikeshedding
Help - Benchmarks
Performance
Testing
GUC
|
20 |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
|
|
1 |
2 weeks ago |
| postgres_fdw: push down FETCH FIRST .. WITH TIES when server version allows |
7269 |
Ready for Committer |
postgres_fdw
Performance
|
20 |
10/10
|
+447−18
|
Sagar Shedge (sdshedge) |
Jeevan Chalke (jeevan.chalke) |
Etsuro Fujita (efujita) |
1 |
1 month ago |
| Use maintenance_io_concurrency for parallel index builds |
7280 |
Needs review |
Bugfix
Performance
|
stable |
10/10
|
+25−12
|
Jingtang Zhang (mrdrivingduck) |
|
|
1 |
1 week ago |
| Improve Hash/Merge Join estimate accuracy when all predicates are Hash/Merge clauses |
7281 |
Needs review |
Performance
|
stable |
10/10
|
+83−11
|
Ilia Evdokimov (ilidock95) |
|
|
1 |
2 weeks ago |
| Allow subquery pull-up past inlineable CTEs |
7283 |
Needs review |
Performance
My First Patch
|
20 |
10/10
|
+244−45
|
Andrey Kazarinov (kazar) |
Xinlei Zhang (clemenza) |
|
1 |
1 month ago |
| Use PG 14's hashed ScalarArrayOpExpr path for a non-Const array the planner can prove is fixed for one execution (col = ANY($1), IN ($1,...,$N), $1::int[], string_to_array($1,','), a stable function), not only for a Const array. |
7285 |
Needs review |
Performance
|
20 |
10/10
|
+767−202
|
Linden Lance (bestxmg) |
David Geier (geidav), Ayoub Kazar (kaz) |
|
1 |
4 days ago |
| Combine qual-based and NOT NULL proofs when reducing outer joins |
7301 |
Ready for Committer |
Performance
|
|
10/10
|
+132−9
|
Zhenglong Li (smartkeyerror.gmail.com) |
Ziming Zhang (torenzhang) |
|
1 |
4 days ago |
| Optimize MCV stats for sortable types and utilize sorted-order properties |
7302 |
Needs review |
Performance
|
|
10/10
|
+2055−159
|
Zizhuan Liu (liuzizhuan) |
|
|
1 |
6 days ago |
| Add get_actual_variable_range index page read limit (complements existing VISITED_PAGES_LIMIT) |
7305 |
Needs review |
Performance
|
|
10/10
|
+36−2
|
Peter Geoghegan (pgeoghegan) |
Rui Zhao (zhaorui) |
|
1 |
1 month ago |
| Optimize truncation logic to reduce AccessExclusive lock impact |
7308 |
Needs review |
Performance
Good First Review
|
20 |
10/10
|
+42−8
|
shihao zhong (zhong950419), Stepan Neretin (snpgg) |
|
|
1 |
1 month ago |
| Improve hash aggregate spilling by writing only the needed columns |
7310 |
Needs review |
Performance
|
|
10/10
|
+113−33
|
Mario Karuza (mkaruza) |
Ethan Tran (quwin) |
|
1 |
3 hours ago |
| Restructured Shared Buffer Hash Table |
7326 |
Needs review |
Performance
|
|
10/10
|
+164−60
|
Dhruv Aron (dhruv.aron.gmail.com) |
Alexandre Felipe (afelipe) |
|
1 |
3 weeks ago |
| Parameterized append subpaths |
7339 |
Needs review |
Performance
|
|
10/10
|
+358−12
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
|
|
1 |
1 month ago |
| Speed up lpad() and rpad() |
7340 |
Needs review |
Performance
|
20 |
10/10
|
+218−44
|
Sehrope Sarkuni (sehrope) |
Nathan Bossart (bossartn) |
Nathan Bossart (bossartn) |
1 |
1 month ago |
| pg_dump: Fetch sequence data only for sequences being dumped |
7350 |
Needs review |
Bugfix
Backport
Performance
|
|
10/10
|
+56−20
|
Andrew Krylosov (krylosov-aa) |
Diego - (galponcio), Christopher Bell (bellcr) |
|
1 |
1 month ago |
| postgres_fdw: Fix costing of remote sorts without remote estimates |
7357 |
Needs review |
postgres_fdw
Performance
|
|
10/10
|
+415−350
|
Jelte Fennema-Nio (jeltef) |
Rui Zhao (zhaorui) |
|
1 |
yesterday |
| Skip LEFT/ANTI joins to a provably empty inner rel |
7360 |
Needs review |
Performance
|
stable |
10/10
|
+212−0
|
Ilia Evdokimov (ilidock95) |
|
|
1 |
1 month ago |
| Halve memory allocation for toast_flatten_tuple |
7362 |
Needs review |
Performance
|
20 |
10/10
|
+313−47
|
Pavel Borisov (pborisov) |
Johannes Edmeier (jedmeier) |
|
1 |
3 weeks ago |
| Costing for parallel scans with few/single row produced in the outer side |
7364 |
Needs review |
Bugfix
Performance
|
|
Needs rebase!
|
|
Matthias van de Meent (mmeent) |
|
|
1 |
1 month ago |
| ATTACH PARTITION cost grows linearly with pg_constraint size (seqscan in CloneFkReferenced), much worse since not-null constraints are in pg_constraint (PG 18) |
7365 |
Needs review |
Performance
|
20 |
10/10
|
+92−20
|
Manuel Reyes Bravo (manu15) |
|
|
1 |
yesterday |
| REPACK (CONCURRENTLY): do not block the table while waiting for the final lock |
7369 |
Needs review |
Performance
|
|
10/10
|
+71−1
|
shihao zhong (zhong950419) |
|
|
1 |
4 weeks ago |
| Reduce LWLockWaitListLock() cache-line contention with adaptive spin reads |
7376 |
Needs review |
Performance
|
20 |
10/10
|
+25−2
|
Andrew Kim (andrewk1), Baohong Min (minbaohong), Jun Jin (jun-intel) |
|
|
1 |
3 weeks ago |
| Throwing away unnecessary spin-locks |
7383 |
Needs review |
Performance
|
|
8/10
|
+89−58
|
Alexandre Felipe (afelipe) |
|
|
1 |
1 month ago |
| Add ASCII fast path to Unicode normalization functions |
7388 |
Needs review |
Performance
|
20 |
10/10
|
+252−23
|
Andrew Dunstan (adunstan) |
Rui Zhao (zhaorui) |
|
1 |
4 weeks ago |
| Enlarge the syslogger pipe on Linux (F_SETPIPE_SZ) |
7390 |
Needs review |
Performance
|
|
10/10
|
+31−0
|
Sehrope Sarkuni (sehrope) |
|
|
1 |
1 month ago |
| Let an ordering index scan hand its ORDER BY value to the target list |
7392 |
Needs review |
Performance
|
20 |
10/10
|
+4021−257
|
Greg Burd (gregburd) |
|
|
1 |
1 week ago |
| Planning time quadratic in the IN-list length for "c = X AND (a, b) IN (...)" with BitmapOr |
7393 |
Ready for Committer |
Performance
|
20 |
10/10
|
+108−1
|
Manuel Reyes Bravo (manu15) |
Stefan Guha (sguha) |
|
1 |
1 month ago |
| gist_trgm_ops '=' operator: planner picks it over btree, ~300x slower |
7401 |
Needs review |
Performance
|
20 |
10/10
|
+129−5
|
Vaibhav Dalvi (vaibhavdalvi) |
|
|
1 |
3 weeks ago |
| Reduce SyncRepLock contention on the commit path |
7402 |
Needs review |
Performance
|
20 |
10/10
|
+673−54
|
Yura Sokolov (funny_falcon), Vadim Ponomarev (vbp1) |
|
|
1 |
3 weeks ago |
| Expand OR clauses in joins to UNION ALL paths |
7405 |
Needs review |
Performance
|
20 |
10/10
|
+3099−1
|
Ayoub Kazar (kaz) |
Zsolt Parragi (zsolt.parragi) |
|
1 |
37 minutes ago |
| Reset unlogged relations before syncing the data directory? |
7406 |
Needs review |
Performance
|
20 |
10/10
|
+26−16
|
Ayush Tiwari (aytiwari) |
|
|
1 |
3 weeks ago |
| Batch TIDBitmap insertions in index scans |
7422 |
Ready for Committer |
Performance
|
20 |
10/10
|
+119−44
|
David Geier (geidav) |
Haibo Yan (billyean) |
|
1 |
1 week ago |
| Detoast a column once per row instead of once per reference |
7423 |
Needs review |
Performance
My First Patch
|
|
10/10
|
+2798−47
|
Johannes Edmeier (jedmeier) |
Denis Smirnov (darthunix) |
|
1 |
3 weeks ago |
| Unlocked path for GetSnapshotDataReuse |
7425 |
Needs review |
Performance
|
|
10/10
|
+180−87
|
Matthias van de Meent (mmeent) |
|
|
1 |
3 weeks ago |
| [RFC PATCH v1] On-demand WAL replay: accept connections before crash recovery has applied the WAL |
7427 |
Needs review |
Performance
|
20 |
Needs rebase!
|
|
Srinath Reddy (srinath-reddy-sadipiralla) |
|
|
1 |
3 weeks ago |
| LWLock granular partition lock memory layout |
7429 |
Needs review |
Performance
|
|
10/10
|
+94−57
|
Alexandre Felipe (afelipe) |
|
|
1 |
3 weeks ago |
| bufmgr Half state CAS |
7430 |
Needs review |
Performance
|
|
9/10
|
+283−21
|
Alexandre Felipe (afelipe) |
|
|
1 |
3 weeks ago |
| Use a hash table for the regexp cache |
7439 |
Needs review |
Performance
|
|
10/10
|
+242−75
|
Tianyi Gao (gtydoit.gmail.com) |
|
|
1 |
4 days ago |
| Avoid O(N^3) planning time in choose_plan_name() |
7454 |
Needs review |
Bugfix
Performance
|
|
10/10
|
+281−29
|
Manuel Reyes Bravo (manu15) |
Ayoub Kazar (kaz) |
|
1 |
2 hours ago |
| Improve ndistinct estimates for flattened UNION |
7462 |
Needs review |
Performance
|
|
10/10
|
+566−20
|
Xiangxin Zeng (xiangxin-zeng) |
|
|
1 |
3 weeks ago |
| Perf: Specialize ExecIndexOnlyScan() like ExecSeqScan() |
7468 |
Needs review |
Performance
|
20 |
10/10
|
+199−5
|
Matthias Dötsch (brain.exe) |
|
|
1 |
3 weeks ago |
| Reducing relcache memory usage 2: shrink sizeof(RelationData) |
7483 |
Needs review |
Performance
|
20 |
10/10
|
+745−603
|
David Geier (geidav) |
Matthias van de Meent (mmeent) |
|
1 |
2 weeks ago |
| [PATCH 0/3] Improve UNION de-duplication |
7496 |
Needs review |
Performance
|
|
4/10
|
+3037−159
|
Xiangxin Zeng (xiangxin-zeng) |
|
|
1 |
2 weeks ago |
| Optimize mergejoinscansel() by avoiding redundant computations |
7499 |
Needs review |
Performance
|
|
10/10
|
+261−10
|
Zizhuan Liu (liuzizhuan) |
|
|
1 |
1 week ago |
| improving handling of FPIs during recovery prefetching |
7512 |
Needs review |
Performance
|
|
10/10
|
+241−10
|
Tomas Vondra (fuzzycz) |
|
|
1 |
6 days ago |
| Incorrect selectivity estimates for NOT on nullable boolean columns |
7514 |
Ready for Committer |
Performance
|
stable |
10/10
|
+19−7
|
Ilia Evdokimov (ilidock95) |
Pierre Forstmann (pifor) |
|
1 |
3 days ago |
| PL/pgSQL: allow parallel query for assignment statements |
7516 |
Needs review |
Performance
PL/pgSQL
|
20 |
10/10
|
+49−6
|
Jeevan Chalke (jeevan.chalke) |
|
|
1 |
1 week ago |
| nbtree: opt-in leaf key prefix compression |
7523 |
Needs review |
Performance
|
20 |
8/10
|
+2464−87
|
Greg Burd (gregburd) |
|
|
1 |
yesterday |
| Don't close relation files when the visibility map is extended |
7524 |
Needs review |
Performance
|
|
10/10
|
+77−12
|
Bryan Green (lispyone) |
|
|
1 |
1 week ago |
| Hash index inserts serialise on the metapage tuple counter |
7531 |
Needs review |
Performance
|
20 |
10/10
|
+1124−227
|
Greg Burd (gregburd) |
|
|
1 |
yesterday |
| Add amnotifydelete, an index AM callback for deleted tuples |
7544 |
Needs review |
Performance
|
20 |
9/10
|
+851−15
|
Jan Bjorge Lovland (janbjorge) |
|
|
1 |
1 week ago |
| Quickselect instead of a heap for ORDER BY ... LIMIT N large bounded sorts |
7565 |
Needs review |
Performance
|
20 |
10/10
|
+443−2
|
Greg Burd (gregburd) |
|
|
1 |
6 days ago |