Commitfest 2024-07 (2024-07-01 – 2024-07-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: Committed: 118. Moved to next CF: 236. Withdrawn: 23. Returned with Feedback: 11. Rejected: 8. Total: 396.
Closed patches
| Patch | ID | Status | Tags | Ver | CI status | Stats | Author | Reviewers | Committer | Num cfs | Latest mail |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Parallelize correlated subqueries that execute within each worker | 3246 | Moved to different CF | Performance | Not processed | James Coleman (jcole1989) | Akshat Jaimini (akshatj) | 15 | 1 year ago | |||
| In-place persistence change of a relation (fast ALTER TABLE ... SET LOGGED with wal_level=minimal) | 3461 | Moved to different CF | Performance | Not processed | Kyotaro Horiguchi (horiguti) | Heikki Linnakangas (heikki), Justin Pryzby (justinpryzby), Jakub Wartak (jakub.wartak.tomtom) | 16 | 1 year ago | |||
| 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 | ||
| Speed up releasing of locks | 3501 | Withdrawn | Performance | Not processed | Andres Freund (andresfreund), David Rowley (davidrowley) | Heikki Linnakangas (heikki) | 13 | 2 years ago | |||
| nbtree performance improvements through specialization on key shape | 3672 | Moved to different CF | Performance | Not processed | Matthias van de Meent (mmeent) | 14 | 1 year ago | ||||
| Add sortsupport for range types and btree_gist | 3686 | Moved to different CF | Performance | Not processed | Christoph Heiss (christoph.heiss) | Tomas Vondra (fuzzycz), Bernd Helmle (psoo) | 12 | 10 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 | |
| ALTER TABLE and CLUSTER fail to use a BulkInsertState for toast tables | 3705 | Moved to different CF | Performance | Not processed | Justin Pryzby (justinpryzby) | Bertrand Drouvot (bertranddrouvot.pg) | 13 | 1 year ago | |||
| Check lateral references within PHVs for memoize cache keys | 4067 | Committed | Performance | Not processed | Richard Guo (richardguo) | Paul Jungwirth (pjungwir) | Richard Guo (richardguo) | 8 | 1 year ago | ||
| Evaluate arguments of correlated SubPlans in the referencing ExprState | 4209 | Committed | Performance | Not processed | Andres Freund (andresfreund) | Tom Lane (tgl), Alena Rybakina (alenka) | Andres Freund (andresfreund) | 7 | 1 year ago | ||
| Cross-database SERIALIZABLE safe snapshots | 4240 | Moved to different CF | Performance | Not processed | Thomas Munro (macdice) | Heikki Linnakangas (heikki) | 9 | 2 years ago | |||
| Support Right Semi Join | 4284 | Committed | Performance | Not processed | Richard Guo (richardguo) | wenhui qiu (wenhuiqiu), Wen Yi (wenyi) | Richard Guo (richardguo) | 6 | 1 year ago | ||
| Avoid unnecessary PlaceHolderVars for simple Vars | 4319 | Moved to different CF | Performance | Not processed | Richard Guo (richardguo) | James Coleman (jcole1989) | Richard Guo (richardguo) | 9 | 1 year ago | ||
| XLog size reductions: smaller XLogRecordBlockHeader | 4324 | Moved to different CF | Performance | Not processed | Matthias van de Meent (mmeent) | Wen Yi (wenyi) | 7 | 2 years ago | |||
| pg_upgrade, pg_combinebackup --copy-file-range | 4338 | Committed | Performance | Not processed | Tomas Vondra (fuzzycz), Thomas Munro (macdice), Jakub Wartak (jakub.wartak.tomtom) | Tomas Vondra (fuzzycz), Jakub Wartak (jakub.wartak.tomtom) | Tomas Vondra (fuzzycz) | 4 | 1 year ago | ||
| Index Prefetching | 4351 | Moved to different CF | Performance |
9/10
|
+4482−2214 | Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) | Alexandre Felipe (afelipe) | 14 | 3 hours ago | ||
| Index-only filters without IOS | 4352 | Withdrawn | Performance | Not processed | Tomas Vondra (fuzzycz) | Jeff Davis (jdavis), James Coleman (jcole1989) | 6 | 2 years ago | |||
| Opportunistically pruning page before insert | 4384 | Moved to different CF | Performance | Not processed | James Coleman (jcole1989) | Melanie Plageman (melanieplageman) | 7 | 1 year ago | |||
| XLog size reductions: Reduced XLog record header size | 4386 | Returned with feedback | Performance | Not processed | Matthias van de Meent (mmeent) | 6 | 1 year ago | ||||
| Use ReadRecentBuffer() for btree root page | 4419 | Moved to different CF | Performance | Not processed | Thomas Munro (macdice) | 7 | 2 years ago | ||||
| Replace a large number of OR clauses with ANY expression | 4450 | Moved to different CF | Performance | 17 | Not processed | Andrei Lepikhov (lepikhov), Alena Rybakina (alenka) | Nikolay Shaplov (nataraj), Ranier Vilela (raniervilela) | Alexander Korotkov (smagen) | 7 | 1 year ago | |
| Extract numeric field in JSONB more effectively | 4476 | Moved to different CF | Performance | Not processed | Andy Fan (andyf) | Chapman Flack (chap) | 8 | 1 year 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 | |
| Should consider materializing the cheapest inner path in consider_parallel_nestloop() | 4549 | Committed | Performance | Not processed | Tender Wang (tndrwang) | Robert Haas (rhaas), Richard Guo (richardguo), Yuki Fujii (fujiiyuki) | Richard Guo (richardguo) | 4 | 1 year ago | ||
| Reuse child_relids in try_partitionwise_join | 4553 | Committed | Performance | Not processed | Ashutosh Bapat (ashutoshbapat) | Richard Guo (richardguo) | Richard Guo (richardguo) | 4 | 1 year 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 | |||
| Index Insert Prefetching | 4622 | Withdrawn | Performance | Not processed | Tomas Vondra (fuzzycz) | 4 | 2 years 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 | 11 months ago | |
| nbtree: implement dynamic prefix truncation | 4635 | Moved to different CF | Performance | Not processed | Matthias van de Meent (mmeent) | 7 | 1 year ago | ||||
| nbtree: downlink right separator/HIKEY optimization | 4638 | Moved to different CF | Performance | Not processed | Matthias van de Meent (mmeent) | 7 | 1 year ago | ||||
| autovectorize page checksum code included elsewhere | 4649 | Withdrawn | Performance | 18 | Not processed | Nathan Bossart (bossartn) | 3 | 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 | ||
| 64-bit XIDs | 4703 | Moved to different CF | Performance | 18 | Not processed | Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Aleksander Alekseev (a.alekseev), Konstantin Knizhnik (knizhnik), Nikita Glukhov (n.glukhov), Yura Sokolov (funny_falcon), Maxim Orlov (m.orlov), Pavel Borisov (pborisov) | Chris Travers (einhverfr), wenhui qiu (wenhuiqiu) | 4 | 1 year ago | ||
| Adjust tuples estimate for appendrel | 4711 | Moved to different CF | Performance | Not processed | Richard Guo (richardguo) | 4 | 2 years ago | ||||
| shared detoast datum | 4759 | Moved to different CF | Performance | Not processed | Andy Fan (andy2) | 6 | 1 year ago | ||||
| Reordering DISTINCT keys to match input path's pathkeys | 4787 | Moved to different CF | Performance | Not processed | Richard Guo (richardguo) | Richard Guo (richardguo) | 4 | 1 year ago | |||
| Optimize planner memory consumption for huge arrays | 4825 | Moved to different CF | Performance | 17 | Not processed | Andrei Lepikhov (lepikhov) | Alena Rybakina (a.rybakina) | 3 | 1 year ago | ||
| JIT compilation per plan node | 4837 | Moved to different CF | Performance | Not processed | David Rowley (davidrowley), Melih Mutlu (melihmutlu) | 3 | 1 year ago | ||||
| The Prepare statement with the skewed parameter uses the custom plan | 4839 | Moved to different CF | Performance | Not processed | Zongliang Quan (quanzl) | 3 | 1 year ago | ||||
| Partial aggregates push down | 4857 | Moved to different CF | Performance | Not processed | Yuki Fujii (fujiiyuki) | 3 | 1 year ago | ||||
| type cache cleanup improvements | 4865 | Moved to different CF | Performance | 18 | Not processed | Fedor Sigaev (sigaev) | Roman Zharkov (r.zharkov) | Alexander Korotkov (smagen) | 3 | 1 year ago | |
| Pass sk_attno to GIST consistent function | 4902 | Moved to different CF | Performance | Not processed | Michal Kleczek (mkleczek) | 2 | 1 year ago | ||||
| Add a attopt to disable MCV when estimating for Var = Const | 4909 | Moved to different CF | Performance | Not processed | Andy Fan (andy2) | 4 | 1 year ago | ||||
| further improving roles_is_member_of() | 4925 | Withdrawn | Performance | 18 | Not processed | Nathan Bossart (bossartn) | 1 | 1 year ago | |||
| SupportRequestRows support function for generate_series_timestamptz | 4926 | Committed | Performance | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 1 | 1 year ago | |||
| Optimize numeric.c mul_var() using the Karatsuba algorithm | 4930 | Moved to different CF | Performance | Not processed | Joel Jacobson (joeljacobson) | Dean Rasheed (deanr) | 2 | 1 year ago | |||
| improve performance of pg_dump --binary-upgrade | 4936 | Committed | Performance | 18 | Not processed | Nathan Bossart (bossartn) | Daniel Gustafsson (d_gustafsson) | Nathan Bossart (bossartn) | 1 | 1 year ago | |
| Use read streams in CREATE DATABASE command when the strategy is wal_log | 4947 | Committed | Performance | Not processed | Nazir Bilal Yavuz (nbyavuz) | Noah Misch (nmisch) | Noah Misch (nmisch) | 1 | 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 | |
| improve performance of pg_dump with many sequences | 4967 | Committed | Performance | 18 | Not processed | Nathan Bossart (bossartn) | Euler Taveira (eulerto), Yogesh Sharma (sharmay) | Nathan Bossart (bossartn) | 1 | 1 month ago | |
| Use generation memory context for tuplestore.c | 4968 | Committed | Performance | Not processed | David Rowley (davidrowley) | Matthias van de Meent (mmeent) | David Rowley (davidrowley) | 1 | 1 year ago | ||
| add --no-sync to pg_upgrade's calls to pg_dump and pg_dumpall | 4969 | Committed | Performance | 18 | Not processed | Nathan Bossart (bossartn) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| [CREATE|RE] INDEX CONCURRENTLY with single heap scan | 4971 | Moved to different CF | Performance | 19 | Needs rebase! | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Matthias van de Meent (mmeent) | 9 | 1 month ago | ||
| Speed up Hash Join by teaching ExprState about hashing | 4985 | Moved to different CF | Performance | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 2 | 1 year ago | |||
| Performance improvement for pg_dump in binary upgrade mode | 4993 | Moved to different CF | Performance | Not processed | Daniel Gustafsson (d_gustafsson) | Nathan Bossart (bossartn) | Daniel Gustafsson (d_gustafsson) | 2 | 1 year ago | ||
| optimizing pg_upgrade's once-in-each-database steps | 4995 | Moved to different CF | Performance | 18 | Not processed | Nathan Bossart (bossartn) | Ilya Gladyshev (qoops) | Nathan Bossart (bossartn) | 2 | 1 year ago | |
| Speed up JSON escape processing with SIMD plus other optimisations | 5002 | Moved to different CF | Performance | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 2 | 1 year ago | |||
| An implementation of multi-key quick sort | 5013 | Moved to different CF | Performance | 18 | Not processed | hongxu ma (interma), Yao Wang (yaowangm) | Heikki Linnakangas (heikki), Tomas Vondra (fuzzycz) | 2 | 1 year ago | ||
| use CREATE DATABASE STRATEGY = FILE_COPY in pg_upgrade | 5016 | Committed | Performance | 18 | Not processed | Nathan Bossart (bossartn), Matthias van de Meent (mmeent) | Nathan Bossart (bossartn) | 1 | 1 year ago | ||
| Parallel CREATE INDEX for GiST indexes | 5026 | Moved to different CF | 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 | ||
| empty | 5037 | Rejected | Performance | Not processed | 1 | ||||||
| Speed up collation cache | 5038 | Committed | Performance | 18 | Not processed | Jeff Davis (jdavis) | Andreas Karlsson (kandreas) | Jeff Davis (jdavis) | 1 | 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 | 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 | |
| Inline non-SQL SRFs | 5083 | Moved to different CF | Performance | 19 |
10/10
|
+755−115 | Paul Jungwirth (pjungwir) | Tom Lane (tgl) | Tom Lane (tgl) | 5 | 2 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 | |||
| Optimize numeric multiplication for one and two base-NBASE digit multiplicands. | 5094 | Moved to different CF | Performance | Not processed | Joel Jacobson (joeljacobson) | Dean Rasheed (deanr) | Dean Rasheed (deanr) | 2 | 1 year ago | ||
| Make tuple deformation faster | 5097 | Moved to different CF | Performance | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 4 | 1 year ago |