Get the most out of your PostgreSQL database by learning about performance tuning techniques.
This half-day training session focuses on areas that you should master to tune PostgreSQL for performance. The training starts by explaining the overall architecture of the database system, how it interacts with the operating system and what settings are important; both in PostgreSQL and the operating system itself.
PostgreSQL is a multi-user system executing queries in parallel and it uses a fair amount of locking to co-ordiante those independent processes. As locks are a natural enemy of parallel systems, we'll spend some time explaining the basics of locking in PostgreSQL and how to investigate these issues. We'll also look at the basics of MVCC, a PostgreSQL feature that allows database systems to reduce the amount of locking. It's important to understand the basic MVCC idea as it has consequences for maintenance, particularly with regards to reclaiming space by VACUUM/autovacum.
We will then discuss topics that are relevant for performance optimisation at the query level, such as; alternative ways to design a database, workload analysis, indexes, using EXPLAIN to tune queries, partitioning and - as a continuation of the MVCC discussion - transactions and isolation levels.
Course content includes: Server Architecture and Tuning, MVCC and VACUUM, Locking and Concurrency, Security, Database Design Alternatives, Advanced Development, EXPLAIN SQL Tuning, Workload Analysis, Join Planning, Indexes, Partitioning, and Transactions and Isolation.
2ndQuadrant has a reputation for delivering the most comprehensive training, specific to PostgreSQL, available from any organisation. All of our tutors are expert level engineers and consultants who are active contributors to the design and evolution of PostgreSQL core code. This means you get access to people who understand PostgreSQL at the deepest level and have real life practical knowledge and expereince, through their consultancy assignments.
Tutor: Dr. Gianni Ciolli (Principal Consultant, 2ndQuadrant),
Gianni is a highly regarded and popular tutor of PostgreSQL training topics and also a leading database consultant. He is regular contributor to the PostgreSQL development project with a particular interest and expertise in PostGIS (spatial database extender for the PostgreSQL)
Course length: 0.5 days
Course fee includes refreshments and a buffet lunch.
This is a condensed version of a similar 1 day course we run, for people with limited time who want the information but cannot spare a whole day. You'll receive the same information but the pace of the course is quicker. You then may be interested in more advanced technniques which are covered in our 3 day Advanced Development & Performance course: https://2ndquadrant.com/en/training/courses/advanced-development-performance/
For a full list of our training curriculum, visit https://2ndquadrant.com/en/training/