Re: Column oriented pgsql
От
Joshua Tolley
Тема
Re: Column oriented pgsql
Дата
Msg-id
20090508185610.GC25551@eddie
Ответ на
Re: Column oriented pgsql (John R Pierce)
Список
Дерево обсуждения
Column oriented pgsql Mag Gam <magawake@gmail.com>
Re: Column oriented pgsql John R Pierce <pierce@hogranch.com>
Re: Column oriented pgsql Joshua Tolley <eggyknap@gmail.com>
Re: Column oriented pgsql John R Pierce <pierce@hogranch.com>
Re: Column oriented pgsql Christophe <xof@thebuild.com>
Re: Column oriented pgsql Mag Gam <magawake@gmail.com>
Re: Column oriented pgsql "bfriedman.postgresql" <bfriedman.postgresql@gmail.com>
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, 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. 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. - Josh / eggyknap
В списке pgsql-general по дате отправления
