title

text

Alexander Korotkov
Alexander Korotkov Postgres Professional
15:45 04 February
45 мин

PostgreSQL bottlenecks #2

Last year I made a talk about unexpected PostgreSQL bottlenecks, which could make sad surprise to user (or DBA). Feedback to my talk was very positive. Additionally I have new material after year. This is why I'm making a sequel including new unexpected situations when your database hangs. This time focus will be on multicore hardware platforms, but not only them.

Материалы к докладу

Слайды

Видео

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

  • Dmitry Vasilyev
    Dmitry Vasilyev Postgres Professional
    45 мин

    Using PostgreSQL in AWS RDS: problems, recipes and tools.

    Everyone has probably heard about such a service as AWS RDS. I will talk about my experience by using the AWS RDS PostgreSQL Engine: the positive and negative aspects of the DBA work. This talk will focus on the tools that helped me create a comfortable environment in RDS. https://www.dropbox.com/s/v7udx5x96as5gbd/pgconf2020.pdf

  • Александр Чирков
    Александр Чирков Барс Груп
    Александр Кварацхелия
    Александр Кварацхелия БАРС Груп
    45 мин

    Migration from Oracle to PostgreSQL using an automatic converter

    In the report, we want to talk about the experience of migrating one large system from Oracle to PostgreSQL. The system itself was built on the PHP + Oracle stack; its distinguishing feature was that all business logic was implemented in PL / SQL code. In a DBMS, there are more than 3000 packages with 4-10 functions (procedures) in each. In PHP - more than 10,000 forms with inserts of anonymous blocks used to receive data, process and save results in Oracle.

    To solve this extremely voluminous work, we took ANTLR4 (a powerful parser generator for reading, processing, executing, or translating structured text), PL/SQL grammar, and created an automatic converter that allows you to convert all objects in the schema and our system from Oracle to working code for PostgreSQL.

  • Ivan Panchenko
    Ivan Panchenko Postgres Professional
    90 мин

    JSON use cases

    In this tutorial, we will solve several programming problems using JSON functionality that extends SQL capabilities and virtually turns a relational database into an almost ready-to-use application server. :)
    We will learn how to use aggregates, both standard and custom, as well as review possible benefits of JSON recursive structure.

  • Дмитрий Гребенщиков
    Дмитрий Гребенщиков ООО "Диасофт"
    22 мин

    Features of migration of engineering software from Oracle to PostgreSQL

    Migrating engineering software from Oracle to PostgreSQL
    Dmitry will talk about using an automated migrator developed by "Diasoft" company for migrating Russian systems to PostgreSQL.
    Taking the LOOTSMAN engineering software (developed by the ASKON company), we will speak about the key aspects of migration, review possible issues and ways to resolve them, as well as discuss performance optimization methods for migrated stored procedures.