On Fri, May 08, 2009 at 11:25:30AM -0700, John R Pierce wrote: > Mag Gam wrote: >> Is it possible to tweak (easily) Postgresql so the storage is column >> oriented versus row-oriented? We would like to increase read >> optimization on our data which is about 2TB. >> >> > > you read your tables by column, rather than by row?? > > SQL queries are inherently row oriented, the fundamental unit of storage > is a 'tuple', which is a representation of a row of a table. http://en.wikipedia.org/wiki/Column_oriented_database This has come up on the lists from time to time; the short answer is it's really hard. - Josh / eggyknap
Attachment:
signature.asc
Description: Digital signature
