Blog Posts by

Amazon's DocumentDB, MongoDB, and TechCrunch
Jan 17, 2019
Over on TechCrunch, you can find an article posted with the inflammatory title AWS gives open source the middle finger . The premise of the article...
Parallelism and Partitioning - Improvements in Postgres 11
Oct 2, 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
Jul 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 PostgreSQL VACUUM
Jan 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
Jan 9, 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
Dec 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
Sep 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...
Qui contribue au développement de PostgreSQL ?
Apr 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...
Nouvelles fonctionnalités à venir dans PostgreSQL 10
Apr 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 (...
Requête parallèle v2
Mar 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
Nov 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
Jan 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!
Nov 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
Apr 1, 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...