Subject: Re: Migration to Postgres training
To: oracle-l@freelists.org
References: <a426e1e7-1419-252d-199e-6aa7446923d5@commandprompt.com>
 <CADEE6ZMPwPAzthZfUbFX-Ph+QOUa-tsvGua6DRPhKyZGcihaow@mail.gmail.com>
 <CAJoeKmsu6CS-3Q5d6cwsy68NkJbGZhU30vQ4pc9V6LUJaHJUMg@mail.gmail.com>
From: Mladen Gogala <gogala.mladen@gmail.com>
Message-ID: <f79bce92-7f86-046c-4f8b-cfcb3d80a972@gmail.com>
Date: Thu, 8 Aug 2019 13:02:38 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.8.0
MIME-Version: 1.0
In-Reply-To: <CAJoeKmsu6CS-3Q5d6cwsy68NkJbGZhU30vQ4pc9V6LUJaHJUMg@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: gogala.mladen@gmail.com

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
>
--
http://www.freelists.org/webpage/oracle-l