Re: Column oriented pgsql

Joshua Tolley wrote:
> http://en.wikipedia.org/wiki/Column_oriented_database
> This has come up on the lists from time to time; the short answer is it's
> really hard.
>

indeed. among other issues is, just what order should those columns be
stored in? database tables have no implicit order, they are abstractly
unordered sets of rows. an index can impose an order but a given table
can have multiple indexes, and a given query can sort on most any
arbitrary thing it wants. and, say you are storing the columns sorted
by the primary key, how do you do inserts or updates that change this
order?

instead of one table with (key, v1, v2, v3) how about N tables, (k,v1),
(k,v2), (k,v3) ? or at least, one extra table with just the value
that you want columnar access to?