Anatoly Anfinogenov
Anatoly Anfinogenov АО "ВНИИЖТ" (ДЗО ОАО "РЖД")
10:00 26 October
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.



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

  • Andrey Borodin
    Andrey Borodin Яндекс.Облако
    45 мин

    CREATE INDEX CONCURRENTLY implementation details

    From the very beginning of 2021, I'm fixing a bug in CREATE INDEX CONCURRENTLY. This bug manifests extremely seldom. I could not find any traces of it in mailing lists ever since the introduction of the feature in 8.2. Yet the bug affected our systems, so I decided to fix it. This is how the9i detective bug-hunting story started. In this story, I'll share details of the implementation of transactions and lock mechanics.

  • Ivan Muratov
    Ivan Muratov Первая Мониторинговая Компания
    45 мин

    TimescaleDB 2.0 - Time-series data in TimescaleDB distributed cluster on top of PostgreSQL ORDBMS.

    TimescaleDB extension allows to turn good old Postgres into a real distributed cluster for storing time series data while maintaining the relational model, convenient SQL and a time-tested ecosystem. And additional features such as continuous materialized views and data compression allow to build truly powerful telematic hubs.

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

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