ERROR: deadlock detected - Mailing list pgsql-admin

From Andreas Schmitz
Subject ERROR: deadlock detected
Date
Msg-id 200302121557.55277.a.schmitz@cityweb.de
Whole thread Raw
Responses Re: ERROR: deadlock detected  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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.schmitz@cityweb.de


pgsql-admin by date:

Previous
From: "vivek K."
Date:
Subject: Connection refused
Next
From: Robert Treat
Date:
Subject: Re: Connection refused