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時間間隔、實時聚合。 來源：timescale/pg-aiguide。

查看原文