From: Oleg Bartunov <oleg@sai.msu.su>
To: Aaron Bono <postgresql@aranya.com>
Cc: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Re: Efficient Searching of Large Text Fields
Date: Wed, 14 Jun 2006 11:07:41 +0400 (MSD)
Message-ID: <Pine.GSO.4.63.0606141107050.10866@ra.sai.msu.su> (raw)
In-Reply-To: <bf05e51c0606131330w75fd9b84ke63778a22ee0b2d9@mail.gmail.com>
References: <bf05e51c0606131330w75fd9b84ke63778a22ee0b2d9@mail.gmail.com>
Don't invent a wheel and use contrib/tsearch2 for that.
On Tue, 13 Jun 2006, Aaron Bono wrote:
> In another post on a different topic, Rod Taylor said the following:
>
> "A\tcat in the\nhat" might be stored as ARRAY['A', 'cat', 'in', 'the',
> 'hat'].
>
> This got me thinking. I have a discussion forum for gamers and want
> to provide searching capabilities so the user can type in a phrase
> like "magical bow" and get all posts, sorted by relevance that contain
> these words.
>
> My questions are:
> 1. Will storing the posts in an ARRAY help improve performance of
> these searches? If so, by how much?
> 2. What functions or libraries are available to make such searching
> easy to implement well?
> 3. What is the best way to sort by relevance?
>
> Thanks,
> Aaron Bono
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: oleg@sai.msu.su, postgresql@aranya.com
Subject: Re: Efficient Searching of Large Text Fields
In-Reply-To: <Pine.GSO.4.63.0606141107050.10866@ra.sai.msu.su>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox