| Index Prefetching |
4351 |
Needs review |
Performance
|
|
Needs rebase!
|
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
Alexandre Felipe (afelipe) |
|
14 |
7 hours ago |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan |
4971 |
Needs review |
Performance
DDL
|
19 |
10/10
|
+2863−476
|
Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) |
Matthias van de Meent (mmeent) |
|
9 |
3 days ago |
| Asynchronous MergeAppend Execution |
5129 |
Needs review |
Performance
|
|
10/10
|
+1447−726
|
Alexander Pyhalov (a.pyhalov) |
Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) |
|
8 |
2 weeks ago |
| Showing applied extended statistics in explain Part2 |
5359 |
Needs review |
Performance
|
18 |
Needs rebase!
|
|
Tatsuro Yamada (tatsuro_yamada) |
Tomas Vondra (fuzzycz), Andrei Lepikhov (lepikhov), Masahiro Ikeda (masahiro.ikeda), Ilia Evdokimov (ilidock95) |
Tomas Vondra (fuzzycz) |
5 |
6 months ago |
| Adding compression of temporary files |
5382 |
Needs review |
Performance
|
|
10/10
|
+4008−22
|
Filip Januš (fjanus) |
Zsolt Parragi (zsolt.parragi), lakshmi g (lakshmi) |
|
6 |
3 weeks ago |
| Eliminating SPI / SQL from some RI trigger functions |
5450 |
Needs review |
Performance
|
19 |
10/10
|
+1698−12
|
Amit Langote (amitlan) |
|
|
5 |
1 hour ago |
| Pull-up subquery if INNER JOIN-ON contains refs to upper-query |
5487 |
Waiting on Author |
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 |
Needs review |
Performance
|
19 |
5/10
|
+576−228
|
Greg Burd (gregburd) |
|
|
5 |
yesterday |
| Compress big WAL records |
5621 |
Waiting on Author |
Performance
|
|
Needs rebase!
|
|
Andrey Borodin (x4m) |
Fujii Masao (masaofujii) |
|
5 |
1 month ago |
| Reduce timing overhead of EXPLAIN ANALYZE using rdtsc |
5622 |
Needs review |
Performance
|
|
10/10
|
+807−91
|
Andres Freund (andresfreund), Lukas Fittl (lfittl), David Geier (geidav) |
|
|
5 |
18 hours ago |
| Produce LLVM bitcode files on meson builds |
5671 |
Needs review |
Performance
|
19 |
10/10
|
+799−50
|
Andres Freund (andresfreund), Diego Fronza (dfronza), Nazir Bilal Yavuz (nbyavuz) |
|
|
4 |
1 month ago |
| Create DATA dump objects for partitioned tables too |
5692 |
Needs review |
Performance
|
|
9/10
|
+223−41
|
Tom Lane (tgl) |
|
|
5 |
10 months ago |
| Enable auto-vectorization for page checksum calculations |
5726 |
Ready for Committer |
Performance
|
19 |
10/10
|
+384−34
|
Matthew Sterrett (matthew.sterrett.intel.com), Andrew Kim (andrewk1) |
John Naylor (john.naylor) |
John Naylor (john.naylor) |
3 |
2 weeks ago |
| Accounting for metapages in genericcostestimate() |
5727 |
Needs review |
Performance
|
|
10/10
|
+55−13
|
Tom Lane (tgl) |
|
|
5 |
9 months ago |
| Improve hash join's handling of tuples with null join keys |
5738 |
Waiting on Author |
Performance
|
|
10/10
|
+381−71
|
Tom Lane (tgl) |
Chao Li (chaol) |
|
5 |
6 months ago |
| Parallel processing of indexes in autovacuum |
5755 |
Needs review |
Performance
|
18 |
Needs rebase!
|
|
Maxim Orlov (m.orlov), Daniil Davydov (dddaniil) |
Masahiko Sawada (masahikosawada), Sami Imseih (simseih) |
|
5 |
6 hours ago |
| 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) |
|
|
4 |
1 month ago |
| Vectorized CRC on Arm64 |
5789 |
Needs review |
Performance
|
|
10/10
|
+209−5
|
John Naylor (john.naylor) |
|
|
3 |
1 month ago |
| Improve the performance of Unicode Normalization Forms. |
5802 |
Ready for Committer |
Performance
|
|
10/10
|
+7702−12682
|
Alexander Borisov (lexborisov) |
Victor Yegorov (vyegorov) |
|
5 |
2 days ago |
| Eliminate xl_heap_visible to reduce vacuum and COPY FREEZE WAL volume |
5841 |
Needs review |
Performance
|
19 |
10/10
|
+0−0
|
Melanie Plageman (melanieplageman) |
Kirill Reshke (reshke) |
|
5 |
1 week ago |
| Adding pg_dump flag for parallel export to pipes |
5893 |
Needs review |
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 |
Needs review |
Performance
|
19 |
10/10
|
+40−0
|
Anthonin Bonnefoy (bonnefoa) |
|
|
4 |
1 week ago |
| Speed up COPY FROM text/CSV parsing using SIMD |
5952 |
Needs review |
Performance
|
19 |
10/10
|
+137−4
|
Shinya Kato (shinyakato) |
Nathan Bossart (bossartn), Ayoub Kazar (kaz) |
Nathan Bossart (bossartn) |
3 |
yesterday |
| Stack-based tracking of per-node WAL/buffer usage |
6023 |
Needs review |
Performance
|
19 |
0/10
|
+2338−357
|
Lukas Fittl (lfittl) |
|
|
4 |
4 days ago |
| Improve read_local_xlog_page_guts by replacing polling with latch-based waiting |
6024 |
Needs review |
Performance
Logical Replication
|
19 |
10/10
|
+40−11
|
Xuneng Zhou (dylanzhou) |
|
|
3 |
3 weeks ago |
| Get rid of pgstat_count_backend_io_op*() functions |
6025 |
Needs review |
Performance
Refactoring Only
|
19 |
10/10
|
+31−57
|
Bertrand Drouvot (bertranddrouvot.pg) |
|
|
3 |
5 months ago |
| MPTCP - multiplexing many TCP connections through one socket to get better bandwidth |
6061 |
Needs review |
Performance
|
19 |
0/10
|
+72−2
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
2 |
5 months ago |
| pgstattuple: Use streaming read API in pgstatindex functions |
6125 |
Ready for Committer |
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 |
Needs review |
Performance
|
|
10/10
|
+268−8
|
Matheus Alcantara (matheus.alcantara) |
Masahiko Sawada (masahikosawada) |
|
3 |
yesterday |
| Optimize SnapBuildPurgeOlderTxn: use in-place compaction instead of temporary array |
6141 |
Needs review |
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 |
Needs review |
Performance
|
19 |
10/10
|
+6626−8086
|
Alexander Borisov (lexborisov) |
|
|
3 |
3 months ago |
| Use log_newpage_range in HASH index build |
6158 |
Needs review |
Performance
|
stable |
0/10
|
+77−0
|
Kirill Reshke (reshke) |
lakshmi g (lakshmi) |
|
2 |
1 month ago |
| Optimize SnapBuild by maintaining committed.xip in sorted order |
6187 |
Needs review |
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 |
Needs review |
Performance
Multithreading
|
19 |
10/10
|
+88−16
|
Zhiguo Zhou (zhiguozhou) |
|
|
3 |
7 months ago |
| Lock-free XLog Reservation from WAL |
6192 |
Needs review |
Performance
Multithreading
|
19 |
10/10
|
+532−57
|
Yura Sokolov (funny_falcon), Zhiguo Zhou (zhiguozhou) |
|
|
3 |
3 months ago |
| Increase NUM_XLOGINSERT_LOCKS |
6193 |
Needs review |
Multithreading
Performance
|
19 |
10/10
|
+34−21
|
Yura Sokolov (funny_falcon) |
|
|
3 |
1 year ago |
| tuple radix sort |
6217 |
Waiting on Author |
Performance
|
|
10/10
|
+48−7
|
John Naylor (john.naylor) |
Chengpeng Yan (chengpeng.yan) |
|
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 |
Waiting on Author |
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 |
Needs review |
Performance
|
|
10/10
|
+501−35
|
Mircea Cadariu (mcadariu) |
lakshmi g (lakshmi) |
|
2 |
4 days ago |
| Idea to enhance pgbench by more modes to generate data (multi-TXNs, UNNEST, COPY BINARY) |
6245 |
Needs review |
Performance
My First Patch
Refactoring Only
|
19 |
10/10
|
+763−131
|
Boris Mironov (bmironov) |
Egor Madyshev (emadyshev) |
|
2 |
4 days ago |
| Better Performance for PostgreSQL with large INSERTs |
6266 |
Needs review |
Performance
GUC
|
19 |
10/10
|
+24−14
|
Filip Januš (fjanus) |
|
|
2 |
2 months ago |
| Add a greedy join search algorithm to handle large join problems |
6274 |
Needs review |
Performance
|
|
2/10
|
+1922−4
|
Chengpeng Yan (chengpeng.yan) |
lakshmi g (lakshmi) |
|
2 |
1 week ago |
| Expose checkpoint timestamp and duration in pg_stat_checkpointer |
6307 |
Needs review |
Extensions
Performance
|
19 |
Needs rebase!
|
|
Soumya S Murali (soumyamurali) |
|
|
2 |
2 months ago |
| change default default_toast_compression to lz4 |
6312 |
Waiting on Author |
Performance
GUC
|
|
10/10
|
+35−5
|
Euler Taveira (eulerto) |
|
Peter Eisentraut (petere) |
2 |
yesterday |
| Remove header lock BufferGetLSNAtomic() on architectures with 64 bit atomic operations |
6334 |
Needs review |
Performance
|
19 |
10/10
|
+52−33
|
Andreas Karlsson (kandreas) |
|
|
2 |
3 weeks ago |
| Streamify more code paths |
6346 |
Needs review |
Extensions
AIO
Performance
|
19 |
10/10
|
+300−46
|
Xuneng Zhou (dylanzhou) |
|
|
2 |
2 weeks ago |
| Improve performance of tuple deformation |
6352 |
Needs review |
Performance
|
|
8/10
|
+1103−659
|
David Rowley (davidrowley) |
Zsolt Parragi (zsolt.parragi) |
|
2 |
yesterday |
| Hash-based MCV matching for large IN-lists |
6356 |
Needs review |
Performance
|
stable |
10/10
|
+686−5
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Tatsuya Kawata (croissant) |
|
2 |
yesterday |
| llvmjit: always add the simplifycfg pass |
6384 |
Needs review |
Performance
|
19 |
10/10
|
+16−4
|
Pierre Ducroquet (pinaraf) |
Matheus Alcantara (matheus.alcantara) |
|
1 |
4 weeks ago |
| Resetting snapshots during the first phase of [CREATE |RE]INDEX CONCURRENTLY |
6401 |
Needs review |
Performance
DDL
|
19 |
10/10
|
+1138−159
|
Mihail Nikalayeu (mihailnikalayeu) |
|
|
1 |
1 month ago |
| Reduce build times of pg_trgm GIN indexes |
6418 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
David Geier (geidav) |
|
|
1 |
1 month ago |
| aio: warn user if combined io_uring memory mappings are unavailable |
6421 |
Needs review |
Performance
|
stable |
10/10
|
+12−4
|
Jakub Wartak (jakub.wartak.tomtom) |
|
|
1 |
3 months ago |
| ANALYZE: hash-accelerate MCV tracking for equality-only types |
6422 |
Needs review |
Performance
|
|
10/10
|
+227−24
|
Chengpeng Yan (chengpeng.yan) |
Ilia Evdokimov (ilidock95), Tatsuya Kawata (croissant) |
|
1 |
yesterday |
| LLVMJIT: introduce force-inlined functions |
6437 |
Needs review |
Performance
|
19 |
10/10
|
+103−4
|
Pierre Ducroquet (pinaraf) |
|
|
1 |
1 month ago |
| Optimizing SELECT expr INTO var in plpgsql |
6447 |
Needs review |
Performance
|
|
10/10
|
+43−11
|
Tom Lane (tgl) |
|
|
1 |
3 weeks ago |
| Convert NOT IN sublinks to anti-joins when safe |
6455 |
Needs review |
Performance
|
19 |
10/10
|
+1272−66
|
Richard Guo (richardguo) |
wenhui qiu (qiuwenhuifx.163.com) |
|
1 |
2 weeks ago |
| Remove no-op PlaceHolderVars |
6457 |
Needs review |
Performance
|
19 |
10/10
|
+357−240
|
Richard Guo (richardguo) |
|
|
1 |
1 month ago |
| Change default of jit to off |
6465 |
Ready for Committer |
Performance
GUC
|
|
10/10
|
+5−4
|
Jelte Fennema-Nio (jeltef) |
|
|
1 |
2 weeks ago |
| Unfortunate pushing down of expressions below sort |
6467 |
Needs review |
Performance
|
|
10/10
|
+318−56
|
Chengpeng Yan (chengpeng.yan) |
|
|
1 |
2 weeks ago |
| llvmjit - improve code generated in O0 |
6469 |
Needs review |
Performance
|
19 |
10/10
|
+59−25
|
Pierre Ducroquet (pinaraf) |
|
|
1 |
2 weeks ago |
| SLOPE - Planner optimizations on monotonic expressions. |
6479 |
Needs review |
Performance
|
|
10/10
|
+1466−221
|
Alexandre Felipe (afelipe) |
|
|
1 |
1 week ago |
| Pipelined Recovery |
6487 |
Needs review |
Performance
|
19 |
Needs rebase!
|
|
Imran Zaheer (imranzaheer) |
|
|
1 |
1 week ago |
| Change the default wal_blocksize to 4KB |
6490 |
Needs review |
Performance
|
|
9/10
|
+12−12
|
Andy Pogrebnoi (birdofdada) |
|
|
1 |
1 week ago |
| Fix severe performance regression with gettext 0.20+ on Windows |
6491 |
Needs review |
Windows
Performance
|
|
10/10
|
+30−1
|
Bryan Green (lispyone) |
Peter Eisentraut (petere) |
Peter Eisentraut (petere) |
1 |
1 week ago |
| Optional skipping of unchanged relations during ANALYZE? |
6516 |
Needs review |
psql
Performance
SQL Commands
|
19 |
10/10
|
+252−2
|
Vasu M (vasu01) |
|
|
1 |
1 week ago |
| Reduce planning time for large NOT IN lists containing NULL |
6519 |
Needs review |
Performance
|
stable |
10/10
|
+94−0
|
Ilia Evdokimov (ilidock95) |
David Geier (geidav), Zsolt Parragi (zsolt.parragi) |
|
1 |
2 days ago |
| Simplify SortSupport implementation for macaddr |
6530 |
Needs review |
Performance
|
19 |
10/10
|
+5−95
|
Aleksander Alekseev (a.alekseev) |
|
|
1 |
2 days ago |
| pg_restore add --no-globals option when restored using pg_dumpall non-text dump |
6541 |
Needs review |
Performance
|
19 |
10/10
|
+44−5
|
Mahendra Singh Thalor (mahithalor) |
|
|
1 |
yesterday |
| synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
6543 |
Needs review |
Performance
Logical Replication
|
|
1/10
|
+519−91
|
SATYANARAYANA NARLAPURAM (satyanarayanan) |
|
|
1 |
yesterday |