PgConf.Russia 2017 - we invite you to the March conference in Moscow

In March, the third international conference PgConf.Russia will be held in Moscow for the third time. For the first time, the conference gathered about 460 participants, in the second - about 600, at those times it was a world record for events dedicated to PostgreSQL, which, along with the high information richness of the program, confirms the tremendous interest in this DBMS in Russia. Presentations and videos of reports of past conferences are available at https://pgconf.ru/2016 and https://pgconf.ru/2015 .

Traditionally, the first day of the conference, March 15, is dedicated to master classes, and the next two days, March 16 and 17, to reports. Reports will go in three streams, and will begin immediately after a short opening. At the very end of the conference, the participants will come together again in a session of blitz reports.

The conference will be held at the Digital October site in the center of Moscow.

Differences from the previous conference

The first PgConf.Russia took place two years ago. And now we see radical changes, many interesting projects have been implemented at Postgres in Russia, many projects are still being developed, the Russian community has become more mature and more active, including in terms of submitting reports to the conference. Therefore, the conference has become more specific, more technical, more Russian. The time when it was necessary to promote Postgres in Russia, has passed, the time has come for this work. Therefore, the new conference will have more practical reports from the “fields”, and less rhetoric.

Workshops (March 15)

It is recommended to come to the master class with your own laptop. In this case, you can try everything that the speakers show. As a rule, they will offer for downloading some materials, or images of virtual machines, containing the environment ready for the exercises of the master class.

The master classes program includes the following topics:

• D. Vasiliev. Mamonsu is a Swiss knife for controlling and monitoring PostgreSQL .
• I. Panchenko. JSON, JSONB, JSQuery .
• F. Sigaev, A. Zakirov. Full-text search capabilities in PostgreSQL.
• A. Hernandez. Java programming for PostgreSQL .
• D. Lebedev. Explore geodata using PostGIS and related tools .
• E. Horn. ProBackup: fast, reliable, incremental.
• P. Luzanov. Overview of tools for debugging, profiling and tracing server code.

Reports (March 16 and 17)

A list of accepted reports can be viewed on the conference website at https://pgconf.ru/2017 . Here we will give a brief overview of the main topics covered by the reports already adopted.

The architecture of complex and high-performance systems is always a topical issue. Let's start with her.

As you know, the Skype platform is built mainly on PostgreSQL, has been working on it for many years and serves more than 2 billion subscribers. The total number of transactions per second reaches hundreds of thousands. Skype Alexey Plotnikov will talk about the architecture and experience of using Skype databases . There will be another report from Skype - Radoslav Glinsky, about how a test environment is organized in Skype and how its adequacy to the production environment is ensured.

Vladimir Borodin will make a report on how Yandex addresses the issue of maintaining tens of thousands of connections to a single database. Yandex Mail completed the transition to Postgres last year. The daily audience of this service exceeds 10 million people, the daily number of incoming letters is more than 150 million.

Christopher Travers will talk about his experience with dozens of terabytes of databases in science , and Dmitry Beloborodov from UIS, CoMagic about how the company went from a couple of gigabytes to multi-terabyte databases , and what technological and organizational practices have been gained.

The Vadim Yatsenko report from Progress Soft focuses on how the system was created, the data volume of which grows by more than 1 billion records per day, which technical solutions made it possible to save a lot on the amount of stored data, how design errors were eliminated and new versions of Postgres helped solve these problems.
')

Alexey Lesovsky, a renowned PostgreSQL maintenance expert, will talk about troubleshooting issues with streaming replication operations . Ilya Kosmodemyansky will present a report on the interaction of the DBMS with the Linux I / O subsystem on how to achieve maximum performance when reading and writing data.

Dmitry Vasiliev, the author of mamonsu , Dmitry Vagin from AVITO and Nikolay Sivko from Okmeter will tell about various aspects of the monitoring implementation.

PostgreSQL and 1C . An important topic, as many organizations using the 1C platform, consider the transition from Microsoft SQL Server to PostgreSQL, but this transition is often hampered by a lack of information. Therefore, on PgConf.Russia a separate section will be devoted to topics 1C. The report section from the Postgres Professional company will open, in which it will be told how the new Postgres developments can improve 1C performance. Then Anton Doroshkevich from Infosoft and Dmitry Yukhtimovsky from gilev.ru, leading companies solving the most difficult tasks of operating 1C, will perform. Their reports will be devoted to practical experience with large databases. We also expect a report from the company 1C.

Clusters, distributed processing and fault tolerance. The topic will be opened by a review report by Stas Kelvich, who will also talk about the current status of Multimaster with support for distributed transactions and fault tolerance. Ildar Musin will talk about the current partitioning status of tables in Postgres, the pg_pathman extension, and distributed partitioning using FDW. Ivan Frolkov will tell about the new feature - alienable (portable) tables , which allow to solve many administrative tasks and improve the performance of a number of operations. A report on working with BDR under load is also expected.

Practical organization of fault-tolerant configurations will be devoted to the reports of Mikhail Kulagin from Postgres Professional and Alexander Kukushkin from Zalando. Demonstration of failover clusters and Multimaster can be viewed and discussed at the Postgres Professional booth.

Marco Slot will talk about how Citus DB aims for a million records per second, and Dave Cramer from Pivotal will talk about the architecture and practical side of Greenplum.

A pleasant surprise will be the story of the Voskhod team and the MCST on how and why to launch Postgres on Elbrus . As is known, this team is engaged in the creation of a state system for registering passport and visa documents. Also, the speakers will address issues of fault tolerance and increase the reliability of data storage.

As you know, the Postgres Pro team develops RUM, an advanced version of GIN indices that allows you to speed up full-text search. Oleg Bartunov’s report “RUM-indices and their application” will tell about him. Marcus Nullmeier of the University of Heidelberg will talk about his development of RUM ideas and his developments that improve RUM and add data compression in the index. The topic of index extensibility is also covered in the report by Andrei Borodin from Oktonika.

The theme of the JIT compilation of SQL queries will be revealed by Dmitry Melnik from the ISP RAS team. This is a very popular development direction for PostgreSQL now, which allows you to increase the performance of complex queries by about an order of magnitude, and sometimes more. The ISP RAS team has advanced further in this direction.

Mikhail Shurutov from Postgres Professional will talk about various ways to implement offline transactions .

Oleg Ivanov from Moscow State University will present his extension for Postgres 9.6, which implements the optimization of queries to the DBMS using machine learning technologies .

Semi-structured data and capabilities for working with them is one of the well-known advantages of Postgres. Alvaro Hernandez , the developer of ToroDB, will talk about the transparent migration of data from MongoDB to Postgres.

Alexander Alekseev from Postgres Professional will talk about the ZSON extension developed by him for vocabulary JSON compression . Roland Zonnenshain's report will focus on using JSON (B) in production management .

The reports by Andrey Fefelov and Sergey Mirvoda will discuss the use of Postgres in BI systems, and the report of Maxim Viharev on the use of Postgres in the Alytics contextual advertising system . The theme of PostGIS will be devoted not only to Dmitry Lebedev's master class, but also to the presentation by Dorofey Prolesovsky “ Moving Goals in PostGIS ”.

These are not all reports, but only a part, and the full list can be seen on the conference website.

The conference is international in its mood; last year’s success made a big impression on the community, and many famous people accepted the invitation or expressed their desire to speak at PgConf.Russia, despite the language barrier (as a rule, international conferences are held in English, at PgConf. Russia is the working language of Russian, and professional double-sided simultaneous translation will work in all halls).

The conference is not only reports, but also communication. Therefore, this year PgConf.Russia will host 2 round tables: “Problems of import substitution and transition to domestic or free software” and “The Future of IT Education”, and the living room of developers, where you can ask questions to Russian and foreign developers Postgres, and discuss with they are any problems.

What to do if you do not have time to submit a report? As you can see on the site, the form of receiving reports continues to operate. We have left several backup slots for which several more reports compete. If you offer something interesting, it will definitely be considered. In addition, there is an opportunity to speak at the session of five-minute blitz reports, which will be recorded directly at the conference. If you want to speak at the round table, write about it at info@pgconf.ru . At the same address, the organizing committee will answer any questions about the conference.

How to get involved?

To participate in the conference you need to register on the site https://pgconf.ru/ . Participation can be paid by card on the site or request an invoice for payment through the bank.

Other PostgreSQL World Community Events

Conferences like ours are held in the world, each of them has its own specifics. For developers of the database engine, the main one is PgCon , traditionally held in Ottawa. There are several annual conferences for users in the United States, the largest are PgConf.US in New York and PgConf.Silcon Valley in San Francisco. In Europe, PgConf.EU takes place each year in the fall , and in Asia - PgConf.Asia and PgDay.Asia . There are two large conferences in Russia - Moscow PgConf.Russia and St. Petersburg PgDay . At HighLoad ++ and regional IT conferences on postgres, there are also usually several reports. Postgres Professional conducts free seminars and training courses in various cities of Russia, including the next January bouquet seminar at Peterservis office in St. Petersburg. Further plans have not yet been published, but this year it is planned to hold several small events in the Black Earth, Volga region, in the South and beyond the Urals. The RuPostgres Russian mitap group often organizes small but dynamic events. The nearest of them in Moscow will be devoted to full-text search in PostgreSQL.