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
Postgres Tutorials
Tablespaces are designed to allow Postgres clusters to be spread across multiple storage devices. Create tablespace creates a symbolic link in the pg_tblspc directory in the cluster's data directory pointing to the newly-created tablespace directory.
Postgres Tutorials
In my previous blog post, I showed how statistics generated on expression indexes can be used to produce more accurate row counts and potentially better plans. While I did show more accurate row counts via explain, I did not show changed query plans. I plan to do so in this blog post.
Postgres Tutorials
Postgres uses native CPU alignment to store values in a row. This allows blocks to be copied unchanged from disk into shared buffers and accessed as local variables, as outlined in this presentation.
Postgres Tutorials
Most people know that Postgres allows the creation of indexes on expressions. This is helpful if you need index lookups of expressions used in where clauses. However, there is another benefit to expression indexes, and that is optimizer statistics. Not only do expression indexes allow rapid lookups of matching expressions, but they also provide optimizer statistics, which improve row estimates and hence query plans.
Postgres Tutorials
One of the major attractions of Postgres is the ability to stop using database software controlled by a single vendor. Single-vendor control means a single entity controls the software, tools, training, and support. There are sometimes options from other vendors, but they are usually hampered because the source code is closed.
EDB Labs
Postgres 15 is out, with 183 new features and changes. Many of these features are major, but we always try to highlight one feature that is simple and useful. For Postgres 15, we have chosen additions to the copy command for text output and verification of copy headers.
Business Transformation
Practical steps and considerations for cloud migration when moving a database application from on-premises, VMs, and Kubernetes to the cloud or IaaS and DBaaS providers. Here is a short list of things that need to be considered before migrating from on-premise to cloud.
Cloud vendors are barriers like department stores and supermarkets are barriers. But, people associate these entities with providing a huge variety of goods and services, all in one place — so how can that be a barrier? Well, that’s looking at it from the consumer perspective. For the producer, there are mixed benefits. These "super sellers" allow access to much larger markets for most single...
Postgres is an incredibly powerful database that’s packed with many different features. Some of its most interesting and productive capabilities, however, aren’t always evident. This collection of Postgres tips highlights some of the more obscure features users might not be familiar with but can greatly enhance the use of Postgres. 1. S.M.A.R.T. Tools S.M.A.R.T. is an industry-standard way of...
EDB Labs
The world of the Database Administrator (DBA) has changed since the technology went mainstream in the 1970s, writes Bruce Momjian, co-founder of the PostgreSQL Global Development Group. Over the last 40 years three or four vendors have sought to dominate the market and have invested heavily in building the “Rolls Royce” of databases for mission-critical on premises applications.