Comparison of Oracle and PostgreSQL full text search

From: Howard Rogers <hjr(at)diznix(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Comparison of Oracle and PostgreSQL full text search
Date: 2010-07-28 01:58:40
Message-ID: AANLkTi=9n9wpSuR=d05hv76i5zgJr0zPp_OqqzKLKzBK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks to some very helpful input here in earlier threads, I was
finally able to pull together a working prototype Full Text Search
'engine' on PostgreSQL and compare it directly to the way the
production Oracle Text works. The good news is that PostgreSQL is
bloody fast! The slightly iffy news is that the boss is now moaning
about possible training costs!

For what it's worth, I wrote up the performance comparison here:
http://diznix.com/dizwell/archives/153

Maybe it will be of use to anyone else wondering if it's possible to
do full text search and save a couple hundred thousand dollars whilst
you're at it!

Regards
HJR

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-07-28 02:20:25 Re: psql problem
Previous Message Patrick May 2010-07-28 01:25:05 Re: Histogram generator