Blog Posts by

Parallelism and Partitioning - Improvements in Postgres 11
October 02, 2018
There have been a number of articles on the upcoming improvements in Postgres v11, including one by EnterpriseDB’s own Bruce Momjian . A couple of...
Are you using force_parallel_mode correctly?
Using force_parallel_mode Correctly
July 30, 2018
I admit it: I invented force_parallel_mode. I believed then, and still believe now, that it is valuable for testing purposes. Certainly, testing...
Built-in Sharding for PostgreSQL
May 22, 2018
Built-in sharding is something that many people have wanted to see in PostgreSQL for a long time. It would be a gross exaggeration to say that...
DO or UNDO - There is no VACUUM
January 30, 2018
What if PostgreSQL didn’t need VACUUM at all? This seems hard to imagine. After all, PostgreSQL uses multi-version concurrency control (MVCC), and if...
The State of VACUUM
January 09, 2018
In a recent blog post , I talked about why every system that implements MVCC needs some scheme for removing old row versions, and how VACUUM meets...
MVCC and VACUUM
December 19, 2017
Experienced PostgreSQL users and developers rattle off the terms “MVCC” and “VACUUM” as if everyone should know what they are and how they work, but...
PostgreSQL's Hash Indexes Are Now Cool
September 26, 2017
Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes were...
Who Contributes to PostgreSQL Development?
April 27, 2017
In a talk which I gave at PGCONF.IN and, in a shorter version, at PGCONF.US, I had a few slides on who contributes to PostgreSQL development. Here, I...
New Features Coming in PostgreSQL 10
April 10, 2017
The list of new features coming in PostgreSQL 10 is extremely impressive. I've been involved in the PostgreSQL project since the 8.4 release cycle (...
Parallel Query v2
March 16, 2017
A recent Twitter poll asked What is your favorite upcoming feature of PostgreSQL V10? In this admittedly unscientific survey, "better parallelism" (...
Uber's Move Away from PostgreSQL
November 16, 2016
Last week, a blog post by an Uber engineer explained why Uber chose to move from PostgreSQL to MySQL . This article was widely reported and discussed...
Corporate Giving: EDB’s Contributions to PostgreSQL
May 25, 2016
There is an important difference between the open source PostgreSQL community and many other open source communities – it is not controlled by a...
PostgreSQL Past, Present, and Future: Moving The Goalposts
January 13, 2016
It's nice to see that PostgreSQL 9.5 is finally released! There are a number of blog posts out about that already, not to mention stories in...
Parallel Sequential Scan is Committed!
November 11, 2015
I previously suggested that we might be able to get parallel sequential scan committed to PostgreSQL 9.5. That did not happen. However, I'm pleased...
PostgreSQL Shutdown
April 01, 2015
PostgreSQL has three shutdown modes: smart, fast, and immediate. For many years, the default has been "smart", but Bruce Momjian has just committed a...
Parallel Sequential Scan for PostgreSQL 9.5
March 18, 2015
Amit Kapila and I have been working very hard to make parallel sequential scan ready to commit to PostgreSQL 9.5. It is not all there yet, but we are...

Top Authors

Bruce Momjian is a co-founder of the PostgreSQL Global Development Group, and has worked on Po...

Robert is Chief Architect, Database Server, employed at EnterpriseDB as well as a PostgreSQL C...

Before joining EnterpriseDB, Marc spent almost 4 years at Polycom, the leading maker of video ...

Ken Rugg is EDB's Chief Product and Strategy Officer and is charged with leading the company's...