Неравный бой с "распуханием" в реалиях баз 1С
Data is getting bigger, disks are getting faster, the DBMS optimizer is getting smarter, but the problem of " bloating " remains extremely relevant. I want to share my experience and approach to dealing with this effect on a large number of tables and data in them.
Слайды
Дорошкевич Антон - Неравный бой с распуханием в реалиях баз 1С.pptxДругие доклады
-
90 мин
Sergey Novikov ЕДИНЫЙ ЦУПИСВнедрение партицирования без простоя
The built-in partitioning mechanism in PostgreSQL has been developing for several years. However, there is no magic button that would transform an ordinary table into a partitioned one. I will explain how to implement partitioning in a production system, how to prepare your table and apps for partitioning, and what pitfalls can make a DBA's life harder. We will also take a deep dive into various techniques of transferring data between partitions, also considering their pros, cons and limitation.
-
22 мин
Alexandra Kuznetsova Postgres ProfessionalНовые возможности Mamonsu 3.0
Mamonsu is an active monitoring agent for PostgreSQL based on Zabbix. Mamonsu 3.0 Major Update includes new metrics and more possibilities for data visualization via Zabbix screens. It also introduces the improved functionality of Mamonsu tools for interacting with the DBMS. In addition to the new functionality overview, I will also share the nuances of upgrading to the 3.0 version.
-
22 мин
Alexey Sabanov АО "Аладдин Р.Д."AAlexander Dodokhov АО "Аладдин Р.Д."Безопасность данных при миграции в условиях импортозамещения
Multiple data leaks can occur during data migration. How to protect your sensitive data and stay compliant with the requirements of regulatory institutions? This is what you will learn from my presentation.
-
22 мин
Nikita Drey OT-OILОсобенности миграции ECM платформы на PostgreSQL
In this presentation, we'll reveal the process and peculiarities of our Oracle to PostgreSQL migration project. We have moved our ELDOKA corporate ECM platform to PostgreSQL, and during this talk we will explain how we ensured object-based and role-based access to data, which features were missing in the community-developed PostgreSQL, how we organized our work with spatial data and changed approach to storing our file content. We will also share our experience in time and resource savings, as well as data replication between our nodes. Performance test results will also be shared with the audience.