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
Product Updates
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.
Usually, the database administrator controls who can access database data. However, it is possible for clients to completely control who can access data they add to the database, with the help of openssl. First, let's create rsa keys for three users from the command line. We first create an rsa public/private key pair for each user in their home subdirectory and then make a copy of their rsa...
When storing data in the database, there is an assumption that you have to trust the database administrator to not modify data in the database. While this is generally true, it is possible to detect changes (but not removal) of database rows. To illustrate this, let's first create a table: CREATE TABLE secure_demo ( id SERIAL, car_type TEXT, license TEXT, activity TEXT, event_timestamp TIMESTAMP...
News
I’ve come to the end of my time in Europe now and I thought I’d share some of the feedback I’ve received from EDB customers along the way. I’ve been to Stockholm, Paris and Amsterdam, before heading on to Prague, Milan and Brussels.
I have been in Europe now for more than two weeks meeting a number of our customers and PostgreSQL users at the EDB Postgres Summer School. So far I have been in Zürich, London and Oslo and there are further events in the Netherlands, France, Czech Republic, Italy, and Belgium, the Nordics, Spain and Germany throughout the Summer. The purpose of these events is to offer PostgreSQL users a one-day...
EDB Labs
I previously mentioned the importance of high quality documentation, so we are always looking for improvements.
EDB Labs
Postgres isn't the best at naming things. Of course, there is the old computer saying, "There are only two hard things in Computer Science: cache invalidation and naming things." With Postgres being 31 years old and developed by several different project teams, naming can be even more inconsistent. One naming inconsistency, which we have lived with for years, is the name of the write-ahead log...
An age-old question is whether it is better to put data in a database or a file system. Of course, the answer is "it depends," but let's look at what it depends on. First, Postgres stores its data in the file system, so the file system must be good for something. Postgres also stores some of its configuration files in the file system, e.g. pg_hba.conf, so it isn't just a issue that once you have a...
Postgres Alerts It is cool to be able to stare at colorful graphs to see what Postgres is doing, but sometimes you just want to setup something, walk away, and be informed when there is problem. That is what check_postgres and tail_n_mail are designed to do. check_postgres is a script designed to be run from cron or a monitoring tool like Nagios. It reports on areas in the database that need...
EDB Labs
During research for my Postgres Window Magic talk, I studied the unusual behavior of percent_rank and cumm_dist ( cumulative distribution). The Postgres documentation wasn't helpful. I finally came up with this paragraph to add to the Postgres 10 docs: cume_dist computes the fraction of partition rows that are less than or equal to the current row and its peers, while percent_rank computes the...