/plushcap/analysis/timescale/timescale-overheard-office-hours-queries-performance-metrics

Overheard @ Office Hours

What's this blog post about?

During Timescale Office Hours, participants discussed various topics such as speeding up queries, performance tuning, storing metrics, and more. Key points included the use of indexes for text field LIKE queries, treating TimescaleDB indexes similarly to PostgreSQL ones, hardware tuning suggestions like running timescaledb-tune and increasing max connections limit, lack of observed performance issues with Docker, scaling out to multiple machines using read replicas, ZFS compression, successful integration of TimescaleDB with Zabbix, and the Telegraf plugin for PostgreSQL & TimescaleDB.

Company
Timescale

Date published
March 10, 2021

Author(s)
Matthew Perry

Word count
450

Language
English

Hacker News points
None found.


By Matt Makai. 2021-2024.