Review of some historical CVEs

I'm not a real security expert. But this will help me to do ELI5 explanation of the funniest historical Postgres CVEs.

Adaptive Query Optimization (AQO) in PostgreSQL

Experience of migration a highly loaded system from DB2 for z/OS to PostgresPro in multimaster configuration

The developer shares his experience of migration a highly loaded system in the field of railway transport from IBM DB2 for z/OS to PostgresPro in a multimaster configuration. The main focus is on the nuances of working with a cluster operating in multimaster mode, what problems had to be faced and how to solve them.

Practical cases for query optimization in PostgreSQL

In my opinion, every DBA has to deal with "heavy" queries. The question is whether we can do something at all to speed up such query. Is it possible to optimize such queries, or maybe it doesn't make sense? For example, rewriting such query may take much longer than getting any performance gain from this rewritten query. During this talk, I'll tackle several approaches to speeding up queries, and demonstrate some practical examples of optimizations that I use at work.