title

text

A
Alena Rybakina Postgres Professional
A
Andrey Lepikhov Postgres Professional
14:15 26 September
45 мин

Перепланирование безнадежных запросов в реальном времени

During the years of its existence, Postgres Pro piled up a pool of problems when query execution was inappropriately slow or a query was too expensive to be executed, so it was never executed. Almost always in our practice, this was due to the choice of a non-optimal query plan. In our story, we will talk about a very unconventional attempt to solve this problem by re-planning queries. We will tell you what it is, how it works, who will find it helpful and the prospects for using this feature.

Видео

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

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

  • I
    Ivan Chuvashov SoftSwiss
    45 мин

    А давайте рассмотрим ваши таблицы под микроскопом

    As you probably know, PostgreSQL has a number of distinct features compared to other DBMSs. For example, Postgres can process and store many different types of data. However, you need to know something about them before using them. In this talk, we will find the reason why queries to the table begin to slow down (and autovacuum / vacuum has nothing to do with it) and try to speed up such queries. I will tell you how integer data types work in PostgreSQL and touch on the topic of speeding up such queries. And finally, let's talk about how to make your data in tables take up less space while increasing the speed of queries to this data.

  • Artem Sergienko
    Artem Sergienko Postgres Professional
    22 мин

    Харденинг кластерного ПО

    Hardening is the process of strengthening the security of a system in order to reduce risks from possible threats. In my presentation, I will tell you how to protect service cluster communications using TLS connections, in order to avoid accidental or unauthorized access to Patroni's REST API and ETCD storage.

  • A
    Anton Doroshkevich ИнфоСофт
    45 мин

    Всё работает! Что вам ещё надо?

    I have been working with 1C on PostgreSQL for 6 years, and the DBMS has changed significantly since I started. In this presentation, I'm going to cover the progress it has made. The users will, just as always, claim that this is not enough. So in addition to milestones and achievements, I'll tackle the possible feature requests from the maintenance viewpoint and explain some workarounds.

  • A
    Alexandr Burtsev Skala-R
    Sof'ya Kopikova
    Sof'ya Kopikova Postgres Professional
    D
    Darya Lepikhova Postgres Professional
    45 мин

    CFS и PTRACK в pg_probackup – нюансы компрессии в инкрементальном резервном копировании

    We will answer the questions about the importance of compression in backup process. Will show a demo how to use the following available algorithms: pglz, zlib, zstd, lz4 in different editions of pg_probackup. We'll show you how to make incremental backups and restore even faster with PTRACK and CFS (tablespace compression) in Postgres Pro. The plans for further development will also be announced.