title

text

June 20 – 21 , 2022

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
    минут общения

Доклады

Архив докладов

PGConf.Russia 2022
  • Oleg Bartunov
    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
    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
    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.

Все доклады

Партнёры

PGConf.Russia 2022

Informational

Partner