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 Performance Fundamentals
- PostgreSQL Query Planner and execution workflow
- Using EXPLAIN and EXPLAIN ANALYZE to interpret plans
- Cost-based optimisation and statistics
2. Indexing and Query Optimisation
- Advanced indexing strategies: B-tree, hash, BRIN, GIN, GiST
- Partial, composite, and expression-based indexes
- Optimising joins, aggregations, and subqueries
- Impact of partitioning on performance
3. Memory and Configuration Tuning
- Core performance parameters: shared_buffers, work_mem, maintenance_work_mem
- Parallel query execution and control
- Autovacuum tuning and impact on I/O performance
- Understanding caching and I/O behaviour
4. Monitoring and Benchmarking
- Monitoring tools and extensions: pg_stat_statements, auto_explain
- Logging slow queries and analysing workloads
- Measuring throughput and latency with PgBench
- Designing performance baselines
5. Troubleshooting and Best Practices
- Identifying performance bottlenecks
- Common query anti-patterns
- Practical optimisation case studies
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
Testimonials (3)
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
Shivam - Paessler LLC
Course - PostgreSQL Fundamentals
new knowledges that can be apply in our system
Laurence Bangsal - PayMaya Philippines, Inc.
Course - PostgreSQL Administration, Optimization and Replication
I genuinely enjoyed the trainer Subject Knowledge.
