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
-
Andrey Zelensky Beresta RK LLCThe volume of data stored in Postgres Pro databases is growing rapidly. In some organizations, such databases have already exceeded tens of terabytes in size. The existing approaches to backups don't ensure timely backup and restore of data in such cases. We have supplemented the well-known and well-tested Postgres Pro backup tools with functionality that will allow users to backup and restore large databases. In addition to that, we have created our solution with the convenience of DBAs in mind.
-
Alexander Liubushkin LLC "FORS Telecom"
Rustam AbdrakhimovThe 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 .
-
Denis Sukhovei Aladdin R.D. JSC.
Alexey Sabanov Aladdin R.D. JSC.The myths and misconceptions of software import substitution. The acute threat of non-working DBMS servers. The basic plans for import substitution and problems of the transition period. DBMS data protection and the image of an ideal protection system. Crypto BD is the cryptographic data protection system. How does it work?
-
Anastasia Volkova DBeaverTasks 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.
Photos
Photo archive