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.

JD

--
Command Prompt, Inc. || http://the.postgres.company/ ;|| @cmdpromptinc
Postgres centered full stack support, consulting and development.
Advocate: @amplifypostgres || Get help: https://commandprompt.com/
*****     Unless otherwise stated, opinions are my own.   *****

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


Other related posts: