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.
Duration 7 hours
Course Outline
1. Introduction to Distributed PostgreSQL
- Addressing the scaling limitations of single-node PostgreSQL deployments
- An overview of the Citus extension, covering its purpose, architecture, and core components
- Exploration of fundamental concepts, including coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Distinguishing between node types: coordinators versus workers
- Understanding different table types: distributed, replicated, and local tables
- Steps for installing and configuring Citus within existing PostgreSQL environments
- Processes for cluster discovery and effective node management
3. Data Distribution and Sharding Strategies
- Comparing sharding methods: hash distribution versus append
- Strategies for selecting the optimal distribution column to maximise performance
- Best practices for managing distributed and replicated tables
- Techniques for re-balancing shards and scaling the cluster outward
4. Distributed Query Execution and Optimisation
- An analysis of how Citus routes and parallelises query execution
- Interpreting and understanding distributed query plans
- Implementing query pushdown and other execution optimisation techniques
5. Consistency, Transactions and Fault Tolerance
- Examining Two-Phase Commit (2PC) mechanisms and atomic operations
- Strategies for handling failures within distributed transaction scenarios
6. Operational Management and Use Cases
- Utilising monitoring tools and system views specific to Citus
- Executing maintenance tasks and upgrades in distributed environments
Requirements
- Completion of the Advanced Administration (High Availability & Replication) module or possession of equivalent practical experience
- A strong command of PostgreSQL configuration and performance tuning principles
- Working knowledge of Linux systems and fundamental networking concepts
Audience
This course is tailored for experienced Database Administrators, DevOps Engineers, and System Architects who currently manage production PostgreSQL environments and require the skills 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 1300 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
Tuning strategies.
Jeffrey Zieg - Matrix Consulting
Course - PostgreSQL Performance Tuning
Logging behaviour when the instance is under stress, and the hierarchy/nomenclature of instances, databases, files, etc.
