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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
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,
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
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,
Got it thanks!
On Fri, May 8, 2009 at 2:57 PM, Christophe x...@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
Joshua Tolley wrote:
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.
indeed. among other issues is, just what order should those columns be
stored in? database tables have no implicit order, they
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'