On Mon, 2007-09-10 at 16:09 -0400, Robert Bernier wrote:
> Two links here, comments anybody?
>
> http://www.computerworlduk.com/technology/applications/databases/news/index.cfm?newsid=5059
>
> http://www.databasecolumn.com/
As Stonebraker himself points out, "one size fits all" isn't true. His
claim than column-oriented databases can perform 50 times faster than
row-oriented (i.e. us) is IMHO true, but only on certain queries and he
neglects to comment that on many queries they suck really badly too.
My advocated approach is to learn from the technique and include lessons
learned into PostgreSQL, that way we have the benefits of multiple
techniques as and when required.
So, yes, one day I expect to include column-oriented techniques into the
database server, but it probably won't be a straight implementation of
verbatim Stonebraker... There is some discussion on -hackers on this
now, but please everybody don't start a surge on this now or soon, we
have a release to get out of the door.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com