Re: Migration to Postgres training

From: Joshua D. Drake <>
Date: Thu, 8 Aug 2019 11:44:26 -0700
Message-ID: <>

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. || || _at_cmdpromptinc
Postgres centered full stack support, consulting and development.
Advocate: _at_amplifypostgres || Get help:
*****     Unless otherwise stated, opinions are my own.   *****

Received on Thu Aug 08 2019 - 20:44:26 CEST

Original text of this message