title

text

Dmitry Vasilyev
Dmitry Vasilyev Postgres Professional
12:30 25 October
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.

Слайды

Видео

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

  • Anatoly Anfinogenov
    Anatoly Anfinogenov АО "ВНИИЖТ"
    45 мин

    Migration from Oracle PL/SQL to Postgres pl/pgSQL: Two Years Later

    In 2019 we migrated distributed railway application from Oracle 11g SE to vanilla PostgreSQL 11.9. Almost 2 years have passed, the system is working good. The report focuses on how we migrated, what problems we faced during this migration and after migration, as well as what we would have done differently today experience.

  • 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.

  • Vladimir Slinko
    Vladimir Slinko Intel
    22 мин

    An overview of new Intel hardware features

    This talk is a brief overview of Intel technologies: CPU development, including features for AI algorithms. The memory speed/volume pyramid > PMem space, encryption development, software tools to improve parallel computing performance. I will also share a couple of cases where PG and Intel were implemented.

  • Sergey Novikov
    Sergey Novikov ЕДИНЫЙ ЦУПИС
    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.