Error get alias
Moscow
Completed event
October 5, 2023
LOFT HALL, LOFT #4
Moscow, 2nd Kozhukhovsky drive, 29k6
PG BootCamp Russia 2023
PG BootCamp Russia 2023 was an event aimed at deepining practical skills when working with PostgreSQL DBMS. The program of the event was designed for both novice specialists and experienced developers willing to improve their knowledge of the PostgreSQL core and ecosystem and put that into practice.

The participants were able to get more up-to-date information on the effective use of PostgreSQL DBMS, listen to lectures and take part in practical master classes from leading experts in this domain.
About the event
PG BootCamp Russia 2023
Event summary
October 5, 2023
Moscow
speakers
11
participants
1 000
Watch presentations
workshops
lectures
6
6
Watch sessions
hours of video content
10+
Event highlights

Expertise

The participants learned firsthand about the most recent trends, technologies, and best practices, as well as how to identify new opportunities and utilize the most exciting PostgreSQL capabilities in your projects

Experience

Recognition

The participants got to know how to develop efficient database schemas, optimize queries, maintain data security, and much more while working with PostgreSQL
PG BootCamp Russia 2023 followed the international guidelines, was recognized by the worldwide PostgreSQL community and directly contributed to its development
Networking
A great place to meet in the PostgreSQL community, an ideal environment for communicating with colleagues and industry experts with opportunities for future collaboration
Travel partner
Media partners
Supporters
Conference program

09:30 – 10:00
Guests registration at the venue
10:10 – 11:10
PG BootCamp Russia 2023 Welcome speech
Michael Goldberg
Member of PostgreSQL Code of Conduct Committee (as of 2020), Chair (as of 2023), Member of PG BootCamp Initiative Group, PGDay Israel Conferences Organizer (as of 2017)
CEO, Tantor Labs
Vadim Yatsenko

Download presentation

Watch footage
Working with psql effectively
basic
What does a beginner PostgreSQL developer need to know?
GiST index news
medium

Lectures

10:10 – 11:10
Andrey Borodin
PostgreSQL Contributor, Yandex Cloud
View presentation
Watch lecture
Generalized Search Trees (GiST) are one of the distinctive architectural features of Postgres. GiST uses the idea of dividing objects into groups based on some similarity feature. At the same time, it is already very different from the original scientific papers in which the first ideas were proposed. You will learn about the innovations and features that are still in development.
Autovacuum. Bad advice
medium
11:10 – 12:10
Vadim Yatsenko

CEO, Tantor Labs

View presentation
Watch lecture
In this report, I will tell you about one interesting, in my opinion, case of our client. I will share how a series of errors at different stages of the database lifecycle once led to its complete shutdown for more than a week, wraparound, broken blocks, maintenance problems and sleepless nights in search of a solution.
12:10 – 12:30
Coffee break


medium
SQL HowTo: Graph Algorithms
12:30 – 13:30
Kirill Borovikov

Leading Database Architect, Tensor

View presentation
Watch lecture
I will talk about how to use PostgreSQL to turn a fly into an elephant, build a maze or find a mutual friend.
13:30 – 14:30
Lunch
Workshops
basic
14:30 – 15:50
Ilya Evdokimov
Senior Developer, Tantor Labs
View presentation
Watch workshop
You will learn about why PostgreSQL, and not MySQL, NoSQL or something else, learn about the PostgreSQL community, who are the committer and contributor, major contributor, how to get into the PostgreSQL community, how to build PostgreSQL and how to debug it, and much more.
16:00 – 17:20
Vladimir Vinogradov
DevOps Team lead, Tantor Labs
View presentation
Watch workshop
15:50 – 16:00
Working with the database through the psql terminal client can be useful and productive. Let's get acquainted with connecting to a cluster via psql, learn how to use meta commands, manage output and input, see how you can use the query buffer – and all this with examples.
Coffee break


Writing a PostgreSQL extension
medium
17:30 – 19:00
Ilya Evdokimov
Senior Developer, Tantor Labs
View presentation
Watch workshop
Let's look at why it's worth starting with extensions, how to write .the c file and the test for it, how to write a Makefile and how to install the extension in PostgreSQL.
17:20 – 17:30
Coffee break
19:00 – 21:00
Buffet table
Hint-based optimization: from pg_hint_plan extension to modern ML solution
Autonomous transactions in PostgreSQL
Lectures
10.10 – 11.10
advanced
View presentation
Watch lecture
Autonomous transactions (AT) are executed independently of the main transactions that trigger them, and will be completed successfully even if the main transaction has rolled back. Let's look at what ATs are, how and when they are used, what are the possibilities, limitations and implementation mechanisms.
11.10 – 12.10
Dmitriy Dorofeev
Chief architect, Luxms
View presentation
Watch lecture
What can PostgreSQL offer to server application developers today and in the near future? We will share our experience and talk about the prospects, about hot code reloading, updating application versions, comparing strongly typed data with JSON, FDW and http API calls directly from the database, as well as plv8 and PL/pgSQL.
12.10 – 12.30
Coffee break
Optimizing cascade queries with Greenplum ORCA
12.30 – 13.30
Maxim Milutin
Senior Database Engineer, RRI Huawei
View presentation
Watch lecture
Vanilla PostgreSQL implements a query optimizer that has its roots back in the 1970s. The method is still relevant today, but there are some drawbacks. In the report, we will talk about an alternative that is gaining more attention , is much more extensible and has other advantages. In the PostgreSQL world, this framework is implemented in the ORCA product for the distributed analytical database Greenplum.
13.30 – 14.30
Lunch
Workshops
14.30 – 15.50
Andrey Borodin
PostgreSQL Contributor, Yandex Cloud
View presentation
Watch workshop
Let's analyze the exploitation of several Postgres vulnerabilities. The information is intended only for educational purposes and for auditing technical systems. Remember about administrative and criminal liability in case of illegal use of acquired knowledge!
16.00 – 17.20
Sergey Zinchenko
R&D engineer, RRI Huawei, openGauss Contributor
View presentation
Watch workshop
15.50 – 16.00
Coffee break
medium
To build or not to build…, or Building the PostgreSQL from sources in a proper way
17.30 – 19.00
Vadim Ponomaryov
Team lead, Tantor Labs
View presentation
Watch workshop
17.20 – 17.30
Coffee break
19:00 – 21:00
Buffet table
Using PostgreSQL as an application server
Vadim Yatsenko
advanced
CEO, Tantor Labs
Exploiting the historical vulnerabilities (CVE)
Ivan Kushnarenko
Senior Developer, Tantor Labs
advanced
medium
The optimizer is the DBMS brain that chooses the way queries are executed. And sometimes... it makes mistakes. Let's figure out why this happens and how to fix its errors using the pg_hint_plan extension, then let's step a little further and train the neural network to automate the process.
advanced
A master class on how to build PostgreSQL from source and test it, how to work with patches to Postgres code, and why an ordinary developer might need all this.
Program committee
Selection completed
Applications accepted
Aug, 20 – Sep 25, 2023
Michael Goldberg
Member of PostgreSQL Code of Conduct Committee (as of 2020), Chair (as of 2023), Member of PG BootCamp Initiative Group, PGDay Israel Conferences Organizer (as of 2017)
Maxim Milutin
PostgreSQL Contributor, Huawei RRI
Umair Shahid
PostgreSQL Code of Conduct Committee Member (2019–2022) and Chair (2021-2022), Founder, Stormatics
Organizing committee
Vadim Yatsenko
Andrey Borodin
PostgreSQL Contributor, Yandex Cloud
CEO, Tantor Labs