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