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

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