Alexander Nikitin
Alexander Nikitin ЗАО ЦФТ
: December
22 мин

Working with queries - DBA perspective

Optimisation of queries can have a significant impact on database performance. In my talk, I will review the tools that we use in our practice and discuss some use-cases. This talk is of interest to database administrators or developers who would like to optimise their database performance and learn new query optimisation techniques.


Никитин Александр - Работа с запросами с точки зрения DBA.pptx


Видео доступно участникам мероприятия, выполнившим вход в личный кабинет

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

  • Vladimir Surdin
    Vladimir Surdin МГУ
    45 мин

    Basic Astronomy for Database Engineers

    We are surrounded by myths, so we are constantly under delusion in regard to politics, economy, history and... space. Let's tackle the most pressing issues related to astronomy and space research. Perhaps we will start to better understand the world around us, avoid exaggerated sensations and spot really interesting and attractive aspects of scientific research.

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

  • Sergey Pronin
    Sergey Pronin Percona
    45 мин

    PostgreSQL Disaster Recovery in Kubernetes

    Running PostgreSQL in Kubernetes became a common theme with the rise of the operators. In this talk, we will show you how easy it is to deploy a highly available PostgreSQL cluster in Kubernetes with Operator. We will also show how to prepare for the failure of a data center by running a hot-standby cluster on a DR site.

  • Gregory Smolkin
    Gregory Smolkin Postgres Professional
    45 мин

    Backup for 1.5K clusters with pg_probackup

    PostgreSQL maintenance without backups is unacceptable. The constant growth of PostgreSQL clusters in maintenance creates new issues and bottlenecks for the chosen backup scenario. In this presentation, we will explain how to efficiently use pg_probackup under such circumstances.