The problem is that when I want to convert a simple Postgresql table to timescaledb table or hypertable using created_at table field for indexing then it will show this error. The table name is ord...

how can we change the chunk time interval, when it is way too large? use case: we have an existing hypertable, where we have set the chunk_time_interval to 1 month (when using create_hypertable(...

Just recently started using TimescaleDB with Postgres to handle most requests for data. However I'm running into an issue where I have a horribly inefficient request for time series of data. It's a...

I set up a fully functional logical replication of multiple masters to one slave. As soon as I convert any of the replicated tables to timescaleDB's hypertable, the replication stops working - on...

I am testing an PostgreSQL extension named Timescaledb for time series data. If I read the document of PostgreSQL right, the query for example WHERE x = 'somestring' and timestamp between 't1' an...

I was trying to hook up the sqlalchemy with my underlying postgresql, which uses the timescaledb extension. All queries work fine when I try them from the psql terminal client. But when I try...

As specified in the official docs I added the Timescale PPA repository to apt. I then installed it via sudo apt install timescaledb-postgresql-9.6. All was working fine. With a recent run of sudo ...

I am using the below query with timescaledb to get the 10 minute candles from a ticks database. SELECT time_bucket('10minute', time) AS min, first(ticks, time) AS open, last(ticks, time) AS clos...

I'm new to database. Recently I start using timescaledb, which is an extension in PostgreSQL, so I guess this is also PostgreSQL related. I observed a strange behavior. I calculated my table struc...