Questions tagged [timescaledb]

TimescaleDB is an open source time-series database built on PostgreSQL. Use this tag for questions related to TimescaleDB. Also tag with the more general "time-series-databases".

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

How to handle varying insert rates?

Use case We have a monitoring app that will upload data to the server and we store it in a hypertable. But the upload rate may vary, e.g. first the customer may upload data every 10 minutes for 1 ...
0
votes
0answers
53 views

How to use timescale-bitnami image on Windows?

Since there are issues with collations in the default alpine-based timescaledb images, I tried to use the bitnami-image. But I get an error on startup. docker run ^ -p 5432:5432 ^ -v tsdb-bitnami:/...
0
votes
1answer
96 views

Best way to async data inserts into timescaledb

Having 3 files with one data set of daily data inside: 2019-09-11.txt 2019-09-12.txt 2019-09-13.txt Having lines like: 2019-09-11 15:59:37.459802,1 2019-09-11 15:59:38.959802,1 [...] The files are ...
0
votes
1answer
94 views

Reordering a postgresql timescaledb hypertable

Is the standard postgresql way also possible on a timescaledb hypertable? CLUSTER [VERBOSE] tablename [ USING indexname ] Example: Creating table & hypertyble CREATE TABLE IF NOT EXISTS l1( ...
0
votes
2answers
80 views

How to move old data to cheap hard drive

I have a quite big PostgreSQL database (with timescale plugin). Right now it is consuming about 500Gb on a SSD. Most of the data is in the form of time series. In most cases data older than a few ...
1
vote
0answers
57 views

Group by equidistant integer intervals

I am using TimescaleDB (an extension to PostgreSQL) to store altitude data from a GPS sensor. The table looks like: CREATE TABLE IF NOT EXISTS altitude ( time TIMESTAMPTZ NOT ...
0
votes
0answers
301 views

TimescaleDB performance

I am trying to optimize some queries on a huge table but I can't manage to make then faster. I was wondering is it possible to make timescaleDB run any faster? Test results: tracker=> select count(*)...
7
votes
1answer
178 views

Which data model/schema to apply to a timeseries datastore for data sources with varying fields

I'm asked to develop a data-storage for time-series data, yet despite significant research I'm unsure about the data model and storage technology to chose. About the data The source data which is ...
0
votes
0answers
69 views

How to partition a table without time data?

I am using postgresql to store information about event ticket sales. I have two tables: event_sale and event_sale_seat: event_sale (id integer, created_at timestamp with time zone) event_sale_seat (...
5
votes
1answer
844 views

Can I use hypertables in timescaledb merely to get better insert rates?

I have a PostgreSQL db that I have a large bulk load running into. I wish this load to be as fast as possible. I'm already using the copy command etc. I have been reading about timescaledb and how ...
1
vote
1answer
88 views

Speeding up group by and max query

In my iot use case, I have a table which stores sensor readings. I am using the timescaledb extension. I have the following table definition: CREATE TABLE readings ( id BIGSERIAL ...
1
vote
0answers
34 views

How to aggregate transactions to form a stateful view which can be updated efficiently?

How to aggregate transactions to form a stateful view which can be updated efficiently? For example how to turn the following transactions: CREATE TABLE txns_combined(from_party,to_party,price,qty,...