Andreas Schmitz <a.schmitz@cityweb.de> writes:
> 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 ?
This does not sound like an out-of-resources kind of problem. Either
you did something wrong or you found a bug. But it's impossible to
tell which. Can you provide a SQL script that reproduces the behavior
you're seeing?
regards, tom lane