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
  • 947 KB
Slides-v2.0
  • 1.47 MB

Introduction to the Course

Replication Concepts
  • 31 mins
  • 56.3 MB
Preview

Preparing the System for Lab Practices

Link to download Pre-built VMs
    Initial System Setup
    • 22 mins
    • 53.3 MB

    File-based Replication

    About File-based Replication
    • 15 mins
    • 10.7 MB
    Hands-on: File-based Replication
    • 31 mins
    • 40 MB

    Streaming Replication

    About Streaming Replication
    • 34 mins
    • 27.4 MB
    Hands-on: Converting File-base Replication to Aynchronous Streaming Replication
    • 13 mins
    • 20.1 MB
    Hands-on: Configuring Asynchronous Streaming Replication from Scratch
    • 34 mins
    • 47.2 MB
    About Synchronous Streaming Replication
    • 9 mins
    • 6.12 MB
    Hands-on: Configuring Synchronous Streaming Replication
    • 14 mins
    • 16.9 MB
    Configuring Multiple Standbys
    • 11 mins
    • 8.99 MB
    Hand-on: Configuring Multiple Standbys
    • 36 mins
    • 48.4 MB

    Logical Replication

    About Logical Replication
    • 25 mins
    • 18.9 MB
    Hands-on: Implementing Logical Replication
    • 22 mins
    • 31.7 MB

    Internals and Tuning of Shared Buffers

    Internals of Shared Buffers
    • 31 mins
    • 22 MB
    Hands-on: Internals and Tuning of Shared Buffers
    • (1h 04m 36s)
    • 93.1 MB

    Internals and Tuning of Work Memory

    Tuning Work Memory
    • 18 mins
    • 22.4 MB

    Internals and Tuning of Maintenance Work Mem

    About Maintenance Work Memory and Vacuuming
    • 27 mins
    • 20.1 MB
    Hands-on: Vacuum in action
    • 7 mins
    • 8.51 MB
    About Autovacuum and Tuning Autovacuum
    • 24 mins
    • 19.3 MB