Re: Migration to Postgres training
Date: Thu, 8 Aug 2019 11:44:26 -0700
Message-ID: <02738ebd-596f-100e-8ad1-f17ec23ee33e_at_commandprompt.com>
On 8/8/19 10:02 AM, Mladen Gogala wrote:
> 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.
Partitioning: This gets better every release. Version 10 was o.k., 11 was much better, and 12 is even better. Pretty much the only thing missing as of 12 is the global indexes. However, you can have Primary Keys per partition with 12.
It all depends on your specific needs but PostgreSQL can usually service
100% of 95% of Oracle users needs.
JD
-- Command Prompt, Inc. || http://the.postgres.company/ || _at_cmdpromptinc Postgres centered full stack support, consulting and development. Advocate: _at_amplifypostgres || Get help: https://commandprompt.com/ ***** Unless otherwise stated, opinions are my own. ***** -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 08 2019 - 20:44:26 CEST