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 in scaling single-node PostgreSQL instances
- Introduction to the Citus extension: objectives, architecture, and core components
- Essential concepts: coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Configuration
- Node distinctions: coordinator versus worker nodes
- Table categories: distributed, replicated, and local tables
- Installing and configuring Citus within existing PostgreSQL setups
- Cluster discovery mechanisms and node administration
3. Data Distribution and Sharding Methodologies
- Sharding techniques: hash-based versus append-based strategies
- Choosing distribution columns for peak performance
- Administration of distributed and replicated tables
- Re-balancing shards and scaling out the cluster
4. Distributed Query Execution and Optimization
- Mechanisms by which Citus routes and parallelizes query execution
- Interpreting distributed query execution plans
- Query pushdown techniques and execution optimization strategies
5. Consistency, Transactions, and Fault Tolerance
- Two-Phase Commit (2PC) protocols and atomic operations
- Managing failures within distributed transactions
6. Operational Management and Practical Applications
- Monitoring tools and system views available for Citus
- Maintenance procedures and upgrade processes in distributed environments
Requirements
- Completion of the Advanced Administration (High Availability & Replication) module or comparable professional experience
- Robust understanding of PostgreSQL configuration and performance optimization
- Proficiency with Linux systems and fundamental networking concepts
Audience
Targeted at seasoned Database Administrators, DevOps Engineers, and System Architects who maintain 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