title

text

February 05 – 07 , 2018

PGConf.Russia 2018

Lomonosov Moscow State University, Moscow, Russia

PGConf.Russia 2018

PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 500 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 3-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.

Thems

  • PostgreSQL at the cutting edge of technology: big data, internet of things, blockchain
  • New features in PostgreSQL and around: PostgreSQL ecosystem development
  • PostgreSQL in business software applications: system architecture, migration issues and operating experience
  • Integration of PostgreSQL to 1C, GIS and other software application systems.
  • более
    0 участников
  • 0 доклада
  • оффлайн
    формат
  • 0
    минут общения

Доклады

Архив докладов

PGConf.Russia 2018
  • Ivan Panchenko
    Ivan Panchenko Postgres Professional
    90 мин

    Программирование серверных процедур на языках PL/Perl, PL/Python, PL/v8

    Tutorial will show specifics of server programming in these languages. I will present practical examples and compare the features of these languages in PostgreSQL environment from the viewpoint of solving practical tasks.

  • Michael Balayan
    Michael Balayan Acronis
    45 мин

    MVCC в картинках и когда длинные транзакции - это проблема

    Many of us know that it is MVCC that provides concurrency access to data in many relational databases that guarantee transactions consistency and isolation. But only deep understanding of the implementation of this mechanism in PostgreSQL allows us to better understand the processes in the database, to design the application logic and table structures to be the most effective in a high-load world. We'll take one of the processes in our product to understand how MVCC is implemented in PostgreSQL and we'll explain one of the peculiarity when seemingly unrelated activities can affect each other.

  • Eren Basak
    Eren Basak Citus Data
    45 мин

    Использование PITR в распределенных cистемах на базе PostgreSQL

    Postgres has a nice feature called Point-in-time Recovery (PITR) that would allow you to go back in time. In this talk, we will discuss what are the use-cases of PITR, how to prepare your database for PITR by setting good base backup and WAL shipping setups, with some examples. We will expand the discussion with how to achieve PITR if you have a distributed and sharded Postgres setup by mentioning challenges such as clock differences and ways to overcome them, such as two-phase commit and pg_create_restore_point.

  • Vadim Yatsenko
    Vadim Yatsenko Tantor Lab
    Sergei Kim
    Sergei Kim Ingram Micro Cloud
    45 мин

    PostgreSQL High Availability кластер для Enterprise

    Lately, the PostgreSQL is more widely being used for Enterprise. Our company, Ingram Micro Cloud, is one of the first companies that did it. We have been using PostgreSQL for many years as the main DBMS for our products. In our report, we want to tell about the evolution of our High Availability (HA) PostgreSQL cluster. We will tell about how quickly we implemented the solution using pgpool-II, wrote failover scripts, tested Postgres-XL, and came up with unusual configurations of Stolon. We will also cover the problems of load balancing, pooling connections, and backups.

Все доклады

Партнёры

PGConf.Russia 2018

Silver

Organizational

Informational

Partner