Re: Is possible to connect through dblink from xe to postgresql to use plsql logic

From: Mladen Gogala <>
Date: Mon, 22 Feb 2016 22:57:57 -0500
Message-ID: <>

On 2/19/2016 11:48 AM, Juan Carlos Reyes Pacheco wrote:
> Anyway is interesting to find a real big tendency to move to open
> source database.
> I think that is expected.

Postgres is very, very far from Oracle. Partitioning is a joke, you cannot create a global index and is somewhat reminiscent of Oracle 7 partition views. There is no internal parallelism, nothing like parallel query. Until very recently, hints were not supported and are still frowned upon by Postgres community. Some Japanese guy created the extension called pg_hint_plan, which mimics Oracle hints, but you will read next to nothing about it on the "mainstream" PostgreSQL forums. Add to that the ridiculous architecture decision to put old rows (UNDO segments in Oracle) into the table itself, and you will get a ridiculously slow full table scans. Postgres is nowhere near Oracle and the article in Tech Republic is ridiculous. The only real competitor to Oracle is IBM DB2, every bit as powerful as Oracle, but a lot cheaper. There is no open source database that can match Oracle. Not even close.

Mladen Gogala
Oracle Consultant

DISCLAIMER: I am solely responsible for any opinion expressed in this email

Received on Tue Feb 23 2016 - 04:57:57 CET

Original text of this message