Re: PostgreSQL flavors - Mailing list pgsql-general

> On 02/23/2016 07:51 AM, Sherrie Kubis wrote:
>> Hello, my first post to the list, thank you for this place to ask
>> questions and get help.
>>
>> Our management has tasked me with devising a plan to migrate our
>> existing databases from Oracle to PostgreSQL.  I$B!G(Bm researching and
>> getting familiar with PostgreSQL before getting a Linux box to start
>> learning and staging.  I have a long way to go, but it will be fun.
>>
>> Out of the gate, I can see different PostgreSQL products $(Q#|(B PostgreSQL,
>> PostgreSQLPlus, EnterpriseDB Advanced Server.
>
> So here's a quick rundown.  I'm sure I'm forgetting some, but here's a
> lot of them.  I've deliberately omitted PostgreSQL forks/versions
> which are no longer maintained or not commercially available.
>
> Open Source
> -----------
>
> PostgreSQL Plus: EnterpriseDB's distribution of PostgreSQL with extra
> open source tools included in the installer.
>
> GreenPlum: fork of PostgreSQL 8.2, designed for large-scale big data,
> data mining and analytics.
>
> PostgresXC: beta-quality open source fork designed for small clusters
> of transaction-processing, ala Oracle RAC.
>
> PostgresXL: fork of PostgresXC, more stable, and a bit more oriented
> towards data analytics.
>
> Stado: Version of PostgreSQL with java middleware to do big-data
> scale-out.  At various times called ExtenDB and GridSQL.
>
> BigSQL: PostgreSQL+Hadoop for big data scale-out.
>
> PipelineDB: streaming SQL engine built from PostgreSQL.
>
>
> Closed Source
> -------------
>
> PostgreSQL Plus Advanced Server/EDB Server: EnterpriseDB's fork of
> PostgreSQL which has Oracle compatibility and some other tools (like
> xDB replication).  Sometimes includes features from future versions of
> PostgreSQL
>
> CitusDB: latest/greatest big data scale-out version of PostgreSQL.
> Soon to be open-source.
>
> Aster: prior generation of PostgreSQL MPP and Map/Reduce scale-out.
>
> Hadapt: proprietary PostgreSQL+Hadoop fusion.  Based on HadoopDB,
> which was open source.
>
> Paraccel: Column-oriented in-memory cluster database built from
> PostgreSQL 8.2.
>
> RedShift: Amazon's fork of Paraccel, available only on AWS as a
> service.
>
> Vertica: Another PostgreSQL-based column store.  Unclear on how much
> PostgreSQL code it uses, but uses a version of the PostgreSQL protocol
> and psql client.
>
> FAST: Fujitsu's spin of PostgreSQL, optimized for high performance on
> high-end hardware.

PowerGres: Surviving since 2003. Full compatible with PostgreSQL
except "PowerGres plus" which has the transparent database encryption
and the redundant WAL.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp