|
Glacial query speeds, looking for guidance [beginner]
|
|
4
|
419
|
May 30, 2025
|
|
Ignition Scada slow with timescaledb
|
|
0
|
40
|
April 30, 2025
|
|
Newer chunks are slower to read from?
|
|
1
|
36
|
April 16, 2025
|
|
Performance issue when refreshing continuous aggregate
|
|
5
|
72
|
April 14, 2025
|
|
Index issue (load average 40, fixes with table reindexing)
|
|
2
|
650
|
March 20, 2025
|
|
How to revert back to normal table from hypertable
|
|
3
|
1321
|
March 12, 2025
|
|
Efficient Update of hundreds of millions of rows
|
|
1
|
38
|
March 10, 2025
|
|
Move chunks() to different table space will reduce disk storage
|
|
1
|
56
|
February 11, 2025
|
|
Slow "order by .. limit 1" performance
|
|
3
|
65
|
February 10, 2025
|
|
Running into "remaining connection slots reserved" even after adding Connection Pooling
|
|
3
|
101
|
February 6, 2025
|
|
Chunk_skipping is not working
|
|
7
|
162
|
February 5, 2025
|
|
Performance issue in write-heavy workload
|
|
6
|
493
|
January 28, 2025
|
|
Query time increase significantly with just a few values added to WHERE IN clause
|
|
3
|
109
|
January 20, 2025
|
|
Native postgres version faster than timescaledb - upserts and reads (version 2.16.1)
|
|
2
|
484
|
December 5, 2024
|
|
Different Performance on Different Time Ranges for Same Query Irrespective of Length of Period
|
|
1
|
94
|
December 4, 2024
|
|
Query Performance Comparison: Uncompressed vs. Compressed Data in TimescaleDB
|
|
2
|
276
|
November 15, 2024
|
|
300m row ingestion into a hypertable per day
|
|
1
|
253
|
October 22, 2024
|
|
Performance of updates on compressed table chunks
|
|
4
|
1911
|
October 15, 2024
|
|
Seeking Advice on Optimizing Continuous Aggregations for High-Frequency Data
|
|
0
|
242
|
September 26, 2024
|
|
Correct indexing strategy for columns derived from hypertable key
|
|
1
|
548
|
September 17, 2024
|
|
Query reads all chunks Select + order by timestamp desc + Limit 1
|
|
9
|
3268
|
April 3, 2023
|
|
Performance problem
|
|
1
|
301
|
August 29, 2024
|
|
What is recommended wal_segment_size parameter for TimescaleDB?
|
|
3
|
1289
|
August 28, 2024
|
|
hypertable pagination
|
|
1
|
390
|
August 26, 2024
|
|
Continuous aggregate without or with a large time_bucket span
|
|
1
|
487
|
August 12, 2024
|
|
Performance drop when starting to write to a new chunk
|
|
1
|
384
|
July 31, 2024
|
|
High CPU Usage in PostgreSQL Service
|
|
2
|
854
|
July 29, 2024
|
|
Received Immediate Shutdown Request in TimescaleDB
|
|
3
|
1820
|
July 8, 2024
|
|
VERY Slow query execution with simple time condition
|
|
1
|
355
|
July 5, 2024
|
|
Retrieving the most recent record with skip scan is easy enough, but how do I get the timestamp of the previous record as well?
|
|
2
|
509
|
June 5, 2024
|