General search problem - challenge

From: "Postgres User" <postgres(dot)developer(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: General search problem - challenge
Date: 2007-07-02 22:36:20
Message-ID: b88c3460707021536j41d9278bq91a08dd04fa03115@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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++ ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jason Buberel 2007-07-02 23:01:14 Re: recovery_target_time ignored or recovery always recov ersto end of WAL
Previous Message Dimitrius Weddington 2007-07-02 21:53:47 how to covert a column?