Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Amazon's "Redshift" data warehouse and PostgreSQL
15 views
Skip to first unread message
Ian Lawrence Barwick
Feb 18, 2013, 12:44:07 AM2/18/13
to
FYI
> Its architecture is based around columnar data storage, advanced compression, and fast disk and network I/O.
>
> This, combined with its roots in the open source PostgreSQL database, has prompted The Reg to speculate that Amazon has managed to parallelize the PostgreSQL technology.
http://www.theregister.co.uk/2013/02/15/amazon_redshift_goes_ga/
> Its architecture is based around columnar data storage, advanced compression, and fast disk and network I/O.
>
> This, combined with its roots in the open source PostgreSQL database, has prompted The Reg to speculate that Amazon has managed to parallelize the PostgreSQL technology.
http://www.theregister.co.uk/2013/02/15/amazon_redshift_goes_ga/
Ian Barwick
Josh Berkus
Feb 18, 2013, 2:15:05 PM2/18/13
to
Redshift is based on Paraccel, which is a parallel, column-store DW fork
of Postgres which forked off version 8.2, and has been around since
2007. Paraccel competes with Vertica Greenplum, Netezza, Aster Data,
and similar DW PostgreSQL forks.
It's DW-only, though; it's completely unsuited to OLTP/webapp workloads.
Analytics only.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-advocacy mailing list (pgsql-a...@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-advocacy
damien clochard
Feb 20, 2013, 11:46:27 AM2/20/13
to
0 new messages