Course Outline
1. Introduction to Distributed PostgreSQL
- Addressing scaling challenges with single-node PostgreSQL
- Overview of the Citus extension: its purpose, architecture, and key components for government use
- Core concepts: coordinator node, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Node types: differentiating between the coordinator and worker nodes for government operations
- Table types: distributed, replicated, and local tables in a government context
- Installing and configuring Citus on existing PostgreSQL environments for government use
- Cluster discovery and node management strategies for government systems
3. Data Distribution and Sharding Strategies
- Sharding methods: comparing hash and append sharding for government data
- Selecting a distribution column to optimize performance in government applications
- Managing distributed and replicated tables for enhanced government operations
- Re-balancing shards and scaling out to meet government needs
4. Distributed Query Execution and Optimization
- How Citus routes and parallelizes queries for efficient government data processing
- Understanding distributed query plans in a government context
- Query pushdown and execution optimization techniques for government use
5. Consistency, Transactions, and Fault Tolerance
- Two-Phase Commit (2PC) and atomic operations in government systems
- Handling failures in distributed transactions for government reliability
6. Operational Management and Use Cases
- Monitoring tools and views for Citus to support government oversight
- Maintenance and upgrades in distributed environments for continuous government operations
Requirements
- Completion of Advanced Administration (High Availability & Replication) or equivalent experience for government
- Solid knowledge of PostgreSQL configuration and performance tuning
- Familiarity with Linux and basic network concepts
Audience
This training is designed for experienced Database Administrators, DevOps Engineers, and System Architects who are currently managing production PostgreSQL environments within the public sector and require strategies to scale these systems horizontally.
Testimonials (5)
The provided examples and labs
Christophe OSTER - EU Lisa
Course - PostgreSQL Advanced DBA
Amount (a lot) of knowledge provided. Cheerful aprroach to the subject.
Oskar Debowski - Asseco Poland S.A
Course - PostgreSQL Administration, Optimization and Replication
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
Shivam - Paessler LLC
Course - PostgreSQL Fundamentals
By the end of the 1st day, one attendee suggested more interaction in practices and the trainers took this in for the second day.
Daniela - Unit4
Course - PostgreSQL 16 for Developers and Administrators
A factual and practical approach to the subject. A nice atmosphere, conducive to asking questions.
