Published 8/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
PostgreSQL Database Administration : Walk-in a Beginner, Walk-Out an Expert (Performance Tuning)
What you’ll learn
PostgreSQL Installation from Source Code.
Segregation of PostgreSQL Files and Best Practices.
Performance tuning PostgreSQL Server Parameters.
Query Optimization.
Performance Monitoring and Events.
Optimizer and Extended Statistics.
Error Reporting and logging.
PgBadger.
Pg_Buffercache.
Pg_Prewarm.
Internals of Shared Buffers and Clock Sweep Algorithm.
Requirements
Basic Knowledge of Database Concepts
Working Knowledge on Windows and Linux
Internet access is required to download PostgreSQL Server
Description
Overview
Section 1: Introduction
Lecture 1 Introduction to Performance Tuning
Section 2: Source Code Installation and Segregation of Postgresql Files
Lecture 2 Source Code Install Introduction
Lecture 3 Source Code Install Demo
Lecture 4 Move Pg_Wal Files from Default Location to Desired Location.
Lecture 5 Move Temp Files to Desired Location Intro.
Lecture 6 Move Temp Files to Desired Location Demo.
Lecture 7 Move User Objects – Default Tablespace
Lecture 8 Memory Parameters – Shared Buffer Intro
Lecture 9 Clock Sweep Algorithm
Lecture 10 Shared Buffer Demo
Lecture 11 Pg_Buffercache Extension
Lecture 12 Pg_Prewarm Extension
Lecture 13 Work_Mem Tuning Intro
Lecture 14 Work_Mem Tuning Demo
Lecture 15 Maintenance_ Work_Mem
Lecture 16 AutoVacuum_Work_Mem
Lecture 17 Max Connection Tuning Intro
Lecture 18 Max Connection Tuning Demo – 1
Lecture 19 Max Connection Tuning Demo – 2
Lecture 24 Checkpoint Tuning Intro
Lecture 25 Checkpoint Timeout
Lecture 26 Checkpoint Completion Target
Lecture 27 Max_Wal_Size
Lecture 28 Pg_Stat_Bgwriter
Lecture 29 Effective Cache Size
Lecture 30 Asynchronous Behavior
Lecture 31 Statement Processing.
Lecture 32 Components of Explain Plan.
Lecture 33 Table Access Method
Lecture 37 Index Optimization Intro
Lecture 38 Index on Expression
Lecture 40 Multi-Column Indexes
Lecture 41 Null Value Considerations.
Lecture 42 Covering Indexes
Lecture 43 Useful Index Queries – Demo
Lecture 44 Extended Statistics Intro
Lecture 45 Extended Statistics Demo
Section 8: Postgresql Monitoring
Lecture 49 Error Logging and Reporting.
Lecture 50 PgBadger Introduction
Lecture 51 PgBadger Demo – 1
Lecture 52 PgBadger Demo – 2
Lecture 53 Pg_Stat_Statements Introduction
Lecture 54 Pg_Stat_Statements Demo
Lecture 55 Server OS Monitoring – Windows
Lecture 56 Server OS Monitoring – Linux
Database Administrators,Accidental DBA’s,Developers,Architects and Analyst,Students,Anyone who is curious about PostgreSQL
