PostgreSQL Fundamentals: Architecture

Intended Audience

This course is intended for:

• Database administrators
• Database developers
• Database architects
• Database engineers

Course Objectives

In this course, you will learn how to:

• Understand the architecture of a PostgreSQL database
• Read, write, and edit data in a PostgreSQL database
• Store data in a PostgreSQL database

Prerequisites

We recommend that attendees of this course have the following prerequisites:

• Taken the PostgreSQL Fundamentals course
• Familiarity with relational databases
• Familiarity with structured query language (SQL)

Delivery Method

This course is delivered through:

• Digital training

Duration

1 hour

Course Outline

This course covers the following concepts:

• Client Architecture
• Server Overview
• Process Components
• Memory Components
• Per-Session Memory
• Data Directory
• base Directory
• Block / Page Layout
• Storing Large Values
• TOAST Table
• pg_wal Directory
• On-Disk Components
• In-Motion
• Connect Request
• Reading Data
• Writing (or deleting) Data
• MVCC
• Logical Layout
• Logical-Physical Mappings