| Index Prefetching |
4351 |
Moved to different CF |
Performance
|
|
10/10
|
+4300−2204
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
|
|
13 |
16 hours ago |
| CRC32C Parallel Computation Optimization on ARM |
4620 |
Returned with feedback |
Performance
|
|
Needs rebase!
|
|
xiang gao (xiang.gao) |
Nathan Bossart (bossartn), John Naylor (john.naylor) |
|
8 |
9 months ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Moved to different CF |
Performance
|
19 |
10/10
|
+2867−479
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
8 |
2 weeks ago |
| Inline non-SQL SRFs |
5083 |
Moved to different CF |
Performance
|
19 |
10/10
|
+755−115
|
Paul Jungwirth (pjungwir) |
Tom Lane (tgl) |
Tom Lane (tgl) |
5 |
2 months ago |
| Parallel heap vacuum |
5326 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Masahiko Sawada (masahikosawada) |
Hayato Kuroda (ha-kun) |
|
7 |
4 months ago |
| Adding compression of temporary files |
5382 |
Moved to different CF |
Performance
|
|
10/10
|
+4008−22
|
Filip Januš (fjanus) |
Zsolt Parragi (zsolt.parragi), lakshmi g (lakshmi) |
|
6 |
6 days ago |
| Eliminating SPI / SQL from some RI trigger functions |
5450 |
Moved to different CF |
Performance
|
19 |
10/10
|
+675−73
|
Amit Langote (amitlan) |
|
|
4 |
1 month ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Moved to different CF |
Performance
|
19 |
10/10
|
+1487−46
|
Alena Rybakina (a.rybakina) |
Ilia Evdokimov (ilidock95) |
|
5 |
3 months ago |
| SVE enablement for hex-encode and hex-decode |
5538 |
Moved to different CF |
Performance
|
19 |
10/10
|
+418−4
|
Chiranmoy Bhattacharya (chiranmoy), Susmitha Devanga (susmithad) |
Nathan Bossart (bossartn) |
Nathan Bossart (bossartn) |
4 |
3 months ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Moved to different CF |
Performance
|
19 |
10/10
|
+2380−511
|
Greg Burd (gregburd) |
|
|
4 |
2 weeks ago |
| Introduce RWSpin lock and use it in sinvaladt.c and xlogrecovery.c |
5573 |
Moved to different CF |
Performance
|
18 |
10/10
|
+217−42
|
Yura Sokolov (funny_falcon) |
|
|
3 |
5 months ago |
| Compress big WAL records |
5621 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii) |
|
4 |
2 weeks ago |
| Lock-free XLog Reservation from WAL |
5633 |
Moved to different CF |
Performance
|
|
9/10
|
+532−57
|
Yura Sokolov (funny_falcon) |
|
|
2 |
9 months ago |
| Memoize ANTI and SEMI JOIN inner |
5636 |
Withdrawn |
Performance
|
19 |
6/7
|
+112−22
|
Andrei Lepikhov (lepikhov) |
|
|
1 |
6 months ago |
| Produce LLVM bitcode files on meson builds |
5671 |
Moved to different CF |
Performance
|
19 |
10/10
|
+799−50
|
Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) |
|
|
4 |
2 weeks ago |
| optimizations for dumping statistics |
5678 |
Committed |
Performance
|
18 |
7/7
|
+276−64
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
1 |
8 months ago |
| Small optimization set tuple block/tableOid once |
5683 |
Moved to different CF |
Performance
|
19 |
10/10
|
+40−18
|
Ranier Vilela (raniervilela) |
|
|
2 |
9 months ago |
| Reduce "Var IS [NOT] NULL" quals during constant folding |
5685 |
Committed |
Performance
|
19 |
10/10
|
+576−227
|
Richard Guo (richardguo) |
|
Richard Guo (richardguo) |
1 |
6 months ago |
| Create DATA dump objects for partitioned tables too |
5692 |
Moved to different CF |
Performance
|
|
10/10
|
+223−41
|
Tom Lane (tgl) |
|
|
4 |
9 months ago |
| Performance issues with v18 SQL-language-function changes |
5695 |
Committed |
Performance
|
18 |
7/7
|
+264−211
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
1 |
8 months ago |
| Add planner expectations for Memoize in EXPLAIN |
5697 |
Committed |
Performance
|
19 |
10/10
|
+62−12
|
Ilia Evdokimov (ilidock95) |
|
David Rowley (davidrowley) |
1 |
6 months ago |
| NUMA shared memory interleaving |
5703 |
Returned with feedback |
Performance
|
19 |
6/10
|
+317−1
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
1 |
6 months ago |
| adjust the place of list_copy() call to reduce the overhead of function call and memory copies. |
5704 |
Committed |
Performance
|
|
10/10
|
+2−1
|
Tender Wang (tndrwang) |
|
Tom Lane (tgl) |
1 |
6 months ago |
| Enable auto-vectorization for page checksum calculations |
5726 |
Moved to different CF |
Performance
|
19 |
10/10
|
+384−34
|
Matthew Sterrett (matthew.sterrett.intel.com), Andrew Kim (andrewk1) |
John Naylor (john.naylor) |
John Naylor (john.naylor) |
3 |
1 week ago |
| Accounting for metapages in genericcostestimate() |
5727 |
Moved to different CF |
Performance
|
|
10/10
|
+55−13
|
Tom Lane (tgl) |
|
|
4 |
9 months ago |
| speed up pg_upgrade with many large objects |
5737 |
Committed |
Performance
|
19 |
10/10
|
+103−6
|
Nathan Bossart (bossartn) |
Hannu Krosing (hannukrosing), Saurabh Uttam (saurabhuttam), Nitin Motiani (nitinmotiani) |
Nathan Bossart (bossartn) |
1 |
6 months ago |
| Improve hash join's handling of tuples with null join keys |
5738 |
Moved to different CF |
Performance
|
|
10/10
|
+381−71
|
Tom Lane (tgl) |
Chao Li (chaol) |
|
4 |
5 months ago |
| Improve Valgrind support and remove some memory leaks |
5748 |
Moved to different CF |
Performance
|
|
10/10
|
+546−125
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
2 |
5 months ago |
| Parallel processing of indexes in autovacuum |
5755 |
Moved to different CF |
Performance
|
18 |
7/10
|
+1077−23
|
Maxim Orlov (m.orlov), Daniil Davydov (dddaniil) |
Masahiko Sawada (masahikosawada), Sami Imseih (simseih) |
|
4 |
1 week ago |
| remove ISB in AArch64's spin_delay() implementation |
5763 |
Moved to different CF |
Performance
|
19 |
10/10
|
+10−6
|
|
Nathan Bossart (bossartn) |
|
2 |
5 months ago |
| Extending FK check skipping on replicas to ADD FK and TRUNCATE |
5774 |
Moved to different CF |
Performance
Logical Replication
Help - Stuck Rebasing
|
19 |
10/10
|
+96−3
|
Hannu Krosing (hannukrosing) |
|
|
3 |
2 weeks ago |
| Speedup truncations of temporary relation forks |
5788 |
Committed |
Performance
|
18 |
10/10
|
+19−14
|
Daniil Davydov (dddaniil) |
Fujii Masao (masaofujii), Maxim Orlov (m.orlov) |
Fujii Masao (masaofujii) |
1 |
6 months ago |
| Vectorized CRC on Arm64 |
5789 |
Moved to different CF |
Performance
|
|
10/10
|
+209−5
|
John Naylor (john.naylor) |
|
|
3 |
2 weeks ago |
| Pathify RHS unique-ification for semijoin planning |
5795 |
Committed |
Performance
|
19 |
Needs rebase!
|
|
Richard Guo (richardguo) |
|
Richard Guo (richardguo) |
1 |
6 months ago |
| Improve the performance of Unicode Normalization Forms. |
5802 |
Moved to different CF |
Performance
|
|
10/10
|
+7702−12682
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov) |
|
4 |
2 weeks ago |
| Improve array-element-test estimation when no array elements qualify as common |
5805 |
Moved to different CF |
Performance
|
|
10/10
|
+67−30
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
2 |
4 months ago |
| Optimize-transaction-waiting-during-logical-decoding |
5806 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Xuneng Zhou (dylanzhou) |
Fujii Masao (masaofujii) |
Fujii Masao (masaofujii) |
3 |
4 months ago |
| parallel pg_restore: avoid disk seeks when jumping short distance forward |
5809 |
Moved to different CF |
Performance
|
19 |
10/10
|
+5−1
|
Dimitrios Apostolou (jimis) |
Tom Lane (tgl) |
Tom Lane (tgl) |
2 |
3 months ago |
| parallel pg_restore: move offset-building phase to before forking |
5817 |
Moved to different CF |
Performance
|
|
10/10
|
+86−6
|
Dimitrios Apostolou (jimis) |
Tom Lane (tgl) |
|
2 |
3 months ago |
| Returning nbtree posting list TIDs in DESC order during backwards scans |
5824 |
Moved to different CF |
Performance
|
|
10/10
|
+53−41
|
Peter Geoghegan (pgeoghegan) |
Mircea Cadariu (mcadariu) |
Peter Geoghegan (pgeoghegan) |
2 |
1 month ago |
| Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume |
5841 |
Moved to different CF |
Performance
|
19 |
10/10
|
+2−2
|
Melanie Plageman (melanieplageman) |
Kirill Reshke (reshke) |
|
4 |
11 hours ago |
| Extend int128.h to more of numeric.c |
5853 |
Committed |
Performance
|
19 |
Needs rebase!
|
|
Dean Rasheed (deanr) |
John Naylor (john.naylor) |
Dean Rasheed (deanr) |
1 |
6 months ago |
| OAuth: fix performance bug with stuck multiplexer events |
5864 |
Committed |
Bugfix
Performance
|
18 |
10/10
|
+833−93
|
Jacob Champion (jchampion) |
|
Jacob Champion (jchampion) |
1 |
6 months ago |
| Saving stack space in nbtree's _bt_first function |
5897 |
Committed |
Performance
|
|
9/10
|
+3−3
|
Peter Geoghegan (pgeoghegan) |
Mircea Cadariu (mcadariu) |
Peter Geoghegan (pgeoghegan) |
2 |
6 months ago |