Postgres Pro
Downloads
Home   >   mailing lists

Re: odd deadlock on CREATE TABLE AS SELECT - Mailing list pgsql-bugs

From Greg Stark
Subject Re: odd deadlock on CREATE TABLE AS SELECT
Date
Msg-id 407d949e0911090325r2c14758ax9e80358ea0d66cdf@mail.gmail.com
Whole thread Raw
In response to Re: odd deadlock on CREATE TABLE AS SELECT  (digitaldeath <digital.death@gmx.it>)
List pgsql-bugs
Tree view 
On Mon, Nov 9, 2009 at 9:48 AM, digitaldeath <digital.death@gmx.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

pgsql-bugs by date:

Previous
From: digitaldeath
Date:
Subject: Re: odd deadlock on CREATE TABLE AS SELECT
Next
From: Robert Haas
Date:
Subject: Re: BUG #5128: Returning nested composite types in plpython