⇽ Bruce Momjian ⇽

Old/Superseded Presentations



Postgres

PostgreSQL:  Introduction and Concepts - Book

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.
Duration: 6 hours, 8 hours with questions

YeSQL: Battling the NoSQL Hype Cycle with Postgres

Relational databases are regularly challenged by new technologies that promise to make SQL obsolete, but the new technologies often fade into obscurity. This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads.
Duration: 45 minutes, 1 hour with questions

Great Steps in PostgreSQL History

This talk explores the challenges faced by the PostgreSQL community. The challenges often seemed insurmountable, but everything came out well in the end.
Duration: 45 minutes, 1 hour with questions

The PostgreSQL Decade

This talk explores the first ten years of PostgreSQL development, with highlights on the first few months of its formation.
Duration: 45 minutes, 1 hour with questions

Enterprise Postgres Growth in Japan

Japan was the first country with wide-spread enterprise adoption of Postgres. This talk explores why Japan was such an early adopter of Postgres, and how Japanese developers are being encouraged to move Postgres forward.
Duration: 45 minutes, 1 hour with questions

How to Get Your PostgreSQL Patch Accepted

Developing a patch for the Postgres project is a fairly complex process, and success is not guaranteed. This talk will suggest many ways to improve your chances of submitting a successful patch to the PostgreSQL community.
Duration: 45 minutes, one hour with questions

Get To Know PostgreSQL

This talk was written by Oddbjørn Steffensen and is a great overview of PostgreSQL. It gives a good sampling of the database's capabilities and community efforts. It is particularly useful for those considering migrating from other databases to PostgreSQL. This is a technical talk only to the extent it covers database capabilities.
Duration: 45-90 minutes, 1-2 hours with questions

History of PostgreSQL

Writing an Internet Book

PostgreSQL:  Introduction and Concepts -- One Year Later - Article

History of PostgreSQL - Chapter

Behavior of Open-Source Support Companies - Article

Advantages of PostgreSQL and Open Source Software

How Companies Can Effectively Contribute To Open Source Communities - Article

Drive Your Own Car

This talk explores how technology changes in the past have dramatically altered industries that seemed unchangeable. It then shows how the Internet is another of those technology changes that will dramatically alter the software world.
Duration: 45 minutes, 1 hour with questions

Selling Your Boss On Open Source

This talk is the same as "PostgreSQL Adoption and Trends", except most of the PostgreSQL-specific parts have been removed. It is more general and emphasizes on open source in general.
Duration: 60 minutes, 75 minutes with questions

PostgreSQL's Path to the Future

This talk considers the possible future directions for the PostgreSQL software and the project.
Duration: 30 minutes, 45 minutes with questions

The Postgres Trajectory

This short presentation covers the two driving forces behind Postgres's dramatic rise in popularity — its open source development and extendibility. Open source software now dominates the enterprise software stack, and Postgres is no exception. This talk explains how open source is able to produce software of superior features, quality, and performance. The second part of the talk explains how the extendibility built into Postgres from its inception has enabled it to efficiently adapt to today's data needs.
Duration: 20 minutes, 30 minutes with questions

The Postgres Open Source Development Process

This talk is for people who are unfamiliar with the open source community or need to work directly with the community.  The talk highlights how open source development differs from proprietary development, the pattern of PostgreSQL development, and PostgreSQL developer motivation. Renamed and restructured, June 2014
Duration: 45 minutes, 60 minutes with questions

PostgreSQL: Past, Present, and Future

This talk is perfect for those new to PostgreSQL or people who just want a general introduction to the project.  It covers its origins in academia, its movement to Internet-based development, why people choose PostgreSQL, its current usage, and future directions.
Duration: 30 minutes, 1 hour with questions

The Magic of Hot Streaming Replication

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.
Duration: 30 minutes, 45 minutes with questions

PostgreSQL Replication Solutions

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.
Duration: 45 minutes, 75 minutes with questions



Other Topics

Preventing Data Loss Through Prudent Archiving

No one likes the sinking feeling of having lost data - pictures, documents, source code, or video that is gone and can never be fully recreated. Though prudent archiving and risk analysis, it is possible to avoid data loss in all but the most extreme circumstances. Data longevity is also an important aspect of archiving, including the use of open data formats.
Duration: 45 minutes, 1 hour with questions

Increasing Website Bandwidth Using Cloud Services

Most websites haves several frequently-accessed or slow-downloading files. They might also have content that could be very popular one day. This talk shows how you can use cloud storage for these files to greatly increase your website's bandwidth and responsiveness. This requires minimal website changes. The demonstration includes Amazon S3 bucket configuration, mapping DNS subdomains to S3 buckets, and using Linux's s3cmd tool to upload files. Also included is configuration of CloudFront to increase the responsiveness of your website globally.
Duration: 20 minutes, 30 minutes with questions

Blocking Unsolicited Email (Spam) - Article