title

text

Dmitriy Pavlov
Dmitriy Pavlov Arenadata
18:00 06 February
45 мин

How to train your Greenplum

In the pitch I will talk about the most important nuances of deployment and operations of the distributed analytical open-source database based on PostgreSQL - Greenplum. I will analyze the typical mistakes in its use, give the best practices and warn about bottlenecks.

Материалы к докладу

Слайды

Видео

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

  • Иван Картышов
    Иван Картышов Postgres Professional
    Dmitry Ivanov
    Dmitry Ivanov Postgres Professional
    22 мин

  • Christopher Travers
    Christopher Travers DeliveryHero SE
    45 мин

    PostgreSQL at 20TB and Beyond

    In the last six months I have been working with a massive OLAP environment with 20TB shards, spanning around 400TB of data. Come to listen to how we make it all work, the challenges, and the skills involved. This talk has very little in common with the 10TB and Beyond talk because the data environments are very different.

    We will cover analytics performance, data alignment, reasons for building extensions in C, and moving data around between servers in multiple data centers.

  • Andrey Hitrin
    Andrey Hitrin RedSys
    Alexander Fedorov
    Alexander Fedorov dbeaver.com
    45 мин

    Open Source IDE for Postgres

    DBeaver is the Universal Databases Manager. We creating DBeaver using Open Source Software model. We pay special attention to the PotgreSQL because of its capabilities, popularity and OSS nature. We will talk about DBeaver evolution and structure, will demonstrate the basic functionality. We are going to cover challenges of PostgreSQL client creation. Also we will discuss requirements management model and interaction with the PostgreSQL community. We will show in details how to debug the PL/pgSQL stored procedures interactively. We are going to introduce some new features of the nearest DBeaver release and to share our plans.

  • Alexander Kukushkin
    Alexander Kukushkin Zalando SE
    Alexey Klyukin
    Alexey Klyukin Zalando SE
    180 мин

    Tutorial: Management of High-Availability PostgreSQL clusters with Patroni

    Patroni is a Python application to create high-availability PostgreSQL clusters based on the streaming replication. It is used by Red Hat, IBM Compose, Zalando and many other companies. This tutorial will highlight Patroni architecture, provide attendees with hands-on experience of configuring high-availability PostgreSQL clusters with Patroni, describe how to take advantage of numerous additional features and give an opportunity to learn more about common mistakes related to running Patroni and its troubleshooting.

    In order to take most out of the Patroni tutorial one needs a laptop with git, vagrant and virtual box installed.

    Vagrant can be obtained from https://www.vagrantup.com Virtualbox is at https://www.vagrantup.com

    Alternatively, one can install your Linux distribution packages (or use homebrew on Mac).

    Once Vagrant and Virtualbox are installed one can run the Patroni VM by issuing the following commands:

    $ git clone https://github.com/alexeyklyukin/patroni-training
    $ cd patroni-training
    $ vagrant up
    

    When the setup concludes Patroni box can be accessed via ssh using vagrant ssh command.