| Index Prefetching |
4351 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Alexandre Felipe (afelipe) |
|
14 |
11 hours ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Moved to different CF |
Performance
DDL
|
19 |
1/10
|
+2863−476
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
9 |
6 days ago |
| Asynchronous MergeAppend Execution |
5129 |
Moved to different CF |
Performance
|
|
10/10
|
+1447−725
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
8 |
yesterday |
| 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) |
|
6 |
4 months ago |
| Expanding HOT updates for expression and partial indexes |
5556 |
Moved to different CF |
Performance
|
19 |
10/10
|
+3345−233
|
Greg Burd (gregburd) |
|
|
5 |
11 hours ago |
| Compress big WAL records |
5621 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii) |
|
5 |
1 month ago |
| Reduce timing overhead of EXPLAIN ANALYZE using rdtsc |
5622 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) |
|
|
5 |
3 days ago |
| Create DATA dump objects for partitioned tables too |
5692 |
Moved to different CF |
Performance
|
|
10/10
|
+223−41
|
Tom Lane (tgl) |
|
|
5 |
10 months ago |
| Accounting for metapages in genericcostestimate() |
5727 |
Moved to different CF |
Performance
|
|
10/10
|
+55−13
|
Tom Lane (tgl) |
|
|
5 |
10 months ago |
| Improve hash join's handling of tuples with null join keys |
5738 |
Moved to different CF |
Performance
|
|
9/10
|
+381−71
|
Tom Lane (tgl) |
Chao Li (chaol) |
|
5 |
6 months 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) |
|
5 |
8 hours 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) |
|
|
4 |
1 month 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 |
5 days 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 |
2 months ago |
| Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume |
5841 |
Moved to different CF |
Performance
|
19 |
10/10
|
+1077−940
|
Melanie Plageman (melanieplageman) |
Kirill Reshke (reshke) |
|
5 |
6 hours 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) |
|
3 |
1 week ago |
| Don't keep closed WAL segment in page cache after replay |
5894 |
Moved to different CF |
Performance
|
19 |
10/10
|
+40−0
|
Anthonin Bonnefoy (bonnefoa) |
Hüseyin Demir (demir) |
|
4 |
22 hours ago |
| Eagerly evict bulkwrite strategy ring |
5919 |
Moved to different CF |
Performance
|
19 |
Needs rebase!
|
|
Melanie Plageman (melanieplageman) |
|
|
5 |
1 month ago |
| Making jsonb_agg() faster |
5930 |
Committed |
Performance
|
|
Needs rebase!
|
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
3 |
1 month ago |
| Speed up COPY FROM text/CSV parsing using SIMD |
5952 |
Moved to different CF |
Performance
|
19 |
10/10
|
+137−4
|
Shinya Kato (shinyakato) |
Nathan Bossart (bossartn), Ayoub Kazar (kaz) |
Nathan Bossart (bossartn) |
3 |
10 hours ago |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Moved to different CF |
Performance
|
19 |
0/10
|
+2338−357
|
Lukas Fittl (lfittl) |
|
|
4 |
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 |
1 month 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 |
5 months ago |
| Checkpointer write combining |
6043 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Melanie Plageman (melanieplageman) |
Soumya S Murali (soumyamurali) |
|
3 |
5 days ago |
| Optimize LISTEN/NOTIFY |
6078 |
Committed |
Performance
|
|
10/10
|
+1161−184
|
Joel Jacobson (joeljacobson) |
Tom Lane (tgl) |
Tom Lane (tgl) |
2 |
1 month ago |
| use SIMD in GetPrivateRefCountEntry() |
6101 |
Withdrawn |
Performance
|
19 |
Needs rebase!
|
|
Nathan Bossart (bossartn) |
|
|
2 |
4 months ago |
| pgstattuple: Use streaming read API in pgstatindex functions |
6125 |
Moved to different CF |
Extensions
AIO
Performance
|
19 |
10/10
|
+48−9
|
Xuneng Zhou (dylanzhou) |
Shinya Kato (shinyakato) |
|
3 |
3 months ago |
| postgres_fdw: Use COPY to speed up batch inserts |
6137 |
Moved to different CF |
Performance
|
|
9/10
|
+268−8
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada) |
|
3 |
4 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 |
1 month ago |
| Optimization of the is_normalized() function. |
6152 |
Moved to different CF |
Performance
|
19 |
10/10
|
+6626−8086
|
Alexander Borisov (lexborisov) |
|
|
3 |
4 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) |
|
|
3 |
2 months 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 |
7 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 |
4 months ago |
| Increase NUM_XLOGINSERT_LOCKS |
6193 |
Moved to different CF |
Multithreading
Performance
|
19 |
10/10
|
+34−21
|
Yura Sokolov (funny_falcon) |
|
|
3 |
1 year ago |
| tuple radix sort |
6217 |
Moved to different CF |
Performance
|
|
10/10
|
+48−7
|
John Naylor (john.naylor) |
Chengpeng Yan (chengpeng.yan) |
|
2 |
2 weeks 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) |
|
2 |
2 weeks ago |
| parallel pgbench -i |
6242 |
Moved to different CF |
Performance
|
|
10/10
|
+501−35
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
2 |
1 week 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
|
+869−132
|
Boris Mironov (bmironov) |
Egor Madyshev (emadyshev) |
|
2 |
2 hours ago |
| Better Performance for PostgreSQL with large INSERTs |
6266 |
Moved to different CF |
Performance
GUC
|
19 |
9/10
|
+24−14
|
Filip Januš (fjanus) |
|
|
2 |
2 months ago |
| Add a greedy join search algorithm to handle large join problems |
6274 |
Moved to different CF |
Performance
|
|
2/10
|
+1922−4
|
Chengpeng Yan (chengpeng.yan) |
lakshmi g (lakshmi) |
|
2 |
20 hours 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 week ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Moved to different CF |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
2 |
2 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 |
4 days 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 |
2 months ago |
| Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations |
6334 |
Moved to different CF |
Performance
|
19 |
10/10
|
+52−33
|
Andreas Karlsson (kandreas) |
|
|
2 |
3 weeks ago |
| Reuse data from readRecordBuf in XLogDecodeNextRecord |
6343 |
Withdrawn |
AIO
Performance
My First Patch
|
19 |
2/10
|
+97−68
|
Sonya Valchuk (pyos) |
|
|
1 |
2 months ago |
| Streamify more code paths |
6346 |
Moved to different CF |
Extensions
AIO
Performance
|
19 |
10/10
|
+300−46
|
Xuneng Zhou (dylanzhou) |
|
|
2 |
3 weeks ago |
| Improve performance of tuple deformation |
6352 |
Moved to different CF |
Performance
|
|
9/10
|
+1166−656
|
David Rowley (davidrowley) |
Zsolt Parragi (zsolt.parragi) |
|
2 |
yesterday |
| Change IndexAmRoutines to be statically allocated |
6355 |
Committed |
Performance
|
|
9/10
|
+0−0
|
Matthias van de Meent (mmeent) |
|
Tom Lane (tgl) |
1 |
2 months ago |
| Hash-based MCV matching for large IN-lists |
6356 |
Moved to different CF |
Performance
|
stable |
10/10
|
+686−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
2 |
9 hours ago |
| Speed up ICU case conversion |
6360 |
Committed |
Performance
|
19 |
10/10
|
+208−94
|
Andreas Karlsson (kandreas) |
|
Jeff Davis (jdavis) |
1 |
1 month ago |