[SERVER-72615] Compute cardinality estimates for statistics computed with sampling Created: 08/Jan/23  Updated: 29/Oct/23  Resolved: 24/Jan/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 6.3.0-rc0

Type: Task Priority: Major - P3
Reporter: Misha Tyulenev Assignee: Alya Berciu
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
depends on SERVER-72614 Implement sampling for historgram com... Closed
Assigned Teams:
Query Optimization
Backwards Compatibility: Fully Compatible
Sprint: QO 2023-02-06
Participants:

 Description   

CE should use the sample rate to multiply the final estimate. Let's say if sample rate 0.5. then we should multiply each estimate by 2.

All per-type counters have to be scaled as well, not just the histogram-based estimates.



 Comments   
Comment by Githook User [ 25/Jan/23 ]

Author:

{'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}

Message: SERVER-72615 Fix sample histogram golden test
Branch: master
https://github.com/mongodb/mongo/commit/19d71c2910c2ee4796217c52e03d404451e84668

Comment by Githook User [ 24/Jan/23 ]

Author:

{'name': 'Alya Berciu', 'email': 'alya.berciu@mongodb.com', 'username': 'alyacb'}

Message: SERVER-72615 Compute CE for sampled histograms
Branch: master
https://github.com/mongodb/mongo/commit/1acba68fc3cb501df6e9a23f1f041e1043edc101

Generated at Thu Feb 08 06:22:19 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.