Re: Column oriented pgsql

From: Christophe <xof(at)thebuild(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Column oriented pgsql
Date: 2009-05-08 18:57:14
Message-ID: 6D4A3D5E-1E2B-4395-9D84-622DBB356201@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On May 8, 2009, at 11:25 AM, John R Pierce wrote:
> 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.

I believe what is referring to is the disk storage organization,
clustering a single column from multiple rows together onto a page.
For example, if your typical use of a table is to read one particular
column from a large number of rows, this could (in theory) improve
performance.

AFAIK, PostgreSQL doesn't support this.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Johnny Edge 2009-05-08 19:05:28 pg query exec time, reports
Previous Message Joshua Tolley 2009-05-08 18:56:10 Re: Column oriented pgsql