PostgreSQL Performance Tuning Training Course
Course
In City Of London
Description
-
Type
Course
-
Location
City of london
This training is designed for Database Administrators and Architects who want to tune PostgreSQL Database for Performance. Learn how to log slow workload and find the possible pain points in a query. This topic also covers the most important parameters that must be tuned for optimal performance.
Facilities
Location
Start date
Start date
Reviews
Subjects
- Database training
- Database
Course programme
- 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
PostgreSQL Performance Tuning Training Course
