Re: [9.4 bug] The database server hangs with write-heavy workload on Windows

Поиск
Список
Период
Сортировка
От MauMau
Тема Re: [9.4 bug] The database server hangs with write-heavy workload on Windows
Дата
Msg-id C14E24B014CB434EA821DE702EEC3253@maumau
обсуждение исходный текст
Ответ на Re: [9.4 bug] The database server hangs with write-heavy workload on Windows  ("MauMau" <maumau307@gmail.com>)
Список pgsql-hackers
From: "MauMau" <maumau307@gmail.com>
> Thank you very much.  I didn't anticipate such a difficult complicated 
> cause.  The user agreed to try the patch tonight.  I'll report back the 
> result as soon as I got it from him.

The test ran successfully without hang for 24 hours.  It was run with your 
patch + the following:

> BTW, in LWLockWaitForVar(), the first line of the following code fragment 
> is not necessary, because lwWaitLink is set to head immediately.  I think 
> it would be good to eliminate as much unnecessary code as possible from 
> the spinlock section.
>
>  proc->lwWaitLink = NULL;
>
>  /* waiters are added to the front of the queue */
>  proc->lwWaitLink = lock->head;
>

Regards
MauMau




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

Предыдущее
От: Lucas Lersch
Дата:
Сообщение: Re: Buffer Requests Trace
Следующее
От: Alexander Korotkov
Дата:
Сообщение: WIP: Access method extendability