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
  • Andrei Nikolayenko
    Andrei Nikolayenko IBS
    Alexander Korotkov
    Alexander Korotkov PostgresPro
    Борис Нейман
    Борис Нейман Mellanox
  • Ildar Musin
    Ildar Musin PostgresPro
    Dmitry Ivanov
    Dmitry Ivanov PostgresPro

    Partitioning is a long-awaited feature in PostgreSQL. Although Postgres supports partitioning via inheritance, this approach has some disadvantages, such as the need to manually create partitions and support triggers, significant planning overhead, and no query execution optimizations. In this talk, we’ll tell you about the pg_pathman extension we are developing. pg_pathman supports HASH and RANGE partitioning, performs planning and execution optimizations, supports fast insert by using Custom Node instead of triggers, provides functions for partition management (add, split, merge, etc.), supports FDW, non-blocking data migration, and more. We'll also speak about pg_pathman integration with Postgres Pro Enterprise Edition and Oracle-like syntax support for partitioning. Finally, we'll discuss new partitioning capabilities in PostgreSQL 10, the already implemented features and further development plans.

    VIDEO

  • Dmitry Vasilyev
    Dmitry Vasilyev PostgresPro

    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.

  • Ivan Panchenko
    Ivan Panchenko PostgresPro

    A summary of what the Postgres Professional company has achieved in its two-year history:

    • Our achievements in PostgreSQL development.
    • What is the Russian Postgres Pro DBMS, and how is it related to PostgreSQL?
    • What is Postgres Pro Enterprise, and why Enterprise?
    • What about trainings and certification?

    VIDEO

All talks