1 Introduction (128.36 MB)
1 Multi-Version Concurrency Control (17.82 MB)
2 MVCC Demo (75.29 MB)
1 Chapter Contents (1.7 MB)
2 VACUUM and Auto-VACUUM (20.34 MB)
3 Autovacuum parameters and understanding the parameters (25.08 MB)
4 Demo (111.37 MB)
1 Intro to Extension (27.66 MB)
2 Installing and Managing Extensions (8.66 MB)
3 Installation of Extension Demo - Using Contrib Module and pgxn client (73.9 MB)
1 PGAdmin4 Intro (6.97 MB)
2 PGAdmin GUI Tool Demo (130.81 MB)
1 User and Roles (37.67 MB)
2 Demo User and Roles (218.42 MB)
1 Chapter Contents (4.34 MB)
10 Demo on Physical Backup and Point in time Recovery (163.91 MB)
2 Understanding Basics - LSN, WAL Segments (20.61 MB)
3 Enable Archive Mode (12.16 MB)
4 Database Crash Recovery (9.26 MB)
5 Backup & Recovery Comparison (11 MB)
6 Timelines (Incarnations) (10.69 MB)
7 Logical Backups (21.64 MB)
8 Demo on Logical Backup and Restore, along with Validation using PGADMIN (160.28 MB)
9 Physical Backup (pg basebackup) and Point in Time Recovery (36.13 MB)
1 Chapter Contents Patching and Upgrade (1.78 MB)
2 Understanding Versioning (5.6 MB)
3 Contacting Postgresql Community for help (10.29 MB)
4 Minor version Upgrade (4.94 MB)
5 Minor Version Upgrade Demo (37.98 MB)
6 Major Version Upgrade using pg upgrade (31.36 MB)
7 Demo on Major Version Upgrade -Postgres 13 to Postgres 15 (Including Extensions) (154.48 MB)
1 Chapter Contents (5.75 MB)
10 PGBadger Demo (127.86 MB)
11 Generating Oracle Style AWR Reports Using pg profile (17.82 MB)
12 DEMO Generating Oracle Style AWR Reports Using pg profile (116.87 MB)
2 Comparison of Performance Tuning Options (15.73 MB)
3 Different types of Indexes (36.97 MB)
4 Partioning (17.85 MB)
5 Understanding the Explain Plan (57.7 MB)
6 Using Hints (14.8 MB)
7 Demo on hints and passing hints without changing code (73.02 MB)
8 Parallelism (52.08 MB)
9 PGBadger (72.02 MB)
1 Chapter Contents (3.71 MB)
10 Demo Part 2 - Configuring PGPool-II to distribute load (68.8 MB)
2 Comparison of HA options (8.56 MB)
3 Understanding Streaming Replication (10.9 MB)
4 Replication Slots (23.25 MB)
5 repmgr - Replication Manager (12.83 MB)
6 PGBouncer (15.86 MB)
7 PGPool-II (10.05 MB)
8 Demo Setup Intro (7.48 MB)
9 Demo Part 1 - Configuring Streaming Replication, Switchover & Automatic Failover (241.32 MB)
1 Chapter Contents (1.83 MB)
2 Regular Administration and Maintenance Activities (18.09 MB)
3 Managing Bloat (19.17 MB)
4 Reindex (11.91 MB)
5 Debugging (14.46 MB)
6 log line prefix (3.78 MB)
1 Highlevel Comparison between Oracle and Postgresql (60.19 MB)
1 End of Course and Reference Document (19.49 MB)
1 Architecture Chapter Contents (3.01 MB)
2 Database Cluster & Instance (102.05 MB)
3 Process Comparison (18.72 MB)
4 Functions of Postmaster (8.08 MB)
5 Summary of Background Processes and its functions (1.42 MB)
6 Listener in Postgres (10.63 MB)
7 Memory Comparison (22.59 MB)
1 Installation - Chapter Contents (2.33 MB)
2 Demo on Installation (62.12 MB)
1 Working with psql (70.64 MB)
2 pgpass (4.49 MB)
3 psqlrc (5.79 MB)
1 Instance Management in Postgres and Comparison with Oracle (8.93 MB)
2 Demo Instance Management (36.52 MB)
1 Contents of PGDATA Chapter Contents (6.15 MB)
10 Quiz on pg hba conf (19.39 MB)
11 Demo on pg hba conf (49.7 MB)
2 Folder Structure of PGDATA (17.82 MB)
3 Control File (19.83 MB)
4 Demo on Exploring contents of PGDATA (86.23 MB)
5 Important Parameters (42.02 MB)
6 Context of a parameter to determine static or dynamic (27.7 MB)
7 Demo of Concepts so far (123.64 MB)
8 Using tools for setting recommended parameters (39.4 MB)
9 pg hba conf (25.33 MB)
1 Logical and Physical Structure - Chapter contents (1.6 MB)
10 TOAST Demo (39.08 MB)
2 Global Objects (7.64 MB)
3 Tablespaces (19.35 MB)
4 Tablespaces DEMO (30.52 MB)
5 Temporary Tablespace (7.87 MB)
6 Temporary Tablespace Demo (43.67 MB)
7 Datafiles (7.82 MB)
8 Datafiles Demo (51.19 MB)
9 TOAST (The Oversized-Attribute Storage Technique) (12.32 MB)
1 System Catalog (29.11 MB)
2 System Catalog Demo (76.75 MB)