Ühel kenal päeval, E, 2007-09-10 kell 11:01, kirjutas Alvaro Herrera:
> Mark Mielke wrote:
> > Simon Riggs wrote:
> >> ISTM we would be able to do this fairly well if we implemented
> >> Index-only columns. i.e. columns that don't exist in the heap, only in
> >> an index.
> >> Taken to the extreme
Avery Payne wrote:
> >I thought maybe we can call it COAST, Column-oriented attribute storage
> technique, :-)
>
> I like it. :-)http://www.2ndQuadrant.com";> I
> just wish I would have read this before applying for a project name
> at pgfoundry, the current proposal is given as "pg-cstore".
>ISTM we would be able to do this fairly well if we implemented
>Index-only columns. i.e. columns that don't exist in the heap, only in
>an index.
>Taken to the extreme, all columns could be removed from the heap and
>placed in an index(es). Only the visibility information would remain on
>
Mark Mielke wrote:
> Simon Riggs wrote:
>> ISTM we would be able to do this fairly well if we implemented
>> Index-only columns. i.e. columns that don't exist in the heap, only in
>> an index.
>> Taken to the extreme, all columns could be removed from the heap and
>> placed in an index(es). Only t
Simon Riggs wrote:
ISTM we would be able to do this fairly well if we implemented
Index-only columns. i.e. columns that don't exist in the heap, only in
an index.
Taken to the extreme, all columns could be removed from the heap and
placed in an index(es). Only the visibility information would
On Fri, 2007-09-07 at 13:52 -0700, Avery Payne wrote:
> So I've been seeing/hearing all of the hoopla over vertical databases
> (column stores), and how they'll not only slice bread but also make
> toast, etc. I've done some quick searches for past articles on
> "C-Store", "Vertica", "Column S
On 9/7/07, Avery Payne <[EMAIL PROTECTED]> wrote:
>
> Avery,
>
>
>
> >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,
> >a
Avery,
>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 b
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
