Tiger Data Blog

Time-Series Is Just Postgres: What You Get When You Don't Split the Architecture

PostgreSQL

Time-Series Is Just Postgres: What You Get When You Don't Split the Architecture

You don't have to decide which data goes where, and a lot gets simpler once you stop drawing the line.

By Matty Stratton

November 5th, 2026

Building the Modern Enterprise Historian: TimescaleDB Enterprise Is Now in Public Beta

TimescaleDB

TimescaleDB Enterprise

Building the Modern Enterprise Historian: TimescaleDB Enterprise Is Now in Public Beta

Adaptive Integer Compression in TimescaleDB: Built for the Read Path

Compression

TimescaleDB

Adaptive Integer Compression in TimescaleDB: Built for the Read Path

We built three memory systems. The most expressive one wasn’t the most useful.

searchgres.js

We built three memory systems. The most expressive one wasn’t the most useful.

Designing IIoT Ingest That Survives a Cut Uplink

IIoT

PostgreSQL

Designing IIoT Ingest That Survives a Cut Uplink

Introducing searchgres.js: Composable Search in PostgreSQL

Announcements & Releases

searchgres.js

Introducing searchgres.js: Composable Search in PostgreSQL

Building an Ingest Safety Monitor for Your IIoT Pipeline in SQL

IIoT

PostgreSQL

Building an Ingest Safety Monitor for Your IIoT Pipeline in SQL

Announcing pg_vectorsearch: Scalable Open-Source Vector Search in PostgreSQL

Announcements & Releases

pg_vectorsearch

Announcing pg_vectorsearch: Scalable Open-Source Vector Search in PostgreSQL

pg_vectorsearch is a new open-source Postgres extension. Its PRISM index serves 100M vectors in 6 ms on 4x less RAM than HNSW, with builds in under 2 hours.

By Erik Nordström

October 13th, 2026

Measuring How Fast Your IIoT Queries Are Degrading

IIoT

PostgreSQL

Measuring How Fast Your IIoT Queries Are Degrading

Stop waiting for the dashboard to get slow. Record latency against row count, fit the curve, and get a date when your query breaches its target.

By John Shi

October 9th, 2026

Continuous Aggregate Refresh Policies for Solar and Wind SCADA Data: Choosing the Right Policy Shape

IIoT

TimescaleDB

Continuous Aggregate Refresh Policies for Solar and Wind SCADA Data: Choosing the Right Policy Shape

Five refresh policy shapes for solar and wind SCADA: frequent, daily, hierarchical, retention-aware, and manual. Pick the one that fits each job.

By Damaso Sanoja

October 7th, 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

Normalizing a Wide Well and Pipeline Telemetry Table Without Re-Ingesting History

IIoT

Normalizing a Wide Well and Pipeline Telemetry Table Without Re-Ingesting History

Reshape a wide oilfield SCADA table into a narrow hypertable plus tag metadata, in place, with dashboards running and history left where it is.

By Damaso Sanoja

September 30th, 2026

RAG Complexity Is a Bet Against the Model

RAG

RAG Complexity Is a Bet Against the Model

One Postgres table with two indexes beat every published RAG pipeline on MuSiQue. Every architectural addition is a bet the model stays weak.

By Matvey Arye

September 30th, 2026

Agent Memory Is a Search Problem, Not a Storage Problem

AI agents

Agent Memory Is a Search Problem, Not a Storage Problem

No fact extraction, no graphs, no memory manager. One Postgres table and three search tools scored F1 0.665 on LoCoMo.

By Matvey Arye

September 29th, 2026

41 Experiments in 6 Days: What the Human Was Actually For

AI agents

41 Experiments in 6 Days: What the Human Was Actually For

41 experiments in 6 days took LoCoMo memory from F1 0.392 to 0.666. Claude wrote the code; the human caught the metrics that were lying.

By Matvey Arye

September 28th, 2026

Sizing Your IIoT Table Before You Deploy

IIoT

PostgreSQL

Sizing Your IIoT Table Before You Deploy

A 20-byte sensor reading costs 95.6 on disk. Measure bytes per row, project 631 billion rows, and test your ingest ceiling before the schema review.

By John Shi

September 25th, 2026

Knowing When Your Composite Index Earns Its Write Cost

PostgreSQL

PostgreSQL Performance

Knowing When Your Composite Index Earns Its Write Cost

Composite indexes charge every insert and pay back only some queries. Four steps to price both sides and audit the indexes you already run.

By John Shi

September 18th, 2026

Stay updated with new
posts and releases.

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

Time-Series Is Just Postgres: What You Get When You Don't Split the Architecture

Building the Modern Enterprise Historian: TimescaleDB Enterprise Is Now in Public Beta

Adaptive Integer Compression in TimescaleDB: Built for the Read Path

We built three memory systems. The most expressive one wasn’t the most useful.

Designing IIoT Ingest That Survives a Cut Uplink

Introducing searchgres.js: Composable Search in PostgreSQL

Building an Ingest Safety Monitor for Your IIoT Pipeline in SQL

Announcing pg_vectorsearch: Scalable Open-Source Vector Search in PostgreSQL

Measuring How Fast Your IIoT Queries Are Degrading

Continuous Aggregate Refresh Policies for Solar and Wind SCADA Data: Choosing the Right Policy Shape

Postgres for sensor and machine data

Normalizing a Wide Well and Pipeline Telemetry Table Without Re-Ingesting History

RAG Complexity Is a Bet Against the Model

Agent Memory Is a Search Problem, Not a Storage Problem

41 Experiments in 6 Days: What the Human Was Actually For

Sizing Your IIoT Table Before You Deploy

Knowing When Your Composite Index Earns Its Write Cost

Stay updated with new posts and releases.

Time-Series Is Just Postgres: What You Get When You Don't Split the Architecture

Building the Modern Enterprise Historian: TimescaleDB Enterprise Is Now in Public Beta

Adaptive Integer Compression in TimescaleDB: Built for the Read Path

We built three memory systems. The most expressive one wasn’t the most useful.

Designing IIoT Ingest That Survives a Cut Uplink

Introducing searchgres.js: Composable Search in PostgreSQL

Building an Ingest Safety Monitor for Your IIoT Pipeline in SQL

Announcing pg_vectorsearch: Scalable Open-Source Vector Search in PostgreSQL

Measuring How Fast Your IIoT Queries Are Degrading

Continuous Aggregate Refresh Policies for Solar and Wind SCADA Data: Choosing the Right Policy Shape

Postgres for sensor and machine data

Normalizing a Wide Well and Pipeline Telemetry Table Without Re-Ingesting History

RAG Complexity Is a Bet Against the Model

Agent Memory Is a Search Problem, Not a Storage Problem

41 Experiments in 6 Days: What the Human Was Actually For

Sizing Your IIoT Table Before You Deploy

Knowing When Your Composite Index Earns Its Write Cost

Stay updated with new
posts and releases.