Re: A Silly Idea for Vertically-Oriented Databases

From: Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Avery Payne <apayne(at)pcfruit(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: A Silly Idea for Vertically-Oriented Databases
Date: 2007-09-10 14:38:02
Message-ID: 46E556CA.4080000@mark.mielke.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 remain on
> the heap.
>
Wouldn't the extreme be - even the visibility information is in the
index? :-)

Cheers,
mark

--
Mark Mielke <mark(at)mielke(dot)cc>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-09-10 14:56:31 Re: integrated tsearch doesn't work with non utf8 database
Previous Message Tom Lane 2007-09-10 14:37:26 Re: integrated tsearch doesn't work with non utf8 database