X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1C0D85E46C0 for ; Wed, 18 Aug 2004 02:01:12 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01734-02 for ; Wed, 18 Aug 2004 05:01:06 +0000 (GMT) Received: from ra.sai.msu.su (ra.sai.msu.su [158.250.29.2]) by svr1.postgresql.org (Postfix) with ESMTP id 12C6A5E46D4 for ; Wed, 18 Aug 2004 02:00:53 -0300 (ADT) Received: from ra (ra [158.250.29.2]) by ra.sai.msu.su (8.12.10/8.12.10) with ESMTP id i7I50cQT018987; Wed, 18 Aug 2004 09:00:38 +0400 (MSD) Date: Wed, 18 Aug 2004 09:00:38 +0400 (MSD) From: Oleg Bartunov X-X-Sender: megera@ra.sai.msu.su To: Gaetano Mendola Cc: pgsql-admin@postgresql.org Subject: Re: Documents storage In-Reply-To: <412297DE.9030903@bigfoot.com> Message-ID: References: <412297DE.9030903@bigfoot.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/156 X-Sequence-Number: 14551 On Wed, 18 Aug 2004, Gaetano Mendola wrote: > Oleg Bartunov wrote: > > > On Tue, 17 Aug 2004, Gaetano Mendola wrote: > > > > > >>Hi all, > >>where I work some times we need to find our documents > >>searching for a couple of words. I was thinking to > >>use the tsearch2. > >> > >>Shall I use OpenFTS? > >>Do you have any suggestion ? > >> > > > > > > tsearch2 is ok if you have docs and db on the same server, OpenFTS > > is a middleware on top of tsearch2. > > What advantage I have on use OpenFTS instead of use tsearch2 directly ? > I read the FAQ but I'm still missing what I can do with OpenFTS that I > can not with tsearch2. ok. OpenFTS abstracts document storage, so you could process and store documents on separate server, while full text indices (tsearch2) live in other server. > > Regards > Gaetano Mendola > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83