Re: Migration to Postgres training

That depends on the purpose of the database. Postgres doesn't have all the capabilities of Oracle RDBMS and if your application is using one of those features, then you're out of luck. Furthermore, as opposed to MariaDB, Postgres doesn't have anything even remotely similar to Oracle in-memory.  Postgres partitioning is a bad joke. It is not possible to define global indexes which means that partitioned tables cannot have a primary key.

On the plus side, the situation with hints was resolved to my satisfaction. There is now an extension called pg_hint_plan which enables me to use Oracle style hints if I want to.

Regards

On 8/8/19 12:29 PM, Igor Neyman wrote:
> My organization switched from Oracle to Postgres 11 years ago.
> So, I could argue regarding "something harder to maintain", and
> regarding savings on licenses. Every specific situation is different,
> and requires specific tool.
> Just don't want to start a "religious war" :)
>
> Regards,
> Igor Neyman
>

--
http://www.freelists.org/webpage/oracle-l