---
title: "Adapting JSON Structures for Real-Time Aggregates in Postgres"
url: https://daily.dev/posts/adapting-json-structures-for-real-time-aggregates-in-postgres-d24dxmxrz
source_url: https://www.timescale.com/blog/adapting-json-structures-for-real-time-aggregates-a-community-solution/
type: article
source: "TigerData (Creators of TimescaleDB)"
published: 2024-03-29T11:00:45.535Z
updated: 2024-05-09T08:39:06.345Z
tags: ["postgresql", "data-management", "timescaledb"]
reading_time: 3
upvotes: 4
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Adapting JSON Structures for Real-Time Aggregates in Postgres

**[TigerData \(Creators of TimescaleDB\)](https://daily.dev/sources/tigerdata)** · 3 min read · 4 upvotes · 0 comments

## Summary

Learn how to efficiently manage and aggregate data from multiple sensors or IoT devices without creating dedicated columns using Timescale's JSON structures. Explore the innovative solution of custom aggregate functions for JSONB values.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.timescale.com/blog/adapting-json-structures-for-real-time-aggregates-a-community-solution/>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments
- [CNCF Unveils Schedule for KubeCon \+ CloudNativeCon Europe 2026](https://daily.dev/posts/cncf-unveils-schedule-for-kubecon-cloudnativecon-europe-2026-ikhcoa5cb) · CNCF · 2 upvotes · 0 comments
- [CNCF Debuts KubeCon \+ CloudNativeCon Japan 2026 Schedule](https://daily.dev/posts/cncf-debuts-kubecon-cloudnativecon-japan-2026-schedule-xp5pyudub) · CNCF · 1 upvotes · 0 comments

---

Tags: [#postgresql](https://daily.dev/tags/postgresql), [#data-management](https://daily.dev/tags/data-management), [#timescaledb](https://daily.dev/tags/timescaledb)

[View this post on daily.dev](https://daily.dev/posts/adapting-json-structures-for-real-time-aggregates-in-postgres-d24dxmxrz)