General search problem - challenge - Mailing list pgsql-general

From Postgres User
Subject General search problem - challenge
Date
Msg-id b88c3460707021536j41d9278bq91a08dd04fa03115@mail.gmail.com
Whole thread Raw
Responses Re: General search problem - challenge  (Steve Atkins <steve@blighty.com>)
Re: General search problem - challenge  (Richard Huxton <dev@archonet.com>)
List pgsql-general
I have a table of around 6,000 places in the world.  Everytime my
server receives a ping, I'm grabbing the content of an article from an
RSS feed.  Then I search the article for the presence of any the 6000
terms.
A typical article is around 1200 words.

I don't need to save the article in a table and the search is
performed only once, so it's not about FTS.

Any thoughts on the best way to execute these searches using a
traditional language like C++ ?

pgsql-general by date:

Previous
From: Poul Møller Hansen
Date:
Subject: Invalid page header
Next
From: Steve Atkins
Date:
Subject: Re: General search problem - challenge