Course Outline
1. Introduction to Distributed PostgreSQL
- Scaling challenges with single-node PostgreSQL
- Overview of the Citus extension: purpose, architecture, and components
- Key concepts: coordinator node, worker nodes, metadata, distribution keys
2. Cluster Architecture and Setup
- Node types: coordinator vs workers
- Table types: distributed, replicated, and local tables
- Installing and configuring Citus on existing PostgreSQL environments
- Cluster discovery and node management
3. Data Distribution and Sharding Strategies
- Sharding methods: hash vs append
- Selecting a distribution column for optimal performance
- Managing distributed and replicated tables
- Re-balancing shards and scaling out
4. Distributed Query Execution and Optimisation
- How Citus routes and parallelises queries
- Understanding distributed query plans
- Query pushdown and execution optimisation
5. Consistency, Transactions and Fault Tolerance
- Two-Phase Commit (2PC) and atomic operations
- Handling failures in distributed transactions
6. Operational Management and Use Cases
- Monitoring tools and views for Citus
- Maintenance and upgrades in distributed environments
Requirements
- Completion of Advanced Administration (High Availability & Replication) or equivalent experience
- Solid knowledge of PostgreSQL configuration and performance tuning
- Familiarity with Linux and basic network concepts
Audience
Experienced Database Administrators, DevOps Engineers, and System Architects who already manage production PostgreSQL environments and need to scale them horizontally.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 1600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
1. A very well-structured training program 2. The warm atmosphere the trainer created, along with his outstanding personal professionalism 3. That the trainer explained everything as if he were talking to a complete beginner, without slipping into any technical jargon.
