Timescale db - multiple hyper tables on single Postgres Table

Question

Can anyone help me with creating multiple timescale hyper tables on single Postgres table. I have a table with one value and 3 timestamp columns. I would like to create hyper table with every timestamp column.

Answer 1

A hypertable is its own store of data, it's not a "view" on another PG table. So you can't make multiple hypertables "on" the same table.

If you are instead looking to move over to this hypertable format and just looking for a migration strategy, then it's easy. Execute

INSERT INTO hypertable_1 SELECT timestamp_1, value FROM old_table;

INSERT INTO hypertable_2 SELECT timestamp_2, value FROM old_table;

INSERT INTO hypertable_3 SELECT timestamp_3, value FROM old_table;

https://docs.timescale.com/latest/getting-started/migrating-data

That said, whether this data model is a good one is a different question, and would have to understand more of your use case.

You can join the Timescale community for more help at slack.timescale.com