Using Debezium as a tool for delta migration
Delta migration case using Debezium is considered in details as well as the process of change data capture, sinking, applying configurations and load testing.
Материалы к докладу
Слайды
Емелин.pptxВидео
Другие доклады
-
Andrey Zubkov Postgres Professional
Workload 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.
-
Sergey Mokeev Maxim Technology
-
Christopher Travers Independent Community Member
Crazy things you can do with PostgreSQL Indexes
Of the relational databases, PostgreSQL is fairly unique in the indexing capabilities it offers. While most of us are familiar with the use of indexes to speed performance when filtering on columns, PostgreSQL indexes can do far more than this.
This talk will focus on cases where difficult problems were solved through the creative use of indexes. Each of these cases is from an episode in my career.
In this presentation, you will learn:
- The general index access methods PostgreSQL supports out of the box
- How the planner uses indexes (only on a high level)
- Functional indexes
- Creative use of Index Only scans.
This is a talk for all audiences. The talk is primarily for beginner to intermediate users, but should have enough information for more advanced users to get some insight or inspiration from the talk as well.
-
Anatoly Anfinogenov АО "ВНИИЖТ"
Vacuum Therapy: Treatment of Chronic DB Disease
Three years ago we successfully migrated our application from Oracle DBMS to vanilla PostgreSQL. After that we faced with "childhood" diseases of our application on the new DBMS, which were successfully cured, and some "chronic diseases", which took much longer to deal with. One of the most memorable problems was the problem of DB performance degradation. The source of this problems was insufficient vacuuming of our database. The experience of understanding and solving this problem is offered to your attention in the form of practical recommendations to prevent DB tables and indices bloat and setting up PostgreSQL VACUUM/autovacuum parameters.