From: | Bráulio Bhavamitra <brauliobo(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Columnar store as default for PostgreSQL 10? |
Date: | 2016-04-21 10:08:53 |
Message-ID: | CAJri6_vF4WcUXn8R2bBxKyMayVbB0QVjV4SBGc2XLiiJ-WfD0A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Olarte | 2016-04-21 11:01:32 | Re: Columnar store as default for PostgreSQL 10? |
Previous Message | Shane Kilkelly | 2016-04-21 09:29:04 | Announcing BedquiltDB: A json doc-store built on PostgreSQL |