Tiger Data Blog | Tiger Data

A practical framework for choosing between self-hosted TimescaleDB and Tiger Cloud: what each path requires, who owns what, and four questions to decide.

By Matty Stratton

June 25th, 2026

Postgres Sorting at Scale Needs More Than ORDER BY

PostgreSQL

Postgres Sorting at Scale Needs More Than ORDER BY

At scale, Postgres ORDER BY on time-series data spills to disk and slows queries. See how time_bucket and continuous aggregates cut a 4s query to 9ms.

By NanoHertz Communications

June 24th, 2026

Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck

PostgreSQL

Database

Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck

A skewed partition key can route 80% of your writes to one partition. Learn how to diagnose PostgreSQL partition hot spots and fix them at the schema level.

By NanoHertz Communications

June 19th, 2026

Postgres for sensor and machine data

Built for industrial, energy, and robotics systems. Run high-ingest telemetry and real-time analytics on the Postgres you already know.

Start a free trial

Great Models Aren't Enough for Physical AI

IoT

Great Models Aren't Enough for Physical AI

Great models aren't enough for Physical AI. Real deployments are gated by regulation, safety, operations, and the data your machines produce.

By Hien Phan

June 18th, 2026

When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture

PostgreSQL

Database

When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture

Postgres handles 90% of workloads well. Here's how to tell if yours is in the 10% — and what the diagnostic query that confirms it looks like.

By NanoHertz Communications

June 12th, 2026

A Unified Namespace Determines Your Historian Schema, Not the Other Way Around

IoT

Database

A Unified Namespace Determines Your Historian Schema, Not the Other Way Around

A UNS puts your historian downstream of continuous tag churn. Learn the schema that survives renames, reorgs, and retirements without rewriting history.

By Damaso Sanoja

June 10th, 2026

TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

Announcements & Releases

TimescaleDB

TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

Up to 160x more efficient UPDATE/DELETE, 30% to 2x faster vectorized execution, and skip unnecessary decompression + compression. Here's what's new in TimescaleDB 2.27.

By Brandon Purcell

June 9th, 2026

Row vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should Be

PostgreSQL

real time analytics

Row vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should Be

Learn why PostgreSQL reads 16x more data than your queries need, and how a hybrid row-columnar storage layout eliminates the bottleneck without changing your SQL.

By NanoHertz Communications

June 5th, 2026

The Engineering Calendar Is the Database Bill Nobody Tracks

PostgreSQL

PostgreSQL Tips

The Engineering Calendar Is the Database Bill Nobody Tracks

The cost of the Optimization Treadmill doesn't show up on the database bill. It shows up on the engineering calendar. And it compounds in ways that are easy to miss until someone actually adds it up.

By Matty Stratton

June 2nd, 2026

Stay updated with new
posts and releases.

Receive the latest technical articles and release notes in your inbox.

What's New in Tiger Cloud: Bigger Performance Gains, Wider Platform Reach, Better Visibility

The Data Layer for the AI Data Center

AI's Physical Constraints: How AI Rewired the Data Center

What We Heard: Three Patterns from Spring 2026 Events

How Float Runs an AI Energy Company on a 3-Person Team with Tiger Data

How Small Postgres Metadata Tables Quietly Throttle Your Largest Queries

What You’re Really Owning When You Self-Host TimescaleDB

Self-Hosted TimescaleDB or Tiger Cloud: A Framework for the Decision

Postgres Sorting at Scale Needs More Than ORDER BY

Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck

Postgres for sensor and machine data

Great Models Aren't Enough for Physical AI

When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture

A Unified Namespace Determines Your Historian Schema, Not the Other Way Around

TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

Row vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should Be

The Engineering Calendar Is the Database Bill Nobody Tracks

Stay updated with new posts and releases.

What's New in Tiger Cloud: Bigger Performance Gains, Wider Platform Reach, Better Visibility

The Data Layer for the AI Data Center

AI's Physical Constraints: How AI Rewired the Data Center

What We Heard: Three Patterns from Spring 2026 Events

How Float Runs an AI Energy Company on a 3-Person Team with Tiger Data

How Small Postgres Metadata Tables Quietly Throttle Your Largest Queries

What You’re Really Owning When You Self-Host TimescaleDB

Self-Hosted TimescaleDB or Tiger Cloud: A Framework for the Decision

Postgres Sorting at Scale Needs More Than ORDER BY

Why Your PostgreSQL Partition Key Is Creating a Write Bottleneck

Postgres for sensor and machine data

Great Models Aren't Enough for Physical AI

When PostgreSQL Isn't the Right Fit: Recognizing Workloads That Need Different Architecture

A Unified Namespace Determines Your Historian Schema, Not the Other Way Around

TimescaleDB 2.27: Broader Vectorized Execution, Up to 160x More Efficient UPDATE/DELETE, and Smarter UPSERT Pruning

Row vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should Be

The Engineering Calendar Is the Database Bill Nobody Tracks

Stay updated with new
posts and releases.