Re: odd deadlock on CREATE TABLE AS SELECT

From: Greg Stark <gsstark(at)mit(dot)edu>
To: digitaldeath <digital(dot)death(at)gmx(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: odd deadlock on CREATE TABLE AS SELECT
Date: 2009-11-09 11:25:03
Message-ID: 407d949e0911090325r2c14758ax9e80358ea0d66cdf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Nov 9, 2009 at 9:48 AM, digitaldeath <digital(dot)death(at)gmx(dot)it> wrote:
> Everybody is doing SELECT only on "adc" table, so why deadlocks if there
> are no write attempts on any row?

Well the deadlock error does include the information about what
queries deadlocked. In newer versions it includes the full text of the
query, but in older versions you would have to check the pg_stat*
views or postgres logs to track them down.

--
greg

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Haas 2009-11-09 12:23:24 Re: BUG #5128: Returning nested composite types in plpython
Previous Message digitaldeath 2009-11-09 09:48:27 Re: odd deadlock on CREATE TABLE AS SELECT