June 20 – 21 , 2022
PGConf.Russia 2022
PGConf.Russia 2022
PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 700 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 2-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.
Thems
- PostgreSQL technology frontiers for highest workloads, huge databases, mission-critical applications
- PostgreSQL scalability for transactional and analytical workloads
- New features in PostgreSQL and around: PostgreSQL and its ecosystem development
- PostgreSQL for business software applications: system architecture, migration issues and operating experience
- PostgreSQL specific features and their applications: JSON(b), (geo)Spatial data, Full text search
Talks
Talks archive
-
Oleg Bartunov PostgresPro
Nikita Glukhov PostgresProIn this presentation, we'll talk about the newest SQL/JSON features committed to PostgreSQL 15. We'll explain how to use them, where they can help and why they make a difference. Is PostgreSQL JSON implementation fully compliant with SQL:2016? In the meantime, the next generation of the SQL standard is being developed. What will the new standard include, and how will Postgres respond to it?
-
Dmitry Vasilyev PostgresProMy talk covers PostgreSQL infrastructure in Ozon: - how do we tune virtual machines (KVM); - which version control system we have created; - which drivers we make and how it relates to fault tolerance and load balancing; - how do we make "hot" upgrades for the parameters of our virtual machines.
-
Denis Volkov YandexSPQR is a lightweight OLTP sharding solution written in Go. In this talk, I'm going to discuss design decisions that led us through FDW-based sharding, CustomNode-based sharding, C-implemented lightweight query routing, and finally to SPQR design.
-
Alexander Nikitin ЗАО «ЦФТ»We'll talk about the ways to change the database records without updates. To do this, we'll explore what's going on at the lowest level and see what can happen if we make changes in data files in different operation modes.
Photos
Photo archive