Postrelease
Talks
Talks archive
-
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
-
Dmitry Susha Ispirer Systems Ltd.The report is focused on the topic of automation of migration to PostgreSQL from other databases using Ispirer Migration and Modernization Toolkit. The issues of data and SQL code migration, conversion of client applications, embedded SQL and database API will be covered, the examples of implemented projects of migration from Oracle to PostgreSQL and from Microsoft SQL Server to PostgreSQL will be given.
VIDEO
-
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
-
Vladimir Borodin YandexIt's not a secret that PostgreSQL connections are expensive so you should save them. To solve this problem there are PgPool-II and PgBouncer for quite a long time. At Yandex tens of thousands of connections to a single database is not a surprise so we use pgbouncer since time immemorial. This talk gives an overview of problems we faced and ways to solve them.
VIDEO
Photos
Photo archive