Commitfest 2025-01 (2025-01-01 – 2025-01-31)
This commitfest is closed. Open patches in this commitfest are no longer being picked up by CI. If you want CI to run on your patch, move it to an open commitfest.
No reviewers
My patches
My reviews
Status summary: Needs review: 23. Waiting on Author: 11. Ready for Committer: 2. Committed: 82. Moved to next CF: 211. Returned with Feedback: 7. Rejected: 4. Withdrawn: 18. Total: 358.
Active patches
| Patch | ID | Status | Tags | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|---|
| In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal) | 3461 | Waiting on Author | Performance | Not processed | Kyotaro Horiguchi (horiguti) | Heikki Linnakangas (heikki), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom) | 16 | 1 year ago | |||
| nbtree performance improvements through specialization on key shape | 3672 | Waiting on Author | Performance | Not processed | Matthias van de Meent (mmeent) | 14 | 1 year ago | ||||
| ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables | 3705 | Needs review | Performance | Not processed | Justin Pryzby (justinpryzby) | Bertrand Drouvot (bertranddrouvot.pg) | 13 | 1 year ago | |||
| Cross-database SERIALIZABLE safe snapshots | 4240 | Ready for Committer | Performance | Not processed | Thomas Munro (macdice) | Heikki Linnakangas (heikki) | 9 | 2 years ago | |||
| Extract numeric field in JSONB more effectively | 4476 | Needs review | Performance | Not processed | Andy Fan (andyf) | Chapman Flack (chap) | 8 | 1 year ago | |||
| nbtree: implement dynamic prefix truncation | 4635 | Waiting on Author | Performance | Not processed | Matthias van de Meent (mmeent) | 7 | 1 year ago | ||||
| nbtree: downlink right separator/HIKEY optimization | 4638 | Needs review | Performance | Not processed | Matthias van de Meent (mmeent) | 7 | 2 years ago | ||||
| shared detoast datum | 4759 | Needs review | Performance | Not processed | Andy Fan (andy2) | 6 | 1 year ago | ||||
| Add a attopt to disable MCV when estimating for Var = Const | 4909 | Needs review | Performance | Not processed | Andy Fan (andy2) | 4 | 1 year ago | ||||
| Consider the number of columns in the sort cost model | 5231 | Needs review | Performance | 18 | Not processed | Andrei Lepikhov (lepikhov) | Kirill Reshke (reshke), Alena Rybakina (alenka) | 2 | 1 year ago |
Closed patches
| Patch | ID | Status | Tags | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|---|
| AcquireExecutorLocks() and run-time pruning | 3478 | Moved to different CF | Performance | Needs rebase! | Amit Langote (amitlan) | Tom Lane (tgl) | Amit Langote (amitlan) | 17 | 4 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 | 11 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 | Needs rebase! | Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) | 14 | 12 hours 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 | 10 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 | 11 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 | 11 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 | 1 year 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 | 10 months ago | |
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan | 4971 | Moved to different CF | Performance DDL | 19 |
10/10
|
+2955−485 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Matthias van de Meent (mmeent) | 9 | 3 days 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 | 1 year 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 | 11 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 | 11 months ago | |
| Streaming Vacuum | 5089 | Moved to different CF | Performance | Not processed | Thomas Munro (macdice), Melanie Plageman (melanieplageman) | Melanie Plageman (melanieplageman) | 5 | 4 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 | 8 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 | 7 months ago | |||
| Asynchronous MergeAppend Execution | 5129 | Moved to different CF | Performance |
10/10
|
+1453−731 | Alexander Pyhalov (a.pyhalov) | Etsuro Fujita (efujita), Matheus Alcantara (matheus.alcantara) | 8 | 1 week 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 | 11 months ago | |
| AIO | 5227 | Moved to different CF | Performance |
7/7
|
+5611−79 | Andres Freund (andresfreund) | Noah Misch (nmisch) | Andres Freund (andresfreund) | 4 | 11 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 | 11 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 | 1 year 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 | 11 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 | 8 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 | 4 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 | 11 months ago | |
| Parallel heap vacuum | 5326 | Moved to different CF | Performance | Needs rebase! | Masahiko Sawada (masahikosawada) | Hayato Kuroda (ha-kun) | 7 | 6 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 | 1 year 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 | 7 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 | 1 year ago | ||
| Using Expanded Objects other than Arrays from plpgsql | 5364 | Moved to different CF | Performance | Not processed | Tom Lane (tgl) | Tom Lane (tgl) | 2 | 1 year 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 | 1 year 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 | 1 year 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 | Needs rebase! | Filip Januš (fjanus) | Zsolt Parragi (zsolt.parragi), lakshmi g (lakshmi) | 6 | yesterday | |||
| 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 | 1 year 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 |
10/10
|
+1645−15 | Amit Langote (amitlan) | Haibo Yan (billyean) | 5 | 2 days 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 |
10/10
|
+1348−104 | Alexander Pyhalov (a.pyhalov), Gleb Kashkin (glebka) | Ashutosh Bapat (ashutoshbapat) | 3 | 1 week ago | |
| Speed up ICU case conversions | 5474 | Moved to different CF | Performance |
2/7
|
+86−41 | Andreas Karlsson (kandreas) | 2 | 2 months ago | |||
| handle batch explosion in hash joins | 5482 | Moved to different CF | Performance |
2/7
|
+5635−0 | Tomas Vondra (fuzzycz) | Tomas Vondra (fuzzycz) | 2 | 1 year ago |