Re: Debugging deadlocks

From: Vivek Khera <vivek(at)khera(dot)org>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Debugging deadlocks
Date: 2005-03-31 04:24:01
Message-ID: 3df8bbda556a97e126009673fa9539ab@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yudie Pg 2005-03-31 04:38:41 Re: Empty date
Previous Message Edson Vilhena de Carvalho 2005-03-31 03:23:15 Database monitor (again)