Receive the latest technical articles and release notes in your inbox.
Ingest fails suddenly, not gradually. Sample WAL volume, replica lag, and dead tuples every minute, and get one headroom percentage you can alert on.
By John Shi
October 16th, 2026
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
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
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
Built for industrial, energy, and robotics systems. Run high-ingest telemetry and real-time analytics on the Postgres you already know.
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.
By Andrew Stebbins
September 16th, 2026
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.
By John Shi
September 11th, 2026
Giving an AI agent unrestricted database access isn't safe. Scoped, read-only, database-enforced access can be. See the framework and guardrails.
By Nicole Ghalwash
September 8th, 2026
Tiger Cloud on Azure vs self-hosting TimescaleDB: skip-scan, compression, continuous aggregates, tiered storage, private endpoints, and cross-region backups—fully managed.
By Nicole Ghalwash
September 3rd, 2026
PostgreSQL table bloat: detect it before it kills performance. Measure heap and index density, set autovacuum thresholds, and alert on dead tuple ratios and vacuum lag.
By John Shi
September 2nd, 2026
Why Postgres wins in the AI era: 40 years of reliability, extensibility, and an open ecosystem. Agents need trusted foundations, not fragile architectures.
By Ajay Kulkarni
September 1st, 2026
