I am totally impressed by the work 2ndQuadrant is doing: many of the recent innovations to Postgres have been done by them and all of that without any obligation for them to be doing so. The BSD license would allow them to add all of these things to a proprietary fork that they could be selling.<p>Or they could just release their own fork under an open license and focus on just adding features.<p>But that's not how they work. All of their contributions are pushed upstream which is a very considerable effort with how conservative Postgres is at accepting new functionality.<p>Aside of that: there are 2ndQuadrant employees in the #postgres IRC chat room, helping people with daily support issues. This is their core business and yet they still help people for free (within reason). This is bloody impressive.<p>If I'm ever at a point when I need help with a Postgres issue, then they will be very first of the list of companies I would consider.<p>Thank you very much for all that you are doing.
FWIW, a simple benchmark by David Rowley (one of the authors of the patch) are here:<p><a href="http://blog.2ndquadrant.com/parallel-aggregate/" rel="nofollow">http://blog.2ndquadrant.com/parallel-aggregate/</a>
It looks like in 9.4 PG went after the document databases and now they are after Oracle. I don't know why I get excited with point releases of postgres, but I do.
There is going to come a point where Postgres passes Oracle in terms of features and performance.<p>There is also a point that Postgres will perform with enough features needed by most businesses that they'll choose it even though it doesn't match Oracle on a feature by feature basis.<p>We have hit peak Oracle. From this point forward it's going to be hard for Oracle to regain momentum. Expect a lot of FUD against Postgres - the more you see, the more worried you know Oracke execs are becoming.
Short of doing a deep dive into Postgresql, do any universities use Postgresql as a basis for their DB implementation courses? I wanted to dive into Postgres and was hoping for some training wheels. Thanks.
Blog post with some details and benchmarks by one of the authors of the patch:<p><a href="http://rhaas.blogspot.com/2015/11/parallel-sequential-scan-is-committed.html" rel="nofollow">http://rhaas.blogspot.com/2015/11/parallel-sequential-scan-i...</a>
I would love to see some sample benchmarks for the type of gains you might see from this. I always see these interesting new PostgreSQL features being posted, and they sound cool, but it's hard to know how much they help in practice. I understand it's often highly workload and data dependent, but something would be better than nothing.
A slight tangent, but I am still shocked that many open source projects lack downloads via https (including PostgreSQL). Sure you can offer some layer of security by signing the distributions, but ultimately users are lazy.
it's pretty interesting especially for those of us who are creating analytics tools on top of postgresql, the increase performance would certainly permit less denormalized work-around , like creating "manual" aggregate directly in the database (with all the problem of keeping them in sync with the rest)<p>and I'm still here waiting for 9.5 to arrive in RDS of amazon :(