timescale / doctor

Rule-based recommendations about your timeseries database.
Apache License 2.0
4 stars 3 forks source link

Add rule to detect bad segmentby column #10

Closed mkindahl closed 1 year ago

mkindahl commented 1 year ago

If the statistics say that the number of distinct values is less than zero for a column that is used as a segment-by column, it grows linearly with the number of rows in the table, which means that it is probably not a good choice for a segment-by column.


If the statistics say that the number of distinct values in a segment-by column is 1, it is pointless to use as a segment-by column.