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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org