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
  • Марк Ривкин
    Марк Ривкин PostgresPro

    Postgres Pro Enterprise is based on open source PostgreSQL. However, the difference is significant: the current version of Postgres Pro Enterprise has 40 more features that are not a part of PostgreSQL. 20 more mechanisms are being developed either as built-in features or separate products. This includes BiHA, DBaaS, pg_probackup, etc. In this presentation, we'll briefly discuss some of them.

  • Nikolai Shaplov
    Nikolai Shaplov PostgresPro

    Fuzzing research is feeding random input data to a program (or a part of it) (in fact, randomness is very conditional) and seeing what we get out of it. And we repeat it many times on many processors.

    Fuzzing a large monolithic program complex is never a simple task. It requires extraordinary solutions. In this talk, I will tell you what and how we searched with the help of fuzzing and what results it led to.

    • Investigation of data type parsing functions (input-functions): for warming up;
    • Investigation of functions implementing operations between types (op-functions): it is better to consider the structure here;
    • Network subsystem fuzzing: let's pretend we are POSIX calls, it's cheaper that way;
    • Recovering disk context: we need Groundhog Day.

    A story about funny bugs and ridiculous hand gestures will be included.

  • Mikhail Zhilin
    Mikhail Zhilin PostgresPro

    Unfortunately, ideal computer systems exist only in science fiction books. PostgreSQL is not exception and sometimes problems may occur. I would like to discuss how to correctly (and incorrectly) try to solve a problem, which way to choose, which tool to use.

    The talk is of interest to both beginners and experienced users and database administrators.

  • Mansur Galiev
    Mansur Galiev Maxim technology

    We'll talk about the tool we created, which monitors changes in the database and creates scripts for migrations of selected objects both interactively and automatically.

All talks

Partners

PGConf.SPB 2023

Informational

Partner