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
- Fundamental concepts: coordinator node, worker nodes, metadata, and distribution keys
2. Cluster Architecture and Setup
- Node types: differentiating between coordinator and worker nodes
- Table types: distributed, replicated, and local tables
- Installing and configuring Citus in existing PostgreSQL environments for government use
- Cluster discovery and node management practices
3. Data Distribution and Sharding Strategies
- Sharding methods: hash versus append
- Selecting an appropriate distribution column for optimal performance
- Managing distributed and replicated tables in a government context
- Re-balancing shards and scaling out the cluster
4. Distributed Query Execution and Optimization
- How Citus routes and parallelizes queries for efficient execution
- Understanding distributed query plans to enhance performance
- Techniques for query pushdown and execution optimization in government databases
5. Consistency, Transactions, and Fault Tolerance
- Two-Phase Commit (2PC) and atomic operations to ensure data integrity
- Strategies for handling failures in distributed transactions within government systems
6. Operational Management and Use Cases
- Monitoring tools and views available for Citus to support operational oversight
- Best practices for maintenance and upgrades in distributed environments, particularly for government operations
Requirements
- Completion of Advanced Administration (High Availability & Replication) or equivalent experience for government systems.
- Solid understanding of PostgreSQL configuration and performance optimization.
- Proficiency with Linux operating systems and fundamental network concepts.
Audience
This training is designed for experienced Database Administrators, DevOps Engineers, and System Architects who are currently managing production PostgreSQL environments within government agencies and require the skills to scale these systems horizontally.
Testimonials (5)
A factual and practical approach to the subject. A nice atmosphere, conducive to asking questions.
Marcin - Santander Bank Polska S.A.
Course - Implementing High Availability in PostgreSQL
It was docker and container plus postgres DB inheritance feature which is not available in Oracle Database.
Manish Kumar
Course - PostgreSQL Essentials
It was clearly tailored to be very appropriate to our purpose which made it extra helpful. I really liked the zoom format as it helped me focus with the material right in front of you all the time and the trainer able to add illustrations and markings on to it as he explained. The trainer answered all our questions in a very satisfying way and I felt surprised at how much I was able to learn in one day. Usually i get tired of training by the afternoon but this was very engaging right through to the end. Pace was perfect and detail went into the right areas.
Davina Sanders - Scottish Government
Course - PostgreSQL Performance Tuning
Michal was very knowledgable and engaging as a teacher.
Nate Clifton - NIIT (USA) Inc.
Course - PostgreSQL Advanced DBA
new knowledges that can be apply in our system
