Charly Batista (PostgreSQL Tech Lead, Percona) will be presenting 2 talks at Postgres Conferfence Orlando on March 18-21, 2025.
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.
Sometimes, PostgreSQL struggles with slow queries. Indexing might help, but it’s important to use the right strategies. In this talk, we’ll explore how advanced indexing can speed up your queries. We’ll quickly review the B-Tree and Hash indexes, but the focus will be less common index strategies like the BRIN, GIN, and GiST indexes.
We’ll start by explaining what B-Tree, Hash, BRIN, GIN, and GiST indexes are, how they work, and when to use them. You’ll see real examples showing how these indexes can improve query performance. However, we’ll also discuss why indexes aren’t a magic fix for all problems. Using indexes effectively requires good planning and strategy.
By the end of this session, you’ll know how to choose and use the right indexes to make your PostgreSQL queries faster and more efficient. Whether you’re a developer or a database administrator, you’ll gain valuable insights to help you optimize your database performance.
Join us to learn how advanced indexing can boost your PostgreSQL performance and the strategies needed to make them work best!
About the event.
For the first time, the Postgres Conference will be held in Orlando, Florida! This year,it expanded the tracks beyond the traditional Dev, Ops, and Essentials to include Professional Development and Variants & Cloud.
Postgres Conference Orlando 2025
