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
