Postgresql 9.6: Support parallel aggregation

ddorian43 wrote: post #3

tiglionabbit wrote: post #2

Does it have generic upserts yet?

What do you mean by generic ? Upserts were implemented in 9.5

As in you don't need to write a unique PL/pgSQL routine for each kind of upsert you want to do.

Oh, it does have upserts now. Awesome =]

Re: Postgresql 9.6: Support parallel aggregation

#5

Post by kbenson » Mon, Mar 21, 2016, 9:36 PM UTC

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.

Re: Postgresql 9.6: Support parallel aggregation

#6

Post by olavgg » Mon, Mar 21, 2016, 9:44 PM UTC

kbenson wrote: post #5

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.

It would help a lot for typical data warehouse queries that involves aggregating millions to billions of rows. SELECT EXPLAIN ANALYZE will tell if its relevant for you ;-)

Re: Postgresql 9.6: Support parallel aggregation

#7

Post by chris_wot » Mon, Mar 21, 2016, 9:55 PM UTC

There is going to come a point where Postgres passes Oracle in terms of features and performance.

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.

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.

Re: Postgresql 9.6: Support parallel aggregation

#8

Post by filereaper » Mon, Mar 21, 2016, 10:00 PM UTC

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.

Re: Postgresql 9.6: Support parallel aggregation

#9

Post by kazagistar » Mon, Mar 21, 2016, 10:05 PM UTC

Blog post with some details and benchmarks by one of the authors of the patch:

http://rhaas.blogspot.com/2015/11/parallel-sequential-scan-i...

Re: Postgresql 9.6: Support parallel aggregation

#10

Post by pbarnes_1 » Mon, Mar 21, 2016, 10:08 PM UTC

chris_wot wrote: post #7

There is going to come a point where Postgres passes Oracle in terms of features and performance. 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. 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 Postgr…

This migration has been happening for many years anyway.

I used to work consulting doing these types of migrations for customers for a huge IT services company.