Re: Column oriented pgsql

If you are looking for a column based dbms, you might want to check out Monet - it is a columnar database.

http://monetdb.cwi.nl/

For some applications, columnar databases can be much faster than traditional rdbms systems.  However, column based databases are not a 'one size fits all' answer. 

Brent Friedman

Mag Gam wrote:

Got it thanks!



On Fri, May 8, 2009 at 2:57 PM, Christophe <xof@thebuild.com> wrote: 

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general