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 to the PostgreSQL Database Server
- Architecture (processes, files)
- Administrative tools
- Installation, upgrade, startup, shutdown
- Configuration (files and configuration parameters)
- Tablespaces, databases, schemas
- Basic maintenance operations (vacuum, analyze, reindex)
User Account and Privilege Management
- Authentication methods
- Restricting network access to the server
- Creating and modifying user account definitions
- Creating groups/roles
- System and object privileges
Protecting Databases Against Failure - Backups and Replication
- Database backups (logical: pg_dump, pg_dumpall, pg_restore; physical: pg_basebackup; incremental physical: pg_combinebackup)
- Database recovery after failure
- WAL file archiving
- Complete and incomplete (point-in-time) recovery
- Standard physical replication
- Standard logical replication
- Auxiliary tools (barman, repmgr)
Managing PostgreSQL Database Server Performance
- Query execution plans, introduction to the Query Planner, statistics for the Query Planner
- Index usage, index types (B-tree, hash, BRIN)
- Advanced table structures (partitioned, unlogged, temporary, materialized views)
- Buffer cache usage (Buffer Cache, Work Memory, Maintenance Work Memory)
- Parallel queries: architecture, monitoring, configuration
- Monitoring workload and performance (logging long-running queries, analyzing table and index load)
- PgBench tool
- Other performance optimization techniques
35 Hours
Testimonials (3)
Tuning strategies.
Jeffrey Zieg - Matrix Consulting
Course - PostgreSQL Performance Tuning
Discussing the significant differences between certain commands available in PostgreSQL and the distinctive features of these databases (e.g., a clear and visual explanation of the differences between VACUUM and VACUUM FULL).
Maciej Golonka - CENTRUM INFORMATYKI RESORTU FINANSOW
Course - PostgreSQL Server Administration
Machine Translated
Logging behaviour when the instance is under stress, and the hierarchy/nomenclature of instances, databases, files, etc.
