Re: Comparison of Oracle and PostgreSQL full text search

From: Mark Cave-Ayland <mark(dot)cave-ayland(at)siriusit(dot)co(dot)uk>
To: 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-07-29 09:03:39
Message-ID: 4C5143EB.5010107@siriusit.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
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).

Interesting. Do you have information about the versions of PostGIS/GEOS
that you were using? Of course we'd be very interested to see examples
of test cases with bad performance on the postgis-users list so that we
can improve them.

ATB,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2010-07-29 09:08:41 PostgreSQL and distributed transactions
Previous Message Ivan Sergio Borgonovo 2010-07-29 08:52:17 Re: Which CMS/Ecommerce/Shopping cart ?