cockroachdb / cockroachdb/cockroach
sql: disable forecasts for specific columns
Open
A-sql-table-stats
C-enhancement
O-support
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Stats forecasts are best suited for ever-growing tables and columns that are ever-increasing or decreasing. In other cases, it can cause inaccurate row estimates and lead to bad plans. See https://github.com/cockroachlabs/support/issues/2792. It would be helpful to disable histogram forecasting for columns that are known to not be every-increasing or decreasing, even if they appear to be in previous stats collections.
Jira issue: CRDB-35406
Contributor guide
Assessment
This issue has not been assessed yet.