setup-timescaledb-hypertables

1# TimescaleDB Complete Setup
2 
3Instructions for insert-heavy data patterns where data is inserted but rarely changed:
4 
5- **Time-series data** (sensors, metrics, system monitoring)
6- **Event logs** (user events, audit trails, application logs)
7- **Transaction records** (orders, payments, financial transactions)
8- **Sequential data** (records with auto-incrementing IDs and timestamps)
9- **Append-only datasets** (immutable records, historical data)
10 
11## Step 1: Create Hypertable
12 
13```sql
14CREATE TABLE your_table_name (
15    timestamp TIMESTAMPTZ NOT NULL,
16    entity_id TEXT NOT NULL,          -- device_id, user_id, symbol, etc.
17    category TEXT,                    -- sensor_type, event_type, asset_class, etc.
18    value_1 DOUBLE PRECISION,         -- price, temperature, latency, etc.
19    value_2 DOUBLE PRECISION,         -- volume, humidity, throughput, etc.
20    value_3 INTEGER,                  -- count, status, level, etc.
21    metadata JSONB                    -- flexible additional data
22) WITH (
23    tsdb.hypertable,
24    tsdb.partition_column='timestamp',
25    tsdb.enable_columnstore=true,     -- Disable if table has vector columns
26    tsdb.segmentby='entity_id',       -- See selection guide below
27    tsdb.orderby='timestamp DESC',     -- See selection guide below
28    tsdb.sparse_index='minmax(value_1),minmax(value_2),minmax(value_3)' -- see selection guide below
29);
30```
31 
32### Compression Decision
33 
34- **Enable by default** for insert-heavy patterns
35…