Re: how to avoid deadlock on masive update with multiples delete

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: how to avoid deadlock on masive update with multiples delete
Дата
Msg-id CAGTBQpbK3K56Jzx_xU3ch1QB2TcnbwmQUd0T_98V6BoScGHOMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: how to avoid deadlock on masive update with multiples delete  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: how to avoid deadlock on masive update with multiples delete  (Maciek Sakrejda <m.sakrejda@gmail.com>)
Re: how to avoid deadlock on masive update with multiples delete  ("Anibal David Acosta" <aa@devshock.com>)
Список pgsql-performance
Дерево обсуждения 
On Thu, Oct 4, 2012 at 1:10 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
> The bulk update could take an Exclusive (not Access Exclusive) lock.
> Or the delete could perhaps be arranged to delete the records in ctid
> order (although that might still deadlock).  Or you could just repeat
> the failed transaction.

How do you make pg update/delete records, in bulk, in some particular order?

(ie, without issuing separate queries for each record)

В списке pgsql-performance по дате отправления:

Предыдущее
От: Igor Neyman
Дата:
Сообщение: Re: how to avoid deadlock on masive update with multiples delete
Следующее
От: Maciek Sakrejda
Дата:
Сообщение: Re: how to avoid deadlock on masive update with multiples delete