Login

  • 1 Year 24/ 7 access

  • Learn at your own pace

  • Your Course, Your Time, Your Comfort

  • Doubts clarification via mail/call/WhatsApp

  • Recommended for busy/working professionals

  • Less cost compared to Live Training

Enroll Now (₹15,000/$215)

About the Course

PostgreSQL is a powerful, open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

This course teaches you the advanced features of PostgreSQL including Replication, Internals and Memory Tuning.

Course Recordings

Course Materials (Downloadable)

Activity-Guide-v5.0
Slides-v2.0

Introduction to the Course

Replication Concepts
Preview

Preparing the System for Lab Practices

Link to download Pre-built VMs
Initial System Setup

File-based Replication

About File-based Replication
Hands-on: File-based Replication

Streaming Replication

About Streaming Replication
Hands-on: Converting File-base Replication to Aynchronous Streaming Replication
Hands-on: Configuring Asynchronous Streaming Replication from Scratch
About Synchronous Streaming Replication
Hands-on: Configuring Synchronous Streaming Replication
Configuring Multiple Standbys
Hand-on: Configuring Multiple Standbys

Logical Replication

About Logical Replication
Hands-on: Implementing Logical Replication

Internals and Tuning of Shared Buffers

Internals of Shared Buffers
Hands-on: Internals and Tuning of Shared Buffers

Internals and Tuning of Work Memory

Tuning Work Memory

Internals and Tuning of Maintenance Work Mem

About Maintenance Work Memory and Vacuuming
Hands-on: Vacuum in action
About Autovacuum and Tuning Autovacuum