Ühel kenal päeval, N, 2007-03-22 kell 10:19, kirjutas Luke Lonergan: > 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.
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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster