From: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Greg Smith <greg(at)2ndquadrant(dot)com>, Greg Williamson <gwilliamson39(at)yahoo(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Comparison of Oracle and PostgreSQL full text search |
Date: | 2010-08-12 03:39:10 |
Message-ID: | 0C35EA38-A0F9-4C00-96B7-3B4692EC0B72@cleverelephant.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Did the FAA ever publish slides of those talks? Sure wish I could see them... :)
P.
On 2010-08-11, at 6:58 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Greg Smith wrote:
>> 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.
>
> The FAA reported something like that at PG East about Oracle vs.
> Postgres performance with GIS data.
>
> --
> Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> EnterpriseDB http://enterprisedb.com
>
> + It's impossible for everything to be true. +
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2010-08-12 03:58:19 | Re: Comparison of Oracle and PostgreSQL full text search |
Previous Message | Bruce Momjian | 2010-08-12 02:00:05 | Re: Comparison of Oracle and PostgreSQL full text search |