Search Postgresql Archives

Re: integration of fulltext search in bytea/docs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello

Dne 29. červenec 2009 16:46 Radek Novotný <radek.novotny@xxxxxxxxxxxx>
napsal(a):
> Hello,
> is there in the roadmap of postgre integration of fulltext searching in
> documents saved in blobs (bytea)?
>

What I know, no. PostgreSQL doesn't know about others binary formats,
so it cannot do it.

> For example linux antiword can export fine text output that can be inserted
> into varchar field.

I understand it well. Three years ago, we used antiword. We stored two
values - bytea - original word doc, and text - antiword output. The
overhead is minimal, and this solution worked very well.

>
> Would be very very nice (postgre users can be proud to be first) to save
> documents into bytea and search that field via to_tsvector, to_tsquery ...
>

It's should be very slow. You have to do repeated transformation.

Pavel Stehule

> --
>
> www.publicstream.cz - vytvořili jsme produkt pro živé přenosy (online
> streaming) a videoarchív ve formátu FLASH.
>
> Bc. Radek Novotný
> jednatel Mediawork group s.r.o.
>
> tel.: +420 724 020 361
> email: radek.novotny@xxxxxxxxxxxx
> http://www.mediawork.cz
>
>

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux