PostgreSQL Administration 16. Configuration and Monitoring

Course ID : PS-DBA2

Duration In-class (в days) : 4 days

Duration Online : 4 days

Сurriculum : Virtual Instructor-Led Training - ONLINE

Overview

This course covers key DBMS mechanisms, such as the multi-version control system (MVCC), buffer cache, write-ahead log (WAL), and others.

Audience for this course

Objective

Prerequisites for this course

Outcomes

By completing this course, students will have acquired the skills to:

    • Configure various configuration parameters based on an understanding of the server’s internal organization
    • Monitor the server using feedback to iteratively adjust parameters
    • Make localization-related adjustments
    • Manage extensions and become familiar with the server update procedure

Outline

Module 1. “Multi-Versioning”

  • Isolation
  • Pages and Row Versions
  • Snapshots
  • HOT updates
  • Vacuum
  • AutoVacuum
  • Freeze

Lab Work

  • Investigу еransaction Behavior at Different Isolation Levels
  • Work with Row Versions and Nested Transactions
  • Work with snapshots
  • In-page updates and vacuum
  • Normal and full cleanup
  • Automatic cleanup and configuration
  • Freeze row versions

Module 2. “Journaling”

  • Buffer cache
  • Write-ahead Log
  • Checkpoint
  • Log configuration

Lab Work

  • Explore and Warming Up the Buffer Cache
  • Work with Log Records
  • Checkpoint Configuration
  • Explore the Impact of Log Settings on Log Size

Module 3. “Lock”

  • Object locking
  • Row locks
  • In-Memory locks

Lab work

  • Work with object locks and predicate locks
  • Row locks and Deadlocks
  • Work with in-Memory Locks

Module 4. “Administration Tasks”

Extension Management

  • Localization
  • Update the Server

Lab Work

  • Create and update an extension
  • Transfere data between databases with different encodings
  • Update the server taking into Account the data placement in certain encodings tablespaces

 

Ask question