From owner-freebsd-database Tue Dec 1 16:33:06 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id QAA13346 for freebsd-database-outgoing; Tue, 1 Dec 1998 16:33:06 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from candle.pha.pa.us (s5-03.ppp.op.net [209.152.195.67]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id QAA13317 for ; Tue, 1 Dec 1998 16:32:34 -0800 (PST) (envelope-from maillist@candle.pha.pa.us) Received: (from maillist@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id SAA07094; Tue, 1 Dec 1998 18:27:41 -0500 (EST) From: Bruce Momjian Message-Id: <199812012327.SAA07094@candle.pha.pa.us> Subject: Re: [HACKERS] Re: Mysql 321 - Mysql 322 - msql In-Reply-To: <1747.912185625@sss.pgh.pa.us> from Tom Lane at "Nov 27, 1998 11:53:45 am" To: tgl@sss.pgh.pa.us (Tom Lane) Date: Tue, 1 Dec 1998 18:27:41 -0500 (EST) Cc: pgsql-hackers@postgreSQL.org, database@FreeBSD.ORG X-Mailer: ELM [version 2.4ME+ PL47 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk > I don't currently have any databases that could benefit from full-text > indexes. But I can think of applications where it'd be important, > particularly after we get rid of the limit on tuple sizes so that it > becomes reasonable to put fair-size chunks of text into database > entries. For example: would it be useful to put my email archive into > a Postgres database, one message per tuple? Maybe ... but if I can't > glimpse it afterwards, forgetaboutit. > > You could probably glue something like this together from existing > spare parts, say by running a nightly cron job that dumps out the > text fields of your database for indexing by Glimpse. But it wouldn't > be integrated into SQL --- you'd have to query the index separately > outside of SQL, then use the results to drive a query to fetch the > selected records. We do have contrib/fulltextindex. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message