title

text

September 25 , 2023

PGConf.SPB 2023

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

Talks

Talks archive

PGConf.SPB 2023
  • Aleksandr Cherkashin
    Aleksandr Cherkashin VTB (Servionika LLC)
    Andrey Sevostyanov
    Andrey Sevostyanov Servionika LLC.

    Facing the restrictions on the use of Western software, our bank has developed and put into commercial operation a reliable mechanism for data replication between two DBMSs. This mechanism allowed the bank's teams without any special restrictions to replace the product from Oracle (Oracle Golden Gate was previously used in the bank for a long time). In the presentation, we will talk about the main advantages of our software and the nuances of its use.

  • Anton Nemtsev
    Anton Nemtsev Netrika LLC

    A story about practical approaches and tools for automating migration using 2 examples: a database with a structure change in the new version and a database with a significant content of the application's business logic.

  • Vladimir Sitnikov
    Vladimir Sitnikov

    A talk on how regular™ indexes work in PostgreSQL. The talk will be extremely useful for those who are starting to work with databases, and for those who have worked with them but have forgotten. If the talk hits the golden picks of "must-see onboarding developer", then the goal is achieved.
    We will tackle the following subtopics:
    - How an index can speed up search;
    - Should we index WHERE conditions;
    - Should we index ORDER BY statements;
    - Should we index foreign keys;
    - What to do if search pre-assumes multiple conditions;
    - Which column order should be specified in an index;
    - Cases when index causes a slow-down and how to reduce its impact on the app.

  • Юрий Темкин
    Юрий Темкин CyberProtect
    Ivan Belinsky
    Ivan Belinsky CyberProtect

    An important aspect of PostgreSQL database security and reliability is backup practices. The talk will reveal the main techniques and methods used to protect data, prevent loss and successfully recover information in case of human error, failures or emergencies. We will tell how CyberBackup helps to protect PostgreSQL, including configuration in Patroni cluster: we will consider system deployment options, important aspects of backup policy configuration, including full and incremental backups. We will also show how to easily work with backups via mount and do granular restores.

All talks

Partners

PGConf.SPB 2023

Informational

Partner