title

text

Ivan Muratov
Ivan Muratov Первая Мониторинговая Компания
17:45 25 October
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.

слайды

Видео

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

  • Alexey Sabanov
    Alexey Sabanov АО "Аладдин Р.Д."
    A
    Alexander Dodokhov АО "Аладдин Р.Д."
    22 мин

    Ensuring data security during migration and compliance with import substitution regulations

    Multiple data leaks can occur during data migration. How to protect your sensitive data and stay compliant with the requirements of regulatory institutions? This is what you will learn from my presentation.

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

  • Sergey Pronin
    Sergey Pronin Percona
    45 мин

    PostgreSQL Disaster Recovery in Kubernetes

    Running PostgreSQL in Kubernetes became a common theme with the rise of the operators. In this talk, we will show you how easy it is to deploy a highly available PostgreSQL cluster in Kubernetes with Operator. We will also show how to prepare for the failure of a data center by running a hot-standby cluster on a DR site.

  • Igor Kosenkov
    Igor Kosenkov Postgres Professional
    45 мин

    Building a GEO-Cluster

    Everyone knows very well what a failover cluster PostgreSQL is and how such a cluster protects against failures within the same data center. However, recently, more and more enterprises have placed increased demands on their services, these requirements include disaster tolerance. We call such clusters a GEO-Cluster (KUK). In the report, I will talk about the varieties, principles and approaches to building GEO-Clusters PostgreSQL based on the Corosync/Pacemaker cluster software.