Hi *,
I am still working on the newspaper archive project. I started indexing the
articles with tsearch. Along the long text parts I get a "ERROR: deadlock
detected" when I try to build the index "update dpa_text set
titleidx=txt2txtidx(volltext);". The table has a count of 356437 datarows. I
already increased the number of locks per transaction. Any ideas on that ?
regards
-andreas
--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a(dot)schmitz(at)cityweb(dot)de