Adaptive Query Optimization (AQO) in PostgreSQL
Слайды
conf1.pptxВидео
Видео доступно участникам мероприятия, выполнившим вход в личный кабинет
Другие доклады
-
45 мин
Andrey Zubkov Postgres ProfessionalWorkload monitoring extensions pg_profile/ pgpro_pwr. Architecture, setup, features and use cases
The major task of workload monitoring tools is to provide measurable statistics about most resource intensive activities in the DBMS. They can't solve any issues but the points for concentrating optimization efforts can be highlighted. We’ll talk about the extensions pg_profile and pgpro_pwr, their architecture, features and use cases.
-
45 мин
Alexander Nikitin ЗАО ЦФТStruggle against database bloating
Every DBA has in one way or another experienced the situation when PostgreSQL tables and indexes grow significantly in size. While looking for the reason for such behavior, we often conclude that database objects have "bloated". In this talk, we'll discuss the reasons behind bloating, create a testing environment to define the best method to reduce bloating. We'll also compare several anti-bloating utilities and get familiar with one more tool that helps us to efficiently struggle against bloating. We expect this presentation to become helpful for PostgreSQL DBAs of any experience level.
-
22 мин
Андрей Григорьев Ростелеком Информационные технологии.jpg.180x180.jpg "Юрий Плотников")
Юрий Плотников РТК ИТThe story on the development of a database change management solution and what we lacked in Liquibase and Flyway
We will tell you how we store database objects in the version control system. Then we compare the traditional approaches to manage database migrations and the one we preferred. We will talk about both methods advantages and disadvantages. Finally, we will present our change management solution - pgmig.
-
22 мин
Maksim Afinogenov АО "ОКБМ Африкантов"Experience in porting the production management system database from Oracle DBMS to PostgresPro DBMS in a manufacturing enterprise
The practice of transferring structure, logic and data from Oracle DBMS to PostgresPro DBMS. Features and main difficulties of migration. Advantages of PostgresPro in terms of porting logic.