Module 2 - System Architecture

Module Objectives

Architectural Summary

Proces and Memory Architecture

Utility Proceses

More Utility Proces

Postmaster as Listener

User Back End Process

Respond to Client

Demo -List of Processes

Disk Read Buffering

Disk Write Buffering

Background Writer Cleaning Scan

Write Ahead Logging (WAL)

Transaction Log Archiving

Commit and Checkpoint

Statement Processing

Physical Database Architecture

Installation Directory Layout

Database Cluster Data Directory Layout

Physical Database Architecture

Demo - Data Directory

Sample - Data Directory Layout

Page Layout

Page Structure

Module Summary