Welcome to PGConf.Russia 2018

Very soon, namely, on February 5-7, 2018, Moscow will be hosting one of the main global conferences on PostgreSQL DBMS - PGConf.Russia . In this article we will announce the main reports of the conference, and tell you about the features of its holding this year.

Features of the conference format

This year, PGConf.Russia was supported by the Moscow State University. Mv Lomonosov. Of the faculties that have offered their venues for the conference, the Faculty of Economics, which occupies a modern, well-equipped and spacious building opposite the circus, is most suitable for its conduct. Of great importance to us is the support of the leadership of the faculty and the National Center for Digital Economy, which opened at the Moscow State University last year.

The conference at the university has determined the dates associated with the days of student holidays. For the same reasons, we put the program on its head: the day of the master classes will not be the first day, as before, but the last. So pay attention:

• Monday and Tuesday are the days of reports;
• Wednesday is the day of the master classes.

As before, the conference will be held in three streams. The conference will be opened by Oleg Bartunov, Fedor Sigaev and Alexander Korotkov with an overview of the interesting new products of the latest version of PostgreSQL and the main areas of development. The closing of the conference will be held on Tuesday evening, its main element will be the session of 5-minute blitz reports. Record on blitz-reports will be conducted directly during the conference. Some prepare them in advance; to others, the blitz reports provide an opportunity to express an idea suddenly lit up at the conference.

Reports February 5-6

A complete list of reports accepted on the day of publication of the article is given on the conference website in the “Program” section. Here we mention only individual reports, selected almost randomly and grouped by topic.

New technologies
Alexander Korotkov, Head of Development at Postgres Professional, will talk about Credereum for the first time - a promising blockchain transaction verification technology developed by this company in the DBMS. In a separate report, he will report on the development status of plug-in repositories that can improve performance or optimize volume at specific loads. Konstantin Knizhnik, one of the most experienced Russian DBMS developers, will tell about the VOPS vector extension created by him, which can significantly speed up the work with OLAP queries. Dmitry Ivanov and Maxim Milutin, the authors of pg_pathman , will compare the built-in Postgres table partitioning mechanism with several third-party solutions. Oleg Bartunov will make a report on the effective indexing of JSON's.

Backup, backup, replication
Andrei Borodin from Yandex will tell you about WAL-G - a tool for cloud backup written in Go. Mikhail Tyurin and Konstantin Evteev from Avito will share ways to use logical replication, which appeared in the 10th version of PostgreSQL, for data recovery . Gulchin Yildirim from “The Second Quadrant” will present a technology of almost non-stop upgrade based on logical replication.

Interesting migrations
Victor Brodlo will tell about petabyte of data transferred by him to PostgreSQL from Elasticsearch . Mark Lokshin from mail.ru will tell about the experience of transferring high-loaded game projects from MySQL to PostgreSQL . Alibek Kosymbaev from Kazakhstan will talk about large-scale migration from Orakla in Kazakhstan , and Alexander Litunenko from 2GIS, how they managed to speed up the application by half with post-rescue migration from MongoDB.

Postgis
The conference will be attended by two leading PostGIS developers - Olivier Kourten, who, in addition to the master class, will also make a report, and Dorofey Proleskovsky, who will talk about working with dynamic data flows in the taxi service Juno.

1C
1C works better and better on postgrese. And now Anton Doroshkevich from Infosoft will share his unique experience. Anton works with a large number of large 1C bases and is one of the best Russian experts in the field of Postgres + 1C . Dmitry Shitov from TsTP will talk about the difference between 1C on postgres with Windows and Linux .

DBA Adventures
Andrei Salnikov from Data Egret will share the serious experience of major updates , and Alexey Lesovsky will offer to discuss the possibility of turning off the vacuum . Sergey Kim and Vadim Yatsenko will talk about the practice of creating highly reliable clusters . Christoph Travers will talk about how he turned hundreds of terabytes into OLAP on postgrace , and Bruce Momgian will teach how to protect the database from all sorts of external attacks. Dmitry Sarafannikov from Yandex will share a very interesting experience of a major upgrade under load .

For the remaining reports - welcome to the conference site.

Master classes February 7

Not all the conference master classes are listed here, because their program is not yet fully defined.

Olivier Courtin (Olivier Courtin), one of the leading developers of PostGIS, will hold
large master class " Advanced spatial data analysis using PostgreSQL, PostGIS and Python ".

Yegor Rogov, who became famous for his record series of 8 (eight!) Habrovsky articles on indexes ( general issues of building and using indexes , device access methods and index connection mechanisms , Hash , BTree , GiST , SP-GiST , GIN , RUM ) came up with a master class in which he will train future users of the index.

Ivan Panchenko, Deputy General Manager of Postgres Professional, will present two small master classes - full-text search , which, in particular, will tell about new patches and extensions that improve the quality of the search, and about programming server-side procedures in non-standard PL languages / Perl, PL / Python, PL / v8 .

Bruce Momgian, one of the leading figures in the PostgreSQL international community, will give a master class on using window functions in PostgreSQL .

')

Gregory Smolkin, one of the creators of the pg_probackup backup utility, will conduct a master class on using pg_probackup for backup and recovery.

Alexey Klyukin and Alexander Kukushkin from Zalando will share their experience in managing highly available PostgreSQL clusters with Patroni.

What to do?

If you have not registered yet, it is not too late. The cost of participation will increase with the approach to the conference, so it is better to register in advance. Can I submit a report? . The deadline has already passed, and the program has been formed by almost one hundred percent. But there is a reserve, in case someone offers a super interesting report. Last year, for example, Hans-Jürgen Schönig was invited to reserve time with his Billion lines per second . In extreme cases, there are blitz reports. In addition, we plan to organize a living room of developers, where we can discuss with them our wishes on new features or fixes of old ones.

It is not too late to join the conference of sponsors and partners of the conference , to whom, taking this opportunity, I want to express my gratitude for the support.