Detail kurzu
POSQLP - PostgreSQL Performance
EDU Trainings s.r.o.
Popis kurzu
This training teaches how to safely and effectively optimize the performance of PostgreSQL server. Students understand how to use the tools to monitor, evaluate and tune. The course makes participants proficient in evaluating architecture, using tools, configuring databases, and tuning SQL code and applications.
Obsah kurzu
Hardware and Disks
- Physical disk anatomy
- Filesystems
- Performance considerations with disks
- Tuning disks for better performance
Transactions and locks
- Locking and concurrency
- Write ahead logs
- Data sync options
- Checkpoints
Operating system
- Tuning operating system
- Memory, work memory and index memory
Indexes and Query planner
- Examining query planner
- Index types and their usage
- Full text searh
- Planner statistics
- Table partitioning
Replication overview
- Log shipping and
Additional tools
- pgbench
Kontaktní osoba
Martina Dubcová
+420 731 175 867
martina.dubcova@edutrainings.cz