title

text

February 03 – 05 , 2016

PgConf.Russia 2016

Postrelease

  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 60 talks
  • offline
    format

Talks

Talks archive

PgConf.Russia 2016
  • Heikki Linnakangas
    Heikki Linnakangas Pivotal Ltd

    PostgreSQL includes several index types: GiST, SP-GiST, GIN, and of course, the regular B-tree. DBAs are familiar with using each of these for specific use cases, GIN for full-text search, GiST for geometrical data, and so on, but how do they work internally? What makes them suitable for the cases they're typically used for?

    In this presentation, I will walk through the internal structure of each of these index types, explaining what strengths and weaknesses each one of them have.

  • Andreas Scherbaum
    Andreas Scherbaum Pivotal Ltd

    Greenplum is a PostgreSQL fork, optimized for Analytics and Data Warehouse use cases. Pivotal announced in early 2015 that a number of products will go Open Source, one of them is Greenplum Database. This talk provides an overview over the history of Greenplum, the entire process of bringing the product into Open Source, all the stumbling blocks we ran into, and explains how contributors can participate.

  • Алексей Игнатов
    Алексей Игнатов PostgresPro
  • Pavel Stehule
    Pavel Stehule freelancer

    • the architecture
    • the design and implementation of PL/pgSQL
    • the difference between PL/SQL and PL/pgSQL
    • the advantage and issues of PL/pgSQL

All talks