Profile cover photo
Profile photo
Robert Haas
PostgreSQL Major Contributor, Committer; Chief Architect, Database Server @ EnterpriseDB
PostgreSQL Major Contributor, Committer; Chief Architect, Database Server @ EnterpriseDB
Robert Haas's posts

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 ...

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...

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...

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...

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...

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...

Post has attachment
PostgreSQL Regression Test Coverage
This evening, I ran the PostgreSQL regression tests (make check-world) on master and on each supported back-branch three times on hydra, a community test machine provided by IBM.  Here are the median results: 9.1 - 3m49.942s 9.2 - 5m17.278s 9.3 - 6m36.609s ...

Post has attachment
PostgreSQL 9.6 with Parallel Query vs. TPC-H
I decided to try out parallel query, as implemented in PostgreSQL 9.6devel, on the TPC-H queries.  To do this, I followed the directions at - thanks to Tomas Vondra for those instructions.  I did the test on an IBM POWER7 ...

Post has attachment
Parallel Query Is Getting Better And Better
Back in early November, I reported that the first version of parallel sequential scan had been committed to PostgreSQL 9.6.  I'm pleased to report that a number of significant enhancements have been made since then.  Of those, the two that are by the far th...

Post has attachment
No More Full-Table Vacuums
I just committed a very important patch to PostgreSQL.  The short summary for the patch is " Don't vacuum all-frozen pages. " and it follows up on a patch I committed last week, whose short summary was " Change the format of the VM fork to add a second bit ...
Wait while more posts are being loaded