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 of single-node PostgreSQL
- Overview of the Citus extension: its objectives, architectural design, and core components
- Essential concepts: coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Configuration
- Understanding node roles: coordinator versus worker nodes
- Table classifications: distributed, replicated, and local tables
- Implementing and configuring Citus within existing PostgreSQL setups
- Cluster discovery mechanisms and node administration
3. Data Distribution and Sharding Approaches
- Sharding techniques: hash-based versus append-based methods
- Choosing the optimal distribution column for peak performance
- Administration of distributed and replicated tables
- Shard rebalancing and horizontal scaling strategies
4. Distributed Query Execution and Tuning
- Mechanisms by which Citus routes and parallelizes query execution
- Analyzing distributed query execution plans
- Implementing query pushdown and execution optimizations
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
- Utilizing monitoring tools and system views for Citus
- Maintenance procedures and upgrade strategies in distributed settings
Requirements
- Successful completion of Advanced Administration (High Availability & Replication) or comparable hands-on experience
- Strong command of PostgreSQL configuration and performance adjustment
- Working knowledge of Linux systems and fundamental networking principles
Target Audience
Seasoned Database Administrators, DevOps Engineers, and System Architects who currently oversee production PostgreSQL environments and require strategies 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