| AcquireExecutorLocks() and run-time pruning |
3478 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Amit Langote (amitlan) |
Tom Lane (tgl) |
Amit Langote (amitlan) |
17 |
2 months ago |
| Reducing planning time when tables have many partitions |
3701 |
Moved to different CF |
Performance
|
|
7/7
|
+446−120
|
Yuya Watari (watari) |
Tom Lane (tgl), Thom Brown (thom), Ashutosh Bapat (ashutoshbapat), Andrei Lepikhov (lepikhov), newtglobal postgresql_contributors (newtpostgrescontributors) |
David Rowley (davidrowley) |
15 |
10 months ago |
| Avoid unnecessary PlaceHolderVars for simple Vars |
4319 |
Committed |
Performance
|
|
Not processed
|
|
Richard Guo (richardguo) |
James Coleman (jcole1989) |
Richard Guo (richardguo) |
9 |
1 year ago |
| Index Prefetching |
4351 |
Moved to different CF |
Performance
|
|
10/10
|
+4300−2204
|
Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) |
|
|
14 |
1 week ago |
| Statistics Import and Export |
4538 |
Moved to different CF |
Performance
|
|
7/7
|
+267−64
|
Corey Huinker (coreyh) |
Nathan Bossart (bossartn), Bharath Rupireddy (bharathrupireddy) |
Jeff Davis (jdavis) |
9 |
8 months ago |
| Reducing memory consumed by RestrictInfo list translations in partitionwise join planning |
4564 |
Moved to different CF |
Performance
|
|
7/7
|
+389−77
|
Ashutosh Bapat (ashutoshbapat) |
|
Amit Langote (amitlan) |
8 |
10 months ago |
| CRC32C Parallel Computation Optimization on ARM |
4620 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
xiang gao (xiang.gao) |
Nathan Bossart (bossartn), John Naylor (john.naylor) |
|
8 |
10 months ago |
| Special-case executor expression steps for common combinations |
4627 |
Moved to different CF |
Performance
|
|
7/7
|
+194−39
|
Andres Freund (andresfreund), Daniel Gustafsson (d_gustafsson) |
Andreas Karlsson (kandreas) |
Daniel Gustafsson (d_gustafsson) |
8 |
10 months ago |
| Teach predtest about IS [NOT] <boolean> proofs |
4690 |
Moved to different CF |
Performance
|
|
10/10
|
+1882−129
|
James Coleman (jcole1989) |
Tom Lane (tgl) |
|
8 |
1 year ago |
| Parallel CREATE INDEX for GIN indexes |
4966 |
Moved to different CF |
Performance
|
|
9/10
|
+7−0
|
Tomas Vondra (fuzzycz) |
Kirill Reshke (reshke), Matthias van de Meent (mmeent), Andy Fan (andy2) |
Tomas Vondra (fuzzycz) |
6 |
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) |
|
9 |
3 weeks ago |
| Parallel CREATE INDEX for GiST indexes |
5026 |
Returned with feedback |
Performance
|
|
Not processed
|
|
Tomas Vondra (fuzzycz) |
Andreas Karlsson (kandreas) |
|
4 |
1 year ago |
| Sort functions with specialized comparators |
5036 |
Moved to different CF |
Performance
|
|
6/7
|
+34−48
|
Andrey Borodin (x4mmm), Stepan Neretin (fenixrnd.mail.ru) |
|
John Naylor (john.naylor) |
5 |
11 months ago |
| Remove self join on a unique column |
5043 |
Moved to different CF |
Performance
|
|
7/7
|
+53−28
|
Andrei Lepikhov (lepikhov) |
Dean Rasheed (deanr) |
Alexander Korotkov (smagen) |
5 |
10 months ago |
| nbtree skip scan |
5081 |
Moved to different CF |
Performance
|
|
7/7
|
+3840−565
|
Peter Geoghegan (pgeoghegan) |
Aleksander Alekseev (a.alekseev), Masahiro Ikeda (masahiro.ikeda), Alena Rybakina (a.rybakina) |
Peter Geoghegan (pgeoghegan) |
5 |
10 months ago |
| Streaming Vacuum |
5089 |
Moved to different CF |
Performance
|
|
Not processed
|
|
Thomas Munro (macdice), Melanie Plageman (melanieplageman) |
|
Melanie Plageman (melanieplageman) |
5 |
3 months ago |
| Make tuple deformation faster |
5097 |
Committed |
Performance
|
|
Not processed
|
|
David Rowley (davidrowley) |
|
David Rowley (davidrowley) |
4 |
1 year ago |
| Improved crc32c performance with AVX-512 algorithm. |
5100 |
Moved to different CF |
Performance
|
18 |
Needs rebase!
|
|
Paul Amonson (pamonson), Raghuveer Devulapalli (rdevulap) |
Nathan Bossart (bossartn) |
|
4 |
1 year ago |
| MergeJoin beats HashJoin in the case of multiple hash clauses |
5114 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Andrei Lepikhov (lepikhov) |
|
Alexander Korotkov (smagen) |
4 |
6 months ago |
| Allow partition-wise join when whole row var is needed |
5128 |
Moved to different CF |
Performance
|
18 |
Needs rebase!
|
|
Ashutosh Bapat (ashutoshbapat), Alexander Pyhalov (a.pyhalov) |
|
|
5 |
6 months ago |
| Asynchronous MergeAppend Execution |
5129 |
Moved to different CF |
Performance
|
|
10/10
|
+1441−710
|
Alexander Pyhalov (a.pyhalov) |
Matheus Alcantara (matheus.alcantara) |
|
8 |
1 month ago |
| Use read streams in autoprewarm |
5162 |
Moved to different CF |
Performance
|
|
6/7
|
+178−76
|
Nazir Bilal Yavuz (nbyavuz) |
Daniel Gustafsson (d_gustafsson) |
Melanie Plageman (melanieplageman) |
4 |
10 months ago |
| AIO |
5227 |
Moved to different CF |
Performance
|
|
7/7
|
+5611−79
|
Andres Freund (andresfreund) |
Noah Misch (nmisch) |
Andres Freund (andresfreund) |
4 |
10 months ago |
| Add ExprState hashing for GROUP BY and hashed SubPlans |
5229 |
Committed |
Performance
|
|
Not processed
|
|
David Rowley (davidrowley) |
|
David Rowley (davidrowley) |
3 |
1 year ago |
| Allow SQL functions use CachedPlan machinery |
5246 |
Moved to different CF |
Performance
|
18 |
7/7
|
+2109−972
|
Alexander Pyhalov (a.pyhalov) |
Tom Lane (tgl), Pavel Stehule (okbobcz) |
Tom Lane (tgl) |
3 |
10 months ago |
| Improve statistics estimation considering GROUP-BY as a 'uniqueiser' |
5269 |
Moved to different CF |
Performance
|
18 |
2/7
|
+37−0
|
Andrei Lepikhov (lepikhov) |
|
Alexander Korotkov (smagen) |
3 |
11 months ago |
| Replace IN VALUES with ANY in WHERE clauses during optimization |
5283 |
Moved to different CF |
Performance
|
18 |
Needs rebase!
|
|
Andrei Lepikhov (lepikhov), Alena Rybakina (a.rybakina) |
newtglobal postgresql_contributors (newtpostgrescontributors) |
Alexander Korotkov (smagen) |
3 |
10 months ago |
| Limiting overshoot in nbtree SAOP parallel index scans |
5299 |
Moved to different CF |
Performance
|
|
10/10
|
+151−23
|
Matthias van de Meent (mmeent) |
|
|
4 |
7 months ago |
| Trigger more frequent autovacuums for insert-heavy tables |
5320 |
Moved to different CF |
Performance
|
|
7/7
|
+37−16
|
Melanie Plageman (melanieplageman) |
Nathan Bossart (bossartn) |
Melanie Plageman (melanieplageman) |
3 |
2 months ago |
| use a non-locking initial test in TAS_SPIN on AArch64 |
5321 |
Committed |
Performance
|
18 |
Not processed
|
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
2 |
1 year ago |
| Add sortsupport for range types and btree_gist |
5325 |
Moved to different CF |
Performance
|
|
7/7
|
+870−8
|
Bernd Helmle (psoo), Christoph Heiss (christoph.heiss) |
Andrey Borodin (x4m), jian he (hellothere) |
Heikki Linnakangas (heikki) |
3 |
10 months ago |
| Parallel heap vacuum |
5326 |
Moved to different CF |
Performance
|
|
Needs rebase!
|
|
Masahiko Sawada (masahikosawada) |
Hayato Kuroda (ha-kun) |
|
7 |
4 months ago |
| Use read_stream in index vacuum |
5327 |
Moved to different CF |
Performance
|
|
7/7
|
+167−25
|
Andrey Borodin (x4m) |
Melanie Plageman (melanieplageman), Kirill Reshke (reshke), Rahila Syed (rahila), Zhao Junwang (zhjwpku) |
Melanie Plageman (melanieplageman) |
3 |
10 months ago |
| Additional function inlining for slow_deform_heap_tuple |
5347 |
Committed |
Performance
|
|
Not processed
|
|
David Rowley (davidrowley) |
|
David Rowley (davidrowley) |
2 |
1 year ago |
| Shave a few cycles off our ilog10 implementation |
5358 |
Withdrawn |
Performance
|
18 |
Not processed
|
|
David Fetter (dfetter) |
Heikki Linnakangas (heikki), David Rowley (davidrowley) |
|
2 |
1 year ago |
| Showing applied extended statistics in explain Part2 |
5359 |
Moved to different CF |
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 |
| Let an Append to consider a tuple fraction when choosing fractional subpaths |
5361 |
Moved to different CF |
Performance
|
18 |
Needs rebase!
|
|
Andrei Lepikhov (lepikhov), Nikita Malakhov (nmalakh) |
|
Alexander Korotkov (smagen) |
2 |
11 months ago |
| Using Expanded Objects other than Arrays from plpgsql |
5364 |
Moved to different CF |
Performance
|
|
Not processed
|
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
2 |
11 months ago |
| Eagerly scan all-visible pages to amortize aggressive vacuum |
5366 |
Moved to different CF |
Performance
|
|
Not processed
|
|
Melanie Plageman (melanieplageman) |
|
Melanie Plageman (melanieplageman) |
2 |
11 months ago |
| optimize file transfer in pg_upgrade |
5369 |
Moved to different CF |
Performance
|
18 |
7/7
|
+642−80
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
2 |
10 months ago |
| Converting SetOp to read its two inputs separately |
5377 |
Committed |
Performance
|
|
Not processed
|
|
Tom Lane (tgl) |
|
Tom Lane (tgl) |
1 |
1 year 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 |
| avoid calling pgstat_read_current_status() in pg_signal_backend() |
5400 |
Committed |
Performance
|
18 |
Not processed
|
|
Nathan Bossart (bossartn) |
|
Nathan Bossart (bossartn) |
1 |
1 year ago |
| [PERF] Improve Cardinality Estimation for Joins with GROUP BY Having Single Clause |
5422 |
Moved to different CF |
Performance
|
18 |
7/7
|
+0−0
|
Ravi Revathy (revathyraavi) |
|
|
2 |
10 months ago |
| Avoid unnecessary wrapping for more complex expressions |
5434 |
Committed |
Performance
|
|
Not processed
|
|
Richard Guo (richardguo) |
|
Richard Guo (richardguo) |
1 |
1 year ago |
| Eliminating SPI / SQL from some RI trigger functions |
5450 |
Moved to different CF |
Performance
|
19 |
9/10
|
+675−73
|
Amit Langote (amitlan) |
|
|
4 |
2 months ago |
| Some ExecSeqScan optimizations |
5453 |
Committed |
Performance
|
18 |
Not processed
|
|
Amit Langote (amitlan) |
|
Amit Langote (amitlan) |
1 |
1 year ago |
| More reliable nbtree detection of unsatisfiable RowCompare quals involving a leading NULL key/element |
5460 |
Committed |
Performance
|
|
Not processed
|
|
Peter Geoghegan (pgeoghegan) |
|
Peter Geoghegan (pgeoghegan) |
1 |
1 year ago |
| Function scan FDW pushdown |
5470 |
Moved to different CF |
Performance
|
18 |
6/7
|
+1046−105
|
Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) |
Ashutosh Bapat (ashutoshbapat) |
|
2 |
1 year ago |
| Speed up ICU case conversions |
5474 |
Moved to different CF |
Performance
|
|
2/7
|
+86−41
|
Andreas Karlsson (kandreas) |
|
|
2 |
1 month ago |
| handle batch explosion in hash joins |
5482 |
Moved to different CF |
Performance
|
|
2/7
|
+5635−0
|
Tomas Vondra (fuzzycz) |
|
Tomas Vondra (fuzzycz) |
2 |
11 months ago |