Dustin Sorensen - Blog

Products
Products & Services
Tiger Cloud
A reliable PostgreSQL cloud for your workloads
Tiger Cloud
Support Services
Support options for your use case, infrastructure, and budget
Cloud support Self-managed support
Workloads
Time Series
Lightning-fast ingest and querying on PostgreSQL
Time Series
Real-Time Analytics
The fastest real-time analytics on PostgreSQL
Real-Time Analytics
AI and Vector
Build RAG, search, and Al agents, all on PostgreSQL
AI and Vector
Open-Source Extensions and Tools
Time Series and Real-Time Analytics
A reliable PostgreSQL cloud for your workloads
timescaledb timescaledb-toolkit
AI and Vector
pgai pgvectorscale
Security Scanner
pgspot
Explore our Enterprise Tier
Security, reliability, and support for demanding businesses.
Solutions
Industries That Rely On Us
Crypto Industrial IoT Energy Transportation and logistics Manufacturing
Featured Articles
Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables
Read more
Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables
Boosting Postgres INSERT Performance by 2x With UNNEST
Read more
Boosting Postgres INSERT Performance by 2x With UNNEST
Customers
Developers
Documentation
TigerData Docs
Learn how to make PostgreSQL faster with our documentation
TigerData Docs
AI and Vector
Learn how to use PostgreSQL for Al with our documentation
AI and Vector
Learn PostgreSQL
Learn PostgreSQL
Learn the PostgreSQL basics and scale your database performance
Overview Time series basics Postgres basics Postgres guides Benchmarks Postgres cheat sheet
TigerData Benchmarks
TigerData benchmarks
See how TigerData performs against the competition
vs RDS PostgreSQL vs Amazon Timestream vs Influx vs MongoDB vs ClickHouse vs Aurora vs Cassandra vs vanilla PostgreSQL
More
Blog
Tutorials
Support
Community
Changelog
GitHub
Slack
Events
Launch Hub
Partners
Pricing

Adapting JSON Structures for Real-Time Aggregates: A Community Solution