Then you should possibly look at Greenplum, which is a PostgreSQL based system designed for data warehouses. True, they lag behind PostgreSQL versions considerably, but if your concern is data warehouses, that’s probably the way to go.
—
Jay
Sent from my iPad
On Feb 12, 2020, at 10:35 AM, soumik.bhattacharjee@kpn.com wrote:
Migration is fine, but is PostgreSQL good for DWH use cases ?
Can PostgreSQL support data warehousing loads?
From: John Wiencek <jwiencek3@comcast.net>
Sent: woensdag 12 februari 2020 16:31
To: Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>
Cc: pgsql-admin@lists.postgresql.org; pgsql-admin@postgresql.org
Subject: Re: Oracle to PostgreSQL - DWH
EnterpriseDB has a product called Migration Toolkit (MTK) that can do this.
John
Did anyone have some use cases for migrating Oracle to PostgreSQL in context to DWH(Data warehousing ) considering 5TB to 8TB database size (Source-Oracle)