Re: Oracle to PostgreSQL - DWH

I am a solution architect and worked on an oracle to postgres project almost 10 years ago. This was a 9 TB oracle 10 to postgres 9.0, Community postgres wasn't a viable option and client leaned on to enterprisedb postgres because of pl/sql, table partitioning, optimizer hints and database links compatibility. They also got some assessment done before I jumped on this project. Believe me, with the help of streaming replication, read scaling wasn't an issue and with the help of pgpool reads were load balanced to standby servers. Table Partitiong and Partial Indexes were quite helpful in query optimization. Postgres required lots of parameter tuning and table level optimization(read about vacuuming and mvcc in postgres)
When you are moving out of oracle the first thought is "how much do I save not today but for the lifespan of an application" and then you think about how database landscape is changing which motivates you to look into databases beyong oracle. Today Postgres open source or any other fork of postgres(https://wiki.postgresql.org/wiki/PostgreSQL_derived_databases) for sure can handle DWH workloads provided it is tuned for read and designed to be scalable.
The project I designed was a success.