Home > mailing lists

Full text indexing on documents outside the DB - Mailing list pgsql-novice

From	Leo
Subject	Full text indexing on documents outside the DB
Date	February 14, 2008 12:02:02
Msg-id	000601c86f12$3ac45920$232401c8@leo Whole thread Raw
List	pgsql-novice

Tree view

Hello, I have installed the new 8.3 Postgres and all works fine for me.

It took some time to reload the old tsearch2 tables, but they are OK now.

My question is: How can I create the tsvector data for large text files WITHOUT loading the text into a column of the DB?

I did it using 2 tables (one with the text inserted with a perl program) and copying the tsvectors and removing the table with the text, but it is not easy to add data this way.

The text files are "frozen" so I don't need a trigger to update the tsvector, all I store is a URL of the text.

So what I am looking for is a way to point to a file and create the tsvector.

Maybe somebody can help me?

BTW the dictionary does a very nice job ignoring all the HTML junk in the files.

Thanks in advance

pgsql-novice by date:

From: Sachin Srivastava
Date: 14 February 2008, 05:38:32
Subject: How to test changes done to the code

From: "Nicholas Hemley"
Date: 15 February 2008, 11:05:24
Subject: installation of postgres 8.3 on CentOs 5.1

Full text indexing on documents outside the DB - Mailing list pgsql-novice

Previous

Next