Re: DeadLocks..., DeadLocks... - Mailing list pgsql-general

From Gregory Stark
Subject Re: DeadLocks..., DeadLocks...
Date
Msg-id 87r6oevbyq.fsf@oxford.xeocode.com
Whole thread Raw
In response to DeadLocks...  (<tom@tacocat.net>)
Responses Re: DeadLocks..., DeadLocks...  (<tom@tacocat.net>)
List pgsql-general
<tom@tacocat.net> writes:

> But everyone once in a long while it seems that I hit simultaneaous
> execute() statements that deadlock on the insertion.

What version of Postgres is this and do you have any foreign key constraints
or triggers on the table you're inserting into? Is that insert the *only* DML
you're executing? No updates or deletes?

What do you mean by saying it deadlocks? Do you get a transaction abort with
an error about a deadlock detected? Or do you just mean it freezes?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-general by date:

Previous
From:
Date:
Subject: DeadLocks...
Next
From: Frank Wittig
Date:
Subject: Re: pg_xlog - files are guaranteed to be sequentialy named?