Top.Mail.Ru
PGConf.Siberia 2017 | PGConf.Russia

title

text

September 23 – 24 , 2017

Talks

Talks archive

PGConf.Siberia 2017
  • Dmitry Ivanov
    Dmitry Ivanov PostgresPro

    Table Partitioning is a highly demanded functionality of PostgreSQL. The existing possibility to make partitioning through inheritance has several serious disadvantages, such as ineffective planning, missing runtime optimization, need to manage triggers and sections manually.

    This talk describes the pg_pathman extension developed by our team. pg_pathman supports HASH and RANGE partitioning and performs query optimization during planning and execution stages, allows fast includes by using custom executor nodes instead of triggers, supports FDW, lock-free data migration and other possibilities.

    In conclusion I will describe the new features, expected in next releases, and our plans for integration with PostgreSQL 10.

  • Anton Doroshkevich
    Anton Doroshkevich InfoSoft

    The file-based storage for 1C should be left in the past. We will compare SQL Express and PostgreSQL on Windows platform, outlining some useful features of MS SQL, still lacking in PostgreSQL, discuss usage of tablespaces in PostgreSQL and MS SQL. Then we'll discuss the important configuration settings and critical operations for running 1C platform, replication, cascades, a fast way for creating developer copies of the databases, and make backups and check their integrity.

  • Anastasia Lubennikova
    Anastasia Lubennikova PostgresPro

    PostgreSQL 10.0 is to be released in autumn 2017. This talk describes the development and release cycle of PostgreSQL, and new features of the upcoming release, including logical replication, declarative partitioning, ehanced statistics and many other.

  • Ivan Kartyshov
    Ivan Kartyshov PostgresPro

    The talk describes the existing solutions for backup and restore for PostgreSQL, including barman, pgbackrest and pg_probackup utilities. The comparison of their functions with analysis of theis drawbacks and advantages will be presented. You will learn how to setup a block level incremental backup with compression and integrity verification.

All talks