Re: stonebraker diffs RDBMS

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Robert Bernier <robert(dot)bernier5(at)sympatico(dot)ca>
Cc: pgsql-advocacy(at)postgresql(dot)org
Subject: Re: stonebraker diffs RDBMS
Date: 2007-09-12 09:33:56
Message-ID: 1189589636.4281.587.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

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

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Bruce Momjian 2007-09-14 15:00:35 Re: Change the name
Previous Message Dave Page 2007-09-12 09:23:53 We got a mention on The Register