Re: Migration to Postgres training
- From: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
- To: gogala.mladen@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 8 Aug 2019 11:44:26 -0700
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.
If you are looking for a single in box solution to solve all your needs,
it is true that Postgres won't necessarily service your needs. However,
to address the two specific points:
No "in-memory": PostgreSQL has unlogged tables. It also works
wonderfully with any number of in-memory solutions such as redis or memcache
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.
Command Prompt, Inc. || http://the.postgres.company/
Postgres centered full stack support, consulting and development.
Advocate: @amplifypostgres || Get help: https://commandprompt.com/
***** Unless otherwise stated, opinions are my own. *****
Other related posts: