Re: Columnar store as default for PostgreSQL 10?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Columnar store as default for PostgreSQL 10?
Дата
Msg-id CAKFQuwbvKob+87g_LpDOVj0kDc3wS6WeqmiBO9OHW2t6wFZa3Q@mail.gmail.com
обсуждение исходный текст
Ответ на Columnar store as default for PostgreSQL 10?  (Bráulio Bhavamitra <brauliobo@gmail.com>)
Ответы Re: Columnar store as default for PostgreSQL 10?  (Geoff Winkless <pgsqladmin@geoff.dj>)
Список pgsql-general
Дерево обсуждения
On Thu, Apr 21, 2016 at 3:08 AM, Bráulio Bhavamitra <brauliobo@gmail.com> wrote:
Hi all,

I'm finally having performance issues with PostgreSQL when doing big analytics queries over almost the entire database of more than 100gb of data.

And what I keep reading all over the web is many databases switching to columnar store (RedShift, Cassandra, cstore_fdw, etc) and having great performance on queries in general and giant boosts with big analytics queries.

I wonder if there is any plans to move postgresql entirely to a columnar store (or at least make it an option), maybe for version 10?

The current extensions are rather limited (types support for example) and require quite some configuration and data migration to work, besides they don't work in services like AWS RDS.

​I have little experience (and nothing practical) with columnar store but at a high level I don't see the point.  I would hope that anyone interested in working on a columnar store database would pick an existing one to improve rather than converting a very successful row store database into one.  And I don't immediately understand how a dual setup would even be viable - it seems like you'd have to re-write so much 
​of the code the only thing left would be the SQL parser.

​
​David J.
​

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Update field to a column from another table