Get in Touch
 Duration 7 hours

Course Outline

1. Introduction to Distributed PostgreSQL

  • The challenges associated with scaling single-node PostgreSQL
  • An overview of the Citus extension, including its purpose, architecture, and core components
  • Core concepts: coordinator nodes, worker nodes, metadata, and distribution keys

2. Cluster Architecture and Setup

  • Differentiating node types: coordinators versus workers
  • Understanding table types: distributed, replicated, and local tables
  • Processes for installing and configuring Citus within existing PostgreSQL environments
  • Techniques for cluster discovery and node management

3. Data Distribution and Sharding Strategies

  • Comparing sharding methods: hash versus append
  • Criteria for selecting a distribution column to maximize performance
  • Best practices for managing distributed and replicated tables
  • Strategies for re-balancing shards and horizontal scaling

4. Distributed Query Execution and Optimisation

  • Insights into how Citus routes and parallelizes queries
  • Interpreting distributed query plans
  • Implementing query pushdown and execution optimisation techniques

5. Consistency, Transactions and Fault Tolerance

  • Application of Two-Phase Commit (2PC) for atomic operations
  • Methods for handling failures within distributed transactions

6. Operational Management and Use Cases

  • Utilizing monitoring tools and views specific to Citus
  • Procedures for maintenance and upgrades in distributed environments

Requirements

  • Completion of the Advanced Administration (High Availability & Replication) course or equivalent practical experience
  • A strong command of PostgreSQL configuration and performance tuning practices
  • Working knowledge of Linux systems and fundamental network concepts

Audience

This course is tailored for experienced Database Administrators, DevOps Engineers, and System Architects who are responsible for managing production PostgreSQL environments and require strategies to scale them horizontally.

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 1450 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (3)

Upcoming Courses

Related Categories