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.
Timescale db - multiple hyper tables on single Postgres Table
619 views Asked by Chandra Challagonda At
1
There are 1 answers
Related Questions in POSTGRESQL
- Only the first SQL script gets executed inside Docker Postgres container
- Compare fields in two tables
- Hibernate ClobJdbcType bindings: what are the diferences?
- Postgres && statement Error in Mybatis Mapper?
- Can this query be optimized? (Choosing a random row to insert, that excludes previously inserted Rows)
- Connection terminated unexpectedly while performing multi row insert using pg-promise
- Processing multiple forms in nodejs and postgresql
- How to copy data from SQLite to postgreSQL?
- PGAdmin4 configured behind a reverse proxy but unable to connect to Postgresql server
- Updates to pgsodium encrypted values don't use specified key_id
- Connecting to Postgres running in a Docker container using psql
- Can't connect to local postgresql server from my docker container
- Django Arrayfield migration to cloud sql (Postgresql) not creating the column
- Get list of matching keywords for each post
- docker-compose can't reset postgresql database
Related Questions in TIMESCALEDB
- Safely using TRUNCATE with active AFTER INSERT triggers in PostgreSQL?
- TimescaleDB add_job not working when triggered from a function
- Optimizing hierarchical continuous aggregates
- Best way to structure timescale table to get most recent value for multiple keys
- ERROR: continuous aggregate view must include a valid time bucket function
- Should I fill gaps on insert or on select in timescaledb for a timeseries
- cant load extension of timescaledb in postgres in selfhost
- TimescaleDB scheduled retention policy
- Does TimescaleDB work with historical data?
- Entity Id of TimescaleDB + JPA
- PostgreSQL query slow when where clause is not on an ID
- Missing rows in a continuous aggregate timescaledb table
- How and when to create non-unique tsdb hypertable two item indexes?
- Getting false positive trigger signal from libpqxx await_notification()
- PostgreSQL / TimescaleDB percentile in partial mode
Related Questions in HYPERTABLE
- enable compression in TimeScaleDB hypertable - invalid column name
- Unable to create distributed hypertable on Multi-node TimescaleDB setup
- How to increase performance of TimescaleDB?
- Postgres grouping by range
- Posgresql crosstab alternative
- TimescaleDB time_bucket() function giving unexpected results for arbitrary time interval
- TimeScaleDB continuous aggregate refresh policy end offset is not working as expected
- How do I use AVG() with GROUP BY in time_bucket_gapfill() in TimeScaleDB, PostgreSQL?
- Is it possible to select one column based on another column without using subquery in SQL?
- How to reference hypertables properly using foreign key constraints in PostgreSQL?
- How do I create a hypertable with TimescaleDB from a table with joint Primary Key?
- Timescale DB not creating hypertable
- Improve query performance by running ANALYZE?
- Timescale db - multiple hyper tables on single Postgres Table
- PostgreSQL - Delete duplicated records - ERROR: too many range table entries
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
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