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 instances.
- An overview of the Citus extension, including its purpose, architecture, and core components.
- Essential concepts: coordinator nodes, worker nodes, metadata, and distribution keys.
2. Cluster Architecture and Setup
- Understanding node types: distinguishing between coordinators and workers.
- Table classifications: distributed, replicated, and local tables.
- Installing and configuring Citus within existing PostgreSQL environments.
- Cluster discovery and node management procedures.
3. Data Distribution and Sharding Strategies
- Comparing sharding methods: hash distribution versus append-only tables.
- Selecting the optimal distribution column to enhance performance.
- Effective management of distributed and replicated tables.
- Re-balancing shards and strategies for scaling out the cluster.
4. Distributed Query Execution and Optimization
- Mechanisms by which Citus routes and parallelizes query execution.
- Interpreting distributed query plans.
- Techniques for query pushdown and execution optimization.
5. Consistency, Transactions, and Fault Tolerance
- Implementing Two-Phase Commit (2PC) for atomic operations.
- Strategies for handling failures within distributed transactions.
6. Operational Management and Use Cases
- Utilizing monitoring tools and system views for Citus.
- Maintenance practices and upgrade procedures in distributed environments.
Requirements
- Completion of the Advanced Administration (High Availability & Replication) course or equivalent practical experience.
- Strong proficiency in PostgreSQL configuration and performance tuning.
- Working knowledge of Linux and fundamental networking concepts.
Audience
This course is designed for experienced Database Administrators, DevOps Engineers, and System Architects who currently manage production PostgreSQL environments and require skills to scale them horizontally.
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