slow-J commented on PR #16268: URL: https://github.com/apache/lucene/pull/16268#issuecomment-5764005651
@stefanvodita I tested it again, this time ran different ids in separate tests to give them separate JVMs. Setup: 33.3M docs, sorted by lastMod_skipper. Three long fields get faceted: lastMod_skipper (single-valued, has a skip index), lastMod_multi_skipper (multi-valued, has skip index), id (no skip index). 126 tasks across those three fields. Run 1 - all three fields, 126 tasks | Task | baseline QPS | StdDev | patched QPS | StdDev | Pct diff | p-value | |---|---:|---:|---:|---:|---:|---:| | BrowseLastModMultiRangeFacets | 0.41 | 1.9% | 0.37 | 0.8% | −10.1% (−12% – −7%) | 0.000 | | BrowseIDRangeFacets | 0.58 | 1.6% | 0.53 | 1.3% | −9.2% (−11% – −6%) | 0.000 | | BrowseLastModMultiOvlpRangeFacets | 0.24 | 1.3% | 0.22 | 0.8% | −5.5% (−7% – −3%) | 0.000 | | BrowseIDOvlpRangeFacets | 0.28 | 1.3% | 0.27 | 0.9% | −4.8% (−6% – −2%) | 0.000 | | MedTermIDOvlpRangeFacets | 3.04 | 2.4% | 2.98 | 1.2% | −2.0% (−5% – 1%) | 0.000 | | MedTermLastModMultiOvlpRangeFacets | 2.39 | 5.2% | 2.36 | 1.3% | −1.1% (−7% – 5%) | 0.036 | | MedTermIDRangeFacets | 6.35 | 6.6% | 6.34 | 1.8% | −0.2% (−8% – 8%) | 0.821 | | MedTermLastModMultiRangeFacets | 3.56 | 9.1% | 3.57 | 1.6% | 0.2% (−9% – 12%) | 0.825 | | MedTermLastModRangeFacets | 3.62 | 6.2% | 5.11 | 2.5% | 41.3% (30% – 53%) | 0.000 | | BrowseLastModRangeFacets | 0.53 | 1.7% | 0.84 | 2.5% | 57.8% (52% – 63%) | 0.000 | | MedTermLastModOvlpRangeFacets | 4.13 | 2.2% | 7.42 | 2.9% | 79.5% (72% – 86%) | 0.000 | | BrowseLastModOvlpRangeFacets | 0.28 | 1.3% | 0.67 | 3.9% | 138.0% (131% – 145%) | 0.000 | Run 2 - id only, 42 tasks, same index | Task | baseline QPS | StdDev | patched QPS | StdDev | Pct diff | p-value | |---|---:|---:|---:|---:|---:|---:| | MedTermIDRangeFacets | 6.53 | 7.3% | 6.17 | 9.3% | −5.4% (−20% – 12%) | 0.000 | | MedTermIDOvlpRangeFacets | 4.15 | 4.1% | 4.00 | 5.2% | −3.6% (−12% – 5%) | 0.000 | | BrowseIDRangeFacets | 0.69 | 3.1% | 0.68 | 2.8% | −2.1% (−7% – 3%) | 0.000 | | BrowseIDOvlpRangeFacets | 0.30 | 1.4% | 0.30 | 0.9% | −1.1% (−3% – 1%) | 0.000 | Run 3 - multi-valued only, 84 tasks, fresh index | Task | baseline QPS | StdDev | patched QPS | StdDev | Pct diff | p-value | |---|---:|---:|---:|---:|---:|---:| | MedTermLastModMultiOvlpRangeFacets | 1.89 | 2.2% | 1.96 | 2.3% | 3.5% (0% – 8%) | 0.000 | | BrowseLastModMultiOvlpRangeFacets | 0.21 | 2.7% | 0.22 | 2.9% | 3.7% (−1% – 9%) | 0.000 | | MedTermLastModMultiRangeFacets | 3.74 | 3.0% | 3.89 | 3.3% | 3.8% (−2% – 10%) | 0.000 | | BrowseLastModMultiRangeFacets | 0.34 | 4.2% | 0.36 | 4.4% | 5.5% (−2% – 14%) | 0.000 | -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
