Re: Debugging deadlocks - Mailing list pgsql-general

From Vivek Khera
Subject Re: Debugging deadlocks
Date
Msg-id 3df8bbda556a97e126009673fa9539ab@khera.org
Whole thread Raw
In response to Re: Debugging deadlocks  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
On Mar 30, 2005, at 4:47 PM, Alvaro Herrera wrote:

> Now this can't be applied right away because it's easy to run "out of
> memory" (shared memory for the lock table).  Say, a delete or update
> that touches 10000 tuples does not work.  I'm currently working on a
> proposal to allow the lock table to spill to disk ...
>

That would be most excellent, as I have deadlocks from transactions
that do upwards of 100k inserts selecting data from other tables.


pgsql-general by date:

Previous
From: Edson Vilhena de Carvalho
Date:
Subject: Database monitor (again)
Next
From: Yudie Pg
Date:
Subject: Re: Empty date