From Sensors to Insights: PostgreSQL in the IoT Ecosystem
Presented by:

Charly Batista
Charly is the PostgreSQL Tech Lead at Percona and is passionate about databases and performance. He has been working with databases and development for over 20 years and has participated in many projects, from the design of a small sensor to count how many times a ball passes through a basketball hoop to complex database proxy applications.
Outside work, he loves sports, as a good Brazilian he practices football (or soccer), volleyball, and surprisingly ping-pong. Charly is also passionate about new cultures, their languages, and traditions, and has lived and/or worked in a few different countries. Today he basically lives between Brazil and China. Not really in between, but stays some time in Brazil and some time in China :D
No video of the event yet, sorry!
Are you working with applications that generate massive data, such as IoT, Finance, or other systems that push the database to the limit? This talk aims to show you how PostgreSQL can handle your data effectively.
In such scenarios, we’ll discuss using PostgreSQL for data ingestion, storage, and processing. You’ll learn how to efficiently manage and process the large amounts of data that those applications and devices generate. We’ll also show you how to build a real-time dashboard using PostgreSQL. You’ll discover how to visualize live data and create dynamic, up-to-the-minute displays while we explore advanced indexing strategies using the traditional B-Tree and Hash indexes and BRIN, GIN, and GiST indexes. You’ll see how these indexes can improve query performance and make your data processing faster and more efficient.
You should leave this presentation with a good understanding of leveraging PostgreSQL for your IoT or any other data-massive application, from data management to real-time visualization, gaining valuable insights to enhance your projects.
Join us to learn to unlock the power of PostgreSQL for our needs!
- Date:
- 2025 March 20 14:30 EDT
- Duration:
- 50 min
- Room:
- Gold Coast 1&2
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Dev
- Difficulty:
- Medium