UPSTREAM FIX

magento2-40546: Inserts indexer changed entries in batches instead of one bulk insert

Community fix magento2-40546 merged into magento/magento2 on 2026-05-12, not in a release yet; applies cleanly to 7 releases from 2.4.8 to 2.4.9.

Inserts indexer changed entries in batches instead of one bulk insert edited

Pull request title
Potential Indexer Performance issue for large catalogs - Bulk Insert & Locking Entire CL table to identity the latest version
Pull request
magento/magento2#40546
Issues
#40331 human
Author
@senthilengg
Merged
2026-05-12
Fixed in
no release yet
Reported on
—
Categories
—
Components
magento/framework

Labels

Area
Framework
Component
Framework/Mview
Priority
P3
Severity
—
Reported on (labels)
2.4.x

Issue

Title and steps come from the upstream issue and pull request.

The upstream issue and pull request have no structured description.

Code match per tag

Each tag was checked with git apply --check against that tag's files. A clean match means the change applies; it is not a test result. Tags that already contain the fix are marked.

LineCode match per tagTests
2.4.6
2.4.6 file-missing 2.4.6-p1 file-missing 2.4.6-p2 file-missing 2.4.6-p3 file-missing 2.4.6-p4 file-missing 2.4.6-p5 file-missing 2.4.6-p6 file-missing 2.4.6-p7 file-missing 2.4.6-p8 file-missing 2.4.6-p9 file-missing 2.4.6-p10 file-missing 2.4.6-p11 file-missing 2.4.6-p12 file-missing 2.4.6-p13 file-missing 2.4.6-p14 file-missing 2.4.6-p15 file-missing
2.4.6: no test data 2.4.6-p1: no test data 2.4.6-p2: no test data 2.4.6-p3: no test data 2.4.6-p4: no test data 2.4.6-p5: no test data 2.4.6-p6: no test data 2.4.6-p7: no test data 2.4.6-p8: no test data 2.4.6-p9: no test data 2.4.6-p10: no test data 2.4.6-p11: no test data 2.4.6-p12: no test data 2.4.6-p13: no test data 2.4.6-p14: no test data 2.4.6-p15: no test data
2.4.7
2.4.7 conflict 2.4.7-p1 conflict 2.4.7-p2 conflict 2.4.7-p3 conflict 2.4.7-p4 conflict 2.4.7-p5 conflict 2.4.7-p6 conflict 2.4.7-p7 conflict 2.4.7-p8 conflict 2.4.7-p9 conflict 2.4.7-p10 conflict
2.4.7: no test data 2.4.7-p1: no test data 2.4.7-p2: no test data 2.4.7-p3: no test data 2.4.7-p4: no test data 2.4.7-p5: no test data 2.4.7-p6: no test data 2.4.7-p7: no test data 2.4.7-p8: no test data 2.4.7-p9: no test data 2.4.7-p10: no test data
2.4.8
2.4.8 clean 2.4.8-p1 clean 2.4.8-p2 clean 2.4.8-p3 clean 2.4.8-p4 clean 2.4.8-p5 clean
2.4.8: no test data 2.4.8-p1: no test data 2.4.8-p2: no test data 2.4.8-p3: no test data 2.4.8-p4: no test data 2.4.8-p5: no test data
2.4.9
2.4.9 clean
2.4.9: no test data

Triage

Model @cf/cloudflare/clef. Probability this is a bug fix: 88.1%. Probability it is security relevant: 0.5%.

Show the model's answers and probabilities
QuestionAnswerProbabilitiesConfidence
Change kindbugfixbugfix 83.6%, refactor 11.7%, feature 2.8%, tests_only 0.9%, dependency 0.6%, docs_only 0.5%65.7%
Areaframeworkframework 91.2%, catalog 2.9%, admin 1.9%80.9%
Reported versionunspecifiedunspecified 23.8%, 2.4.6 2.4%, 2.4.6-p1 2.3%5.5%
Scope0.77 of 20 42.3%, 1 38.8%, 2 18.9%4.7%
Risk1.54 of 22 68.4%, 1 17.4%, 0 14.1%27.8%
Worth backporting1.19 of 21 44.4%, 2 37.3%, 0 18.4%5.4%

Download

For cweagans/composer-patches, choose a version below and download the bundle. Copy its magento2-40546/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Test files are always removed; paths are relative to each package root, using the default -p1 level.

Packages (1): magento/framework
Bundle README (what the ZIP ships)
# magento2-40546

Community fix merged upstream into magento/magento2, adapted by magento.watch.
This is not a patch published by Adobe.

Pull request: https://github.com/magento/magento2/pull/40546
Issue: https://github.com/magento/magento2/issues/40331
Author: @senthilengg
Source commit: a991384b9e14c8152509ff44d9322055fa49bdf2
Modifications: test files and documentation removed, paths rewritten relative to each Composer package.
Licence: OSL-3.0 / AFL-3.0, as the original Magento Open Source code.
Maintainer: Łukasz Bajsarowicz (@lbajsarowicz)

Licence: Magento Open Source code under OSL-3.0 and AFL-3.0. The bundle carries the original author, source commit and the list of modifications.

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.