Week 03 Lecture
DBMS Parameters
Buffer Pool
Buffer Pool
Page Replacement Policies
Effect of Buffer Management
Ex1: Buffer Management Cost Benefit (i)
Ex2: Buffer Management Cost Benefit (ii)
PostgreSQL Buffer Manager
Buffer Pool Data Types
Buffer Pool Functions
Clock-sweep Replacement Strategy
Ex3: PostgreSQL Buffer Pool
Pages
Page/Tuple Management
Pages
Page Formats
Ex4: Fixed-length Records
Page Formats
Example: Inserting Records
Storage Utilisation
Ex5: Space Utilisation
Overflows
PostgreSQL Page Representation
Ex6: PostgreSQL Pages
Tuples
Records vs Tuples
Operations on Records
Operations on Tuples
Operations for Access Methods
Example Query
Fixed-length Records
Variable-length Records
Converting Records to Tuples
PostgreSQL Tuples
Produced: 14 Mar 2016
![[index]](icon/up.gif){kind=icon}