title

text

Dimitri Fontaine
Dimitri Fontaine
13:00 03 March
45 мин

Архитектуры с Postgres в продакшне

When using PostgreSQL in production it is important to implement a strategy for High Availability. With a database service, the HA properties apply to both the service itself and of course to the data set.

In this talk we learn how to think about specific HA needs of your production environment and how to achieve your requirements with Open Source tooling when it comes to your database of choice, PostgreSQL. In particular, we dive in many options that could be implemented for Postgres to evolve its offering from being a toolset to being “batteries included”. What does it mean in the context of HA? How to achieve it?

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

  • Alexey Lesovsky
    Alexey Lesovsky Data Egret
    22 мин

    Noisia - генератор аварийных и нештатных ситуаций в PostgreSQL

    Noisia is the result of my past attempts to gather all the tools for reproducing various incidents with Postgres.

    Noisia is an utility for easy creation of artificial incidents in a Postgres database. This talk will describe the reason for artifical incidents creation, what Noisia does and what is it's possible use. Also I will share the future development roadmap.

  • Andrey Zubkov
    Andrey Zubkov Postgres Professional
    45 мин

    Анализатор исторической нагрузки pg_profile/pgpro_pwr и его новые возможности

    This talk is about postgres extension pg_profile - simple historic database workload profiler. I'll describe it's architecture, features and use cases. There is a new branch of pg_profile called pgpro_pwr, designed to run in PostgresPro Enterprise Edition and PostgresPro Standard Edition databases. It is using extended performance statistics of those databases providing some valuable benefits.

  • Иван Чувашов
    Иван Чувашов ООО Calltouch
    45 мин

    Жизнь DBA в онлайн-кинотеатре "OKKO"

    Okko is one of the largest legal online cinemas in Russia. Our catalog contains 60 000 movies, cartoons and TV series. Since its starting, the service has been visited by over 20 million users. The monthly audience is 2.8 million people. All these figures speak of a reliable high-load service.

    As DBA, I will mainly talk about databases (PostgreSQL, Cassandra, Redis) that are used in the company. We'll take a closer look at PostgreSQL on the topics of high loads, monitoring, optimization, backup and recovery.

  • Yana Krasteva
    Yana Krasteva Swarm64
    22 мин

    Современное хранилище данных на основе PostgreSQL

    PostgreSQL has a long history in DWH. Netezza, Redshift, and Greenplum have turned specific PostgreSQL releases into DWH solutions. Nowadays, with the trends in PostgreSQL towards performance improvements (better partitioning, better statistics, JIT Compilation, etc.) and advanced PostgreSQL extensions, like the Swarm64 Data Accelerator, you can create a forward-looking, no lock-in, versatile, and reliable DWH. This talk will cover the PostgreSQL and DWH trends and touch on key arguments for choosing open source PostgreSQL for DWH.