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. Intro to Distributed PostgreSQL
- Challenges associated with scaling single-node PostgreSQL instances
- Introduction to the Citus extension: its objectives, architecture, and core components
- Core concepts: coordinator nodes, worker nodes, metadata, and distribution keys
2. Cluster Structure and Configuration
- Differentiating node roles: coordinator versus worker nodes
- Categorizing table types: distributed, replicated, and local
- Deployment and configuration of Citus within existing PostgreSQL setups
- Cluster discovery mechanisms and node administration
3. Data Distribution and Sharding Tactics
- Comparing sharding methodologies: hash versus append
- Choosing the optimal distribution column for peak performance
- Oversight of distributed and replicated tables
- Rebalancing shards and executing scale-out operations
4. Distributed Query Processing and Optimization
- Mechanisms by which Citus routes and parallelizes query execution
- Analyzing distributed query execution plans
- Implementing query pushdown and execution enhancements
5. Consistency, Transactions, and Resilience
- Two-Phase Commit (2PC) protocols and atomic operations
- Strategies for managing failures within distributed transactions
6. Operational Oversight and Applications
- Monitoring instruments and views specific to Citus
- Maintenance procedures and upgrades in distributed contexts
Requirements
- Successful completion of Advanced Administration (High Availability & Replication) or comparable professional experience
- Proficiency in PostgreSQL configuration and performance optimization
- Working knowledge of Linux operating systems and fundamental networking concepts
Target Audience
Seasoned Database Administrators, DevOps Engineers, and System Architects who are responsible for production PostgreSQL environments and require solutions 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