Re: Columnar store as default for PostgreSQL 10?

Поиск
Список
Период
Сортировка
От Francisco Olarte
Тема Re: Columnar store as default for PostgreSQL 10?
Дата
Msg-id CA+bJJby4d=kBE4A_jEn5mkQkvEm9cY+kx8SUGT7skk8ni7gf2g@mail.gmail.com
обсуждение исходный текст
Ответ на Columnar store as default for PostgreSQL 10?  (Bráulio Bhavamitra <brauliobo@gmail.com>)
Список pgsql-general
Hi Bráulio:

On Thu, Apr 21, 2016 at 12:08 PM, Bráulio Bhavamitra
<brauliobo@gmail.com> wrote:
> 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.

And have you read anything about the drawbacks of columnar? They are
there, but writing about them does not makes the headlines.

> 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?

An option may be good ( may, not sure because nothing is free. More
complex code, more bug surface, some time will be eaten managing the
extra complexity, less developer time available for each feature, ...
) , but IMHO a complete move would be bad. Columnar is not that good
for a lot of postgres usages. If columnar were the silver bullet
everybody would be doing it.

Francisco Olarte.


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

Предыдущее
От: Steve Rogerson
Дата:
Сообщение: setting time zone in a function
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: Invalid data read from synchronously replicated hot standby