TimescaleDB 快速上手

快速使用TimescaleDB的基本功能

<https://docs.timescale.com/getting-started/latest/create-hypertable/#hypertables-and-chunks>

1. CREATE TABLE stocks_real_time
2. (
3. time       TIMESTAMPTZ      NOT NULL,
4. symbol     TEXT             NOT NULL,
5. price      DOUBLE PRECISION NULL,
6. day_volume INT              NULL
7. );

9. SELECT create_hypertable('stocks_real_time', 'time');
10. CREATE INDEX ix_symbol_time ON stocks_real_time (symbol, time DESC);

1. TABLE timescaledb_information.hypertables;
2. TABLE timescaledb_information.chunks;

1. SELECT add_retention_policy('conditions', INTERVAL '24 hours');
2. SELECT remove_retention_policy('conditions');

4. SELECT j.hypertable_name,
5. j.job_id,
6. config,
7. schedule_interval,
8. job_status,
9. last_run_status,
10. last_run_started_at,
11. js.next_start,
12. total_runs,
13. total_successes,
14. total_failures
15. FROM timescaledb_information.jobs j
16. JOIN timescaledb_information.job_stats js
17. ON j.job_id = js.job_id
18. WHERE j.proc_name = 'policy_retention';

最后修改 2022-07-12: add new article pg-is-best (fae5568)