title

text

Иван Чувашов
Иван Чувашов ООО Calltouch
16:50 26 October
45 мин

Several production cases during one night

We maintain large PostgreSQL databases with the total data volume exceeding 180 TB. Every instance in the cluster gets a workload of 15 thousand requests per second. These circumstances certainly impose limitations on the classical approach to updating database structures. The cost of a DBA error gets higher, as even a small error can lead to a sleepless night) In my talk, I will cover our existing limitations for changes in the production environment, non-classical DBMS behavior under heavy workloads, and will discuss PostgreSQL in general.

Слайды

Чувашов Иван - Неожиданности PostgreSQL, которые украдут вашу ночь.pptx

Видео

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

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

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

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

  • Ekaterina Sokolova
    Ekaterina Sokolova Postgres Professional
    22 мин

    PG_QUERY_STATE: Everything about the inner life of your queries

    When working with PostgreSQL, we regularly encounter queries that take suspiciously long to be executed. What if it's too late to enable statistics or auto explain, and cancellation of the query doesn't look sensible, but you still need to find out what caused the issue or see at what stage execution the query is? pg_query_state is an open source PostgreSQL extension, which can give you access to the query execution plan in real time. It also makes available statistics for each node, including the number of processed rows.

  • Oleg Bartunov
    Oleg Bartunov Postgres Professional
    45 мин

    JSON or not JSON. Pros and cons of JSON usage

    JSON is now the de facto standard for startup developers. Why is this happening and what should be done? Should we teach application developers how to properly design a database according to the canons of relational theory (which Postgres complies very well with) or make the DBMS more JSON-friendly?