PG BootCamp 2023 Moscow

Error get alias

Conference program

Moscow

October 5, 2023

Completed event

LOFT HALL, LOFT #4
Moscow, 2nd Kozhukhovsky drive, 29k6

PG BootCamp Russia 2023

This event was conducted under the community event guidelines.

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

Watch recorded sessions

hours of video content

10+

See complete gallery

Postgres community event

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 2024 Minsk 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)

Download presentation

Watch video

CEO, Tantor Labs

Vadim Yatsenko

Working with psql effectively

What does a beginner PostgreSQL developer need to know?

basic

GiST index news

Lectures

10:10 – 11:10

medium

Andrey Borodin

PostgreSQL Contributor, Yandex Cloud

View presentation

Watch video

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

11:10 – 12:10

Vadim Yatsenko

CEO, Tantor Labs

medium

View presentation

Watch video

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 video

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

14:30 – 15:50

Ilya Evdokimov

Senior Developer, Tantor Labs

View presentation

Watch video

basic

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 video

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.

Writing a PostgreSQL extension

17:30 – 19:00

Ilya Evdokimov

Senior Developer, Tantor Labs

15:50 – 16:00

Coffee break

View presentation

Watch video

medium

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 video

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 video

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 video

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 video

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 video

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 video

17.20 – 17.30

Coffee break

19:00 – 21:00

Buffet table

Using PostgreSQL as an application server

advanced

Exploiting the historical vulnerabilities (CVE)

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.

Vadim Yatsenko

CEO, Tantor Labs

Ivan Kushnarenko

Senior Developer, Tantor Labs

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