Re: A Silly Idea for Vertically-Oriented Databases - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: A Silly Idea for Vertically-Oriented Databases
Date
Msg-id 200709071413.57861.josh@agliodbs.com
Whole thread Raw
In response to A Silly Idea for Vertically-Oriented Databases  (Avery Payne <apayne@pcfruit.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Avery Payne
Date:
Subject: A Silly Idea for Vertically-Oriented Databases
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: integrated tsearch doesn't work with non utf8 database