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