Tiger Data Blog

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

Great Models Aren't Enough for Physical AI

IoT

Great Models Aren't Enough for Physical AI

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

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

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

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

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

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

The Postgres Developer's Guide to Vector Index Tradeoffs

pg_textsearch

PostgreSQL

The Postgres Developer's Guide to Vector Index Tradeoffs

Vector search becomes an index design problem as your data grows. Here's how to make the right call without leaving Postgres.

By Hien Phan

May 26th, 2026

Understanding Why OS RAM and Postgres Buffer Cache Compete

PostgreSQL

PostgreSQL Tips

Understanding Why OS RAM and Postgres Buffer Cache Compete

PostgreSQL and your OS cache the same data twice. Learn how double buffering degrades performance at scale and how the 25% shared_buffers rule fixes it.

By NanoHertz Communications

May 22nd, 2026

Why Giant IN Clauses Slow Down Your App

PostgreSQL Performance

PostgreSQL

Why Giant IN Clauses Slow Down Your App

Giant `IN` clauses inflate PostgreSQL planning time and spike p99 latency. Learn how `ANY(ARRAY[])` cuts the hidden planning tax and keeps your app fast at scale.

By NanoHertz Communications

May 15th, 2026

The True Cost of Database Optimization: Engineering Time

Database

PostgreSQL

The True Cost of Database Optimization: Engineering Time

The true cost of Postgres optimization isn't the cloud bill. It's 12-16 engineer-weeks per year that never show up on a budget report.

By Matty Stratton

May 14th, 2026

How Relational Complexity Crushes Real-Time Dashboards

PostgreSQL

real time analytics

How Relational Complexity Crushes Real-Time Dashboards

Joins on billion-row Postgres tables crush real-time dashboards. Flatten your schema to cut shared buffer hits 70–90% and restore dashboard speed.

By NanoHertz Communications

May 8th, 2026

Five Warning Signs Your Database Needs Different Architecture

PostgreSQL

Five Warning Signs Your Database Needs Different Architecture

There's a category of Postgres performance issue that no amount of tuning will fix. Here's how to tell if you're already in it.

By Matty Stratton

May 7th, 2026

Stay updated with new
posts and releases.

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

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

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

PostgreSQL for Everything

The Postgres Developer's Guide to Vector Index Tradeoffs

Understanding Why OS RAM and Postgres Buffer Cache Compete

Why Giant IN Clauses Slow Down Your App

The True Cost of Database Optimization: Engineering Time

How Relational Complexity Crushes Real-Time Dashboards

Five Warning Signs Your Database Needs Different Architecture

Stay updated with new posts and releases.

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

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

PostgreSQL for Everything

The Postgres Developer's Guide to Vector Index Tradeoffs

Understanding Why OS RAM and Postgres Buffer Cache Compete

Why Giant IN Clauses Slow Down Your App

The True Cost of Database Optimization: Engineering Time

How Relational Complexity Crushes Real-Time Dashboards

Five Warning Signs Your Database Needs Different Architecture

Stay updated with new
posts and releases.