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 scaling limitations in single-node PostgreSQL setups
- An overview of the Citus extension, including its purpose, architecture, and core components
- Essential concepts: coordinator node, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Differentiating node types: coordinator versus worker nodes
- Understanding table types: distributed, replicated, and local tables
- Installing and configuring Citus within existing PostgreSQL environments
- Cluster discovery processes and node management techniques
3. Data Distribution and Sharding Strategies
- Exploring sharding methods: hash-based versus append-based
- Selecting optimal distribution columns to maximize performance
- Managing distributed and replicated table structures
- Rebalancing shards and executing scale-out operations
4. Distributed Query Execution and Optimisation
- Understanding how 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) and atomic operations
- Strategies for handling failures within distributed transactions
6. Operational Management and Use Cases
- Utilizing monitoring tools and views specific to Citus
- Performing maintenance tasks and managing upgrades in distributed environments
Requirements
- Completion of the Advanced Administration course (High Availability & Replication) or possession of equivalent professional experience
- Strong proficiency in PostgreSQL configuration and performance tuning
- Adequate familiarity with Linux systems and fundamental networking concepts
Target Audience
This course is designed for seasoned 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