title

text

Pavel Konotopov
Pavel Konotopov Postgres Professional
14:30 04 April
22 мин

RTT, RTO, RPO and synchronous replication

How does network latency affect performance when using synchronous replication? If a primary node fails, how long will our cluster not be reachable? How much data can be lost? Will there be any anomalies when reading from standby? We are designing our network architecture, give us a minimum RTT value for cluster solution! Many DBAs have to face these issues when designing and implementing cluster solutions. In this short talk we will tell how to quickly estimate RTT, RTO, RPO values, with the help of which Open Source tools one can test cluster solution and experimentally verify the design parameters, which metrics values can be used as a guide in design.

слайды

Видео

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

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

    Tips and tricks for PostgreSQL operations for 1C

    As we have large 1C+PostgreSQL database setups, questions often arise, the answers to which are not so easy to find even in the documentation. I would like to share my experience in solving such issues gained during several migrations of 1C from MS SQL to PostgreSQL made for clients from the RBC500 rating. This talk will cover the following points: How in-depth your statistics should be and why it can be dangerous? How can the creation of an explicit and implicit temporary table provoke the DBMS server downtime and how can we avoid it? In what case will the DBMS process be killed by the operating system due to overuse of RAM and what to do about it? Why having one database per cluster is good and why having multiple databases on one DBMS cluster is bad? If we are stick to the "1 cluster = 1 database" approach, what about server resources for test and development environments? Backups in PostgreSQL: what backup options we have

  • Pavel Tolmachev
    Pavel Tolmachev Postgres Professional
    22 мин

    Let's get acquainted with GEQO in 20 minutes

    -----------------------------------------------------------QUERY PLAN--------------------------------------------------------------
    Hash Join
      Hash Cond: (Subject = GEQO)
      -> Hash Join
            Hash Cond: (**Optimizer task = choose the best query execution plan**)
            -> Seq Scan on **The number of potential plans grows exponentially as the number of tables in a query increases**
            -> Hash
                  -> Seq Scan on **PostgreSQL solves this problem by using the genetic optimizer (GEQO)**
      -> Hash
            -> Seq Scan on **Topics of the report:**
                  Filter: (**(What is GEQO)** AND **(Pros and cons)** AND **(How it works)**)
    (10 rows)
    

  • Alexander Liubushkin
    Alexander Liubushkin ООО "ФОРС Телеком"
    Andrey Chibuk
    Andrey Chibuk ООО "ФОРС Телеком"
    45 мин

    How to transfer 10TB from Oracle to Postgres in 24 hours?

    We offer to your attention our experience in data migration and the Ora2PgCopy program written in Java for high-speed data transfer from Oracle to Postgres, which is used after creating tables and transferring the program code of application systems. High data transfer speed is provided by using the Postgres command “copy”, using multithreaded Java technology for file processing, managing the nologged/logged table option, and supporting LOB and CLOB data types. According to the test results, Ora2PgCopy works noticeably faster than such analogues as: Ispirer (convertum), oracle_fdw, ora2pg, Pentaho kettle. Ora2PgCopy can function as a module as part of the LUI4ORA2PG migration automation system or independently of it. The history of the growth of the Live Universal Interface (LUI) web application development tool and the LUI4ORA2PG migration tool can be found in previous presentations at PGConf conferences: https://pgconf.ru/2019/118109 , https://pgconf.ru/201911/264095 , https://pgconf.ru/2020/262456, https://pgconf.ru/2021/288310, https://pgconf.ru/2022/316022.

  • Anton Nemtsev
    Anton Nemtsev ООО "Нетрика"
    22 мин

    Case of moving a DBMS with business logic to Postgres PRO

    I will share the experience of migration project of an information system from a Microsoft SQL Server DBMS to Postgres PRO. The owner of the DBMS is Rosagroleasing JSC.

    The volume of the DBMS database is about 6 TB (more than 300 tables, up to 4 billion records in each). The team adapted 15 ETL packages and 131 procedures with full functionality and also partial refactoring of the source code. Systems' performance has remained the same.