Soon PGConf.Russia 2019
PGConf.Russia 2019 is not far off - on February 4 master classes, 5-6th - reports. This year, as in the past, the conference is held at the Faculty of Economics of Moscow State University. The activity of the speakers at the time of collecting reports was noticeably higher than in previous years, so the program will be interesting. Even the silent 1C-nicks pulled themselves together: for the first time (together with Infostarte) they managed to assemble a whole section on the topic “Postgres for 1C”. So what awaits us?
The conference will be opened by Oleg Bartunov with the report “ Professional Postgres ”, in which he will tell about his outlook on the history and future of this DBMS, comment on world and Russian trends, and the highlight distributed control system of a modern NPP will be the jewel of the second day.
I'll tell you about other reports and master classes.
Let's start with all sorts of replications and clusters based on them. AVITO, which ate not one dog in this, in the person of Konstantin Evteev, again shares its findings in the report “ Stendby in battle ”.
Andrei Fefelov from Mastery.Pro will talk about choosing a cluster platform for a fault-tolerant system and hold a master class on the same topic, and Joshua Drake, founder and lead consultant of Command Prompt - the world's first postgresovoy company - will give a detailed report on logical replication . He will also have a master class on replication practice . Alexander Kukushkin from the team Zalando and Pavel Molyavin from 2GIS will also share their experience on building highly accessible clusters.
Andrei Salnikov will conduct a master class on major PostgreSQL updates.
Several reports are devoted to the topic of automation of DBMS administration. This topic includes the hypothetical sectioning of Julien Rouault, Tatsuro Yamada’s auto-planning with feedback and experiments with Nikolai Samokhvalov’s industrial tuning .
Ibrarar Ahmed from 2nd Quadrant talks about how to configure Linux for PostgreSQL , Chris Travers - how to save data from a damaged file system .
Amazon's Dignes Shahnesh Shah will share insight and practical tips on working with Amazon RDS.
Alexander Smolin from Russian Railways will talk about configuring and profiling VMware virtual infrastructure for intensive I / O in PostgreSQL .
Vasily Puchkov will tell about the integration of PostgreSQL into the corporate network with its authentication, protection and monitoring.
Pavel Trukhanov will talk about the use of USE and RED methodologies in OkMeter.
Two lectures are dedicated to the topic of Postgres in Docker - Lev Dragunov and Alexander Strizhevsky .
That the administrator feels when switching to Postgres, you can learn from the report of Irina Fast .
Miroslav Šedivý will conduct two master classes on working with PostgreSQL in Python - with the usual
psycopg2 and with asynchronous asyncpg .
Ivan Panchenko will hold a master class on developing stored functions in non-SQL-like procedural languages .
Artemy Ryabinkov for the first time on PgConf.Russia will talk about working with PostgreSQL in the Go language .
Alexey Fadeev will share his practice of using ORM .
Kamil Islamov will propose building business logic on CTE . Ivan Frolkov, an experienced developer and consultant, saddened by the mistakes of application developers, will shed his sadness in the report Typical application errors when working with Postgres .
Alexander Pavlov from Modbank will speak on a similar topic. Stepan Danilov from RT Labs will share his experience in optimizing SQL queries .
Alvaro Ernades from onGres (Spain, USA) organizes his migration experience from Oracle to PostgreSQL in a three-hour master class. Yuri Zhukovets from DocsVision will share his experience in migrating applied T-SQL code to PostgreSQL .
Developers will share the new and secret: Alexander Korotkov, who has recently become a PostgreSQL committer, will share his view of PostgreSQL's Bottlenecks and talk about what the 12th version is preparing for us , and Fyodor Sigaev about the new snapshots feature he is developing.
Anna Akenteva will talk about the features of Avtovaccum , which (so far) have not been documented.
Alexander Kuzmenkov will report on new optimizations for the execution of SQL queries.
Andrei Borodin will talk about the new WAL-G backup system and do it yourself index development , and why .
Artur Zakirov will present the pg_variables extension and show how and why it can replace temporary tables. The pg_threads extension for developing parallel code will be presented by its author Peter Yarmuz .
Esteban Zimani and Mahmoud Zakr of the University of Brussels will talk about the expansion of MobilityDB , which defines the types of data for working with mobile (space-time) data.
Ivan Muratov will talk about using a combination of PostgreSQL + PostGIS + TimescaleDB in a vehicle monitoring system, and
Dorofei Proleskovsky , one of the developers of PostGIS - about how PostGIS helps to study cataclysms and fight them.
Miroslav Šedivý will talk about the implementation of data bitemporality using interval types. About the concept of bitemporality can be found in the materials of Henriette Dombrowski .
Maxim Vikharev tells about how, having crossed PostgreSQL, ClickHouse and GreenPlum, get GreenHouseSQL . Denis Smirnov will reveal the internal structure of GreenPlum .
Stories about tulzy too. This is PGCenter (Alexey Lesovsky), Commvault (Boris Eshchenko),
XOBOT IDE (Alexander Fedorov and Andrey Khitrin, DBEaver developers).
A. Lyubushkin and R. Abrakhimov from FORS-Telecom will talk about their development of LUI - a tool for the collective development of the web-interface of application systems.
Our regular speaker Anton Doroshkevich is developing a new theme - the blockchain ( For the first time in Russia on 1C + Postgres ). Alexey Lustin from Silver Bulleters talks about how to deal with problematic queries, improving the code on the application side. Vladimir Timoshkin will talk about how 1C-nicks treat postgres without post-greessists .
Dmitry Yukhtimovsky from the company of Vyacheslav Gilyov, the famous performance expert 1C, will show magic tricks with subsequent exposure , and Alexander Sheludchenkov from the company Mitra will show something completely unexpected - 1C-ny cluster of MPI and Postgres on the GPU . Against this background, the report by Alexander Strizhevsky, who harnessed Docker, PostgreSQL and 1C , was not exotic.
Shortly after the conference, a professional certification program will open at Postgres Professional. It is announced by one of the authors of PostgreSQL training courses Pavel Luzanov . Get ready!
In addition to regular presentations and master classes, a blitz session will be held at the conference, where anyone who has signed up (only blitz reports will be available on conference days), will be able to give a short 5-minute presentation. And, of course, a buffet.
The conference will be opened by Oleg Bartunov with the report “ Professional Postgres ”, in which he will tell about his outlook on the history and future of this DBMS, comment on world and Russian trends, and the highlight distributed control system of a modern NPP will be the jewel of the second day.
I'll tell you about other reports and master classes.
Clusters and Replication
Let's start with all sorts of replications and clusters based on them. AVITO, which ate not one dog in this, in the person of Konstantin Evteev, again shares its findings in the report “ Stendby in battle ”.
Andrei Fefelov from Mastery.Pro will talk about choosing a cluster platform for a fault-tolerant system and hold a master class on the same topic, and Joshua Drake, founder and lead consultant of Command Prompt - the world's first postgresovoy company - will give a detailed report on logical replication . He will also have a master class on replication practice . Alexander Kukushkin from the team Zalando and Pavel Molyavin from 2GIS will also share their experience on building highly accessible clusters.
Administration
Andrei Salnikov will conduct a master class on major PostgreSQL updates.
Several reports are devoted to the topic of automation of DBMS administration. This topic includes the hypothetical sectioning of Julien Rouault, Tatsuro Yamada’s auto-planning with feedback and experiments with Nikolai Samokhvalov’s industrial tuning .
Ibrarar Ahmed from 2nd Quadrant talks about how to configure Linux for PostgreSQL , Chris Travers - how to save data from a damaged file system .
Amazon's Dignes Shahnesh Shah will share insight and practical tips on working with Amazon RDS.
Alexander Smolin from Russian Railways will talk about configuring and profiling VMware virtual infrastructure for intensive I / O in PostgreSQL .
Vasily Puchkov will tell about the integration of PostgreSQL into the corporate network with its authentication, protection and monitoring.
Pavel Trukhanov will talk about the use of USE and RED methodologies in OkMeter.
Two lectures are dedicated to the topic of Postgres in Docker - Lev Dragunov and Alexander Strizhevsky .
That the administrator feels when switching to Postgres, you can learn from the report of Irina Fast .
Development
Miroslav Šedivý will conduct two master classes on working with PostgreSQL in Python - with the usual
psycopg2 and with asynchronous asyncpg .
Ivan Panchenko will hold a master class on developing stored functions in non-SQL-like procedural languages .
Artemy Ryabinkov for the first time on PgConf.Russia will talk about working with PostgreSQL in the Go language .
Alexey Fadeev will share his practice of using ORM .
Kamil Islamov will propose building business logic on CTE . Ivan Frolkov, an experienced developer and consultant, saddened by the mistakes of application developers, will shed his sadness in the report Typical application errors when working with Postgres .
Alexander Pavlov from Modbank will speak on a similar topic. Stepan Danilov from RT Labs will share his experience in optimizing SQL queries .
Migration
Alvaro Ernades from onGres (Spain, USA) organizes his migration experience from Oracle to PostgreSQL in a three-hour master class. Yuri Zhukovets from DocsVision will share his experience in migrating applied T-SQL code to PostgreSQL .PostgreSQL Developer Reports: New Features and Clarification of Old
Developers will share the new and secret: Alexander Korotkov, who has recently become a PostgreSQL committer, will share his view of PostgreSQL's Bottlenecks and talk about what the 12th version is preparing for us , and Fyodor Sigaev about the new snapshots feature he is developing.
Anna Akenteva will talk about the features of Avtovaccum , which (so far) have not been documented.
Alexander Kuzmenkov will report on new optimizations for the execution of SQL queries.
Andrei Borodin will talk about the new WAL-G backup system and do it yourself index development , and why .
Artur Zakirov will present the pg_variables extension and show how and why it can replace temporary tables. The pg_threads extension for developing parallel code will be presented by its author Peter Yarmuz .
Geoinformation and space-time
Esteban Zimani and Mahmoud Zakr of the University of Brussels will talk about the expansion of MobilityDB , which defines the types of data for working with mobile (space-time) data.
Ivan Muratov will talk about using a combination of PostgreSQL + PostGIS + TimescaleDB in a vehicle monitoring system, and
Dorofei Proleskovsky , one of the developers of PostGIS - about how PostGIS helps to study cataclysms and fight them.
Miroslav Šedivý will talk about the implementation of data bitemporality using interval types. About the concept of bitemporality can be found in the materials of Henriette Dombrowski .
Analytical systems
Maxim Vikharev tells about how, having crossed PostgreSQL, ClickHouse and GreenPlum, get GreenHouseSQL . Denis Smirnov will reveal the internal structure of GreenPlum .
Tulzy
Stories about tulzy too. This is PGCenter (Alexey Lesovsky), Commvault (Boris Eshchenko),
XOBOT IDE (Alexander Fedorov and Andrey Khitrin, DBEaver developers).
A. Lyubushkin and R. Abrakhimov from FORS-Telecom will talk about their development of LUI - a tool for the collective development of the web-interface of application systems.
So what about section 1C?
Our regular speaker Anton Doroshkevich is developing a new theme - the blockchain ( For the first time in Russia on 1C + Postgres ). Alexey Lustin from Silver Bulleters talks about how to deal with problematic queries, improving the code on the application side. Vladimir Timoshkin will talk about how 1C-nicks treat postgres without post-greessists .
Dmitry Yukhtimovsky from the company of Vyacheslav Gilyov, the famous performance expert 1C, will show magic tricks with subsequent exposure , and Alexander Sheludchenkov from the company Mitra will show something completely unexpected - 1C-ny cluster of MPI and Postgres on the GPU . Against this background, the report by Alexander Strizhevsky, who harnessed Docker, PostgreSQL and 1C , was not exotic.
Shortly after the conference, a professional certification program will open at Postgres Professional. It is announced by one of the authors of PostgreSQL training courses Pavel Luzanov . Get ready!
In addition to regular presentations and master classes, a blitz session will be held at the conference, where anyone who has signed up (only blitz reports will be available on conference days), will be able to give a short 5-minute presentation. And, of course, a buffet.
Source: https://habr.com/ru/post/436872/