Re: Full text search on a complex schema - a classic problem?

From: Ivan Voras <ivoras(at)freebsd(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Full text search on a complex schema - a classic problem?
Date: 2010-05-24 09:42:54
Message-ID: htdhmq$j8$2@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05/23/10 07:17, Craig Ringer wrote:
> On 23/05/10 10:40, Ivan Voras wrote:
>> Hello,
>>
>> I have a schema which tracks various pieces of information which would
>> need to be globally searchable.
>
> If systems that exist outside the database its self are acceptable,
> check out Apache Lucerne, and tools that use it like Hibernate Search.

We are currently using such an external system and while it works fast
enough it has two problems:

1) the need to periodically refresh it (via cron)
2) it complicates deployment a bit by adding dependencies

so we're moving away from it.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Gage 2010-05-24 12:21:23 Apache authorization using postgres
Previous Message Ivan Voras 2010-05-24 09:41:37 Re: Full text search on a complex schema - a classic problem?