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
  • Юрий Темкин
    Юрий Темкин 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.

  • Ivan Chuvashov
    Ivan Chuvashov SoftSwiss

    As you probably know, PostgreSQL has a number of distinct features compared to other DBMSs. For example, Postgres can process and store many different types of data. However, you need to know something about them before using them. In this talk, we will find the reason why queries to the table begin to slow down (and autovacuum / vacuum has nothing to do with it) and try to speed up such queries. I will tell you how integer data types work in PostgreSQL and touch on the topic of speeding up such queries. And finally, let's talk about how to make your data in tables take up less space while increasing the speed of queries to this data.

  • Boris Pischik
    Boris Pischik PostgresPro
    Aleksandr Kotin
    Aleksandr Kotin PostgresPro

    We will present adaptive query optimization techniques and key capabilities of the new version of AQO and SR_PLAN extensions.

  • Anton Doroshkevich
    Anton Doroshkevich InfoSoft

    Backup is still a stumbling block when migrating to PostgreSQL from other DBMSs. Its size directly depends on your experience and knowledge about the types of backups in PostgreSQL. In this talk, I will tell you about different types of backups, their pros and cons, and scenarios for using each type.

All talks

Partners

PGConf.SPB 2023

Informational

Partner