Talks
Talks archive
-
Anton Nemtsev Netrika LLCA 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.
-
Alena Rybakina PostgresPro
Andrey Lepikhov PostgresProDuring the years of its existence, Postgres Pro piled up a pool of problems when query execution was inappropriately slow or a query was too expensive to be executed, so it was never executed. Almost always in our practice, this was due to the choice of a non-optimal query plan. In our story, we will talk about a very unconventional attempt to solve this problem by re-planning queries. We will tell you what it is, how it works, who will find it helpful and the prospects for using this feature.
-
Nikolai Shaplov PostgresProFuzzing 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.
-
Boris Pischik PostgresPro
Aleksandr Kotin PostgresProWe will present adaptive query optimization techniques and key capabilities of the new version of AQO and SR_PLAN extensions.
Photos
Photo archive