I have a case where I have a table "tab" that stores data (keyed by symbol and time) as well as a second table "summ" that stores the exponential weighted running average of the data in the first table. I…
I have a PostgreSQL cluster composed of four machines, configured as follows: Three PostgreSQL nodes managed by Patroni and ETCD, using PgBouncer. One of these nodes is the primary, and the other two are replicas. One machine using HAProxy to…
I have a django project which stores real-time data of a few devices. For this manner I have used timescaledb which is suitable for time series and it's based on postgres. Timescale offers a few hyperfunctions which I need to…
I'm encountering an issue while working with PostgreSQL and TimescaleDB. I'm attempting to create a continuous aggregate view, but I keep receiving the following error message: ERROR: continuous aggregate view must include a valid time bucket function CREATE MATERIALIZED VIEW…
I'm using a postgresql (15.5) database with the following logic: We have "meters" who measure electrical consumption. We have "computer meters" who are calculation of the measurements of different meters. For exemple "computedMeterA" = "meterA" + "meterB" I have classical…
Help with terminology would be appreciated to help me rephrase the question I am trying to ask in my post. The Problem: I am using TimeScale DB and am trying to create a time aggregate with a 4 hour time…
I installed timescaleDb using Docker following this tutorial for the setup: https://docs.timescale.com/self-hosted/latest/install/installation-docker/ . I used this image : timescale/timescaledb-ha:pg14-latest Then I connected to the instance with pgAdmin and followed this official tutorial: https://docs.timescale.com/getting-started/latest/tables-hypertables/. CREATE DATABASE "test-timescale"; CREATE TABLE IF NOT…
I have a postgresql query that does pagination using a keyset-based approach. SELECT * FROM public.values_with_variable_view WHERE ( timestamp, id) > ('2024-01-04 01:12:09.267335+00',1996) ORDER BY ( timestamp, id) asc LIMIT 100 I have a requirement to write this using LINQ…
I've been stumped trying to optimize this query and was hoping some of you database wizards might have some insight. Here is the setup. Using TimescaleDB as my database, I have a wide table containing sensor data, it looks like…
I collect device ON/OFF events in a timeseries table. Following is a sample data. time_stamp state 2023-10-04 10:05:53 0 2023-10-04 10:15:58 1 2023-10-04 10:30:59 0 2023-10-04 10:40:00 1 2023-10-04 10:55:01 0 2023-10-04 11:05:03 1 2023-10-04 11:35:36 0 2023-10-04 11:40:39 1…