Andreas Scherbaum
Andreas Scherbaum Pivotal
10:30 17 March
22 мин

Introduction to Greenplum MPP Database

Overview of the architecture of Greenplum MPP (Massively Parallel Processing) database. Explain the internals of GPDB. Show how to configure and setup GPDB. How to distribute data effectively for MPP



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

  • Alexander Korotkov
    Alexander Korotkov Postgres Professional
    45 мин

    RUM indexes and their applications

    I want to present a new custom access method, which extends the current GIN capabilities using additional information stored in posting tree/list. For example, positional information as an additional information allows new AM returns results in relevance order, which could considerably improve execution time of full text queries.

  • Ildar Musin
    Ildar Musin Postgres Professional
    Dmitry Ivanov
    Dmitry Ivanov Postgres Professional
    45 мин

    Partitioning with pg_pathman

    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.


  • 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.


  • Dmitry Susha
    Dmitry Susha ООО Испаер Системс
    22 мин

    Automation of migration to PostgreSQL from various databases

    The report is focused on the topic of automation of migration to PostgreSQL from other databases using Ispirer Migration and Modernization Toolkit. The issues of data and SQL code migration, conversion of client applications, embedded SQL and database API will be covered, the examples of implemented projects of migration from Oracle to PostgreSQL and from Microsoft SQL Server to PostgreSQL will be given.