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

Dev Q&A

By Andrew Stebbins

min read

May 27, 2026

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.

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

Stay updated with new posts and releases.

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

Boost Postgres Performance by 7x With Chunk-Skipping Indexes

Announcements & Releases

By Ana Tavares

Sep 17, 2024

See how we made PostgreSQL performance 7x faster while using 87 % less storage thanks to smarter partition pruning via chunk-skipping indexes.

Scaling PostgreSQL for Cheap: Introducing Tiered Storage in Timescale

Announcements & Releases

By Ana Tavares

Nov 13, 2023

Data management decisions don’t have to be costly. Introducing Tiered Storage, a low-cost infinite storage tier for your historical data needs.

Allowing DML Operations in Highly Compressed Time-Series Data in PostgreSQL

Engineering

By Kirk Laurence Roybal

Oct 03, 2023

We evolved our columnar compression design to comfortably allow data modifications, including INSERTs, UPDATEs, and DELETEs (DML operations).