Top.Mail.Ru
PGConf.Russia 2023 | PGConf.Russia

title

text

April 03 – 04 , 2023

PGConf.Russia 2023

  • more than
    0 participants
  • 0 speakers
  • 0
    minutes of conversation
  • 44 talks
  • hybrid
    format

Talks

Talks archive

PGConf.Russia 2023
  • Igor Alov
    Igor Alov

    One of the main needs of high-load database projects is a right configured load balancer within the database cluster. Most of the solutions I worked with, including Pgpool-II, could not fully suit business requirements. In this article me as a network engineer with broad experience will cover tricky configurations of the Pgpool-II operating in the “Master-Master” mode, as well as consider cases in which similar solutions are indispensable.

  • Alexander Nikitin
    Alexander Nikitin ЗАО «ЦФТ»

    Every DBA has in one way or another experienced the situation when PostgreSQL tables and indexes grow significantly in size. While looking for the reason for such behavior, we often conclude that database objects have "bloated". In this talk, we'll discuss the reasons behind bloating, create a testing environment to define the best method to reduce bloating. We'll also compare several anti-bloating utilities and get familiar with one more tool that helps us to efficiently struggle against bloating. We expect this presentation to become helpful for PostgreSQL DBAs of any experience level.

  • Andrey Rudometov
    Andrey Rudometov PostgresPro

    Since PostgreSQL 9.5 logical replication has replication origin infrastructure for replication progress tracking. Now 16th version is coming with feature which made bi-directional replication setups possible using said infrastructure. In earliest reviews it got a nickname of "native multimaster" for cluster, interconnected with said replication, bearing some resemblance to PostgresPro's Multimaster. We're going to figure out degree of it and explain insides of them. Talk expects you to have a basic knowledge of WAL insides and it's role in PostgreSQL functioning.

  • Евгений Бредня
    Евгений Бредня PostgresPro

    How to thoughtfully recover corrupt data...

All talks

Partners

PGConf.Russia 2023

Golden

Informational

Partner