Bruce Momjian

Postgres Technical Presentations


PostgreSQL:  Introduction and Concepts - Book

Duration: 6 hours, 8 hours with questions
This talk is best for those who are new to databases and SQL.  This talk is a condensed presentation of the material in my book.  It covers all aspects of PostgreSQL, but its primary focus is to introduce SQL.  The talk can be split into two parts: "Introduction to SQL" and "Advanced SQL Features".  Each chapter can be presented independently. (book web site)

PostgreSQL Performance Tuning - Presentation

Duration: 3 hours, 4 hours with questions
This talk is designed for advanced PostgreSQL users who want to know how to maximize PostgreSQL performance.  It covers every aspect of performance: server settings, caching, sizing operating system resources, optimizer processing, problem queries, storage efficiency, and some hardware selection details.  It includes how to size shared memory, how to understand the output of the optimizer, when to restructure queries, and how to configure storage for optimal performance.

Mastering PostgreSQL Administration - Presentation

Duration: 3 hours, 4 hours with questions
This talk is designed for PostgreSQL administrators.  It covers all aspects of PostgreSQL administration, including installation, security, file structure, configuration, reporting, backup, daily maintenance, monitoring activity, disk space computations, and disaster recovery.  It shows how to control host connectivity, configure the server, find the query being run by each session, and find the disk space used by each database.

Data Processing Inside PostgreSQL - Presentation

Duration: 3 hours, 4 hours with questions
This talk is best for those who are are familiar with databases and SQL, but want to learn how to move processing from their applications into the database to improve consistency, administration, and performance.  Topics covered  include advanced SQL features like referential integrity constraints, ANSI joins, views, rules, and triggers.  The presentation also explains how to create server-side functions, operators, and custom data types in PostgreSQL.

PostgreSQL Internals Through Pictures - Presentation

Duration: 3 hours, 4 hours with questions
This talk is designed for advanced PostgreSQL users who want to know more about how the database internally processes a query.  It is also ideal for people wanting to modify the PostgreSQL server source code.  It covers PostgreSQL network communication, query parsing, optimizer plan selection, multiversion concurrency control (MVCC), and internal storage characteristics.  It does not require any programming knowledge.

Inside PostgreSQL Shared Memory - Presentation

Duration: 30 minutes, 45 minutes with questions
This talk is for people who want to understand how PostgreSQL shares information among processes using shared memory. The talk covers the internal data page format, usage of the shared buffers, locking methods, and various other shared memory data structures.

PostgreSQL Replication Solutions - Presentation

Duration: 45 minutes, 75 minutes with questions
This talk is for people who need some kind of replication and want to learn more about the replication options available for PostgreSQL.  Replication is not a single technology but rather a group of needs and solutions that has to be tailored to each usage for optimal performance and functionality.  This talk outlines the major needs for replication and major solutions, including those currently implemented in PostgreSQL and those in development.

Porting PostgreSQL To The Win32 Platform - Presentation

Duration: 30 minutes, 60 minutes with questions
This talk explores the challenges of porting PostgreSQL to the Win32 platform.  The presentation includes a demonstration of installing PostgreSQL on Windows.

Rapid Upgrades With Pg_Upgrade - Presentation

Duration: 30 minutes, 45 minutes with questions
Pg_Upgrade allows data to be transferred between major Postgres versions without a dump/restore. It does this by transfering the user data and version-dependent data separately. This talk explains the internal workings of pg_upgrade and includes a pg_upgrade demonstration.

Securing PostgreSQL From External Attack - Presentation

Duration: 30 minutes, 45 minutes with questions
This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. Postgres supports features to eliminate all of these threats, but administrators must understand the attack vulnerabilities to protect against them. This talk covers all known Postgres external attack methods.

The Magic of Hot Streaming Replication - Presentation

Duration: 20 minutes, 30 minutes with questions
This talk explores the much-anticipated Postgres 9.0 features of hot standby and streaming replication. It explains how these features work, how to configure them, and their current limitations. It includes a hands-on demonstration that can be done either by the instructor or by students.

Writing PostgreSQL Database Applications - Article

PostgreSQL Hardware Performance Tuning - Article