PGConf.Russia 2022

Radisson Slavyanskaya Business Center, Square of Europe 2, Moscow

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

более
0 участников
0 докладов
гибридный
формат
0
минут общения

Oleg Bartunov Postgres Professional

N

Nikita Glukhov Postgres Professional

45 мин

SQL/JSON и дальше

In 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?

Материалы к докладу
Yury Zhukovets ЗАО Дилжитал-Дизайн

22 мин

Временные таблицы как наследие перехода с MS SQL. Проблемы, оптимизация, подходы

Usage of temporary tables in PostgreSQL causes additional issues like high server resources consumption and low query performance. However, sometimes you need to rely on them especially when you need to migrate your code from MS SQL, and your initial code employed them, and you had some logic implemented at the database level. This talk covers issues related to usage of temporary tables when migrating from MS SQL, and the ways to resolve them using built-in PostgreSQL features based on the scenarios contained in the code.

Материалы к докладу
Igor Kosenkov Postgres Professional

22 мин

КУК без потерь

Disaster-tolerant cluster implies minimal data loss in the event of the main data center disaster and switching to the backup data center. The data loss takes place due to the asynchronous replication between the main data center and the backup one. However, there's a solution that can resolve the existing problem and ensure zero data loss in the case of the main data center disaster. My talk covers this solution for zero data loss.

Материалы к докладу
A

Alexander Bychkov ООО "Эльбрус-2000"

Н

Николай Глазков ООО "Эльбрус-2000"

22 мин

Миграция учетной системы ФГУП «Госкорпорация по ОрВД» с СУБД Oracle на Postgres Pro

This talk covers the Oracle-to-Postgres Pro migration project for the billing system of the Federal State Unitary Enterprise “State Air Traffic Management Corporation of the Russian Federation” employed to collect the air navigation charges for the use of airspace.

Материалы к докладу