Upcoming

PostgreSQL 18 Architecture for Oracle DBAs

Riaz Ahmad Ansari

Oracle & Cloud Database Consultant

213 bookings across all services

49 seats left

Nov

Sun 1 Nov

10:00PM GMT+5:30 | 90mins

PostgreSQL 18 Architecture for Oracle DBAs

Join this live session to understand PostgreSQL 18 architecture through the lens of an Oracle DBA.

If you already work with Oracle databases and want to expand your skills into PostgreSQL, this session will help you understand the key architectural concepts and the similarities and differences between the two database platforms.

What You Will Learn

PostgreSQL Architecture: Understand the server architecture, database cluster, databases, and schemas.
Process Architecture: Explore the postmaster, backend processes, and background workers.
Memory Management: Understand shared memory, shared_buffers, work_mem, and backend memory.
Query Processing: Learn how PostgreSQL parses, plans, and executes SQL statements.
Storage Architecture: Explore PGDATA, data files, pages, tuples, and TOAST.
WAL and Recovery: Understand Write-Ahead Logging, checkpoints, and crash recovery.
MVCC and VACUUM: Learn how PostgreSQL manages concurrent transactions and removes obsolete row versions.
Replication and High Availability: Understand streaming replication, hot standby, and key differences from Oracle Data Guard.
Backup and Recovery: Explore base backups, WAL archiving, and Point-in-Time Recovery (PITR).
What's New in PostgreSQL 18: Review important features relevant to database administrators.

Who Should Attend?

Oracle DBAs who want to learn PostgreSQL architecture.
Database administrators preparing for PostgreSQL responsibilities or interviews.
Senior DBAs and database consultants expanding their multi-database skills.
IT professionals interested in Oracle-to-PostgreSQL migration.

Learn PostgreSQL architecture using familiar Oracle concepts, practical comparisons, and DBA-focused explanations.

Expand your database knowledge and take the next step toward becoming a multi-database DBA.