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
- Introduction
- Query Tuning
- Logging in PostgreSQL
- Query Plans
- Statistics
- SQL Best Practices
- Indexes
- Table Partitioning
- Performance Tuning
- Operating System Best Practices
- Server Parameter Tuning
- Extension – pg_stat_statements
- Demo and Labs
- Benchmarking
- Database Benchmarking
- Pgbench
- Reading the Results
- Demo and Labs
Requirements
It is recommended to take this training only if you have a prior knowledge of PostgreSQL.
14 Hours
Testimonials (5)
latihan praktis, demonstrasi dan kepercayaan diri dalam pengetahuan yang ditransfer.
Igor Werry - Unit4 Polska sp. z o.o
Course - PostgreSQL Performance Tuning
Machine Translated
Sulit untuk memilih satu hal, pelatihannya benar-benar bagus secara keseluruhan.
Darren Jones - Unit4 Polska sp. z o.o
Course - PostgreSQL Performance Tuning
Machine Translated
As I was the only participant I could influence the content and relative importance of subjects.
Andrew - WIM Ltd
Course - PostgreSQL Performance Tuning
Presenter memberi kami banyak ide baru untuk menyesuaikan PSQL kami untuk kinerja.
Adam Stafiej - Atlassian Poland sp. z o. o.
Course - PostgreSQL Performance Tuning
Machine Translated
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.
