Upcoming presentations
No upcoming presentations...
Past presentations
There is no protection against bad queries. If a query is poorly written, it's execution can't be improved with any indexes, fast access path or other database advancements. What is the most common source of poorly written queries? Most of the time they do not come from humans; they are generated by applications that use ORMs to communicate with databases. What can we do to prevent it from happ...
The Ultimate Postgres Optimization: Going Beyond Docs and Textbooks
Think like a database
Abstract: Is it possible to teach somebody to optimize? Or is optimization a sort of magic, available only for the limited circle of wizards? We believe that it is entirely possible to become an optimization wizard, and we are going to prove it in the course of this training. We will provide the participants with the opportunity to look at the process of query writing “as a database engine”, a...