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.

• Japan PostgreSQL User's Group, December 8, 2001
• O'Reilly Open Source Convention, July 23-27, 2001

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.

• PGCon 2012, May 15, 2012
• PostgreSQL Conference Europe, October 18, 2011
• PgEast 2011, March 22, 2011
• PG East 2010,March 28, 2010
• PG West 2009, October 16, 2009
• PostgreSQL East, April 3, 2009
• CONSEGI 2008, August 29, 2008
• Linux Forum, March 5, 2005
• Gnu/Linux Congress, September 18, 2003
• SRA, February 4, 2003
• O'Reilly Open Source Convention, July 22, 2002
• 2003 O'Reilly Open Source Convention, July 7-11, 2003
• Renmin University, February 25, 2003
• Free and Open source Software Developers' European Meeting, February 8-9, 2003
• Japan PostgreSQL User's Group, February 1, 2003

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.

• Southeast LinuxFest 2012, June 10, 2012
• ConFoo, February 29, 2012
• GULEV, December 8, 2006
• NordU Usenix 2004, January 29, 2004
• International PHP Conference, November 2-5, 2003
• Free and Open source Software Developers' European Meeting, February 8-9, 2003
• O'Reilly Open Source Convention, July 22, 2002
• SRA, December 10, 2001

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.

• Drexel University February 24, 2010
• OpenSQL Camp, November 15, 2008 (video)
• NordU Usenix 2004, January 29, 2004
• 2003 O'Reilly Open Source Convention, July 7-11, 2003

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.

• ConFoo, February 27, 2013
• New York PostgreSQL Meetup Group, May 7, 2012 (video)
• EnterpriseDB Webcast, June 22, 2011 (video, registration required)