Charly Batista

Postgres Tech Leader at Percona LLC

About

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

Charly Batista has presented the following presentations

Advanced Indexing Techniques in PostgreSQL: Optimizing Queries for Maximum Performance at Postgres Conference 2025
Crafting the Perfect Index for Every Query
presented by Charly Batista
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...
more
Fri 21 2025 Ops
From Sensors to Insights: PostgreSQL in the IoT Ecosystem at Postgres Conference 2025
PostgreSQL for Data Collection and Analysis
presented by Charly Batista
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...
more
Thu 20 2025 Dev
Reducing Costs and Improving Performance With Data Modeling in Postgres at Postgres Conference 2024

presented by Charly Batista
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...
more
Wed 17 2024 Essentials
Monitoring PostgreSQL: Navigating the Landscape of Metrics, OS and Hardware Relationships, and Toolsets at Postgres Conference 2024

presented by Charly Batista
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...
more
Thu 18 2024 Ops
PL/Java - Extend the power of your database at Silicon Valley 2022
How to use Java to extend your database powers
presented by Charly Batista
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...
more
Fri 8 2022 Dev
Reducing Costs and Improving Performance With Data Modeling in Postgres at 2021 Postgres Conference Webinars
Understanding how PostgreSQL organizes the data internally can save costs!
presented by Charly Batista

video
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.
Wed 6 2021 Ops
Reducing Costs and Improving Performance With Data Modeling in Postgres at South Africa 2021
Understanding how PostgreSQL organizes the data internally can save costs!
presented by Charly Batista
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.
Tue 5 2021 Ops & Administration