title

text

Anatoly Anfinogenov
Anatoly Anfinogenov АО "ВНИИЖТ"
14:00 21 June
45 мин

Life after migration to PostgreSQL: configuring the database and stored procedures

Many books end with a wedding, but the reader has no idea about the future life of the heroes except that they lived happily ever after. In 2019, we successfully migrated distributed our railway application from Oracle 11g SE to vanilla PostgreSQL 11.9. But our story did not end with this successful migration - life went on, and sometimes we got startled because of "surprises". We encountered a number of problems, some of which were solved by reorganizing the data, some disappeared after we changed our stored procedures, and some got resolved after tuning the PostgreSQL parameters. Solving our problems would be impossible without the logging and profiling system built into our DB application. Our talk covers the examples of successful detection and resolving of the performance issues that occurred in our PostgreSQL-based application.

Слайды

Видео

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

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

  • Teodor Sigaev
    Teodor Sigaev Postgres Professional
    Nikita Malakhov
    Nikita Malakhov Postgres Professional
    45 мин

    Big values in PostgreSQL

    A modern database should be capable of storing big values. Storing itself is not a big deal, however, operations with big values or fields are a non-trivial task. PostgreSQL has several options for storing big values, but none of them is perfect. How do we respond to this challenge? Our presentation answers this question, let's see how to store big and complex values in Postgres properly, and how operate with them.

  • A
    Alexander Bychkov ООО "Эльбрус-2000"
    Н
    Николай Глазков ООО "Эльбрус-2000"
    22 мин

    How the State Air Traffic Management Corporation of the Russian Federation migrated from Oracle to Postgres Pro

    This talk covers the Oracle-to-Postgres Pro migration project for the billing system of the Federal State Unitary Enterprise “State Air Traffic Management Corporation of the Russian Federation” employed to collect the air navigation charges for the use of airspace.

  • Alexey Borschev
    Alexey Borschev Postgres Professional
    22 мин

    NULLs in Postgres

    This presentation is about NULLs implementation in the Postgres database: - What is NULL? - How is it handled by various Postgres functions? - How are NULLs stored in the database? - Indexing of NULLs

  • Dmitry Vasilyev
    Dmitry Vasilyev Postgres Professional
    45 мин

    Cloud PostgreSQL in Ozon: what's under the hood?

    My talk covers PostgreSQL infrastructure in Ozon: - how do we tune virtual machines (KVM); - which version control system we have created; - which drivers we make and how it relates to fault tolerance and load balancing; - how do we make "hot" upgrades for the parameters of our virtual machines.