Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Full Text Searches

From: "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com>
To: Andy Lewis <alewis(at)themecca(dot)net>
Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, "'pgsql-general'" <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Full Text Searches
Date: 1999-05-24 02:26:08
Message-ID: Pine.LNX.4.04.9905232220040.6721-100000@dragosani.lan2wan.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Sun, 23 May 1999, Andy Lewis wrote:

> Whats the possibility of having full text searches added to text fields?
> 
> That would be awesome.....

Unfortunately, full text indexing is a different issue than the kind of
indexing performed on table columns, and if you want to do any kind of
efficient full text searching, you have to index the individual words in
the text or it'd be so slow as to be hardly useful (especially if you're
talking about 600,000 records with 2K of text in each text field).

Excalibur, for instance, creates its own internal indexing for full text
records, but uses an underlying SQL database for regular fielded data, and
when you design your database, you have to make the distinction about what
kind of indexing you want, stop words (words you don't want indexed, like
'the' and 'of'), and the way certain fields can or will be searched.

Brett W. McCoy           
                                        http://www.lan2wan.com/~bmccoy/
-----------------------------------------------------------------------
The six great gifts of an Irish girl are beauty, soft voice, sweet speech,
wisdom, needlework, and chastity.
		-- Theodore Roosevelt, 1907



In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1999-05-24 03:30:53
Subject: Re: [GENERAL] Full Text Searches
Previous:From: Tom LaneDate: 1999-05-24 00:43:33
Subject: Re: [HACKERS] strange behavior of UPDATE

pgsql-general by date

Next:From: Bruce MomjianDate: 1999-05-24 03:30:53
Subject: Re: [GENERAL] Full Text Searches
Previous:From: Anna LangerDate: 1999-05-24 02:22:04
Subject: Problems with INSERT INTO?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group