Charly Batista
Postgres Tech Leader at Percona LLC
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
Upcoming presentations
No upcoming presentations...
Past presentations
Advanced Indexing Techniques in PostgreSQL: Optimizing Queries for Maximum Performance
Crafting the Perfect Index for Every Query
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, an...
Mar 21 2025
From Sensors to Insights: PostgreSQL in the IoT Ecosystem
PostgreSQL for Data Collection and Analysis
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 tho...
Mar 20 2025
In this session we'll unravel the intricacies of PostgreSQL's internal data organisation, shedding light on the Free Space Map (FSM) mechanism. Delving into the heart of PostgreSQL's data architecture, we'll explore ways to strategically reorganise the data model, capitalising on data alignment within blocks. The goal? To unveil techniques that not only optimise disk space usage but also enhanc...
Apr 17 2024
In the dynamic landscape of PostgreSQL management, robust monitoring is the cornerstone of maintaining a healthy and performant Postgres environment. This talk delves deep into the intricacies of PostgreSQL monitoring, addressing fundamental questions: What are the most crucial aspects to monitor within the database? How do these metrics relate to the underlying operating system? And, in a mark...
Apr 18 2024
PL/Java - Extend the power of your database
How to use Java to extend your database powers
There are some cases when we need to empower our database and Postgres offers many options, including Java. During this talk, we'll not only see how to install and configure PL/Java but we'll walk through examples on how to access database objects, loop through a resultset, and return the result back as a single object like a TEXT. While this sounds interesting we'll also show some complex exam...
Apr 8 2022
Reducing Costs and Improving Performance With Data Modeling in Postgres
Understanding how PostgreSQL organizes the data internally can save costs!
During this talk we will explain how PostgreSQL organizes the data internally, how the Free Space Map (FSM) works and how we can reorganize the data model to take advantage of data alignment inside blocks reducing the size of the data in disk and consequently in memory, which can save money and improve performance.
Reducing Costs and Improving Performance With Data Modeling in Postgres
Understanding how PostgreSQL organizes the data internally can save costs!
During this talk we will explain how PostgreSQL organizes the data internally, how the Free Space Map (FSM) works and how we can reorganize the data model to take advantage of data alignment inside blocks reducing the size of the data in disk and consequently in memory, which can save money and improve performance.
Oct 5 2021