Closed
Description
Jira Link: DB-4319
Description
Improvements to a run of ANALYZE (i.e., the sampling and statistics computation)
- [YSQL] Fix skewed/ incorrect table statistics computed by ANALYZE #14332
- [YSQL] Reduce ANALYZE sampling time by using distributed reservoir sampling #15111
- [YSQL] Ensure that ANALYZE sampling is silent (doesn't affect ongoing workload) #15113
- [YSQL] Explore a random sampling algorithm for ANALYZE that doesn't scan full tablets #15114
Discussion doc for ANALYZE is at https://docs.google.com/document/d/1eG0-_QbzKlO0Sp-c30mVdvIWa3FoevGHSIpceZsUnRc/edit#
TODO: This will be moved to a design doc on github once all design elements are finalized.