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
- Introduction to the Citus extension: objectives, architectural design, and core components
- Core concepts: coordinator nodes, worker nodes, metadata management, and distribution keys
2. Cluster Architecture and Configuration
- Node roles: distinctions between coordinators and workers
- Table categories: distributed, replicated, and local tables
- Installation and configuration of Citus within existing PostgreSQL setups
- Cluster discovery processes and node management techniques
3. Data Distribution and Sharding Methodologies
- Sharding approaches: comparison of hash-based versus append-based strategies
- Choosing optimal distribution columns for enhanced performance
- Oversight of distributed and replicated tables
- Shard rebalancing and horizontal scaling procedures
4. Distributed Query Execution and Optimization
- Mechanisms by which Citus routes and parallelizes queries
- Interpretation of distributed query execution plans
- Query pushdown techniques and execution optimization
5. Consistency, Transactions, and Fault Tolerance
- Two-Phase Commit (2PC) protocols and atomic operations
- Strategies for handling failures within distributed transactions
6. Operational Management and Practical Applications
- Monitoring tools and system views specific to Citus
- Maintenance procedures and upgrade strategies in distributed environments
Requirements
- Completion of Advanced Administration (High Availability & Replication) or comparable practical experience
- Proficient understanding of PostgreSQL configuration and performance tuning
- Familiarity with Linux environments and fundamental networking concepts
Target Audience
Seasoned Database Administrators, DevOps Engineers, and System Architects who currently oversee production PostgreSQL environments and require strategies for 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