Commentaires
- Aucun commentaire trouvé
Champs cochés : Confirmé, Expert 595 téléchargements
Excellent Deep Dive into PostgreSQL 14.
Introduction
1.1 Data Organization
Databases
System Catalog
Schemas
Tablespaces
Relations
Files and Forks
Pages
TOAST
1.2 Processes and Memory
1.3 Clients and the Client-Server Protocol
Part I Isolation and MVCC
2 Isolation
3 Pages and Tuples
4 Snapshots
5 Page Pruning and HOT Updates
6 Vacuum and Autovacuum
7 Freezing
8 Rebuilding Tables and Indexes
Part II Buffer Cache and WAL
9 Buffer Cache
10 Write-Ahead Log
11 WAL Modes
Part III Locks
12 Relation-Level Locks
13 Row-Level Locks
14 Miscellaneous Locks
15 Locks on Memory Structures
Part IV Query Execution
16 Query Execution Stages
17 Statistics
18 Table Access Methods
19 Index Access Methods
20 Index Scans
21 Nested Loop
22 Hashing
23 Sorting and Merging