Charly Batista

We all write SQL, but how many of us have looked under the hood of a relational database like PostgreSQL? This talk is a deep dive into the guts of the database engine, tracking a simple SELECT statement from the moment you hit "Enter" to the final result set.

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.

Vacuum is a very important but largely misunderstood topic in Postgres world, but we will change it now! We will dive deep into the Postgres storage system and its multi-version model (MVCC) during this presentation to give us the needed base to understand what is and why we need Vacuum.We will...

Percona Monitoring and Management (PMM) is a great open source tool used to monitor databases. In this talk, we'll demonstrate how to set up and use the tool to make the most out of your PostgreSQL deployments. We'll review the built-in metrics and dashboards, and how you can add your own...

High availability is a key point in any modern system, and it's no different for Postgres. We will discuss some designs that can be used to implement a high available database ecosystem, and we'll see that it doesn't need to cost a liver to implement. We'll discuss restrictions, the minimum...

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 the disk and consequently in memory, which can save...

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.

Percona Monitoring and Management (PMM) is a great open-source tool used to monitor databases. In this talk, we'll demonstrate how to set up and use the tool to make the most out of your PostgreSQL deployments.

PostgreSQL has a great support for JSON, including proper indexes, and we'll demonstrate how to get the best of the usage of the support it has and how to extend it.

It's easy for Java developers (and users of other OO languages) to mix object-oriented thinking and imperative thinking. But when it comes to writing SQL the nightmare begins! Firstly because SQL is a declarative language and it has nothing to do with either OO or imperative thinking and as for...