PostgreSQL
How to Write Better Queries for Time-Series Data Analysis With Custom SQL Functions
As time-series data becomes more and more ubiquitous, there is a better way to explore it and analyze it with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler time-series data analysis using TimescaleDB.
Engineering
How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster, while requiring 60 % less storage (on average).
Observability
Kubernetes Observability in One Command: How to Generate and Store OpenTelemetry Traces Automatically
Instrumenting your code with OpenTelemetry traces is a manual effort that requires considerable time and effort. With tobs, OpenTelemetry Operator, and Promscale, you can deploy—with a single command— a complete pre-configured observability stack in Kubernetes.
Observability
Observability Powered by SQL: Understand Your Systems Like Never Before With OpenTelemetry Traces and PostgreSQL
Learn how observability powered by SQL can help you unveil performance issues in your distributed systems, courtesy of the now generally available OpenTelemetry tracing support in Promscale.
Events & Recaps
Five Lessons for Managing Growth and Career Development in Software Companies
Managing career growth and development can be tricky, especially in fast-paced software companies. Drawing from personal experience, Timescale’s VP of Engineering shares five lessons for healthy and productive organizations.
Observability
Learn OpenTelemetry Tracing With This Lightweight Microservices Demo
Deploy this simple microservices demo and learn how to get unprecedented insights about your systems! The demo application is instrumented with OpenTelemetry, and it includes six powerful Grafana dashboards built with traces and SQL.
Always Be Launching
Massive Scale for Time-Series Workloads: Introducing Continuous Aggregates for Distributed Hypertables in TimescaleDB 2.5
With this release, we introduce continuous aggregates in multi-node TimescaleDB, support for Postgres 14, and support for time zones in time_bucket_ng (under experimental).
Blog
What is ClickHouse, how does it compare to PostgreSQL and TimescaleDB, and how does it perform for time-series data?
An in-depth look at how ClickHouse and TimescaleDB architectures impact application design, developer experience, and performance - with detailed benchmark results comparing ingest speeds, disk space, and query response times.
Always Be Launching
Function Pipelines: Building Functional Programming Into PostgreSQL Using Custom Operators
Today we are releasing function pipelines, a new feature that allows you to analyze data by composing multiple functions in SQL - introducing a simpler, cleaner way of expressing complex logic in PostgreSQL.
PostgreSQL
How Percentile Approximation Works (and Why It’s More Useful Than Averages)
Get a primer on percentile approximations, why they're useful for analyzing large time-series data sets, and how we created the percentile approximation hyperfunctions to be efficient to compute, parallelizable, and useful with continuous aggregates and other advanced TimescaleDB features.
Observability
Simplified Prometheus monitoring for your entire organization with Promscale
We’re excited to announce multi-tenancy support in Promscale. We’ve built Promscale as a centralized store for metrics, and now developers can enjoy the same operational maturity and query flexibility when storing metrics across their entire organization.
Always Be Launching
Introducing Hyperfunctions: New SQL Functions to Simplify Working With Time-Series Data in PostgreSQL
TimescaleDB hyperfunctions are pre-built functions for the most common and difficult queries that developers write today in TimescaleDB and PostgreSQL. Hyperfunctions help developers measure what matters in time-series data, which generates massive, ever-growing streams of information.