Re: Columnar store as default for PostgreSQL 10? - Mailing list pgsql-general

From Francisco Olarte
Subject Re: Columnar store as default for PostgreSQL 10?
Date
Msg-id CA+bJJby4d=kBE4A_jEn5mkQkvEm9cY+kx8SUGT7skk8ni7gf2g@mail.gmail.com
Whole thread Raw
In response to Columnar store as default for PostgreSQL 10?  (Bráulio Bhavamitra <brauliobo@gmail.com>)
List 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 by date:

Previous
From: Steve Rogerson
Date:
Subject: setting time zone in a function
Next
From: Sameer Kumar
Date:
Subject: Re: Invalid data read from synchronously replicated hot standby