| Index Prefetching |
4351 |
Moved to different CF |
Performance
|
|
9/10
|
+4300−2204
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
|
|
14 |
2 days 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) |
|
9 |
2 weeks ago |
| Inline non-SQL SRFs |
5083 |
Committed |
Performance
|
19 |
10/10
|
+755−115
|
Paul Jungwirth (pjungwir) |
Tom Lane (tgl) |
Tom Lane (tgl) |
5 |
2 months ago |
| Asynchronous MergeAppend Execution |
5129 |
Moved to different CF |
Performance
|
|
10/10
|
+1441−710
|
Alexander Pyhalov (a.pyhalov) |
Matheus Alcantara (matheus.alcantara) |
|
7 |
1 month 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 |
1 week 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 |
Committed |
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) |
|
|
5 |
2 weeks ago |
| Compress big WAL records |
5621 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii) |
|
4 |
2 weeks ago |
| Reduce timing overhead of EXPLAIN ANALYZE using rdtsc |
5622 |
Moved to different CF |
Performance
|
|
9/10
|
+585−70
|
Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) |
|
|
5 |
yesterday |
| 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 |
| Create DATA dump objects for partitioned tables too |
5692 |
Moved to different CF |
Performance
|
|
10/10
|
+223−41
|
Tom Lane (tgl) |
|
|
5 |
9 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) |
|
|
5 |
9 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) |
|
5 |
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) |
|
5 |
1 week 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) |
|
|
4 |
3 weeks ago |
| Improve the performance of Unicode Normalization Forms. |
5802 |
Moved to different CF |
Performance
|
|
10/10
|
+7702−12682
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov) |
|
5 |
2 weeks ago |
| parallel pg_restore: avoid disk seeks when jumping short distance forward |
5809 |
Committed |
Performance
|
19 |
10/10
|
+5−1
|
Dimitrios Apostolou (jimis) |
Tom Lane (tgl) |
Tom Lane (tgl) |
2 |
3 months 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) |
|
5 |
yesterday |
| Don't keep closed WAL segment in page cache after replay |
5894 |
Moved to different CF |
Performance
|
19 |
10/10
|
+51−4
|
Anthonin Bonnefoy (bonnefoa) |
|
|
3 |
6 months ago |
| Making pg_rewind faster |
5902 |
Committed |
libpq
Performance
|
19 |
10/10
|
+215−13
|
Justin Kwan (justinpkwan.outlook.com), John Hsu (johnhsu) |
Michael Paquier (michael-kun) |
Michael Paquier (michael-kun) |
3 |
3 months ago |
| Eagerly evict bulkwrite strategy ring |
5919 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Melanie Plageman (melanieplageman) |
|
|
5 |
2 weeks ago |
| Optimize join selectivity estimation for tables with large number of MCVs |
5929 |
Committed |
Performance
|
19 |
0/10
|
+456−121
|
David Geier (geidav), Ilia Evdokimov (ilidock95) |
Tom Lane (tgl), Ilia Evdokimov (ilidock95) |
Tom Lane (tgl) |
2 |
2 months ago |
| Making jsonb_agg() faster |
5930 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
3 |
3 weeks ago |
| Optimize JsonbContainerTypeName by reordering type checks |
6000 |
Withdrawn |
Performance
Refactoring Only
|
19 |
10/10
|
+5−5
|
Chao Li (chaol) |
|
|
2 |
4 months ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Moved to different CF |
Performance
|
19 |
10/10
|
+739−353
|
Lukas Fittl (lfittl) |
|
|
4 |
2 weeks ago |
| Improve read_local_xlog_page_guts by replacing polling with latch-based waiting |
6024 |
Moved to different CF |
Performance
Logical Replication
|
19 |
0/10
|
+59−11
|
Xuneng Zhou (dylanzhou) |
|
|
2 |
2 months ago |
| Get rid of pgstat_count_backend_io_op*() functions |
6025 |
Moved to different CF |
Performance
Refactoring Only
|
19 |
10/10
|
+31−57
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
2 |
4 months ago |
| Checkpointer write combining |
6043 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Melanie Plageman (melanieplageman) |
|
|
3 |
1 week ago |
| MPTCP - multiplexing many TCP connections through one socket to get better bandwidth |
6061 |
Moved to different CF |
Performance
|
19 |
0/10
|
+72−2
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
2 |
4 months ago |
| Optimize LISTEN/NOTIFY |
6078 |
Moved to different CF |
Performance
|
|
10/10
|
+1161−184
|
Joel Jacobson (joeljacobson) |
Tom Lane (tgl) |
Tom Lane (tgl) |
2 |
2 weeks ago |
| Make few enhancements in GIN redo and GIN pg_waldump . |
6083 |
Committed |
Performance
|
stable |
Needs rebase!
|
|
Kirill Reshke (reshke) |
|
Michael Paquier (michael-kun) |
1 |
3 months ago |
| use SIMD in GetPrivateRefCountEntry() |
6101 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Nathan Bossart (bossartn) |
|
|
2 |
3 months ago |
| pgstattuple: Use streaming read API in pgstatindex functions |
6125 |
Moved to different CF |
Performance
Extensions
AIO
|
19 |
9/10
|
+48−9
|
Xuneng Zhou (dylanzhou) |
Shinya Kato (shinyakato) |
|
2 |
2 months ago |
| pg_stat_statements: faster search by queryid |
6136 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Karina Litskevich (karinalitskevich) |
|
|
2 |
3 months ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Moved to different CF |
Performance
|
|
10/10
|
+206−6
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada) |
|
3 |
3 days ago |
| Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array |
6141 |
Moved to different CF |
Performance
Logical Replication
Refactoring Only
|
19 |
10/10
|
+307−69
|
Xuneng Zhou (dylanzhou) |
Kirill Reshke (reshke) |
|
3 |
2 weeks ago |
| Optimization of the is_normalized() function. |
6152 |
Moved to different CF |
Performance
|
19 |
7/10
|
+6626−8086
|
Alexander Borisov (lexborisov) |
|
|
2 |
3 months ago |
| Use log_newpage_range in HASH index build |
6158 |
Moved to different CF |
Performance
|
stable |
0/10
|
+77−0
|
Kirill Reshke (reshke) |
lakshmi g (lakshmi) |
|
2 |
3 weeks ago |
| Use BumpContext contexts for TupleHashTables' tablecxt |
6168 |
Committed |
Performance
|
|
10/10
|
+90−82
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
1 |
3 months ago |
| Batching in executor, part 1: add batch variant of table AM scan API |
6176 |
Moved to different CF |
Help - Benchmarks
Performance
|
19 |
8/10
|
+1877−3
|
Amit Langote (amitlan) |
|
|
2 |
3 days ago |
| Have the planner convert COUNT(1) / COUNT(not_null_col) to COUNT(*) |
6186 |
Committed |
Performance
|
19 |
10/10
|
+317−36
|
David Rowley (davidrowley) |
|
David Rowley (davidrowley) |
1 |
2 months ago |
| Optimize SnapBuild by maintaining committed.xip in sorted order |
6187 |
Moved to different CF |
Performance
Logical Replication
|
19 |
10/10
|
+151−25
|
Xuneng Zhou (dylanzhou) |
|
|
2 |
1 month ago |
| Optimize shared LWLock acquisition for high-core-count systems |
6191 |
Moved to different CF |
Performance
Multithreading
|
19 |
10/10
|
+88−16
|
Zhiguo Zhou (zhiguozhou) |
|
|
3 |
6 months ago |
| Lock-free XLog Reservation from WAL |
6192 |
Moved to different CF |
Performance
Multithreading
|
19 |
10/10
|
+532−57
|
Yura Sokolov (funny_falcon), Zhiguo Zhou (zhiguozhou) |
|
|
3 |
3 months ago |
| Increase NUM_XLOGINSERT_LOCKS |
6193 |
Moved to different CF |
Performance
Multithreading
|
19 |
9/10
|
+34−21
|
Yura Sokolov (funny_falcon) |
|
|
2 |
1 year ago |
| Improving planner's estimates of TupleHashTable sizes |
6196 |
Committed |
Performance
|
|
10/10
|
+261−126
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
1 |
2 months ago |