Tiger Data Blog

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

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

PostgreSQL for Everything

Built on PostgreSQL, Tiger Cloud combines robustness and flexibility to tame your most demanding workloads, from real-time analytics and IoT data to events and vector embeddings.

Start a free trial

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

Unify Your Plant-Floor Data with Claude Code and TimescaleDB

IoT

TimescaleDB

Unify Your Plant-Floor Data with Claude Code and TimescaleDB

Learn how to use Claude Code Agent Teams and TimescaleDB to build a unified plant-floor data pipeline — one governed table, three protocols, zero middleware.

By Damaso Sanoja

May 28th, 2026

How ApexAnalytica Runs Building Telemetry, Transactional Data, and RAG on a Single Postgres Instance

Dev Q&A

TimescaleDB

How ApexAnalytica Runs Building Telemetry, Transactional Data, and RAG on a Single Postgres Instance

See how open source TimescaleDB powers a year of hourly building energy data in a single heat map view — rendered in under a second across 38 live sites.

By Andrew Stebbins

May 27th, 2026

Stay updated with new
posts and releases.

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

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

Great Models Aren't Enough for Physical AI

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

PostgreSQL for Everything

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

Unify Your Plant-Floor Data with Claude Code and TimescaleDB

How ApexAnalytica Runs Building Telemetry, Transactional Data, and RAG on a Single Postgres Instance

Stay updated with new posts and releases.

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

Great Models Aren't Enough for Physical AI

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

PostgreSQL for Everything

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

Unify Your Plant-Floor Data with Claude Code and TimescaleDB

How ApexAnalytica Runs Building Telemetry, Transactional Data, and RAG on a Single Postgres Instance

Stay updated with new
posts and releases.