Hi,
I've successfully added tsearch2 to an existing database and the speedup of searches is brilliant. I'm now trying to extend this to other parts of our system.
One of the tables holds reasonable amounts of text, some fields hold up to 2Mb. When I try and run
UPDATE table SET idxfti=to_tsvector('default', field);it runs for a while then aborts with the following message
ERROR: value is too big
Does anyone know what the problem might be here? Does tsearch2 have configurable (or compilable) settings that could get around this?
Many Thanks, James
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
