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