Course Outline
- Introduction
- Optimizing Queries
- Logging Mechanisms in PostgreSQL
- Analyzing Query Plans
- Reviewing Statistics
- Adhering to SQL Best Practices
- Utilizing Indexes
- Implementing Table Partitioning
- System Performance Adjustment
- Operating System Configuration Best Practices
- Tuning Server Parameters
- Working with the pg_stat_statements Extension
- Practical Demos and Lab Exercises
- Benchmarking Procedures
- Techniques for Database Benchmarking
- Using Pgbench
- Interpreting Benchmark Results
- Practical Demos and Lab Exercises
Requirements
Existing familiarity with PostgreSQL is strongly advised before enrolling in this training program.
Testimonials (7)
Tuning strategies.
Jeffrey Zieg - Matrix Consulting
Course - PostgreSQL Performance Tuning
Adapting the topics covered to our identified issues with practical examples
Alessandro - Project srl
Course - PostgreSQL Performance Tuning
Machine Translated
the practical exercises, demonstrations and confidence in transferred knowledge.
Igor Werry - Unit4 Polska sp. z o.o
Course - PostgreSQL Performance Tuning
Hard to pick one thing, really good training all round.
Darren Jones - Unit4 Polska sp. z o.o
Course - PostgreSQL Performance Tuning
As I was the only participant I could influence the content and relative importance of subjects.
Andrew - WIM Ltd
Course - PostgreSQL Performance Tuning
The presenter gave us tons of new ideas for tweaking our PSQL for performance.
Adam Stafiej - Atlassian Poland sp. z o. o.
Course - PostgreSQL Performance Tuning
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
