VP, Chief Architect, Database Server @ EnterpriseDB, PostgreSQL Major Contributor and Committer
Tuesday, January 30, 2018
DO or UNDO - there is no VACUUM
What if PostgreSQL didn’t need VACUUM at all? This seems hard to imagine. After all, PostgreSQL uses multi-version concurrency control (MVC...
Friday, January 05, 2018
The State of VACUUM
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...
Monday, December 18, 2017
MVCC and VACUUM
Experienced PostgreSQL users and developers rattle off the terms “MVCC” and “VACUUM” as if everyone should know what they are and how they w...
Tuesday, September 26, 2017
PostgreSQL's Hash Indexes Are Now Cool
Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes w...
Monday, August 14, 2017
Plans for Partitioning in v11
The reaction to the new table partitioning feature in PostgreSQL 10 has been overwhelmingly positive, but a number of people have already as...
Wednesday, April 26, 2017
Who Contributes to PostgreSQL Development?
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...
Saturday, April 08, 2017
New Features Coming in PostgreSQL 10
The list of new features coming in PostgreSQL 10 is extremely impressive. I've been involved in the PostgreSQL project since the 8.4 re...
View web version