Training at PG Day'17 Russia

In the last post, we conducted a brief overview of the sections of the upcoming PG Day'17 Russia conference, which starts on July 5 in St. Petersburg. In today's final publication, we want to bring to your attention various interesting study events that we have prepared for the audience.

PostgreSQL training for PG Day'17 Russia

Alexey Lesovsky , our permanent speaker, a DBA with many years of experience, one of the leading experts of Data Egret, will present a master class on setting up a Posgres for Linux . Alexey is one of the leading experts in system administration of the Posgres and the surrounding infrastructure.

In his training, Alexey collected a wealth of information on how to configure PostgreSQL and hardware along with the operating system for optimal performance. Will consider the numerous components and their configuration. Separately, the methods of diagnosing and troubleshooting the operating system and Postgres itself will be studied.
')

Alexey Lustin, Technical Director of Silver Bulleters, will present the master class dedicated to the PostgreSQL service for 1C . Alexey has been involved in the implementation of 1C solutions in domestic business for many years, conducting trainings and training seminars on the development, administration and construction of technical processes.

The task of this master class is to teach you to effectively diagnose problems with the performance of the tool and to take effective steps to eliminate them. Especially for you, Alexey will review the necessary software and the order of its use, will talk about typical scenarios of 1C behavior and their display using pgBadger, will give recommendations on diagnosing and debugging problematic queries, and also explain what influence the versions of the platform and PG have on the stability " production ". Just the other day we published a detailed interview with Alexey, in which he tells in detail about the planned training.


Ivan Frolkov, an expert at Postgres Professional, will talk about the capabilities of Postgres Pro Enterprise , the domestic fork of PostgreSQL, intended for use in large businesses and state-owned companies, namely, autonomous transactions, distributed master, adaptive query scheduling, and many other features of Postgres Pro Enterprise, explain the differences assemblies from the "vanilla" version and will offer numerous examples of the use of new "features" in everyday development tasks.

Java and PostgreSQL: the secrets of high performance are not a master class, but a real rock concert. World stars will come especially for you: Dave Cramer , creator of the JDBC driver for PostgreSQL, and Álvaro Hernandez Tortosa , a Java expert and contributor to JDBC. Together with Vladimir Sitnikov , one of the most active contributors to the pgjdbc project, colleagues will spend the whole day telling and showing tricks and techniques of JDBC & pgjdbc. Master classes with speakers of this level are extremely rare things, but we have tried especially for you and managed to gather these three coolest specialists under one roof so that they could share their experience. Only practice, only Java, only hardcore!

Perhaps the most interesting event on monitoring will be a practical master class Monitor PostgreSQL with the Elastic Stack by Philip Crenna (Philipp Krenn), an engineer at Elastic. Everyone knows how to use the Elastic Stack to aggregate logs, but not everyone knows how to use this toolkit to effectively monitor the state of PostgreSQL, collect the necessary metrics, analyze logs and monitor queries performed. During the 4-hour workshop you can build such a tool under the strict guidance of Phillip to teach you all this.

What to do if you are a system administrator or a DevOps engineer, you do not have a DBA in your team, and the Postgres is heavily used in the project? Ilya Kosmodemyansky, the founder of DBA Data Egret, will help to survive in this situation. Ilya has prepared for you a master class on survival in difficult conditions . System administrators and DevOps often encounter a problem — there is no dedicated database administrator on the project, and PostgreSQL is increasingly “crazy” as the load grows.

In one academic day, Ilya will briefly tell the maximum amount of knowledge about the PostgreSQL DBMS, necessary and sufficient to start using it tomorrow and not repeating well-known errors. In this course there will be no excess of theory - it is not enough for some admin to really know the subtleties of the B + -tree device or to navigate in a variety of normal forms.

And, of course, two excellent master classes are devoted to MySQL performance: the architecture and performance optimization of InnoDB by Peter Zaitsev and the debugging of MySQL performance by Sveta Smirnova. In preparation for these large-scale events, we interviewed Peter and Sveta. Be sure to read them .

Computer science at PG Day'17 Russia

Teaching theories at a conference that is attended mainly by practitioners is not an easy task. The vast majority of modern specialists in DBMS look at things purely from a practical point of view. Such a tendency was formed for a reason - we all have to work in the limitations that form modern databases. Nevertheless, it is sometimes useful to take a step back, assess the current situation and understand which fundamentally new ways to solve a problem are possible?

This year we decided to take a chance by organizing a section on the more theoretical aspects of modern database science.

Viktor Leis , Ph.D. and professor at the Munich University of Technology, will come to share his experience with you. Victor's scientific career is devoted to the processing of requests, competitive access, data storage and other pressing problems of data warehouses. In his report, Victor will talk about research in query optimization and compiling queries into machine code, which formed the basis of his doctoral dissertation.

Andrei Nikolayenko , IBS Systems Architect, will offer you an overview of the main benchmark benchmarks for DBMS performance in a historical perspective, with a focus on the current state in the face of changing typical loads and the emergence of new DBMS classes.




Artem Barger , an employee of the IBM research team, an expert in building distributed industrial systems, will hold a two-hour seminar on the development of distributed cryptocurrency on the example of the HyperLedger project. HyperLedger is an open initiative aimed at creating a scalable distributed blockchain infrastructure. The seminar will be divided into two sections. The theoretical part is devoted to the issues of architecture, organization and the concept of blockchain. In the practical part, students will learn about the HyperLedger project API and get acquainted with the example of performing various operations that form the foundation for the functioning of a distributed database.

The section will be moderated by Evgeny Morgunov , Ph.D., associate professor of the Computer Science and Computer Engineering Department of the Siberian State Aerospace University. Eugene will also present to the audience a review of the Data Envelopment Analysis methodology for an empirical assessment of the performance of database specialists.

Looking forward to seeing everyone next week in St. Petersburg! Registration will be open until the start of the event.