Thanks Andy and all Experts here for your valuable inputs.
From: Andy Ellicott <andyellicott@gmail.com> Sent: woensdag 12 februari 2020 17:27 To: Gurudutt Dhareshwar <gurudutt.dhareshwar@gmail.com> Cc: Amit jain <amit7.jain@gmail.com>; Bhattacharjee, Soumik <soumik.bhattacharjee@kpn.com>; pgsql-admin@lists.postgresql.org; pgsql-admin@postgresql.org Subject: Re: Oracle to PostgreSQL - DWH
Hi all,
Rather than Greenplum, a fresher option for data warehousing is to use standard Postgres (or EDB), but deployed on FPGA-equipped servers.
FPGAs were part of the magic inside of the old Netezza data warehouse appliances. And Amazon just announced they are using FPGA servers to speed up Redshift. FPGA-equipped hardware is becoming more common (e.g., AWS EC2 F1 instances).
You stay on free Postgres, but do require software to run on the FPGA chips... Swarm64.com (where I work) develops FPGA acceleration software for Postgres (v. 11 and up)...it adds a lot of parallel processing on the FPGA along with columnar indexing (foreign data table) to speed up queries and insertion.
Depending on the data/queries, FPGA will accelerate PG to Oracle-type speeds at terabytes scale, but for a much lower cost of course.
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)