title

text

March 15 – 17 , 2017

Postrelease

  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 63 talks
  • offline
    format

Talks

Talks archive

PgConf.Russia 2017
  • Igor Chizhevskiy
    Igor Chizhevskiy SRC "Voshod"
    Sergey Korolev
    Sergey Korolev MCST
    Dmitry Pogibenko
    Dmitry Pogibenko FGBU "NII Voskhod"
    Stanislav Merzlyakov
    Stanislav Merzlyakov Scientific Research Institute "Voskhod"
    Илья Космодемьянский
    Илья Космодемьянский Data Egret
    Иван Богданов
    Иван Богданов SRC "Voshod"

    Practical experience of carrying out import substitution with using PostgreSQL in government information system including not only the free software, but also the Russian hardware (Elbrus servers and other).

    VIDEO

  • Egor Rogov
    Egor Rogov PostgresPro

    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:

  • Alvaro Hernandez
    Alvaro Hernandez 8Kdata

    MongoDB is a successful database in the NoSQL space, mostly used for OLTP-type workloads. However, due to the lack of ACID (transactions in particular) and significant performance issues with OLAP/DW workloads, more and more MongoDB users are considering migrating off of MongoDB to a RDBMS, where PostgreSQL is the usual choice. This represents a significant opportunity for the PostgreSQL ecosystem, to "bring NoSQL to SQL". This talk will present the challenges that MongoDB users are facing and the state of the art of the available tools and open source solutions available to perform ETL and live migrations to PostgreSQL. In particular, ToroDB Stampede will be discussed, an open source solution that replicates live from MongoDB, transform JSON documents into relational tables, and stores the data in PostgreSQL.

    VIDEO

  • Alexander Alekseev
    Alexander Alekseev PostgresPro

    ZSON is a PostgreSQL extension for transparent JSONB compression. Compression is based on a shared dictionary of strings most frequently used in specific JSONB documents (not only keys, but also values, array elements, etc). In some cases ZSON can save half of your disk space and give you about 10% more TPS.

    VIDEO

All talks