Question : I am trying to restore TimescaleDB data from one ubuntu machine to another ubuntu machine. On the both […]
Tag: timescaledb
Index not picked up on nullable boolean column
Question : I have 2 TimescaleDB Databases (PROD and DEV), both have a hypertable with the same schema and almost […]
Ways to optimize the PostgreSQL/TimeScaleDB query
Question : What approaches I could take to optimize the performance of the following joinless query on the following PostgreSQL/TimeScaleDB […]
Speeding up group by and max query
Question : In my iot use case, I have a table which stores sensor readings. I am using the timescaledb […]
Converting PostgreSQL table to TimescaleDB hypertable
Question : I have a PostgreSQL table which I am trying to convert to a TimescaleDB hypertable. The table looks […]
Postgres: Why is my delete query using up all available disk space?
Question : I have a postgres table set up like so: Table “public.facts” Column | Type | Collation | Nullable […]
Add aggregated value filtered by a condition to existing query
Question : I have this table to collect data from IoT device: CREATE TABLE public.conferimenti ( id bigint NOT NULL […]
Wall clock hourly buckets out of time intervals with postgres or timescale
Question : I have a record of session durations with start and end timestamps: user_id | session_id | session_start | […]
Best way to async data inserts into timescaledb
Question : 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 […]
Find Uncompressed/Compressed Sizes of TimescaleDB Database/Table
Question : For a database/table in TimescaleDB and PostgreSQL 11 running on ZFS with both ZFS compression and native TimescaleDB […]