Re: Column oriented pgsql

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Column oriented pgsql
Дата
Msg-id 4A04791A.9020407@hogranch.com
обсуждение исходный текст
Ответ на Column oriented pgsql  (Mag Gam <magawake@gmail.com>)
Ответы Re: Column oriented pgsql  (Joshua Tolley <eggyknap@gmail.com>)
Re: Column oriented pgsql  (Christophe <xof@thebuild.com>)
Список 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 по дате отправления:

Предыдущее
От: "Gauthier, Dave"
Дата:
Сообщение: Re: Controlling psql output
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Remote access