Provide a best-practice / troubleshooting / Q&A doc for stats and analyze
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
Currently, our stats user documentation does not directly answer many of the most common user questions. During ONCALL, we often receive repetitive questions about stats and analyze. For example, we have had to repeatedly answer similar questions from the user.
Some frequently asked questions include:
• How to know if the cluster’s stats are good enough?
• How to tune ANALYZE config if the cluster’s stats are not healthy?
• How to make ANALYZE faster for large or partitioned tables?
• How to estimate how long an ANALYZE will take for a big table with X rows?
Proposal:
Can we provide a best-practice / troubleshooting / Q&A document for stats, similar to the hint troubleshooting doc?
This would allow us to point users directly to a resource instead of repeatedly answering the same questions.
Contributor guide
Assessment
This issue has not been assessed yet.