Status summary: Committed: 78. Moved to next CF: 237. Withdrawn: 11. Rejected: 2. Returned with Feedback: 8. Total: 336.
| 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 | 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 | ||
| 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 | ||||
| Reducing planning time when tables have many partitions | 3701 | Moved to different CF | Performance |
|
+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 | 9 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 | |||
| Cross-database SERIALIZABLE safe snapshots | 4240 | Moved to different CF | Performance | Not processed | Thomas Munro (macdice) | Heikki Linnakangas (heikki) | 9 | 2 years 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 | ||
| Index Prefetching | 4351 | Moved to different CF | Performance |
|
+4300−2204 | Peter Geoghegan (pgeoghegan), Tomas Vondra (fuzzycz) | 14 | 5 days ago | |||
| Replace a large number of OR clauses with ANY expression | 4450 | Committed | 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 |
|
+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 |
|
+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 |
|
+194−39 | Andres Freund (andresfreund), Daniel Gustafsson (d_gustafsson) | Andreas Karlsson (kandreas) | Daniel Gustafsson (d_gustafsson) | 8 | 10 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 | ||||
| Teach predtest about IS [NOT] <boolean> proofs | 4690 | Moved to different CF | Performance |
|
+1882−129 | James Coleman (jcole1989) | Tom Lane (tgl) | 8 | 1 year 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 | Committed | Performance | Not processed | Richard Guo (richardguo) | Richard Guo (richardguo) | 4 | 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 | ||||
| Parallel CREATE INDEX for GIN indexes | 4966 | Moved to different CF | Performance |
|
+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 |
|
+2867−479 | Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu) | Matthias van de Meent (mmeent) | 9 | 2 weeks 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 |
|
+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 |
|
+53−28 | Andrei Lepikhov (lepikhov) | Dean Rasheed (deanr) | Alexander Korotkov (smagen) | 5 | 9 months ago | |
| nbtree skip scan | 5081 | Moved to different CF | Performance |
|
+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 | Moved to different CF | 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 | 11 months 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 | 5 months ago | |||
| Asynchronous MergeAppend Execution | 5129 | Moved to different CF | Performance |
|
+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 |
|
+178−76 | Nazir Bilal Yavuz (nbyavuz) | Daniel Gustafsson (d_gustafsson) | Melanie Plageman (melanieplageman) | 4 | 10 months ago | |
| prefetching for nestloop / indexscan | 5208 | Withdrawn | Performance | Not processed | Tomas Vondra (fuzzycz) | 2 | 1 year ago | ||||
| Avoiding superfluous buffer locking during nbtree backwards scans | 5222 | Committed | Performance | Not processed | Matthias van de Meent (mmeent) | Peter Geoghegan (pgeoghegan) | 2 | 1 year ago | |||
| AIO | 5227 | Moved to different CF | Performance |
|
+5611−79 | Andres Freund (andresfreund) | Noah Misch (nmisch) | Andres Freund (andresfreund) | 4 | 9 months ago | |
| Add ExprState hashing for GROUP BY and hashed SubPlans | 5229 | Moved to different CF | Performance | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 3 | 1 year ago | |||
| Consider the number of columns in the sort cost model | 5231 | Moved to different CF | Performance | 18 | Not processed | Andrei Lepikhov (lepikhov) | Kirill Reshke (reshke), Alena Rybakina (alenka) | 2 | 1 year ago | ||
| Use syscache to do lookups in pg_extension | 5241 | Committed | Performance | 18 | Not processed | Andrei Lepikhov (lepikhov) | Jelte Fennema-Nio (jeltef) | Michael Paquier (michael-kun) | 1 | 1 year ago | |
| Allow SQL functions use CachedPlan machinery | 5246 | Moved to different CF | Performance | 18 |
|
+2109−972 | Alexander Pyhalov (a.pyhalov) | Tom Lane (tgl), Pavel Stehule (okbobcz) | Tom Lane (tgl) | 3 | 10 months ago |
| Allow pushdown of HAVING clauses with grouping sets | 5248 | Committed | Performance | 18 | Not processed | Richard Guo (richardguo) | Richard Guo (richardguo) | 1 | 1 year ago | ||
| Consider explicit incremental sort for mergejoins | 5265 | Committed | Performance | 18 | Not processed | Richard Guo (richardguo) | Richard Guo (richardguo) | 1 | 1 year ago | ||
| Improve statistics estimation considering GROUP-BY as a 'uniqueiser' | 5269 | Moved to different CF | Performance | 18 |
|
+37−0 | Andrei Lepikhov (lepikhov) | Alexander Korotkov (smagen) | 3 | 11 months ago | |
| micro-optimize nbtcompare.c routines | 5273 | Withdrawn | Performance | 18 | Not processed | Nathan Bossart (bossartn) | 1 | 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 | 10 months ago | |
| Limiting overshoot in nbtree SAOP parallel index scans | 5299 | Moved to different CF | Performance |
|
+151−23 | Matthias van de Meent (mmeent) | 4 | 6 months ago | |||
| type cache cleanup improvements | 5317 | Committed | Performance | 18 | Not processed | Fedor Sigaev (sigaev), Alexander Korotkov (smagen), Andrei Lepikhov (lepikhov) | Alexander Korotkov (smagen) | 1 | 1 year ago | ||
| Trigger more frequent autovacuums for insert-heavy tables | 5320 | Moved to different CF | Performance |
|
+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 | Moved to different CF | 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 |
|
+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 |
|
+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 | Moved to different CF | Performance | Not processed | David Rowley (davidrowley) | David Rowley (davidrowley) | 2 | 1 year ago | |||
| Shave a few cycles off our ilog10 implementation | 5358 | Moved to different CF | 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 | 5 months ago |