From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "Brett W(dot) McCoy" <bmccoy(at)lan2wan(dot)com> |
Cc: | Andy Lewis <alewis(at)themecca(dot)net>, "'pgsql-general'" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Full Text Searches |
Date: | 1999-05-24 03:30:53 |
Message-ID: | 199905240330.XAA12027@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
We have a fulltext stuff in the contrib directory.
> 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
>
>
>
>
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | MAILER-DAEMON | 1999-05-24 04:49:15 | Undeliverable Message |
Previous Message | Brett W. McCoy | 1999-05-24 02:26:08 | Re: [GENERAL] Full Text Searches |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-05-24 03:32:29 | Re: [HACKERS] Current TODO list |
Previous Message | Brett W. McCoy | 1999-05-24 02:26:08 | Re: [GENERAL] Full Text Searches |