Re: DeadLocks..., DeadLocks...

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: DeadLocks..., DeadLocks...
Дата
Msg-id 87r6oevbyq.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на DeadLocks...  (<tom@tacocat.net>)
Ответы Re: DeadLocks..., DeadLocks...  (<tom@tacocat.net>)
Список 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 по дате отправления:

Предыдущее
От:
Дата:
Сообщение: DeadLocks...
Следующее
От: Frank Wittig
Дата:
Сообщение: Re: pg_xlog - files are guaranteed to be sequentialy named?