title

text

Alexander Alekseev
Alexander Alekseev Postgres Professional
17:30 17 March
22 мин

ZSON, PostgreSQL extension for transparent JSONB compression

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

Слайды

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

  • Michael Shurutov
    Michael Shurutov СтандартПроект
    22 мин

    Autonomous transactions in Postgres

    1. What is an autonomous transaction?
    2. An overview of autonomous transactions in "big" DBMS: Oracle.
    3. Autonomous transaction logic in Postgres Pro.
    4. An overview of emulation methods for autonomous transactions in PostgreSQL.
    5. Comparing performance of the built-in Postgres Pro autonomous transaction mechanism and PostgreSQL emulation methods.

    VIDEO

  • Alvaro Hernandez
    Alvaro Hernandez 8Kdata
    45 мин

    Migrating off of MongoDB to PostgreSQL

    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

  • Dmitry Vasilyev
    Dmitry Vasilyev Postgres Professional
    90 мин

    Mamonsu – a Swiss Army knife for managing and monitoring PostgreSQL

    This tutorial shows how to properly monitor PostgreSQL. We will discuss the mamonsu utility, see how to configure it, examine its hidden features and learn how to extend them.