Re: tsearch2 and pdf files

Magnus Hagander <mha@sollentuna.net>

From: "Magnus Hagander" <mha@sollentuna.net>
To: "philip johnson" <philip.johnson@atempo.com>, <pgsql-general@postgresql.org>
Date: 2006-12-12T07:50:58Z
Lists: pgsql-general
> >> 1. Convert PDF to file with e.g xpdf
> >> 2. Insert parsed text to a table of your choice.
> >> 3. Make vectors from the text.
> >
> > Actually, if you're not going to use the headline() 
> function, you cna 
> > just store it directly in a vector, cutting down on the size 
> > requirements.
> What size requirements ?

If you store both text and tsvector, that's going to use up a lot more
space than if you just store the tsvector. With a proper lexer and such,
it will be *more* than twice as large, given that the tsvector will be
smaller than the text.

//Magnus