Program

Download

4 February 2019, Monday . Tutorial sessions

	Hall П8, 4nd floor	Hall П3, 2nd floor	Hall П7, 4th floor
09:00	Registration (daylong) Passport is required welcome coffee break
10:00	Andrey Fefelov Postgres + patroni + consul + s3 + walg + ansible = Simple HA cluster (90 min)	Joshua Drake Postgres Performance and Maintenance (180 min)	Álvaro Hernández Oracle to PostgreSQL Migration Tutorial (180 min)
11:30	Сoffee break (30 min)	Сoffee break (30 min)	Сoffee break (30 min)
12:00	Ivan Panchenko NoSQL/PL: Programming in non-SQL-like procedural languages (90 min)	Joshua Drake (continued)	Álvaro Hernández (continued)
13:30	Lunch (60 min)
14:00
14:30	Andrei Salnikov Major upgrade for PostgreSQL (90 min)	Joshua Drake Practical Postgres Replication (180 min)	Miroslav Šedivý Python and PostgreSQL Using psycopg2 (90 min)
16:00	Сoffee break (30 min)	Сoffee break (30 min)	Сoffee break (30 min)
16:30	Nikolay Ryzhikov, Марат Сурмашев Using JSONB (90 min)	Joshua Drake (continued)	Miroslav Šedivý Asynchronous Python and PostgreSQL Using asyncpg (90 min)

5 February 2019, Tuesday

	Hall П5, 2th floor	Hall П3, 2nd floor	Hall П7, 4rd floor
09:00	Registration (daylong) — Passport is required welcome coffee break
10:00	Conference opening (60 min)
10:15	Oleg Bartunov Professional Postgres (45 min)
11:00	Konstantin Evteev Standby in production (45 min)	Ivan Frolkov Typical errors in application software working on PostgreSQL (45 min)	Peter Gribanov 1С:Enterprise and PostgreSQL (22 min)
11:30			Anton Doroshkevich Russia's first BlockChain on 1C+PostgreSQL (22 min)
11:45	Aleksander Kuzmenkov Towards more efficient query plans: PostgreSQL 11 and beyond (45 min)	Andrey Fefelov How and what we'd choose between patroni, stolon, repmgr for out HA Postgres (45 min)
12:00			Dmitry Yuhtimovsky Magic tricks followed by exposure (1C+PG) (22 min)
12:30	Сoffee break (30 min)
13:00	Alexander Korotkov What should we expect from PostgreSQL 12? (45 min)	Aleksander Pavlov How to break your DBMS with arised-from-nothing high loads? (45 min)	Sergey Andreev What stops the transition on PostgreSQL and how to overcome it (22 min)
13:30			Panel discussion (30 min)
13:45		Boris Yeshchenko Manage and Protect your PostgreSQL data with Commvault (22 min)
14:00	Joshua Drake The Power of Logical Replication (45 min)		Lunch (60 min)
14:15		Lunch (45 min)
15:00	Lunch (45 min)	Dmitry Belyavskiy, Teodor Sigaev LTREE: extending the syntax (22 min)
15:30		Ivan Muratov PostgreSQL + PostGIS + TimescaleDB - storage for transport monitoring systems (22 min)	Aleksander Sheludchenkov Non-standard 1C cluster (22 min)
16:00	Pavel Trukhanov Postgres monitoring with USE and RED (22 min)	Lev Dragunov PostgreSQL inside Docker (22 min)	Alex Lustin Analysis of troublesome queries as a means of recurrent refactoring of 1C code (22 min)
16:30	Сoffee break (30 min)
17:00	Alexander Korotkov PostgreSQL bottlenecks (45 min)	Teodor Sigaev Less known but worthwile PostgreSQL extensions (22 min)	Miroslav Šedivý Bitemporality: Tracking Reproducible Revisions in PostgreSQL Using RANGE Types (45 min)
17:30		Aleksander Smolin Configuring and profiling VMware virtual infrastructure for PostgreSQL intensive input/output (22 min)
18:00	Darafei Praliaskouski PostGIS for Disaster Management (45 min)	Andrey Borodin Backups with WAL-G. What's new in 2019? (45 min)	Arthur Zakirov Using pg_variables as temporary tables (22 min)
18:30			Irina Fast Differences between Oracle DB and PostgreSQL in terms of administrating (22 min)

6 February 2019, Wednesday

	Hall П5, 2th floor	Hall П3, 2nd floor	Hall П7, 4rd floor
09:00	Registration (daylong) Passport is required welcome coffee break
10:00	Pavel Molyavin How we cook PostgreSQL at 2GIS in the DevOps age (45 min)	Jignesh Shah Deep Dive into the RDS PostgreSQL Universe (45 min)	Alexey Fadeev ORM: how to write queries and not to drive database crazy (45 min)
10:45	Esteban Zimányi MobilityDB: A PostgreSQL extension for mobility data management (45 min)	Jignesh Shah Tips and Tricks with Amazon RDS for PostgreSQL (45 min)	Christopher Travers Data Recovery in PostgreSQL on a Damaged Filesystem (45 min)
11:30	Teodor Sigaev Forward to the past (22 min)	Alexander Fedorov, Andrey Hitrin The Ultimate Tool: Xobot IDE (22 min)	Julien Rouhaud HypoPG 2: Hypothetical Partitioning support for PostgreSQL (45 min)
12:00	Pavel Luzanov Training and certification: news and roadmap (22 min)	Alexander Liubushkin, Rustam Abdrakhimov Live Universal Interface (LUI) - team development tool WEB interface applications for Postgres (22 min)
12:30	Сoffee break (30 min)
13:00	Vadim Podolny High Load Distributed Control Systems for Nuclear Power Plants operation (45 min)	Andrey Borodin DIY database index (45 min)	Nikolay Samokhvalov Enterprise-level approach to PostgreSQL tuning: database experiments (45 min)
13:45			Piotr Jarmuż Hacking with Postgres 11 - pg_threads (45 min)
14:00	Lunch (60 min)	Yury Zhukovets Technical features of porting T-SQL code to plpgsql and data from MS SQL to PG on the example of transition ECM "Priority" to Postgres (22 min)
14:30		Lunch (45 min)	Stepan Danilov Optimization of optimized and not quite (22 min)
15:00	Vasiliy Puchkov Integrating PostgreSQL servers into corporate network (45 min)		Lunch (30 min)
15:15		Camille Islamov CTE Queries Usage for Business Logic (22 min)
15:30			Artem Ivanov, Alexey Ignatov Migration to PostgreSQL/Postgres Pro on multi-core Bull servers. With your own hands-on experience. (22 min)
15:45	Alexey Lesovsky Troubleshooting in Postgres with pgCenter (45 min)	Denis Smirnov Greenplum: Internal Structure of MPP PostgreSQL for Analytics (45 min)
16:00			Tatsuro Yamada Auto plan tuning using feedback loop (22 min)
16:30	Сoffee break (30 min)
17:00	Alexander Kukushkin How not to screw up when building HA cluster (45 min)	Maksim Viharev GreenHouseSQL as a scalable analytics system for postgresql, greenplum and clickhouse (45 min)	Artemy Ryabinkov Best Practices and Practical Nuances when working with Postgres using Go (22 min)
17:30			Anna Akentyeva Autovacuum: what can we learn if we read the code instead of the documentation (22 min)
18:00	Lightning talk session (60 min)
19:00	Closing ceremony (30 min)