title

text

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
  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 35 talks
  • hybrid
    format

Talks

Talks archive

PGConf.Russia 2022
  • Vadim Yatsenko
    Vadim Yatsenko

    PostgreSQL has a number of peculiarities that you need to take into account not only while maintaining your database but also when designing your database schema. Experienced PostgreSQL are well aware of vacuuming process. On the web one can find tons of materials covering its internals, configurations and monitoring. Many valuable talks about vacuum were given at numerous conferences. However, we still face the common wraparound problem when the maximum possible number of transactions (xid) is reached. It happens even on databases that are relatively small in size. In my presentation, I will share a customer case that looks interesting to me. A chain of mistakes made at different stages of the database's life cycle once caused a disaster. The database fully stopped for one week, we detected a wraparound and spotted corrupted blocks. Maintenance was problematical, and we spent sleepless nights in search of a solution. We managed to achieve a local win as we finally restored the database, but it's not the end of this story, which makes it even more interesting.

  • Alexander Nikitin
    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.

  • Alexander Liubushkin
    Alexander Liubushkin LLC "FORS Telecom"
    Rustam Abdrakhimov
    Rustam Abdrakhimov

    The talk covers the use of PostgreSQL, LUI and LUI4ORA2PG for building an analytical reporting system.

    The talk tackles the following topics:

    • migration from an Oracle environment;
    • application of JSON functions;
    • how the temporary tables helped us;
    • our own means for load testing and bottlenecks detection;
    • how to make beautiful GeoJSON format maps to display diagrams on them;
    • installation and testing of the system on an "Elbrus" computer;
    • what became an obstacle or was missing when using PostgreSQL.

    The history of growth of the Live Universal Interface (LUI) web application development tool and the LUI4ORA2PG migration tool can be found in our previous presentations at PGConf conferences:

    https://pgconf.ru/2019/118109 ;

    https://pgconf.ru/201911/264095 ;

    https://pgconf.ru/2020/262456 ;

    https://pgconf.ru/2021/288310 .

  • Anastasia Volkova
    Anastasia Volkova DBeaver

    Tasks for migrations from the classic commercial DBMSs to open-source solutions are still relevant nowadays. Tools used to migrate Oracle applications to PostgreSQL has already proved to be efficient. But what if you have SQL Server? We want to introduce you to Babelfish, a OSS solution based on PostgreSQL 13. Babelfish supports TDS network protocol, T-SQL language, and SQL extensions specific to SQL Server. However, it isn't that simple. In our talk, we'll cover the features ensuring compatibility with SQL Server, existing problems and ways to solve them. Bonus: we'll also share the story on how we added the Babelfish support in DBeaver using the JDBC driver from Microsoft.

All talks

Partners

PGConf.Russia 2022

Informational

Partner