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
- Scaling limitations associated with single-node PostgreSQL
- Overview of the Citus extension: its purpose, architectural design, and core components
- Essential concepts: coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Distinguishing between node types: coordinators and workers
- Table categories: distributed, replicated, and local tables
- Installation and configuration of Citus within existing PostgreSQL setups
- Cluster discovery processes and node administration
3. Data Distribution and Sharding Strategies
- Sharding techniques: comparing hash and append methods
- Choosing the optimal distribution column for performance
- Administering distributed and replicated tables
- Re-balancing shards and strategies for scaling out
4. Distributed Query Execution and Optimisation
- Mechanisms for query routing and parallel execution in Citus
- Interpreting distributed query execution plans
- Optimizing performance through query pushdown
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 specific views for Citus
- Maintenance procedures and upgrade processes in distributed environments
Requirements
- Completion of Advanced Administration (High Availability & Replication) or equivalent practical experience
- Proficient knowledge of PostgreSQL configuration and performance tuning
- General familiarity with Linux operating systems and fundamental networking concepts
Target Audience
Senior Database Administrators, DevOps Engineers, and System Architects who currently oversee production PostgreSQL environments and are seeking strategies to achieve 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