setup-timescaledb-hypertables

SKILL.md

Instructions for insert-heavy data patterns where data is inserted but rarely changed:

Must be time-based (TIMESTAMP/TIMESTAMPTZ/DATE) or integer (INT/BIGINT) with good temporal/sequential distribution.

Less ideal: ingestedat (when data entered system - use only if it's your primary query dimension) Avoid: updatedat (breaks time ordering unless it's primary query dimension)

有关设计表模式以及使用超表、索引、压缩、保留策略和连续聚合设置 TimescaleDB 的分步说明。选择说明：分区列、segment_by列、order_by列、chunk时间间隔、实时聚合。 来源：microck/ordinary-claude-skills。

查看原文