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 purpose, architecture, and core components.
- Key concepts including coordinator nodes, worker nodes, metadata, and distribution keys.
2. Cluster Architecture and Setup
- Distinguishing between node types: coordinators versus workers.
- Table types: distributed, replicated, and local tables.
- Installing and configuring Citus within existing PostgreSQL environments.
- Cluster discovery processes and node management.
3. Data Distribution and Sharding Strategies
- Sharding methodologies: hash partitioning versus append distribution.
- Selecting the optimal distribution column for enhanced performance.
- Managing distributed and replicated tables effectively.
- Shard re-balancing and scaling out strategies.
4. Distributed Query Execution and Optimization
- Mechanisms for how Citus routes and parallelizes queries.
- Analyzing distributed query plans.
- Implementing query pushdown and execution optimization.
5. Consistency, Transactions, and Fault Tolerance
- Two-Phase Commit (2PC) and ensuring atomic operations.
- Strategies for handling failures within distributed transactions.
6. Operational Management and Use Cases
- Utilizing monitoring tools and views specifically for Citus.
- Maintenance routines and upgrade procedures in distributed environments.
Requirements
- Completion of the Advanced Administration course (High Availability & Replication) or equivalent practical experience.
- Strong understanding of PostgreSQL configuration and performance tuning techniques.
- Proficiency with Linux 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 seeking 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