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
Ответ на
Список
Дерево обсуждения
[9.4 bug] The database server hangs with write-heavy workload on Windows "MauMau" <maumau307@gmail.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Andres Freund <andres@2ndquadrant.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows "MauMau" <maumau307@gmail.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Craig Ringer <craig@2ndquadrant.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows "MauMau" <maumau307@gmail.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Craig Ringer <craig@2ndquadrant.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows "MauMau" <maumau307@gmail.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Andres Freund <andres@2ndquadrant.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Andres Freund <andres@2ndquadrant.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows "MauMau" <maumau307@gmail.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows "MauMau" <maumau307@gmail.com>
Re: [9.4 bug] The database server hangs with write-heavy workload on Windows Robert Haas <robertmhaas@gmail.com>
From: "MauMau" 
> 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
Дата:
FAQ