Bruce Momjian

Postgres Technical Overview 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.

Mastering PostgreSQL Administration

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.

PostgreSQL Performance Tuning

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.

Data Processing Inside PostgreSQL

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.

Database Hardware Selection Guidelines

Duration: 30 minutes, 45 minutes with questions
Database servers have hardware requirements different from other infrastructure software, specifically unique demands on I/O and memory. This presentation covers these differences and various I/O options and their benefits. Topics include solid-state drives (SSD), battery-backed RAID, controllers, and caching.

Making Postgres Central in Your Data Center

Duration: 45 minutes, 1 hour with questions
Postgres has the unique ability to act as a powerful data aggregator in many data centers. This talk shows how Postgres's extensibility, access to foreign data sources, and ability handle NoSQL-like and data warehousing workloads gives it unmatched capabilities to function in this role.

Postgres Scaling Opportunities

Duration: 45 minutes, 1 hour with questions
Database scaling is the ability to increase database throughput by utilizing additional resources such as I/O, memory, cpu, or additional computers. However, the high concurrency and write requirements of database servers make scaling a challenge. Sometimes scaling is only possible with multiple sessions, while other options require data model adjustments or server configuration changes. This talk explores the multi-session, single-session, and multi-host scaling options and the workloads where these options are appropriate.

The Future of Postgres Sharding

Duration: 30 minutes, 45 minutes with questions
Database sharding involves spreading database contents across multiple servers, with each server holding only part of the database. While it is possible to vertically scale Postgres, and to scale read-only workloads across multiple servers, only sharding allows multi-server read-write scaling. This presentation will cover the advantages of sharding and future Postgres sharding implementation requirements, including foreign data wrapper enhancements, parallelism, and global snapshot and transaction control. This is a followup to my Postgres Scaling Opportunities presentation.