Re: Column oriented pgsql

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Mag Gam <magawake(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Column oriented pgsql
Date: 2009-05-08 18:25:30
Message-ID: 4A04791A.9020407@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2009-05-08 18:32:01 Re: Remote access
Previous Message Gauthier, Dave 2009-05-08 18:13:21 Re: Controlling psql output