[EMAIL PROTECTED] ("Luke Lonergan") writes:
> Andreas,
> On 3/22/07 9:40 AM, "Andreas Pflug" <[EMAIL PROTECTED]> wrote:
>> Wouldn't it be enough to enable having the toast table on a different
>> table space?
> Yes, but the ultimate goal would allow the allocation of a storage mechanism
> that is unique to each column.  The most frequently used mechanism for our
> customers would likely be to have each column associated with it's own
> internal relation (like a separate TOAST table), which puts each column into
> it's own dense page storage.
> Beside the advantages of separating out keys columns from data columns,
> compression and encryption approaches that use column packed data are much
> more effective.
> As Tom points out there are complications WRT update, access, etc that need
> to be worked out to support this, but it's an important capability to have
> IMO.

Hmm.  Are you trying to do something sort of like CStore?


That seems to have some relevant ideas...
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
Where do you  *not* want to go today?  "Confutatis maledictis, flammis
acribus addictis" (<http://www.hex.net/~cbbrowne/msprobs.html>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to