Re: DeadLocks..., DeadLocks...

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: <tom(at)tacocat(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: DeadLocks..., DeadLocks...
Date: 2007-06-14 14:37:33
Message-ID: 87r6oevbyq.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


<tom(at)tacocat(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank Wittig 2007-06-14 14:40:32 Re: pg_xlog - files are guaranteed to be sequentialy named?
Previous Message tom 2007-06-14 14:09:24 DeadLocks...