Re: tsearch2 and pdf files

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: tsearch2 and pdf files
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA0FDF9@algol.sollentuna.se
обсуждение исходный текст
Ответ на Re: tsearch2 and pdf files  ("philip johnson" <philip.johnson@atempo.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Why DISTINCT ... DESC is slow?
Следующее
От: Michael Glaesemann
Дата:
Сообщение: Re: Why DISTINCT ... DESC is slow?