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
- Challenges associated with scaling single-node PostgreSQL
- Overview of the Citus extension, including its purpose, architecture, and core components
- Foundational concepts: coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Differentiating node types: coordinator vs. workers
- Classifying table types: distributed, replicated, and local
- Installing and configuring Citus within existing PostgreSQL environments
- Methods for cluster discovery and node management
3. Data Distribution and Sharding Strategies
- Comparing sharding methods: hash-based vs. append-only
- Selecting the optimal distribution column for performance
- Administering distributed and replicated tables
- Techniques for re-balancing shards and horizontal scaling
4. Distributed Query Execution and Optimisation
- Mechanisms by which Citus routes and parallelizes queries
- Interpreting distributed query execution plans
- Implementing query pushdown and execution optimizations
5. Consistency, Transactions and Fault Tolerance
- Two-Phase Commit (2PC) mechanisms and atomic operations
- Strategies for handling failures within distributed transactions
6. Operational Management and Use Cases
- Leveraging monitoring tools and views specific to Citus
- Conducting maintenance and upgrades in distributed environments
Requirements
- Completion of the Advanced Administration (High Availability & Replication) course or comparable professional experience
- Robust understanding of PostgreSQL configuration and performance optimization
- Working knowledge of Linux systems and fundamental network concepts
Target Audience
This course is tailored for seasoned Database Administrators, DevOps Engineers, and System Architects who currently oversee production PostgreSQL environments and require strategies for horizontal scaling.
Testimonials (3)
I expanded my knowledge on DB performance management, some are directly usable while others provide great insight/context for me.
Longze Chen - Center for Open Science
Course - PostgreSQL Advanced - Performance Management
how to use LLM in daily work
Cont - Everymatrix
Course - PostgreSQL AI: Introduction to semantic search
Tables indexes and qq reperforming & tuning in order to improve them