PG BootCamp Russia 2024
Improving PostgreSQL skills
September 17
Kazan
PG BootCamp Russia: mission and goals
We strive to support the use and development of PostgreSQL as a powerful and reliable relational database management system, contribute to the knowledge sharing and deepening among both beginners and professionals, promote experience sharing and engagement among PostgreSQL users, developers, and administrators in Russia and abroad.
Our goal is to bring together PostgreSQL experts and enthusiasts and contribute to the development and promotion of this robust database management system. We strive for becoming a platform where people can get knowledge, help, and inspiration for their projects.
Recent event
PG BootCamp 2024
April 16, 2024
Minsk
PostgreSQL is a powerful, reliable, and flexible open-source DBMS that is widely used in the industry and becoming increasingly popular and relevant. PostgreSQL offers a rich set of functions, supports extensions, provides high performance, and has excellent scalability.

Thanks to these advantages, PostgreSQL is chosen by an increasing number of organizations.
PostgreSQL is a global attention grabber
+1
120+
major release a year
контрибьюторов
years of development
40
Latest releases
The PostgreSQL Global Development Group has released an update to all supported versions of PostgreSQL, including 16.4, 15.8, 14.13, 13.16, and 12.20, as well as the third beta release of PostgreSQL 17. This release fixes 1 security vulnerability and over 55 bugs reported over the last several months. You can find details on the fixes in the release notes.

You can find information about all of the PostgreSQL 17 features and changes in the release notes. Your testing and feedback will help the community ensure that the PostgreSQL 17 release upholds our standards of delivering a stable, reliable release of the world's most advanced open source relational database. Please read more about our beta testing process and how you can contribute.

PostgreSQL 12 will stop receiving fixes on November 14, 2024. If you are running PostgreSQL 12 in a production environment, we suggest that you make plans to upgrade to a newer, supported version of PostgreSQL. Please see our versioning policy for more information.
15.8
2024-08-08
16.4
2024-08-08
14.13
2024-08-08
13.16
2024-08-08
Other events
2024-08-30
2024-09-09 – 2024-09-11
2024-09-11
2024-09-30 – 2024-10-02
2024-10-20
2024-10-22 – 2024-10-25
Indicates that an event is recognised under the community event guidelines and is directly helping the PostgreSQL community.
2024-09-17
12.20
2024-08-08
PG BootCamp 2024 Minsk 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)
Vadim Yatsenko
CEO, Tantor Labs
10:00 – 10:10
Resolving long-standing bugs, with plv8 as an example
I'll explain how we worked around a long-standing bug in plv8 that was related to the return of scalar JSON values from Javascript functions. We managed to fix the issue, addressing it at the level of the original project to ensure stable operation for all users, rather than using crutches in our code. We will discuss whether it’s worthwhile to push this further because the format for returning NULL data still remains a problem, and also we’ll share the history of this particular pull request's acceptance on GitHub and make some suggestions for those who still doubt to get involved as contributors.
Dmitriy Dorofeyev
Chief architect, Luxms
14:30 – 15:20
Intermediate
Lunch
13:30 – 14:30
PostgreSQL: from a replica to a high-availability cluster
Get ready for a trip through the essential techniques for building a robust and expandable PostgreSQL cluster! We'll start from the fundamentals, explore the synchronous and asynchronous PostgreSQL replication, speak about Patroni, a crucial tool for managing sharding and replication, and its role in automating cluster recovery and failure detection. Using a live example, we’ll see how the cluster functions and add HAProxy and PGbouncer for more efficient load balancing and high availability, and also use keepalived to ensure continuous system operation. Generally speaking, we’ll overview a combination of technologies assemblable into a highly available and scalable PostgreSQL cluster.
Vladimir Vinogradov
DevOps Team lead, Tantor Labs
12:30 – 13:30
Basic
Сoffee break
12:00 – 12:30
int –> bigint migration
When a system starts to expand, it frequently occurs that previous successful features eventually stop functioning. When it comes to data type overflow, this is precisely true. If int4 was sufficient at the start of the project, it could eventually run out entirely and you'll need to move to bigint.
In this talk, I will outline the challenges that DBAs encounter, explain how to address those issues, and present a tool that will make them much easier.
Alexander Nikitin
Lead DBA, PGMechanix
11:05 – 12:00
Intermediate
Postgres Protocol: advantages, drawbacks, and pitfalls
In this paper, I'll discuss the Postgres client-server interaction structure. Even though the protocol has been in place for 20 years, it is now evident there was a better way to implement some parts of it in the past.
PostgreSQL сontributor, head of open-source DBMS development unit, Yandex Cloud
Andrey Borodin
Download presentation
Github
Github
Watch video
YouTube
YouTube
Rutube
Rutube
10:10 – 11:05
Advanced
Guests registration at the venue
09:30 – 10:00
Conference program
Download presentation
Github
Github
Watch video
YouTube
YouTube
Rutube
Rutube
Download presentation
Github
Github
Watch video
YouTube
YouTube
Rutube
Rutube
Download presentation
Github
Github
Watch video
YouTube
YouTube
Rutube
Rutube
Download presentation
Github
Github
Watch video
YouTube
YouTube
Rutube
Rutube
Join the
PG BootCamp channel
on Telegram
Greetings and announcements from PG BootCamp speakers
Useful tips and best practices for using PostgreSQL
News and updates about PostgreSQL and its ecosystem
PostgreSQL learning resources
Discussions and responses to your questions from the PostgreSQL community
News
    Global resources
    PG BootCamp Russia resources
    PG BootCamp Russia
    This website uses cookies to function properly. See cookies policy
    Essential cookies
    Always On. These cookies are essential so that you can use the website and use its functions. They cannot be turned off. They're set in response to requests made by you, such as setting your privacy preferences, logging in or filling in forms.
    Analytics cookies
    Disabled
    These cookies collect information to help us understand how our Websites are being used or how effective our marketing campaigns are, or to help us customise our Websites for you. See a list of the analytics cookies we use here.
    Advertising cookies
    Disabled
    These cookies provide advertising companies with information about your online activity to help them deliver more relevant online advertising to you or to limit how many times you see an ad. This information may be shared with other advertising companies. See a list of the advertising cookies we use here.