The Ultimate Postgres Optimization: Going Beyond . Docs and Textbooks
Henrietta Dombrovskaya is a database researcher and developer with over 30 years of academic and industrial experience. She holds a Ph.D. in Computer Science from University of Saint Petersburg, Russia. She taught Database and Transaction theory at the University of Saint – Petersburg (Russia), as well as multiple database tuning classes for both beginners and advanced professionals.
Her professional experience includes consulting for a number of government projects in Chicago and New York, and providing Data services in the financial sector, manufacturing, and distribution. She is a co-author, with B. Novikov, of the book “System Tuning”, BHV, S.-Petersburg, Russia. Her researches in overcoming object-relational impedance mismatch were publish in the Proceedings of EDBT 2014 Athens and ICDE 2016 in Helsinki. At Braviant Holdings she is happy to have an opportunity to implement the results of her research in practice
Henrietta Dombrovskaya is a co-organizer of the Chicago PostgreSQL User Group
No video of the event yet, sorry!
Note 1: Presentedtogether with Boris Novikov Note 2: Two parts can be presented as two separate trainings
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”, and will teach them “how to think, as a database engine”.
The topics which will be covered include:
- What is a performant system, and how we measure performance
- Performance in OLTP and OLAP systems
- What are short queries and long queries and how to distinguish one from another
- Join algorithms and how to control them
- Indexes, good and bad, how to use and how not to use them
- The art of full scan
- The usage of functions: how they can improve performance, and how they can degrade it
- Application/database interaction: how you can improve application performance
- The power of generated queries
- 2020 March 27 09:00
- 6 h
- Postgres Conference 2020
- Requires Registration:
- Yes (Registered: 0)