About

Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EDB since 2006. He has spoken at many international open-source conferences and is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world's largest law firms. As an academic, Bruce holds a Masters in Education, an honorary doctorate, was a high school computer science teacher, and lectures internationally.


    Bruce Momjian Fireside chat: Building Postgres w/Bruce Momjian & Greg Kemnitz
    Building the original Postgres code-base at Berkeley

    presented by Bruce Momjian

    <placeholder> * The early Postgres years at Berkeley * Database design challenges * Database industry trends

    Thu 7 2022 Dev
    Bruce Momjian Future Postgres Challenges

    presented by Bruce Momjian

    Postgres has been a vibrant project for decades, and probably will be popular for decades to come. However, as with any complex endeavor, challenges are always lurking. This talk explores the many project, competitive, and technical challenges in the future that could derail its success. By exploring these challenges, we will be better able to avoid them.

    Fri 8 2022 Data
    Bruce Momjian Non-Relational Postgres

    presented by Bruce Momjian

    Postgres has always had strong support for relational storage. However, there are many cases where relational storage is either inefficient or overly restrictive. This talk shows the many ways that Postgres has expanded to support non-relational storage, specifically the ability to store and index multiple values, even unrelated ones, in a single database field. Such storage allows for greater ...

    more

    Fri 8 2022 Dev
    Bruce Momjian Will Postgres Live Forever?

    presented by Bruce Momjian


    video

    This presentation explains how open source software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.

    Tue 31 2021 Ops
    Bruce Momjian Building Open Source Teams

    presented by Bruce Momjian


    video

    This presentation highlights the challenges of building and managing an open source team of volunteers. Topics include motivation, communication, and project management.

    Tue 29 2021 Dev
    Stephen Frost Bruce Momjian Developer Unconference
    Developer Unconference

    presented by Stephen Frost and Bruce Momjian

    This is a developer unconference.

    Hosted by Bruce Momjian

    Do come if you have interesting Postgres feature ideas

    Tue 17 2020 Everything about Postgres
    Bruce Momjian Will Postgres Live Forever?

    presented by Bruce Momjian

    This presentation explains how open source software can live for a very long time, and covers the differences between proprietary and open source software life cycles. It also covers the increased adoption of open source, and many of the ways that Postgres is innovating to continue to be relevant.

    Thu 19 2020 Everything about Postgres
    Bruce Momjian Postgres and the Artificial Intelligence Landscape

    presented by Bruce Momjian

    Artificial intelligence, machine learning, and deep learning are intertwined capabilities that attempt to solve problems that defy traditional computational solutions --- problems include fraud detection, voice recognition, and search result recommendations. While they defy simple computation, they are computationally expensive, involving computation of perhaps millions of probabilities and wei...

    more

    Thu 19 2020 Everything about Postgres
    Bruce Momjian Databases, Containers, and the Cloud

    presented by Bruce Momjian

    Containers and the cloud are all the rage as companies seek new efficiencies and flexibility. While they are very popular, database use of these facilities is still growing. This talk explores their benefit for database deployments.

    Fri 20 2020 Cloud
    Bruce Momjian PostgreSQL 13: The encrypted data platform for Regulated Industry

    presented by Bruce Momjian

    Join PostgreSQL Core Member and Committer, Bruce Momjian in exploring the current community efforts to bring a new standard of data privacy to PostgreSQL users. In this presentation we will talk about the status of current efforts, the expectations for the upcoming release of PostgreSQL 13 and future plans. We will also touch briefly on current security trends and where PostgreSQL needs to expa...

    more

    Regulated Industry
    Bruce Momjian Exploring Common Table Expressions and Window Functions

    presented by Bruce Momjian

    Developers are often challenged to deliver results that are hard to implement using simple SQL queries. Fortunately, complex SQL capabilities exist in the SQL standard --- common table expressions and window functions.

    SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be...

    more

    Development
    Bruce Momjian Major Features: Postgres 10

    presented by Bruce Momjian

    PostgreSQL 10 is moving along its beta cycle with a likely release this fall. It has many new and exciting features like Logical Replication and Partitioning. This talk will discuss the many upcoming features in PostgreSQL 10.

    PostgreSQL
    Bruce Momjian Mastering PostgreSQL Administration

    presented by Bruce Momjian

    In this course you will learn the essential details of PostgreSQL configuration, security, maintenance, monitoring, tuning, backups, recovery. The course is designed for people with experience in database administration but who are new to the Postgres platform.

    PostgreSQL
    Bruce Momjian Postgres Party

    presented by Bruce Momjian

    After a fun day at PGConf Local: Philly, end the week with a little more PostgreSQL on your way home. If you are near Philadelphia and a PostgreSQL lover, Bruce Momjian has invited you to attend the 2017 Postgres Party at his home in Newtown Square:

    When: Friday, July 14, 6:20pm

    Where: Momjian Residence in Newtown Square, Pennsylvania (directions)...

    more

    Fri 14 2017
    Bruce Momjian Major Features: Postgres 10

    presented by Bruce Momjian

    PostgreSQL 10 is moving along its beta cycle with a likely release this fall. It has many new and exciting features like Logical Replication and Partitioning. This talk will discuss the many upcoming features in PostgreSQL 10.

    Thu 14 2017 Postgres
    Bruce Momjian Postgres Window Magic

    presented by Bruce Momjian

    Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.

    Postgres
    Bruce Momjian MVCC Unmasked

    presented by Bruce Momjian


    video

    Multi-Version Concurrency Control (MVCC) allows Postgres to offer high concurrency even during significant database read/write activity. MVCC specifically offers behavior where "readers never block writers, and writers never block readers". This talk explains how MVCC is implemented in Postgres and highlights optimizations which minimize the downsides of MVCC. This talk is for advanced users.

    Internals
    Bruce Momjian EDB Workshop: 5 Things Developers Need to Know About Digital Transformation with Postgres

    presented by Bruce Momjian

    As new business requirements grow, solutions with open standards are growing as well to support developer needs. During this workshop, Bruce Momjian, Co-Founder of the PostgreSQL Global Development Group and Senior Database Architect at EnterpriseDB, will walk through the most important things developers need to know to stay ahead of digital transformation.

    Learn about: - Data management s...

    more

    Bruce Momjian Programming the SQL Way with Common Table Expressions

    presented by Bruce Momjian

    SQL is a declarative language, meaning the user submits an SQL command and the database determines the optimal execution. Common Table Expressions (CTEs) allow queries to be more imperative, allowing looping and processing hierarchical structures that are normally associated only with imperative languages. This talk will help developers use implement CTE queries in their applications and allow ...

    more

    Development
    Bruce Momjian Making Postgres Central in Your Data Center

    presented by Bruce Momjian

    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.

    Admin
    Bruce Momjian Postgres 11 and Beyond
    A panel on Postgres 11 features and future development

    presented by Bruce Momjian

    An interactive panel with Postgres hackers and developers, moderated by Bruce Momjian.

    Development
    Bruce Momjian Postgres Window Magic

    presented by Bruce Momjian

    Normal SQL queries return rows where each row is independent of the other returned rows. SQL window functions allow queries to return computed columns based on values in other rows in the result set. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results.

    This presentation needs 65 minutes so has to be before lunch, a brea...

    more

    Wed 18 2018 Development
    Bruce Momjian Mastering PostgreSQL Administration

    presented by Bruce Momjian

    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 th...

    more

    Mon 16 2018 Operations and Administration