Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgresql 9.6: Support parallel aggregation

postgresql.org

Post reply on HN
Print view View original

21–30 of 64 posts

Re: Postgresql 9.6: Support parallel aggregation

#21

Post by chris_wot »

pbarnes_1 wrote: post #10
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.

Yeah, that point is probably occurring as we speak :-)

Re: Postgresql 9.6: Support parallel aggregation

#22

Post by kbenson »

chris_wot wrote: post #20
kbenson wrote: post #17

Earlier quoted context omitted.

> There is going to come a point where Postgres passes Oracle in terms of features and performance. I wouldn't be so sure. Oracle has deep pockets, and I'm not sure there's a reason why anything PostgreSQL wants to roll out they can't pay to prioritize and have done sooner. > 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 m…

Oh, I'm not saying this is an overnight thing or that Oracle will be destroyed. In fact, I don't want to see them destroyed, but what I am interested in is that their market power and influence wanes over time. Ironically, this will be good for Oracle - they will be forced to dump immoral and illegal business practices. The problem commercial businesses have when it comes to open source is that you might be able to r…

Yes, in a way open source acts as a vibrant market of competitors forcing proprietary products to innovate where they may have been willing to stagnate, and in a way immune to some of the more anti-capitalistic ways of preventing innovation (e.g. buying out the main competitors). As unions worked to combat some of the major criticisms of capitalism by Marx (as I understand it), open source works to combat some of the major criticisms of companies in the software market (patents are put in an interesting light in this theory).

Re: Postgresql 9.6: Support parallel aggregation

#24

Post by chris_wot »

kbenson wrote: post #22
chris_wot wrote: post #20

Earlier quoted context omitted.

Oh, I'm not saying this is an overnight thing or that Oracle will be destroyed. In fact, I don't want to see them destroyed, but what I am interested in is that their market power and influence wanes over time. Ironically, this will be good for Oracle - they will be forced to dump immoral and illegal business practices. The problem commercial businesses have when it comes to open source is that you might be able to r…

Yes, in a way open source acts as a vibrant market of competitors forcing proprietary products to innovate where they may have been willing to stagnate, and in a way immune to some of the more anti-capitalistic ways of preventing innovation (e.g. buying out the main competitors). As unions worked to combat some of the major criticisms of capitalism by Marx (as I understand it), open source works to combat some of the…

It's funny, I really feel until open source became widely known as a viable thing that patent reform was dead and non-existent. Not only that, but things like the Sonny Bono Copyright Extension Act passed just before the start of the true mainstreaming of open source culture, but wouldn't fly now.

Re: Postgresql 9.6: Support parallel aggregation

#26

Post by harel »

HoyaSaxa wrote: post #23

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.

Out of curiosity what does it matter if your postgres download is via http or https? Is there any benefit of hiding your download from prying eyes?

Re: Postgresql 9.6: Support parallel aggregation

#27

Post by allan_s »

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)

and I'm still here waiting for 9.5 to arrive in RDS of amazon :(

Re: Postgresql 9.6: Support parallel aggregation

#28

Post by HoyaSaxa »

harel wrote: post #26
HoyaSaxa wrote: post #23

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.

Out of curiosity what does it matter if your postgres download is via http or https? Is there any benefit of hiding your download from prying eyes?

One main benefit of https is confidentiality, but for OSS downloads it more importantly provides an integrity and authentication benefit as well. Sure checksums and/or package signing should provide the same benefit, but most users cannot say they have checked these for every installation (and checksums are useless if served via http because they can be tampered via a man-in-the-middle attack).

Re: Postgresql 9.6: Support parallel aggregation

#29

Post by stuartaxelowen »

harel wrote: post #25

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.

Because they are building an open source industry leading database. What's not exciting about that!

Re: Postgresql 9.6: Support parallel aggregation

#30

Post by reactor »

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…

First hand experience, I work for a bank which is a Fortune 100, and our department was heavily relying on Oracle Exadata, paying between 1-2 millions (don't know exact figure), we moved away to PostgreSQL and Casandra. Cost factor was not the only motive (1-2 millions was actually penny for this bank) but our Director was convinced that exadata was unnecessary.
Post reply on HN