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

From: Malden Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 23 Feb 2016 08:10:31 -0600
Message-Id: <E2D172F4-3130-4E38-A80A-A6B64BFD35E1_at_gmail.com>



I agree. You get what ypu pay for.

Sent from my iPhone

> On Feb 23, 2016, at 7:42 AM, Igor Neyman <igor.neyman_at_gmail.com> wrote:
> 
> Not every application needs all the bells and whistles that come with Oracle.
> For the features it provides, Postgres is a great value. 
> 

>> On Mon, Feb 22, 2016 at 10:57 PM, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>>
>>
>>> 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.
>>> 
>>> http://www.techrepublic.com/article/oracles-biggest-database-foe-could-it-be-postgres/

>>
>> 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
>> http://mgogala.freehostia.com
>>
>> DISCLAIMER: I am solely responsible for any opinion expressed in this email
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 23 2016 - 15:10:31 CET

Original text of this message