title

text

Sergey Novikov
Sergey Novikov ЕДИНЫЙ ЦУПИС
12:05 25 October
90 мин

Implementing partitioning without downtime

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.

Видео

Другие доклады

  • Pavel Tolmachev
    Pavel Tolmachev Postgres Professional
    22 мин

    PostgreSQL certification: personal experience of taking four tests

    In May 2019, Postgres Professional launched the PostgreSQL certification program. I have been working in this company since March 2020, and in a year I have successfully taken four tests on the DBA1, DBA2, DBA 3, QPT courses. In this talk, I will share my experience of preparing for the exams and passing these tests.

  • Nikita Drey
    Nikita Drey OT-OIL
    22 мин

    Peculiarities of ECM platform migration to 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.

  • Dmitry Vasilyev
    Dmitry Vasilyev Postgres Professional
    45 мин

    PostgreSQL monitoring: sampling plan and average active sessions with your own hands

    In OZON, we work on PostgreSQL as a service. Currently, we have thousands of clusters. We know about the important questions software developers ask, and the most crucial ones are as follows: how to understand the database's workload and why this query is getting slow? In this presentation, I will explain how we help our developers answer these questions by simply having a look at our dashboard.

  • В
    Виталий Богданов АО «Байкал Электроникс»
    22 мин