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

Citus Unforks from PostgreSQL, Goes Open Source

citusdata.com

Post reply on HN
Print view View original

151–156 of 156 posts

Re: Citus Unforks from PostgreSQL, Goes Open Source

#151

Post by manigandham »

tlarkworthy wrote: post #32
rkrzr wrote: post #3

This is fantastic news! Postgres does not have a terribly strong High Availability story so far and of course it also does not scale out vertically. I have looked at CitusDB in the past, but was always put off by its closed-source nature. Opening it up seems like a great move for them and for all Postgres users. I can imagine that a very active open-source community will develop around it.

nit: Postgres doesn't scale horizontally, it only scales vertically.

It doesnt scale vertically either. Postgres is single-threaded meaning it can't make use of multiple CPU cores on the same machine. There have been some slow improvements to this and 9.6 seems to hint at some parallel aggregation changes but overall Postgres is strong in features but weak in scaling (in any direction).

Re: Citus Unforks from PostgreSQL, Goes Open Source

#152

Post by manigandham »

X86BSD wrote: post #61
tspiteri wrote: post #51

Earlier quoted context omitted.

The BSDL does not make much economic sense to the company open sourcing their code; a new competitor would fork the code, make closed improvements, and merge any changes from the open source code. That means that the competitor is always gaining by a one-way flow of improvements. To use open source code, the more permissive the license the better. But to actually open your own code, BSDL is a very tough sell. That's…

So you take a BSDL codebase, fork it, close it, make proprietary changes, profiting from the BSDL codebase, then slap the PG community in the face by open sourcing it under a more restrictive license hoping to benefit from the community you just slapped in the face but restricting competition. They are of course free to release their code under any license they wish. I just think releasing code under the *GPL when yo…

Entire industries have profited from BSDL licensed code without contributing anything back. This is the point of BSDL.

Re: Citus Unforks from PostgreSQL, Goes Open Source

#153

Post by anarazel »

manigandham wrote: post #151
tlarkworthy wrote: post #32

Earlier quoted context omitted.

nit: Postgres doesn't scale horizontally, it only scales vertically.

It doesnt scale vertically either. Postgres is single-threaded meaning it can't make use of multiple CPU cores on the same machine. There have been some slow improvements to this and 9.6 seems to hint at some parallel aggregation changes but overall Postgres is strong in features but weak in scaling (in any direction).

"hint at"?

Re: Citus Unforks from PostgreSQL, Goes Open Source

#154

Post by manigandham »

anarazel wrote: post #153
manigandham wrote: post #151

Earlier quoted context omitted.

It doesnt scale vertically either. Postgres is single-threaded meaning it can't make use of multiple CPU cores on the same machine. There have been some slow improvements to this and 9.6 seems to hint at some parallel aggregation changes but overall Postgres is strong in features but weak in scaling (in any direction).

"hint at"?

https://news.ycombinator.com/item?id=11331602

It looks good, will have to wait and see what actually makes it into 9.6 and how well it supports all the possible queries. This is something that many commercial databases have solved so Postgres is pretty behind in vertical scaling.

Re: Citus Unforks from PostgreSQL, Goes Open Source

#155

Post by anarazel »

manigandham wrote: post #154
anarazel wrote: post #153

Earlier quoted context omitted.

"hint at"?

https://news.ycombinator.com/item?id=11331602 It looks good, will have to wait and see what actually makes it into 9.6 and how well it supports all the possible queries. This is something that many commercial databases have solved so Postgres is pretty behind in vertical scaling.

To me it's a bit weird calling committed patches "hints".

Re: Citus Unforks from PostgreSQL, Goes Open Source

#156

Post by tlarkworthy »

anarazel wrote: post #155
manigandham wrote: post #154

Earlier quoted context omitted.

https://news.ycombinator.com/item?id=11331602 It looks good, will have to wait and see what actually makes it into 9.6 and how well it supports all the possible queries. This is something that many commercial databases have solved so Postgres is pretty behind in vertical scaling.

To me it's a bit weird calling committed patches "hints".

British English vs. American English? I dunno if the poster is British but I am. I read that they haven't done enough to call pg vertically scalable but recent work suggestions (hints) that they are working toward it. The expression is more metaphorical than literal, an Atlantic divide my American colleagues explicitly warn me about when I am writing my perf reviews.
Post reply on HN