News for hackers. Stuff that matters.
Re:PostgreSQL Parallel Aggregate by atemerev on Wednesday March 23, 2016 @04:53AM (#11342945)
At last! This was the only feature I was missing in Postgres for years.

Postgres is so amazing I still find it hard to believe it's free. I abused it many times (as a graph database; as a real-time financial data analytics engine with thousands of new ticks coming in each second; as a document storage with several TBs of data per node), and amazingly, it just worked. Magic.

If in doubt, choose Postgres.

Re:PostgreSQL Parallel Aggregate by JohnDoe365 on Wednesday March 23, 2016 @05:53AM (#11343126)
Would love to hear more on your usage as a graph database, especially in light of http://static.googleusercontent.com/media/research.google.co...
Re:PostgreSQL Parallel Aggregate by atemerev on Wednesday March 23, 2016 @06:07AM (#11343165)
They have used adjacency lists, which looks strange to me — this is a common way of representing graph data in memory, but doesn't map well to the relational model. I have used "extreme normalization", where all edges are represented as many-to-many relationships with associative tables.

Though I stored document relationships and social graphs, not semantic graphs, as they describe in this paper. I have little experience with semantic graphs — perhaps, they have different requirements.

Re:PostgreSQL Parallel Aggregate by andy_ppp on Wednesday March 23, 2016 @06:42AM (#11343299)
How many joins did it have (sounds very joinery :-D)/or how deep was your graph? Presumably it was doing full table scans for everything - sounds very interesting anyway.
Re:PostgreSQL Parallel Aggregate by atemerev on Wednesday March 23, 2016 @01:47PM (#11346620)
About 1.5 million nodes (not that big), most of queries followed 3-4 edges.

Joins are good. :)

Re:PostgreSQL Parallel Aggregate by gdulli on Wednesday March 23, 2016 @11:31AM (#11345348)
I have a Postgres database with 25 bn rows on a single host with application level partitioning and a parallel query infrastructure. Surely abuse, but Postgres has handled it beautifully.
Re:PostgreSQL Parallel Aggregate by lamby on Wednesday March 23, 2016 @12:20PM (#11345821)
I built something very similar once. My tip would be to shove some HTTP interface on the front of it for some cache guarantees (ie. no arbitrary writes so you can trivially flush, etc. etc.)
Re:PostgreSQL Parallel Aggregate by JohnDoe365 on Wednesday March 23, 2016 @05:24AM (#11343044)
I miss bi-temporal queries/support most. Unfortunately there is little in place as of now in that regard. http://www.postgresql.org/docs/9.5/static/runtime-config-rep... are the humble beginnings.
Re:PostgreSQL Parallel Aggregate by kelvich on Wednesday March 23, 2016 @08:15AM (#11343707)
It is now under development by Enova. They want to prototype bi-temporal support as an extension. https://hdombrovskaya.wordpress.com/2016/03/15/my-presentati...

While I was listening this presentation I've thought that it's quite weird functionality and intersects a lot with transaction visibility rules that MVCC already has. So it is interesting what is your use case?

Re:PostgreSQL Parallel Aggregate by JohnDoe365 on Tuesday April 05, 2016 @05:50AM (#11429153)
Analysing open data portals. PG holds status data on retrievability of links. Depicting the evolvement of such an open data portal over time is possible with custom datetime columns and window fucntions, it's just tedious and error prone.
Re:PostgreSQL Parallel Aggregate by lamby on Wednesday March 23, 2016 @12:18PM (#11345804)
> I still find it hard to believe it's free

PostgreSQL is only free if your time has no value..

(Paraphrased. In jest..)

Re:PostgreSQL Parallel Aggregate by atemerev on Wednesday March 23, 2016 @01:24PM (#11346439)
Do you know any commercial database with comparable level of documentation and community support?

I worked with a certain other database from a company starting with "O" and ending with "racle", and support/documentation quality was abysmal. Our support contract was quite basic, but still, it expected to be better than free alternatives.

It was very NOT.

Re:PostgreSQL Parallel Aggregate by thornygreb on Wednesday March 23, 2016 @02:19PM (#11346905)
I'm sorry, but documentation is one thing Oracle is NOT lacking.

http://docs.oracle.com/cd/E11882_01/nav/portal_booklist.htm

Re:PostgreSQL Parallel Aggregate by esaym on Wednesday March 23, 2016 @05:00PM (#11348189)
He probably meant "readable" documentation....
Re:PostgreSQL Parallel Aggregate by hackbinary on Wednesday March 23, 2016 @05:45PM (#11348526)
I took it to mean the Oracle's support was lessor than that of Postgres', despite paying a fee for it up front.
Re:PostgreSQL Parallel Aggregate by lamby on Saturday March 26, 2016 @10:30PM (#11368597)
It was a comment in jest (as I mentioned).
Re:PostgreSQL Parallel Aggregate by esaym on Wednesday March 23, 2016 @04:58PM (#11348167)
In comparison to what? Mysql? Perhaps. Mysql is a little simpler and quicker to pick up, but one must remember, the original intent of mysql was to stop Devs from using text files for storage...

But in comparison to an enterprise solution like DB2 or Oracle? Not even close...

If you are trying to pull nosql into the argument, that is not even apples to oranges, plus with nosql, you get to retool your entire architecture.