Re: Column oriented pgsql - Mailing list pgsql-general

From John R Pierce
Subject Re: Column oriented pgsql
Date
Msg-id 4A04791A.9020407@hogranch.com
Whole thread Raw
In response to Column oriented pgsql  (Mag Gam <magawake@gmail.com>)
Responses Re: Column oriented pgsql
Re: Column oriented pgsql
List 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.



pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Re: Controlling psql output
Next
From: John R Pierce
Date:
Subject: Re: Remote access