Main track

Conference program

Guests registration

09:00 – 10:00

PG BootCamp Russia 2024 Kazan welcome speech

Michael Goldberg

Member of PostgreSQL Code of Conduct Committee (since 2020), Chair (since 2023), Member of PG BootCamp Initiative Group, PGDay Israel Conferences Organizer (since 2017)

Vadim Yatsenko

CEO, Tantor Labs, Member of PG BootCamp Initiative Group, PGDay Israel Conferences Organizer (since 2017)

10:00 – 10:10

Practical SQL expressions in PostgreSQL

I'll explain the features of SQL query syntax that let you create more condensed and productive PostgreSQL code.

Leading database architect, Tensor

Kirill Borovikov

10:10 – 11:00

Intermediate

Time zone: MSK (GMT +03:00)
All presentations will be held in Russian

PostgreSQL as an application server, or low-code on Postgres

I'll go over how to make a database-centric application, which premium and free extensions are the most helpful, and how to build a capable full stack developer out of a PostgreSQL developer.

CTO, X-Square

Konstantin Vashchenkov

11:00 – 11:35

Intermediate

Coffee break

11:35 – 12:00

Debugging the Postgres planner

I'll introduce the attendees to debugging the Postgres planner by going over its fundamental components, key data structures, and interdependencies. In the master class section, we'll go over the Constraint Exclusion optimization, considering the constraints of variables to eliminate tables with conflicting criteria from the queries. I'll also include some helpful advice at the conclusion to simplify the planner usage.

Developer, Tantor Labs

Sergey Soloviеv

12:00 – 13:10

Advanced

Watch video

Watch video

Watch video

Buffer manager. Internals

Buffer manager is one of the most hot spot in modern high load database system for which algorithms of multi-core scalability are continuously improved. Despite of its basic algorithms of access and page eviction are well known there is some gap in description of concurrency control mechanics and a whole machinery of buffer manager working in different scenarios for PostgreSQL. In current talk I'm going to expose the buffer manager internals from simple model to actual state highlighting some complex and subtle code fragments. Will talk about wait events around buffer internal routines, consider current and potential monitoring and instrumentation tools, existing and possible useful but little-known features.

openGauss and PostgreSQL contributor

Maxim Milyutun

13:10 – 14:00

Advanced

Lifehacks from a DBA

PostgreSQL performance, backups, Patroni, and other intriguing subjects are frequently discussed at conferences. Those are all very thrilling topics, but we often forget that a DBA might be the weakest link in the whole chain. The server performance matters subjectively less if the DBA gets burned out from routine. In my talk, I'll try to reveal some valuable hints for the DBAs to spend less time on repetitive activities, and free up time for more engaging and innovative work. Supposedly, everyone who's somehow engaged in DB administration will find the advice helpful.

Lead DBA, PGMechanix

Alexander Nikitin

15:00 – 15:45

Basic

Break

17:00 – 17:30

Evaluating your database's security. Ways to safeguard your elephant

Tech lead, Tantor Labs

I'll walk you through performing a security audit on your Postgres-based DBMS and show you how to address the issues. We will discuss community best practices and security guidelines made for the 'clean' version of Postgres that ensure security across various aspects, starting with network and transport security. We will also discuss techniques and resources usable for this challenging matter, and consider if it's always necessary to adopt new minor versions asap.

Artem Sergienko

17:30 – 18:15

Basic

First steps in Postgres core development

Questions like "How do I create a pull request?", "Do you have any good first projects to work on?", "What is the best IDE to use for development?" are frequently asked by community newcomers. Students create a lot of code, DBAs ask for novel features, and engineers keenly understand what is and is not worth being adopted, and all the viewpoints of those groups make sense. In this talk, I'll try to systematize questions and answers to help beginners get started with coding.

PostgreSQL contributor, head of open-source DBMS development unit, Yandex Cloud

Andrey Borodin

18:15 – 19:00

Basic

Buffet

19:00 – 21:00

Enhancing Postgres performance with data array vector processing

The 'one command, multiple data' concept is known to be implemented by the so-called vector instructions, enabling the CPU to process a set (vector) of records at once rather than just one. This is effectively used in graphics accelerators but also for PostgreSQL optimization, improving this technology further. In my talk, I'll reveal the distinctions between sequential and vector CPU data array processing, and demonstrate how to get up to 64x speed boost. We'll speak about the practicalities of employing Postgres-based SIMD and AVX, evaluate various vector processing techniques in relation to vector width, and evaluate the outcomes of synthetic tests. In addition, I'll demonstrate how sorting networks and other operations may be implemented using vector calculations and share some helpful guidance on maximizing efficiency and avoiding mistakes.

Developer, Tantor Labs

Artem Bugaenko

15:45 – 17:00

Advanced

Dinner

14:00 – 15:00

Watch video

Watch video

Watch video

Watch video

Watch video

Additional track

Time zone: MSK (GMT +03:00)

Coffee break

11:35 – 12:00

Deploying a fault-tolerant cluster with backup and replication to a cloud storage

I will talk about the components that make up such a cluster and how the system is deployed on clean servers. As part of the master class, we will analyze the necessary configuration files, consider mechanisms of emergency and forced switching of the leader in the cluster. We'll also look at creating cluster backups and building inside replication using a free solution as an example, as well as keepalived and haproxy joint work for SSO.

DevOps engineer, Tantor Labs

Maxim Bagirov

12:00 – 13:00

Basic

Anonimizing data with pg_anon

In this master class, we'll explain anonymization and how it works in pg_anon. We'll see the modes anonymizer has and how to get ready for each of them. Together, we'll run a basic scenario on a live demo, and answer all questions.

Senior developer, Tantor Labs

Maxim Ibragimov

10:20 – 11:35

Intermediate

Developer, Tantor Labs

Denis Rodionov

Watch video

Watch video