tigerdata_dev

A very common query against a time-series table is fetching the latest row for a device: SELECT *...

When people picture a robot, they picture C-3PO (or if you're a Trekkie, it's Lieutenant Commander...

Every EXPLAIN ANALYZE prints two numbers at the bottom, and most engineers read only one of them....

Yesterday the shift dashboard reported 41,900 units across an eight-hour window. Today the same query...

Your slowest query is rarely your most expensive one. A 4-second report that runs twice a day costs...

ControlCom Connect streams telemetry from thousands of industrial and facility assets into...

Your ingest workers are queuing. pg_stat_activity shows lock waits. The blocked query is not a slow...

This is Part II of a two-part series on the AI data center stack. Part I, AI's Physical Constraints:...

For most of the cloud era, a server rack was a five to twenty kilowatt object. You could fill a room...

Spring 2026 was relentless. Tiger Data teams covered ten events across Europe and the US: GrafanaCON...

Danish startup achieves 99.3% compression on 1Hz smart meter data, powering real-time appliance-level...

Most time-series performance work starts with the obvious suspect: the fact table. Five hundred...

Written by Matty Stratton, Brandon Purcell, Noah Hein, Hien Phan Why operating TimescaleDB for...

Notes from our Physical AI dinner What should a drone do when a police helicopter approaches it? We...

When PostgreSQL isn't the right fit, the signs don't announce themselves clearly. Postgres is the...

Most teams build the historian schema first, then connect it to a Unified Namespace. Adopt a UNS and...

Here's a query that runs on most time-series tables: SELECT time_bucket('1 hour', ts) AS hour, ...

Vector search in Postgres usually starts simply. You add an embedding column, run a nearest-neighbor...

You just doubled the RAM on your database server to handle a climb in p95 latency. You expect the...

"We can fix the performance issue with better indexes, smarter partitioning, and some vacuum tuning....

Giuseppe “Polliog” Pollio started writing code for LogTide in September 2025. By early 2026, the...

ClickHouse is fast. The benchmarks aren't lying. If you've run a comparison against vanilla Postgres...

MongoDB gets a bad reputation in certain engineering circles that it doesn't entirely deserve. It...

Design, implementation, and benchmarks of a native BM25 index for Postgres. Now generally available...

Sensor Data Looks Simple Until It Isn’t Sensor data appears straightforward. It just has...

In case you missed the quiet launch of our timescaledb-ruby gem, we’re here to remind you that you...

TL;DR: We're excited to announce that pgai Vectorizer—the tool for robust embedding creation and...

Vector search is becoming a core workload for AI-driven applications. But do you really need to...

Modern applications need data that's both accessible and fast. You have data in S3, but transforming...

It's Timescale Launch Week and we’re bringing benchmarks: Postgres vs. Qdrant on 50M...