Measuring How Fast Your IIoT Queries Are Degrading (opens on the source site)
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.
Read at the sourceTHE COMPANY INDEX TRACKED BLOG
Tiger Data
Ideas, decisions, and lessons from the team.
blog.timescale.com (opens on the source site)LinkedIn X13Posts tracked
yesterdayLatest publication
1.1Posts / month over the last 12 months
Latest writing
13 of 13 postsContinuous Aggregate Refresh Policies for Solar and Wind SCADA Data: Choosing the Right Policy Shape (opens on the source site)
Five refresh policy shapes for solar and wind SCADA: frequent, daily, hierarchical, retention-aware, and manual. Pick the one that fits each job.
Read at the sourceNormalizing a Wide Well and Pipeline Telemetry Table Without Re-Ingesting History (opens on the source site)
Reshape a wide oilfield SCADA table into a narrow hypertable plus tag metadata, in place, with dashboards running and history left where it is.
Read at the sourceRAG Complexity Is a Bet Against the Model (opens on the source site)
One Postgres table with two indexes beat every published RAG pipeline on MuSiQue. Every architectural addition is a bet the model stays weak.
Read at the source41 Experiments in 6 Days: What the Human Was Actually For (opens on the source site)
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.
Read at the sourceSizing Your IIoT Table Before You Deploy (opens on the source site)
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.
Read at the sourceKnowing When Your Composite Index Earns Its Write Cost (opens on the source site)
Composite indexes charge every insert and pay back only some queries. Four steps to price both sides and audit the indexes you already run.
Read at the sourceHow Meshtastic Metrics Exporter Turned Eight Prometheus Queries Into One with Tiger Data (opens on the source site)
Meshtastic Metrics Exporter reduced 500K+ Prometheus metric series to one Postgres database: consolidated eight queries into one with Tiger Data for 10,000 mesh radio nodes.
Read at the sourceThe Real Cost of a Single Insert in Postgres (opens on the source site)
PostgreSQL write amplification explained: why indexes multiply WAL volume, how to measure it on your tables, and four ways to reduce it without schema changes.
Read at the sourceIs It Safe to Give an AI Agent Access to Your Production Database? (opens on the source site)
Giving an AI agent unrestricted database access isn't safe. Scoped, read-only, database-enforced access can be. See the framework and guardrails.
Read at the sourceWhy a 40-Year-Old Database Is Still Winning in the AI Era (opens on the source site)
Why Postgres wins in the AI era: 40 years of reliability, extensibility, and an open ecosystem. Agents need trusted foundations, not fragile architectures.
Read at the sourceHow Companion.energy Reduced Query Latency 25x and Compressed Terabytes to Gigabytes with Tiger Cloud (opens on the source site)
How Companion.energy optimized real-time energy data: 25x faster queries, 43.5x compression, continuous aggregates, and unified Tiger Cloud architecture.
Read at the sourceTime-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows (opens on the source site)
Cardinality is a consequence of how many dimensions you index your readings by. Here is where the curve bends, measured, and what you can do about it without leaving Postgres. Someone adds a firmware_ver column to the sensor table. It is one line of DDL, and it clears review in a minute. Two weeks later, the ingest job is missing its window, a dashboard query that used to return in milliseconds takes seconds, and the on-call engineer is digging through EXPLAIN output to work out when the planne
Read at the source