Re: TOASTing smaller things

Ühel kenal päeval, N, 2007-03-22 kell 10:19, kirjutas Luke Lonergan:
> Andreas,
>
> On 3/22/07 9:40 AM, "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de> 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.

Maybe monetdb ( http://monetdb.cwi.nl/ ) can be of some inspiration ?

btw, it may be a good idea to have a verion of bizgresMPP which has
monetdb as partition db, if monetdb is as efficient as they tell it is .

>
> 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.
>
> - Luke
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
--
----------------
Hannu Krosing
Database Architect
Skype Technologies OÜ
Akadeemia tee 21 F, Tallinn, 12618, Estonia

Skype me: callto:hkrosing
Get Skype for free: http://www.skype.com