Re: A Silly Idea for Vertically-Oriented Databases

Avery,

> Make one small, very tiny syntactic change to "CREATE TABLE" that
> includes a new keyword, "COLUMN-STORE" or something similar.

If someone writes the rest of the code, I doubt the syntax will be the
holdup. But writing an efficient C-store table mechanism is much harder
than I think you think it is; Vertica worked on it for a year and failed,
and Paraccel took two years to succeed. FYI, Paraccel is based on
Postgres.

So, put up a pgfoundry project and start hacking a c-store table; I'm sure
you;ll get interest if you can make something work.

--
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco