Re: Q: Comparing PostgreSQL and Oracle

st 20. 5. 2020 v 9:34 odesílatel Alfonso <achavesco(at)gmail(dot)com> napsal:

> Hi colleagues.
>
>
> I'm working in a Java application with some colleagues and we are in
> doubt wether to use Oracle or PostgreSQL as the data store. It will be a
> OLTP mainly application.
>
> Beside of license terms/costs which is a clear point in favor of
> PostgreSQL, could you please help me to get some more details regarding
> what you can do in PostgreSQL and you can't in Oracle oand viceversa,
> and what can be done using both but it is better done by PostgreSQL vs
> Oracle and so on?
>
> I mean, about functionalities, performance, support costs if any and
> qualtity, etc.
>

this analyse can have more than thousand pages. Oracle and Postgres are two
different databases (in some parts - ACID implementation, planner, plan
cache, architecture it is very different).

Probably a distance between Oracle and Postgres is much less than Oracle
and MSSQL database, but that is all what can be reply on too general
question.

You can read some notes related to migration from Oracle to Postgres. More
it depends how deep are you SQL and database knowledges. For some low
levels (lot of developers has less than minimum knowledges about databases)
the the difference is very small. On high levels almost all is different
(in details). It is hard to say if some is better or worse, or is better to
do something on Postgres and better to do something on Oracle - because
these databases are different and has different sensitivity on patterns and
antipatterns.

Very different is maintenance of these databases. Postgres is simply
database with low necessity of maintenance (sure, that depends on
dimensions and risks). Oracle is much more complex difficult to learn
system. But for Oracle there is lot of commercial (not cheap tools) and
generally Oracle is better adapted in enterprise area (special hw, tools,
legislative).

So in detail - almost all are different, but both these databases are
relational SQL databases.

Regards

Pavel

>
> Many thanks.
>
> Best Regards.
>
>
>
>
>