Skip site navigation (1) Skip section navigation (2)

Re: Comparison of Oracle and PostgreSQL full text search

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Greg Williamson <gwilliamson39(at)yahoo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Comparison of Oracle and PostgreSQL full text search
Date: 2010-07-29 23:42:57
Message-ID: 4C521201.2070303@2ndquadrant.com (view raw or flat)
Thread:
Lists: pgsql-general
Greg Williamson wrote:
> Our tests -- very much oriented at postGIS found Oracle to be between 5
> and 15% _faster_ depending on the specifics of the task. We decided to go
> with postgres given the price difference (several hundred thousand dollars for
> Oracle in the configuration we needed vs. zip for postgres -- we already had
> trained postgres DBAs).
>   

Can always throw the licensing savings toward larger hardware too; $100K 
buys a pretty big server nowadays.  At the FAA's talk about their 
internal deployment of PostgreSQL:  
https://www.postgresqlconference.org/2010/east/talks/faa_airports_gis_and_postgresql

They were reporting that some of their difficult queries were 
dramatically faster on PostgreSQL; I vaguely recall one of them was 100X 
the speed it ran under Oracle Spatial.  It was crazy.  As always this 
sort of thing is very workload dependent.  There are certainly queries 
(such as some of the ones from the TPC-H that big DB vendors optimize 
for) that can be 100X faster on Oracle too.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com   www.2ndQuadrant.us


In response to

Responses

pgsql-general by date

Next:From: Greg SmithDate: 2010-07-29 23:58:22
Subject: Re: Which CMS/Ecommerce/Shopping cart ?
Previous:From: Howard RogersDate: 2010-07-29 23:38:32
Subject: Re: Comparison of Oracle and PostgreSQL full text search

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group