timescaledb Questions
2
Solved
I just started using timescaleDB with postgresql. I have a database named storage_db which contains a table named day_ahead_prices.
After installing timescaledb, I was following Migrate from the s...
Weaken asked 14/4, 2020 at 9:59
2
Solved
I'm currently using this timescaleDB integrated with postgresql13, I found this patch called incremental view maintenance which i think is also very important for my project
https://github.com/srao...
Sanderson asked 12/9, 2021 at 17:42
2
Solved
command used to take backup
C:\Program Files\PostgreSQL\12\bin>pg_dump -h localhost -U postgres -p 5432 -Fc -f "D:\Database Backup\temp_10.bak" GESEMS_Performace_Test.
Error :
pg_dum...
Admeasurement asked 22/10, 2020 at 8:43
2
Solved
According to the docs:
TimescaleDB supports having different extension versions on different databases within the same PostgreSQL instance.
I can get the installed version of the instance with th...
Maurer asked 19/8, 2019 at 9:54
2
Solved
I try to add the plpython3 extension to my timescaledb/postgres (based on linux alpine) image:
FROM timescale/timescaledb:0.9.0-pg10
RUN set -ex \
&& apk add --no-cache --virtual .plpyth...
Correa asked 20/3, 2018 at 8:26
2
Solved
A naive question on RDS: TimescaleDB acts as a postgres extension. As an AWS user, can I install TimescaleDB as a postgres extension on AWS RDS for postgres?
Cockoftherock asked 26/5, 2021 at 20:35
5
Solved
I have just started to use TimescaleDB and want to create a hypertable on a table with events.
Originally I thought of following the conventional pattern of:
CREATE TABLE event (
id serial PRIMARY...
Boykins asked 3/2, 2021 at 17:4
5
Solved
I want to create TimescaleDB tables in Postgres on the fly as I'm dealing with data sources that change (financial feeds, so could be 100, could be 1000) over time and I want one table per data sou...
Krugersdorp asked 4/3, 2018 at 23:45
3
Solved
I have timeseries data in a table using Timescaledb.
Data is as follows:
time locationid parameterid unitid value
2022-04-18T10:00:00.000Z "1" "1" "2" 2.2
2022-04-18T...
Crayon asked 22/4, 2022 at 21:15
4
Solved
I have the following table:
id | number_of _trip | start_date | end_date | seconds
1 637hui 2022-03-10 01:20:00 2022-03-10 01:32:00 720
2 384nfj 2022-03-10 02:18:00 2022-03-10 02:42:00 1440
3 102f...
Fade asked 16/3, 2022 at 4:59
2
Solved
quite new to timescaledb and I'm struggling with a migration script. I'm trying to create migrations for a flask application with SQLAlchemy.
Let's say I created a table (as in timescaledb docs) l...
Pedaias asked 12/9, 2019 at 15:30
2
Solved
I have a Timescale database that someone else created.
How do I determine if create_hypertable was called on a table ?
For now I use this, but there must be a better way:
SELECT * FROM hyperta...
Massorete asked 16/10, 2019 at 11:43
4
I have a postgres database with the timescaledb extension.
My primary index is a timestamp, and I would like to select the latest row.
If I happen to know the latest row happened after a certain ...
Beak asked 28/7, 2018 at 20:25
0
As I see in pg_stat_activiry, only one of COPY command executes at once. Other queries are in Lock state as I see in wait_event_type column.
How can I run several COPY mytable FROM STDIN in parall...
Thence asked 6/11, 2021 at 21:45
2
I've been saving some tick data in TimescaleDB and have been surprised at how much space it's been taking up. I'm pretty new to this but I'm saving roughly 10 million rows a day into a table that h...
Turbojet asked 4/6, 2020 at 4:57
1
Solved
I am experiencing real time aggregation not to be up to date in real time. Is there something I am missing?
A reproducible example on version 2.4.2 using the current docker image timescale/timescal...
Cupel asked 1/10, 2021 at 10:38
2
Solved
I've seen few places which give definition of time-series cardinality similar to:
Assume you have 1000 IoT devices in 20 locations, they're running one
of 5 firmware versions, and report input fro...
Psychobiology asked 25/6, 2021 at 16:9
1
Solved
I have a hyper table for exchange candle data set up using TimescaleDB.
TimescaleDB official image timescale/timescaledb:latest-pg12 set up and running with Docker with the exact version string st...
Veradia asked 12/6, 2021 at 21:20
1
Solved
I'm trying to display hypertable information but can't seem to access the information table.
This request succeeds
select * from _timescaledb_catalog.hypertable;
But this one doesn't, says the tab...
Coxalgia asked 14/4, 2021 at 9:31
2
Our current project relies heavily on SQL Alchemy for table creation/data insertion. We would like to switch to timescaledb's hypertables, but it seems the recommended way to create hypertables is ...
Unfathomable asked 14/6, 2018 at 17:3
1
Solved
I am trying to take a backup of a TimescaleDB database, excluding two very big hypertables.
That means that while the backup is running, I would not expect to see any COPY command of the underlying...
Oath asked 24/11, 2020 at 20:58
1
Solved
In my database (Postgresql 12; timescaleDB 1.7.0) there are multiple metrics tables containing one row per minute and device. It contains a deviceId, the time, four doubles and an enum value.
There...
Extraordinary asked 1/9, 2020 at 12:36
1
Solved
I am new to the Timescale database. I was learning about chunks and how to create chunks based on time.
But there is another time/space chunking which is confusing me a lot.
What is a "dimens...
Mccubbin asked 2/5, 2020 at 2:10
1
Solved
To determine the size of my TimescaleDB table my_table (which has a hypertable created previously), I ran the SQL query
pg_size_pretty( pg_total_relation_size('my_table') );
However, despite hav...
Bertrand asked 31/12, 2019 at 3:54
1
Solved
I am trying to insert CSV records to Postgres database using nifi.
Sample csv file :
timenow,location
'2019-10-21 15:13:11','colombo'
When nifi scenario runs, it gives following error
Error ...
Bilberry asked 21/10, 2019 at 11:41
1 Next >
© 2022 - 2024 — McMap. All rights reserved.