Re: lock problem

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: lock problem
Дата
Msg-id 4EF1B04D0200002500043F4C@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: lock problem  (Rural Hunter <ruralhunter@gmail.com>)
Ответы Re: lock problem
Список pgsql-admin
Rural Hunter <ruralhunter@gmail.com> wrote:

> I still have this question:
> same statement A,B,C,D update same row. The start order is
> A->B->C-D.  From what I've gotten, B/C/D got the lock before A.
> Why did that happen?

Did you do anything to prevent it from happening?  If not, the OS
scheduler is going to give time to one process or another in a
fairly unpredictable way.

-Kevin

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

Предыдущее
От: Rural Hunter
Дата:
Сообщение: Re: lock problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: stats and unix sockets