|
Slow delete query
|
|
3
|
746
|
August 2, 2023
|
|
Slow query response to retrieve first time of table
|
|
1
|
456
|
July 28, 2023
|
|
Strange CPU consumption after querying hypertable
|
|
3
|
358
|
July 26, 2023
|
|
Slow update statement
|
|
3
|
422
|
August 17, 2023
|
|
SELECT TOP 1 queries hanging
|
|
3
|
626
|
July 4, 2023
|
|
How to get faster query speeds
|
|
2
|
747
|
July 3, 2023
|
|
Index issue (load average 40, fixes with table reindexing)
|
|
1
|
358
|
June 27, 2023
|
|
Timescaledb conversion taking a long time for Zabbix Postgresql database (a lot of system resources are free)
|
|
3
|
803
|
June 14, 2023
|
|
Slow lateral join queries, doesn't filter chunk
|
|
1
|
592
|
June 7, 2023
|
|
Creating an index
|
|
1
|
659
|
May 24, 2023
|
|
Slow query on nested CAgg
|
|
0
|
537
|
May 23, 2023
|
|
Db becomes unresponsive during aggregate refresh
|
|
0
|
412
|
May 5, 2023
|
|
Impossible amount of Writes - WAL
|
|
2
|
694
|
May 4, 2023
|
|
Join two hypertables by timestamp produce different plan (fast & slow)
|
|
2
|
1542
|
April 3, 2023
|
|
Query reads all chunks Select + order by timestamp desc + Limit 1
|
|
9
|
1938
|
April 3, 2023
|
|
Recommendation / Ideas on backfilling data with enabled compression and lots of data
|
|
3
|
614
|
March 28, 2023
|
|
SELECT query takes too much time even for a single record out of 165 total records in the users table
|
|
0
|
557
|
March 23, 2023
|
|
VACUUM ANALYZE on 100B-row compressed hypertable
|
|
0
|
715
|
February 16, 2023
|
|
Large refresh on unchanged data is time consuming
|
|
1
|
612
|
February 7, 2023
|
|
Data Deduplication
|
|
0
|
1059
|
January 18, 2023
|
|
Unable to Bulk DELETE Rows from TIMESCALEDB /POSTGRES
|
|
1
|
1168
|
January 4, 2023
|
|
Does recalc mechanism of CAgg recalcs every time whole chunk?
|
|
3
|
954
|
December 22, 2022
|
|
Can we drop Default Index timescaledb creates?
|
|
0
|
771
|
December 13, 2022
|
|
AWS Best practices and things to know ECS vs EC2
|
|
0
|
988
|
November 28, 2022
|
|
Insertion rate is very slow after continuous aggregates generation
|
|
1
|
1062
|
November 28, 2022
|
|
CAgg spends a lot of time recalculating one day bucket
|
|
4
|
1301
|
November 24, 2022
|
|
Generic design decisions and narrow table performance
|
|
1
|
1398
|
November 18, 2022
|
|
Now() is slow vs fixed dates
|
|
6
|
2240
|
November 8, 2022
|
|
CAgg recalculate all unnecessary buckets between two neccessary buckets
|
|
3
|
1196
|
November 3, 2022
|
|
What are best practices to manage different Resolution with Timescale DB
|
|
2
|
2236
|
October 27, 2022
|