Postrelease
Talks
Talks archive
-
Igor Chizhevskiy SRC "Voshod"
Sergey Korolev MCST
Dmitry Pogibenko FGBU "NII Voskhod"
Stanislav Merzlyakov Scientific Research Institute "Voskhod"
Илья Космодемьянский Data Egret.jpg.180x180.jpg "Иван Богданов")
Иван Богданов SRC "Voshod"Practical experience of carrying out import substitution with using PostgreSQL in government information system including not only the free software, but also the Russian hardware (Elbrus servers and other).
VIDEO
-
Ildar Musin PostgresPro
Dmitry Ivanov PostgresProPartitioning is a long-awaited feature in PostgreSQL. Although Postgres supports partitioning via inheritance, this approach has some disadvantages, such as the need to manually create partitions and support triggers, significant planning overhead, and no query execution optimizations. In this talk, we’ll tell you about the pg_pathman extension we are developing. pg_pathman supports HASH and RANGE partitioning, performs planning and execution optimizations, supports fast insert by using Custom Node instead of triggers, provides functions for partition management (add, split, merge, etc.), supports FDW, non-blocking data migration, and more. We'll also speak about pg_pathman integration with Postgres Pro Enterprise Edition and Oracle-like syntax support for partitioning. Finally, we'll discuss new partitioning capabilities in PostgreSQL 10, the already implemented features and further development plans.
VIDEO
-
Nicholas Sivko okmeter.ioIt often happens that you already have PosgtreSQL in production, but you don’t have a DBA. To demystify the PostgreSQL database, I’ll tell you how to troubleshoot various problems while working with PosgtreSQL. We will try to understand how to answer "routine" questions of a typical system administrator: - Is everything OK with the database? - What consumes DB server resources? - What to optimize first to reduce resource consumption?
VIDEO
-
Maksim Viharev AlyticsIn the data persistence layer, using PostgreSQL from the very start of development, we went all the way from a small cluster on a virtual machine to a multi-host system that provides near real-time processing of mixed OLTP/OLAP load. In this talk, I’m going to tell you about the main development stages of our analytical solution at the application and infrastructure levels, and describe the specifics of using PG that we encountered.
VIDEO
Photos
Photo archive