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: its objectives, architecture, and core components
- Essential concepts: coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Differences between node types: coordinator vs. workers
- Table classifications: distributed, replicated, and local tables
- Installing and configuring Citus within existing PostgreSQL setups
- Cluster discovery processes and node management
3. Data Distribution and Sharding Strategies
- Comparison of sharding methods: hash-based vs. append-based
- Selecting the optimal distribution column to maximize performance
- Managing distributed and replicated tables
- Rebalancing shards and strategies for scaling out
4. Distributed Query Execution and Optimisation
- Mechanisms for query routing and parallel execution in Citus
- Analyzing distributed query execution plans
- Query pushdown techniques and execution optimization
5. Consistency, Transactions and Fault Tolerance
- Two-Phase Commit (2PC) mechanisms and atomic operations
- Strategies for handling failures in distributed transactions
6. Operational Management and Use Cases
- Monitoring tools and system views specific to Citus
- Maintenance procedures and upgrade strategies in distributed environments
Requirements
- Completion of the Advanced Administration (High Availability & Replication) course or possession of equivalent hands-on experience
- Strong proficiency in PostgreSQL configuration and performance optimization
- Comfort with Linux environments 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 are looking to implement horizontal scaling solutions.
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