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’m 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 – 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.
--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
