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



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

  • Dmitry Beloborodov
    Dmitry Beloborodov UIS, CoMagic
    45 мин

    Using PostgreSQL in UIS, CoMagic Projects

    Using PostgreSQL since 2003, we went all the way from a database of a couple of GB to a cluster of more than 5TB. At the moment, we have more than 700 tables and about 1500 stored procedures. We are ready to share with you the following: - Problems encountered at different development stages and how we resolved them. - Best practices in database administration. - Our own extension to work with several closely related databases. - Best known methods and tools that enable our several teams to work together without interference. - How we set up test equipment of different types. And, of course, we'll talk about optimization, and how we identify bottlenecks and high-load use cases.


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


  • Markus Nullmeier
    Markus Nullmeier University of Heidelberg
    45 мин

    Accelerating queries of set data types with GIN, GiST, and custom indexing extensions

    Sets are apparently a useful data type for many kinds of applications. While PostgreSQL offers no built-in set data type, sets may be emulated to some degree with its built-in array and JSONB data types. Also, acceleration of respective containment (subset) queries is readily available as a built-in feature of the GIN index type.

    Starting with the above, we will then explore the performance gains enabled by custom set data types, and especially by customisation code in C ("operator classes") for the GIN and GiST index types.