On Tue, 22 Feb 2005, James Croft wrote:
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?
this is tsearch2 limitation on length of ts_vector about 1mb. you may stop using postional information for this vector.
Many Thanks, James
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
