Bruce Momjian

VP, Postgres Evangelist, EDB

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996 as a committer and community leader. He is a frequent speaker and Postgres evangelist and travels worldwide appearing at conferences to help educate the community on the business value of Postgres advances and new technology enhancements. He is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. 

 

 

Read Blogs

EDB Labs

Who is in charge of Postgres?

When people want to get involved with the Postgres project, they assume we have a structure similar to other organizations. They look for those in charge: "Who controls limited resources?", "How to get in a position of leadership?", and they get confused. Sometimes they focus on the core team — they must be in charge, but they aren't elected, and the list of things they manage doesn't appear to be foundational to the project.
Business Transformation

The History of PostgreSQL: How Postgres Became the World’s Leading Open Source Database

Discover the fascinating history of PostgreSQL, from its origins at Berkeley to its rise as the top open-source database. Learn how Postgres evolved to power modern applications worldwide.
EDB Labs

Explaining the PostgreSQL Query Optimizer with Bruce Momjian—Beyond Joins and Indexes: Webinar Recap

What exactly is the PostgreSQL query optimizer capable of? Are you experiencing its full potential, or just scratching the surface? We recently released Part 1 of our two-part webinar series, explaining the PostgreSQL query optimizer. Now, we’re excited to share our recap of Part 2, which you can watch in its entirety on-demand.
EDB Labs

Explaining the PostgreSQL Query Optimizer with Bruce Momjian: Webinar Recap

In EDB’s recent webinar, Explaining the PostgreSQL Query Optimizer Part 1, EDB Vice President and Postgres Evangelist Bruce Momjian broke down the importance of the PostgreSQL query optimizer: what makes it such a dynamic tool, and how your teams can take full advantage of it.
Postgres Tutorials

Postgres AT TIME ZONE Explained

I saw AT TIME ZONE used in a query, and found it confusing. I read the Postgres documentation and was still confused, so I played with some queries and finally figured it out. I then updated the Postgres documentation to explain it better, and here is what I found.
Product Updates

PostgreSQL unique constraint null: Allowing only one Null

While the SQL standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g. MSSQL) allow only a single null in such cases. Users migrating from other database systems sometimes want to emulate this behavior in Postgres. Fortunately, this can be done.
Postgres Tutorials

How to use pg_dump and pg_restore in multi-host enviorment

You have probably looked at logical dumps as supported by pg_dump and restores by pg_restore or, more simply, psql. What you might not have realized are the many options for dumping and restoring when multiple computers are involved.
Postgres Tutorials

How to use Xmin in PostgreSQL Queries

Someone at a conference mentioned they were using the invisible xmin column to perform updates. I was initially skeptical of this approach, but once he explained the purpose, it made sense.
Postgres Tutorials

How to properly sign rows to provide integrity in PostgreSQL

With the rsa keys created in my previous blog entry, we can now properly sign rows to provide integrity and non-repudiation, which we did not have before. To show this, let's create a modified version of the previous schema by renaming the last column to signature.
Postgres Tutorials

Switchover/Failover and Session Migration

I have already covered switchover and failover. In the case of failover, the old primary is offline so there are no options for migrating clients from the old primary to the new primary. If there is a switchover, there are options for client migration. Assuming you are using streaming replication, only one server can accept writes.