Column stores are all the rage now in the data warehousing world as an
alternative to traditional approaches and to MPP approaches that include
Greenplum. There's one company, InfoBright, that's offering a
column-store engine, not open source, for MySQL.
Would a column store work within PostgreSQL from a technical point-of-view
and is anyone pursuing this?
(As an aside, I explored something along these lines myself in the
mid-'90s using InterBase (now Firebird) and Illustra, building on top of
blobs to store data arrays.)
Seth
--
Seth Grimes Alta Plana Corp, analytical computing & data management
Intelligent Enterprise magazine (CMP), Contributing Editor
grimes@altaplana.com http://altaplana.com 301-270-0795