VP, Chief Architect, Database Server @ EnterpriseDB, PostgreSQL Major Contributor and Committer
Thursday, June 21, 2018
Using force_parallel_mode Correctly
I admit it: I invented force_parallel_mode. I believed then, and still believe now, that it is valuable for testing purposes. Certainly, t...
Friday, June 01, 2018
Who Contributed to PostgreSQL Development in 2017?
Last year, I wrote a post on who contributed to PostgreSQL development in 2016 . This is a (belated) version of the same information for 20...
Thursday, May 17, 2018
Built-in Sharding for PostgreSQL
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 th...
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...
View web version