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

From Bráulio Bhavamitra
Subject Columnar store as default for PostgreSQL 10?
Date
Msg-id CAJri6_vF4WcUXn8R2bBxKyMayVbB0QVjV4SBGc2XLiiJ-WfD0A@mail.gmail.com
Whole thread Raw
Responses Re: Columnar store as default for PostgreSQL 10?
Re: Columnar store as default for PostgreSQL 10?
Re: Columnar store as default for PostgreSQL 10?
Re: Columnar store as default for PostgreSQL 10?
List pgsql-general
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.

best regards,
bráulio 

pgsql-general by date:

Previous
From: Sachin Kotwal
Date:
Subject: Re: error while installing auto_explain contrib module
Next
From: Steve Rogerson
Date:
Subject: setting time zone in a function