Course Outline

1. Introduction to Distributed PostgreSQL

  • Scaling challenges with single-node PostgreSQL
  • Overview of the Citus extension: purpose, architecture, and components
  • Key concepts: coordinator node, worker nodes, metadata, distribution keys

2. Cluster Architecture and Setup

  • Node types: coordinator vs workers
  • Table types: distributed, replicated, and local tables
  • Installing and configuring Citus on existing PostgreSQL environments
  • Cluster discovery and node management

3. Data Distribution and Sharding Strategies

  • Sharding methods: hash vs append
  • Selecting a distribution column for optimal performance
  • Managing distributed and replicated tables
  • Re-balancing shards and scaling out

4. Distributed Query Execution and Optimisation

  • How Citus routes and parallelises queries
  • Understanding distributed query plans
  • Query pushdown and execution optimisation
  • Combining Citus with PostgreSQL performance features

5. Consistency, Transactions and Fault Tolerance

  • Two-Phase Commit (2PC) and atomic operations
  • Handling failures in distributed transactions
  • Integration with replication and high availability
  • Monitoring cluster health and query distribution

6. Operational Management and Use Cases

  • Monitoring tools and views for Citus
  • Performance benchmarking for large-scale deployments
  • Use cases: multi-tenant applications, IoT data platforms, analytics workloads

Maintenance and upgrades in distributed environments

Requirements

  • Completion of Advanced Administration (High Availability & Replication) or equivalent experience
  • Solid knowledge of PostgreSQL configuration and performance tuning
  • Familiarity with Linux and basic network concepts

Audience

Experienced Database Administrators, DevOps Engineers, and System Architects who already manage production PostgreSQL environments and need to scale them horizontally.

 7 Hours

Number of participants


Price per participant

Open Training Courses require 5+ participants.

Testimonials (3)

advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)

Shivam - Paessler LLC
Course - PostgreSQL Fundamentals

new knowledges that can be apply in our system

Laurence Bangsal - PayMaya Philippines, Inc.
Course - PostgreSQL Administration, Optimization and Replication

I genuinely enjoyed the trainer Subject Knowledge.

Julian Pirau
Course - PostgreSQL for Administrators

Upcoming Courses

PostgreSQL Advanced: Scalability and Sharding (Citus)

2025-12-23 09:30
7 hours
CB Center
270 EUR (Online)
270 EUR (Classroom)

PostgreSQL Advanced: Scalability and Sharding (Citus)

2026-01-06 09:30
7 hours
CB Center
270 EUR (Online)
270 EUR (Classroom)

PostgreSQL Advanced: Scalability and Sharding (Citus)

2026-01-20 09:30
7 hours
CB Center
270 EUR (Online)
270 EUR (Classroom)

PostgreSQL Advanced: Scalability and Sharding (Citus)

2026-02-03 09:30
7 hours
CB Center
270 EUR (Online)
270 EUR (Classroom)

Related Courses

Migrating Oracle to Azure SQL or PostgreSQL

 7 Hours

This instructor-led, live training in Moldova (online or onsite) is aimed at database administrators and cloud architects who wish to migrate Oracle databases to Azure SQL or PostgreSQL.

By the end of this training, participants will be able to:

  • Compare Azure SQL with PostgreSQL to choose the database that best meets business objectives and needs.
  • Prepare databases to move definitions, data, and procedures from Oracle to AzureSQL or PostgreSQL database system.
  • Perform post-migration steps to test, optimize, update, and maintain a migrated database.
Read more...

PostgreSQL Advanced - Performance Management

 14 Hours

This hands-on course focuses on the practical aspects of performance tuning in PostgreSQL. Participants will learn to analyse query execution, optimise indexing, adjust memory and system parameters, and monitor workloads effectively. Real-world scenarios and live exercises demonstrate how to identify and resolve bottlenecks at both the database and system levels.

Read more...

PostgreSQL for Developers: SQL and PL/pgSQL

 35 Hours

This practical 5-day training covers the complete skill set required to develop robust applications using PostgreSQL.
Participants learn advanced SQL, procedural programming with PL/pgSQL, and database design techniques that improve performance and maintainability.
Real-world exercises focus on building stored functions, triggers, and automation logic directly inside PostgreSQL.

Read more...

PostgreSQL Server Administration

 14 Hours
This course provides the essential knowledge required to install, configure, and manage PostgreSQL databases effectively. Participants will learn how to handle user security, perform backups and restores, manage logs, and tune basic parameters. Through practical exercises, learners will perform real-world administration tasks and prepare for advanced topics such as performance and replication.
Read more...

PostgreSQL Administration, Optimization and Replication

 35 Hours

In this instructor-led, live training in Moldova (onsite or remote), participants will learn the general and advanced aspects of PostgreSQL, including administration, performance turning, advanced development, and replication as they step through a series of hands-on, live-lab exercises involving setup, configuration, testing, deployment and troubleshooting.

By the end of this training, participants will be able to:

  • Use advanced administration techniques to configure and manage a PostgreSQL server.
  • Optimize the database and queries for maximum performance.
  • Replicate and scale a PostgreSQL server.
Read more...

PostgreSQL Advanced: Replication and High Availability (RepMgr, PgPool-II)

 14 Hours

This course provides in-depth coverage of replication, high availability, and cluster management in PostgreSQL. Participants will build and manage multi-node environments, configure failover automation, and explore load balancing and connection pooling solutions. The course includes live replication labs and recovery simulations.

Read more...

PostgreSQL Fundamentals

 14 Hours

This instructor-led, live training in Moldova (online or onsite) is aimed at beginner-level professionals who wish to learn how to use PostgreSQL for creating databases, writing SQL queries, manipulating data, and managing tables using both SQL commands and PGAdmin. The course also provides a basic introduction to the Timescale extension for time-series data.

By the end of this training, participants will be able to:

  • Understand relational database principles and PostgreSQL architecture.
  • Install, configure, and navigate PostgreSQL and PGAdmin.
  • Write and run SQL queries for data selection, filtering, grouping, and joining.
  • Manipulate data with SQL statements and manage database objects.
  • Create and manage views and explore PostgreSQL extensions like Timescale.
Read more...

PostgreSQL with Python

 21 Hours

This instructor-led, live training in Moldova (online or onsite) is aimed at developers and administrators who wish to use PostgreSQL with Python to build secure, reliable, and stable applications at scale.

By the end of this training, participants will be able to:

  • Install, configure, and connect PostgreSQL with Python.
  • Get a refresher on Python programming fundamentals.
  • Understand the benefits of using PostgreSQL with Python.
  • Learn how to perform basic SQL operations with Python.
  • Learn how to use the advanced PostgreSQL features with Python.
  • Implement data safety, security, monitoring, and optimization techniques.
Read more...

Related Categories

PostgreSQL
PostgreSQL