| Index Prefetching |
4351 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
|
|
15 |
1 week ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Moved to different CF |
Performance
DDL
|
19 |
10/10
|
+3060−484
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
10 |
6 days ago |
| Asynchronous MergeAppend Execution |
5129 |
Moved to different CF |
Performance
|
|
10/10
|
+1427−744
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
9 |
4 days ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Moved to different CF |
Performance
|
19 |
10/10
|
+1508−58
|
Alena Rybakina (a.rybakina) |
Ilia Evdokimov (ilidock95) |
|
7 |
2 weeks ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Greg Burd (gregburd) |
Nathan Bossart (bossartn) |
|
6 |
3 weeks ago |
| Compress big WAL records |
5621 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii), Zsolt Parragi (zsolt.parragi) |
|
5 |
1 month ago |
| Reduce timing overhead of EXPLAIN ANALYZE using rdtsc |
5622 |
Moved to different CF |
Performance
|
|
9/10
|
+134−19
|
Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) |
|
Andres Freund (andresfreund) |
5 |
1 week ago |
| Create DATA dump objects for partitioned tables too |
5692 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Tom Lane (tgl) |
|
|
6 |
1 year ago |
| Accounting for metapages in genericcostestimate() |
5727 |
Moved to different CF |
Performance
|
|
9/10
|
+55−13
|
Tom Lane (tgl) |
Henson Choi (assam258.gmail.com) |
Tom Lane (tgl) |
5 |
4 weeks ago |
| Improve hash join's handling of tuples with null join keys |
5738 |
Moved to different CF |
Performance
|
|
10/10
|
+414−82
|
Tom Lane (tgl) |
Chao Li (chaol) |
Tom Lane (tgl) |
5 |
4 weeks ago |
| Parallel processing of indexes in autovacuum |
5755 |
Moved to different CF |
Performance
|
18 |
Needs rebase!
|
|
Maxim Orlov (m.orlov), Daniil Davydov (dddaniil) |
Masahiko Sawada (masahikosawada), Sami Imseih (simseih) |
Masahiko Sawada (masahikosawada) |
5 |
1 week ago |
| Extend skipping FK checks on replicas to include ADD FK and TRUNCATE |
5774 |
Moved to different CF |
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 |
Moved to different CF |
Performance
|
|
10/10
|
+7706−12726
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov) |
|
6 |
3 weeks ago |
| Returning nbtree posting list TIDs in DESC order during backwards scans |
5824 |
Committed |
Performance
|
|
10/10
|
+53−41
|
Peter Geoghegan (pgeoghegan) |
Mircea Cadariu (mcadariu) |
Peter Geoghegan (pgeoghegan) |
2 |
4 months ago |
| Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume |
5841 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Melanie Plageman (melanieplageman) |
Kirill Reshke (reshke) |
Melanie Plageman (melanieplageman) |
5 |
1 week ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Moved to different CF |
Performance
System Administration
|
stable |
Needs rebase!
|
|
Hannu Krosing (hannukrosing), Nitin Motiani (nitinmotiani) |
Dilip Kumar (dilip.kumar) |
|
4 |
1 month ago |
| Don't keep closed WAL segment in page cache after replay |
5894 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Anthonin Bonnefoy (bonnefoa) |
Hüseyin Demir (demir) |
|
4 |
1 month ago |
| Automatically sizing the IO worker pool |
5913 |
Moved to different CF |
Performance
|
19 |
9/10
|
+850−0
|
Thomas Munro (macdice) |
|
Thomas Munro (macdice) |
4 |
4 days ago |
| Eagerly evict bulkwrite strategy ring |
5919 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Melanie Plageman (melanieplageman) |
|
|
5 |
3 months ago |
| Making jsonb_agg() faster |
5930 |
Committed |
Performance
|
|
Needs rebase!
|
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
3 |
3 months ago |
| Speed up COPY FROM text/CSV parsing using SIMD |
5952 |
Moved to different CF |
Performance
|
19 |
10/10
|
+184−3
|
Shinya Kato (shinyakato) |
Nathan Bossart (bossartn), Ayoub Kazar (kaz) |
Nathan Bossart (bossartn) |
3 |
1 month ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Moved to different CF |
Performance
|
19 |
9/10
|
+0−0
|
Lukas Fittl (lfittl) |
Zsolt Parragi (zsolt.parragi) |
|
5 |
1 week ago |
| Improve read_local_xlog_page_guts by replacing polling with latch-based waiting |
6024 |
Moved to different CF |
Performance
Logical Replication
|
19 |
10/10
|
+40−11
|
Xuneng Zhou (dylanzhou) |
|
|
3 |
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) |
|
|
3 |
6 months ago |
| Checkpointer write combining |
6043 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Melanie Plageman (melanieplageman) |
Soumya S Murali (soumyamurali) |
|
3 |
1 month ago |
| Optimize LISTEN/NOTIFY |
6078 |
Committed |
Performance
|
|
10/10
|
+1161−184
|
Joel Jacobson (joeljacobson) |
Tom Lane (tgl) |
Tom Lane (tgl) |
2 |
3 months ago |
| use SIMD in GetPrivateRefCountEntry() |
6101 |
Withdrawn |
Performance
|
19 |
Needs rebase!
|
|
Nathan Bossart (bossartn) |
|
|
2 |
5 months ago |
| pgstattuple: Use streaming read API in pgstatindex functions |
6125 |
Moved to different CF |
Extensions
AIO
Performance
|
19 |
Needs rebase!
|
|
Xuneng Zhou (dylanzhou) |
Shinya Kato (shinyakato) |
Michael Paquier (michael-kun) |
3 |
5 months ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Moved to different CF |
Performance
|
|
10/10
|
+417−9
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada) |
|
4 |
1 week 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 |
3 months ago |
| Optimization of the is_normalized() function. |
6152 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Alexander Borisov (lexborisov) |
|
|
4 |
1 week ago |
| Batching in executor, part 1: add batch variant of table AM scan API |
6176 |
Moved to different CF |
Help - Benchmarks
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
|
|
3 |
1 week 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) |
Yogesh Sharma (sharmay), Aditya Gollamudi (adigoll) |
|
4 |
1 week 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 |
8 months ago |
| Lock-free XLog Reservation from WAL |
6192 |
Moved to different CF |
Performance
Multithreading
|
19 |
Needs rebase!
|
|
Yura Sokolov (funny_falcon), Zhiguo Zhou (zhiguozhou) |
|
|
3 |
5 months ago |
| Increase NUM_XLOGINSERT_LOCKS |
6193 |
Moved to different CF |
Multithreading
Performance
|
19 |
9/10
|
+34−21
|
Yura Sokolov (funny_falcon) |
|
|
3 |
1 year ago |
| Reduce unnecessary locking of pruned partitions when reusing cached plans |
6216 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Amit Langote (amitlan) |
|
|
2 |
2 weeks ago |
| tuple radix sort |
6217 |
Moved to different CF |
Performance
|
|
10/10
|
+0−0
|
John Naylor (john.naylor) |
Chengpeng Yan (chengpeng.yan) |
John Naylor (john.naylor) |
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 |
Moved to different CF |
Performance
libpq
|
stable |
Needs rebase!
|
|
Hannu Krosing (hannukrosing) |
Dilip Kumar (dilip.kumar), Pavel Stehule (okbobcz), Neil Min (neilmin) |
|
3 |
2 weeks ago |
| Bypassing cursors in postgres_fdw to enable parallel plans |
6233 |
Moved to different CF |
postgres_fdw
Performance
|
19 |
10/10
|
+627−51
|
Rafia Sabih (rafia.sabih) |
|
|
2 |
5 days ago |
| parallel pgbench -i |
6242 |
Moved to different CF |
Performance
|
|
10/10
|
+134−4
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
3 |
5 days ago |
| Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) |
6245 |
Moved to different CF |
Performance
My First Patch
Refactoring Only
|
19 |
10/10
|
+978−150
|
Boris Mironov (bmironov) |
Fujii Masao (masaofujii), Egor Madyshev (emadyshev) |
|
3 |
4 weeks ago |
| Better Performance for PostgreSQL with large INSERTs |
6266 |
Moved to different CF |
Performance
GUC
|
19 |
10/10
|
+24−14
|
Filip Januš (fjanus) |
|
|
2 |
4 months ago |
| Add a greedy join search algorithm to handle large join problems |
6274 |
Moved to different CF |
Performance
|
|
3/10
|
+1922−4
|
Chengpeng Yan (chengpeng.yan) |
lakshmi g (lakshmi) |
|
3 |
1 month ago |
| Expose checkpoint reason to completion log messages. |
6306 |
Moved to different CF |
Extensions
Performance
|
19 |
10/10
|
+35−25
|
Soumya S Murali (soumyamurali) |
Fujii Masao (masaofujii), Michael Banck (mbanck), Vasu M (vasu01) |
Fujii Masao (masaofujii) |
2 |
1 month ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Moved to different CF |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
3 |
4 months ago |
| change default default_toast_compression to lz4 |
6312 |
Moved to different CF |
Performance
GUC
|
|
10/10
|
+35−5
|
Euler Taveira (eulerto) |
|
Peter Eisentraut (petere) |
2 |
1 month ago |
| Do not emit FPW for unlogged relations in BRIN empty-page |
6324 |
Committed |
Performance
|
stable |
10/10
|
+5−1
|
Kirill Reshke (reshke) |
|
Heikki Linnakangas (heikki) |
1 |
4 months ago |
| Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations |
6334 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Andreas Karlsson (kandreas) |
|
Tomas Vondra (fuzzycz) |
2 |
1 month ago |
| Reuse data from readRecordBuf in XLogDecodeNextRecord |
6343 |
Withdrawn |
AIO
Performance
My First Patch
|
19 |
2/10
|
+97−68
|
Sonya Valchuk (pyos) |
|
|
1 |
4 months ago |
| Streamify more code paths |
6346 |
Moved to different CF |
Extensions
AIO
Performance
|
19 |
Needs rebase!
|
|
Xuneng Zhou (dylanzhou) |
|
Michael Paquier (michael-kun) |
2 |
1 month ago |
| Improve performance of tuple deformation |
6352 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
David Rowley (davidrowley) |
Zsolt Parragi (zsolt.parragi) |
David Rowley (davidrowley) |
2 |
2 weeks ago |
| Change IndexAmRoutines to be statically allocated |
6355 |
Committed |
Performance
|
|
9/10
|
+0−0
|
Matthias van de Meent (mmeent) |
|
Tom Lane (tgl) |
1 |
3 months ago |
| Hash-based MCV matching for large IN-lists |
6356 |
Moved to different CF |
Performance
|
stable |
10/10
|
+542−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
3 |
1 week ago |
| Speed up ICU case conversion |
6360 |
Committed |
Performance
|
19 |
10/10
|
+208−94
|
Andreas Karlsson (kandreas) |
|
Jeff Davis (jdavis) |
1 |
3 months ago |