Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
1. Understanding PostgreSQL Query Planner
- Query execution plans, Query Planner algorithms (classic, genetic)
- Analysing query execution plans (data access methods, join methods)
- Controlling plan selection (configuration parameters, pg_hint_plan)
2. Query Planner Statistics
- Execution plan cost estimation
- Default statistics model
- ANALYZE operation, extended statistics
3. Using Indexes
- B-tree indexes (single column, composite, function-based, partial)
- Hash indexes
- BRIN indexes
- GiST, GIN indexes
4. Using Advanced Table Structures
- Partitioned tables
- Unlogged tables
- Temporary tables
- Materialised views
5. Using Cache Memory
- Buffer Cache
- Work Memory
- Maintenance Work Memory
6. Parallel Query
- Architecture
- Configuration parameters
- Analysing parallelised query execution plans
7. Workload and Performance Monitoring
- Logging slow queries
- Using auto_explain extension
- Using pg_stat_statements extension
- Cumulative Statistics
8. Benchmarking with PgBench
Requirements
- Completion of PostgreSQL Server Administration or equivalent knowledge
- Working experience with SQL and PostgreSQL operations
Audience
Database Administrators, DevOps Engineers, and Developers responsible for tuning and maintaining PostgreSQL in production environments.
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
Amount (a lot) of knowledge provided. Cheerful aprroach to the subject.
Oskar Debowski - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
Shivam - Paessler LLC
Course - PostgreSQL Fundamentals
By the end of the 1st day, one attendee suggested more interaction in practices and the trainers took this in for the second day.
Daniela - Unit4
Course - PostgreSQL 16 for Developers and Administrators
A factual and practical approach to the subject. A nice atmosphere, conducive to asking questions.
