title

text

Egor Rogov
Egor Rogov
11:00 15 March
90 мин

ProBackup: fast, reliable, and incremental

Modern state of backup tools for PostgreSQL certainly leaves some room for improvements. Standard utilities provides only basic functionality, third-party tools solve some, but not all, problems. To take backups reliably, fast, and incrementally on page level, one needs not only a backup tool, but also some support from the database server. On this tutorial we will talk about our new backup and recovery manager ProBackup, and will show it in action.

Demonstration script:

слайды

Видео

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

  • Egor Rogov
    Egor Rogov
    90 мин

    ProBackup: fast, reliable, and incremental

    Modern state of backup tools for PostgreSQL certainly leaves some room for improvements. Standard utilities provides only basic functionality, third-party tools solve some, but not all, problems. To take backups reliably, fast, and incrementally on page level, one needs not only a backup tool, but also some support from the database server. On this tutorial we will talk about our new backup and recovery manager ProBackup, and will show it in action.

    Demonstration script:

  • Peter Gribanov
    Peter Gribanov
    22 мин

    1C:Enterprise business platform: working with PostgreSQL

    "1C:Enterprise" is the most popular in Russia/Eastern Europe business applications development framework supports PostgreSQL for 10+ years. We'll review some cases and pecularities of 1C and PostgreSQL tandem.

  • Ivan Panchenko
    Ivan Panchenko
    90 мин

    JSON, JSONB, JSQuery

    This tutorial is about various applied JSON usage patterns and the related PostgreSQL functionality. We will discuss data storage in the JSON format, retrieving, changing, and searching such data, JSON features for simple SQL queries, as well as using JSON in stored procedures in different languages. You’ll get hands-on experience with some of the discussed problems on the provided virtual machines.

  • Andrey Borodin
    Andrey Borodin
    45 мин

    GiST speedup: patches, hacks and tweaks

    This report overviews some ideas and implementations to speedup different parts of generalized search trees (GiST): 1. Intrapage indexing 2. Fractal tree technology 3. Modern algorithms for spatial indexing (RR*-tree) 4.. Possible advancements of GiST API

    VIDEO