BEGIN:VCALENDAR VERSION:2.0 METHOD:PUBLISH CALSCALE:GREGORIAN PRODID:-//WordPress - MECv5.5.0//EN X-ORIGINAL-URL:https://osb-alliance.de/ BEGIN:VEVENT UID:MEC-4600fac20e73cc30e734c8201ae46d5c@osb-alliance.de DTSTART:20260112T070000Z DTEND:20260116T170000Z DTSTAMP:20251231T180500Z CREATED:20251231 LAST-MODIFIED:20260126 SUMMARY:PostgreSQL Advanced for DBA (DBA2) – Data Egret DESCRIPTION:🗓️ 12-16 January 2026 💻 5 live online sessions, 3h30m each 🎤 Includes: Q&A, theory and live demo 🏷️ Price: €850 before taxes PREREQUISITES To participate in this course, you must either have completed our (DBA1) PostgreSQL Essentials course or possess practical experience with PostgreSQL daily operations (creating databases, managing roles, performing routine maintenance tasks, and exporting/importing data). You should also be comfortable with SQL transactions and able to manage PostgreSQL services and configurations on Linux systems. Familiarity with performance monitoring and basic shell scripting is also recommended. For details see the course T&Cs This advanced multi-day course is designed for database administrators who want to strengthen their knowledge of PostgreSQL internals and best practices. PostgreSQL architecture and processes Optimal configuration techniques MVCC and the transactional engine Physical backups and Point-in-Time Recovery (PITR) Partitioning and connection pooling What You’ll Learn The course is designed to equip you with the essential skills to install, operate, maintain, and monitor PostgreSQL for reliable and efficient database management. PostgreSQL architecture and Write-Ahead Logging This chapter introduces PostgreSQL’s internal architecture, focusing on how it manages processes, memory, and durability. Highlights include: The main background processes and their responsibilities Shared and per-process memory areas, and their tuning How PostgreSQL organises files in PGDATA The role of Write-Ahead Logging (WAL) in ensuring data consistency and recovery MVCC, VACUUM and isolation levels This chapter explores PostgreSQL’s Multi-Version Concurrency Control (MVCC) model and how it ensures both consistency and concurrency. Highlights include: How PostgreSQL manages row versioning with system columns such as xmin, xmax, and ctid The impact of isolation levels (READ COMMITTED, REPEATABLE READ, SERIALIZABLE) on transaction consistency The internals of VACUUM and autovacuum: cleaning dead tuples, trigger conditions, and tuning options Strategies to prevent bloat and protect against transaction ID wraparound Point-in-Time Recovery and WAL Archiving in PostgreSQL This chapter introduces the principles and practices of Point-in-Time Recovery (PITR) in PostgreSQL. Highlights include: Continuous archiving and its role in recovery Configuring WAL archiving for PITR Performing file system backups with pg_basebackup or manual methods Executing a point-in-time recovery and controlling recovery targets Best practices for backups, restore testing, and minimising downtime Declarative table partitioning in PostgreSQL This chapter introduces declarative table partitioning in PostgreSQL, a feature designed to simplify the management of large datasets. Highlights include: An overview of the partitioning methods: list, range, and hash How to define multi-column and nested (sub-)partitions Managing partitions: attach, detach, and default partitions Performance considerations and planning-time behaviour Common limitations and best practices for effective partitioning Connection pooling in PostgreSQL with PgBouncer This chapter explores how PostgreSQL can efficiently handle large numbers of client connections through connection pooling, focusing on PgBouncer. It covers: Why and when to use a connection pooler Comparison of pooling modes: session, transaction, and statement Installation, configuration, and monitoring of PgBouncer Advanced usage: delegated authentication, query cancellation, and multi-instance scaling Format and Schedule This extensive PostgreSQL course consists of 5 live sessions (3h30m each), delivered over five days, w/c 12 January 2026. To receive a certificate of attendance, participants must attend all five sessions. Sessions will be conducted in English via Zoom. Participants must have the latest version of Zoom installed on their computer. Please note: Sessions will not be recorded. The course format combines theoretical slides with live demos, led by the instructor in real time. Each session includes a live Q&A for direct interaction. There will be a 10-minute break halfway through each 3.5-hour session. Cost: €850 before taxes. Session Schedule (all times CET) Monday, 12 January 10:00–13:30 Tuesday, 13 January 10:00–13:30 Wednesday, 14 January 10:00–13:30 Thursday, 15 January 10:00–13:30 Friday, 16 January 10:00–13:30 URL:https://osb-alliance.de/veranstaltungen/postgresql-advanced-for-dba-dba2-data-egret ORGANIZER;CN=Data Egret GmbH:MAILTO: LOCATION:Online-Veranstaltung ATTACH;FMTTYPE=image/png:https://osb-alliance.de/wp-content/uploads/2025/12/DBA2-OSBA.png END:VEVENT END:VCALENDAR