Talks
Talks archive
-
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.
-
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.
-
Alexandr Burtsev Postgres Professional
Sof'ya Kopikova PostgresPro
Darya Lepikhova PostgresProWe will answer the questions about the importance of compression in backup process. Will show a demo how to use the following available algorithms: pglz, zlib, zstd, lz4 in different editions of pg_probackup. We'll show you how to make incremental backups and restore even faster with PTRACK and CFS (tablespace compression) in Postgres Pro. The plans for further development will also be announced.
-
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.
Photos
Photo archive