Profile cover photo
Profile photo
Robert Haas
PostgreSQL Major Contributor, Committer; VP, Chief Architect, Database Server @ EnterpriseDB
PostgreSQL Major Contributor, Committer; VP, Chief Architect, Database Server @ EnterpriseDB
About
Posts

Post has attachment
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 (MVCC), and if you create multiple versions of rows, you have to eventually get rid of the row versions somehow . In Postg...
Add a comment...

Post has attachment
The State of VACUUM
In a recent blog post , I talked about how why every system that implements MVCC needs some scheme for removing old row versions, and how VACUUM meets that need for PostgreSQL. In this post, I’d like to examine the history of VACUUM improvements in recent y...
Add a comment...

Post has attachment
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 work, but in fact many people don’t. This blog post is my attempt to explain what MVCC is and why PostgreSQL uses it,...
Add a comment...

Post has attachment
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 were committed to PostgreSQL 10 which is expected to be released next week, it seems like a good time for a brief revi...
Add a comment...

Post has attachment
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 astutely observed that there is plenty of room for improvement.  PostgreSQL 10, already at beta3, will go GA some time ...
Add a comment...

Post has attachment
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.  Here, I'd like to present a slightly expanded version of the information which was in the talk.  The information i...
Add a comment...

Post has attachment
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 release cycle (2008-2009), and I've never seen anything like this.  Many people have already blogged about these features e...
Add a comment...

Post has attachment
Parallel Query v2
A recent Twitter poll asked What is your favorite upcoming feature of PostgreSQL V10?   In this admittedly unscientific survey, "better parallelism" (37%) beat out "logical replication" (32%) and "native partitioning" (31%).  I think it's fruitless to argue...
Add a comment...

So, I'm going to Postgres Vision in San Francisco October 11-13th. Other PostgreSQL people who will be there include: Magnus Hagander, Michael Meskes, Oleg Bartunov, Alexander Korotkov, Bruce Momjian, Dave Page, and (at least briefly) Andres Freund. There will be lots of business folks there too. I'm told that I have a personal discount code of RH10offPV which you can use to get 10% off when registering. Come see me talk! I hate talking to an empty room...
Add a comment...

Post has attachment
Uber's move away from PostgreSQL
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 within the PostgreSQL community, with many users and
developers expressing the clear sentiment that Uber ha...
Add a comment...
Wait while more posts are being loaded