Postgres Pro
Downloads
Home   >   mailing lists

Thread: Documents storage

Documents storage

From
Gaetano Mendola
Date:
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 ?



Regards
Gaetano Mendola

Re: Documents storage

From
Oleg Bartunov
Date:
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.

>
>
> Regards
> Gaetano Mendola
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

    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

Re: Documents storage

From
Gaetano Mendola
Date:
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.

Regards
Gaetano Mendola

Re: Documents storage

From
Oleg Bartunov
Date:
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