Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows

Cardinality is a consequence of how many dimensions you index your readings by. Here is where the curve bends, measured, and what you can do about it without leaving Postgres. Someone adds a firmware_ver column to the sensor table. It is…