Training objectives
- Understand how PostgreSQL uses the system resources (CPU, I/O, Memory) and configure them
- Learn how the Cost Based Optimizer optimizes the access to your data
- Know everything about execution plan operations (sequental scans, index access, sorts, etc.)
- Monitor the performance with standard PostgreSQL tools and extensions
- Learn the tuning of queries via features available to the developer and/or DBA
- Understand the PostgreSQL index types
- Using stored procedures
Topics
- Memory Sizing: shared_buffers, work_mem, …
- I/O calls performed by PostgreSQL
- CBO, cardinality, cost, optimization, execution plan, parameters
- Statistics
- Sequential scans and indexing
- Sorts and Group By
- Join methods
- pg_stat_statements, pg_buffercache
- Connection handling
- Transaction isolation levels
- Performance relevant logging parameters
Method
- Presentation with countless practical exercises and trainings
- Case studies, live demos, discussions
- Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)
- Graphical tool courtesy of DB Visualizer
Target groups
- Database administrators (DBAs) wanting to improve the system performance, Database developers wanting to improve the application performance
Language & documentation
- Workshop training normally held in English; French or German possible instead as course languages
- Documentation: content details, scripts, case study solutions as PDF file (in English)
For your information
- IT performance management : review and tuning
- Testimonials : what customers are saying about dbi services
- Our expertise in database management