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

41–50 of 64 posts

Re: Postgresql 9.6: Support parallel aggregation

#41

Post by sandGorgon »

pilif wrote: post #35

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. Or they could just release their own fork under an open license and focus on just adding features. But that's not how they…

I wish they would build a RDS alternative. I would use them in a heartbeat. There are all these companies/startups who are not in the target market for consulting... But who would gladly pay for hosted postgres.

Re: Postgresql 9.6: Support parallel aggregation

#42

Post by jpgvm »

sandGorgon wrote: post #41
pilif wrote: post #35

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. Or they could just release their own fork under an open license and focus on just adding features. But that's not how they…

I wish they would build a RDS alternative. I would use them in a heartbeat. There are all these companies/startups who are not in the target market for consulting... But who would gladly pay for hosted postgres.

If you don't mind hosting it yourself check out Flynn our pg appliance is very similar to how RDS is constructed. Or if you are more adventurous look at Joyent Manatee which the Flynn code is based off.

Re: Postgresql 9.6: Support parallel aggregation

#43

Post by sandGorgon »

jpgvm wrote: post #42
sandGorgon wrote: post #41

Earlier quoted context omitted.

I wish they would build a RDS alternative. I would use them in a heartbeat. There are all these companies/startups who are not in the target market for consulting... But who would gladly pay for hosted postgres.

If you don't mind hosting it yourself check out Flynn our pg appliance is very similar to how RDS is constructed. Or if you are more adventurous look at Joyent Manatee which the Flynn code is based off.

But that is precisely what I want to avoid. For most startups at an early stage, what we are short of is people. It's the github vs self hosted argument - most people with limited people resources would default to github.

RDS is the most expensive thing we pay for. It's worth it.

Re: Postgresql 9.6: Support parallel aggregation

#44

Post by pbreit »

stuartaxelowen wrote: post #29
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!

Is anyone still starting with MySQL anymore?

Re: Postgresql 9.6: Support parallel aggregation

#45

Post by reactor »

chris_wot wrote: post #38
reactor wrote: post #30

Earlier quoted context omitted.

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.

Out of interest, what are the benefits of Exadata, or is it really a bit of emperorer's new clothes? Can you not get similar performance with similar good hardware?

We were on x5-2 and it was a beast, but in reality we never needed those specs. I think, Oracle sales guys got to those MD's who were calling the shots.

Re: Postgresql 9.6: Support parallel aggregation

#46

Post by spariev »

filereaper wrote: post #8

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.

There is a "Hacking PostgreSQL" course[1], which tries to explain PostgreSQL internals and architecture, but it is available in Russian only[2]

[1] http://postgrespro.ru/education/courses/hacking [2] https://www.youtube.com/watch?list=PLaFqU3KCWw6Jfb8IBNk3hZ07...

Re: Postgresql 9.6: Support parallel aggregation

#47

Post by htn »

sandGorgon wrote: post #41
pilif wrote: post #35

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. Or they could just release their own fork under an open license and focus on just adding features. But that's not how they…

I wish they would build a RDS alternative. I would use them in a heartbeat. There are all these companies/startups who are not in the target market for consulting... But who would gladly pay for hosted postgres.

Please check out our Aiven (https://aiven.io). Managed & hosted pay-per-hour PostgreSQL that is available on GCE, AWS and DigitalOcean.

Re: Postgresql 9.6: Support parallel aggregation

#48

Post by sandGorgon »

htn wrote: post #47
sandGorgon wrote: post #41

Earlier quoted context omitted.

I wish they would build a RDS alternative. I would use them in a heartbeat. There are all these companies/startups who are not in the target market for consulting... But who would gladly pay for hosted postgres.

Please check out our Aiven ( https://aiven.io ). Managed & hosted pay-per-hour PostgreSQL that is available on GCE, AWS and DigitalOcean.

Very cool! I would definitely use you guys once my aws credits run out. Quick suggestion - please make your pricing front and center. If you didn't tell me on HN, I would have dropped off on your home page. Check cloudways pricing page for a very similar business model pricing page.

Re: Postgresql 9.6: Support parallel aggregation

#49

Post by jpgvm »

sandGorgon wrote: post #43
jpgvm wrote: post #42

Earlier quoted context omitted.

If you don't mind hosting it yourself check out Flynn our pg appliance is very similar to how RDS is constructed. Or if you are more adventurous look at Joyent Manatee which the Flynn code is based off.

But that is precisely what I want to avoid. For most startups at an early stage, what we are short of is people. It's the github vs self hosted argument - most people with limited people resources would default to github. RDS is the most expensive thing we pay for. It's worth it.

Agreed, but the option is always nice. :)

Re: Postgresql 9.6: Support parallel aggregation

#50

Post by harel »

pbreit wrote: post #44
stuartaxelowen wrote: post #29

Earlier quoted context omitted.

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

Is anyone still starting with MySQL anymore?

"mySql" is dead to me. Literally. Anything Oracle touches becomes a potential legal liability. Its Maria DB now and although I do maintain a legacy 100GB+ MARIA db, I will never use it again for new projects. The thing about postgres is that once you start using it you understand there is really very little competition in both the open or commercial worlds. My previous big project relied on mongoDB for statistical data. At the time there was no other compelling document database for our use case. Today, this decision is no longer relevant because if I can get the same functionality and performance out of Postgres I will choose postgres. The ability to combine the SQL with "NoSQL" is just too compelling.
Post reply on HN