cockroachdb / cockroachdb/cockroach
sql: do not collect stats so frequently for small tables with lots of updates
Open
A-sql-table-stats
C-bug
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
If a small table gets `UPDATE`d frequently, auto-stats collection can occur very frequently. In one real-world case, we've seen an auto-stats jobs started every 1-2 minutes for a table. This is a lot of extra work and puts unnecessary pressure on the jobs system. How can we make stats collection less frequent on these types of tables?
Jira issue: CRDB-30108
Contributor guide
Assessment
This issue has not been assessed yet.