Re: [PERFORM] Hanging queries on dual CPU windows

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: [PERFORM] Hanging queries on dual CPU windows
Дата
Msg-id dv30nr$1aaf$1@news.hub.org
обсуждение исходный текст
Ответ на Re: [PERFORM] Hanging queries on dual CPU windows  ("Magnus Hagander" <mha@sollentuna.net>)
Список pgsql-hackers
""Magnus Hagander"" <mha@sollentuna.net> wrote
> Ok, I've coded up a patch that changes the code to use a mutex instead.

Are we asserting the problem is caused by the spinlock random wake-up order?
I am not sure why this would fix the problem. If my memory serves, a
critical section might be a problem if one process aborts unexpected while
it is inside. Other waiting processes can never have a chance to enter it
(also have no chance to handle SIGQUIT) -- so this patch may solve this.

There is another suspect in http://www.devisser-siderius.com/stack1.jpg,
i.e., process 3 does shmctl. I once filed a server core dump bug in win32 of
reporting WSAEWOULDBLOCK.
(http://archives.postgresql.org/pgsql-bugs/2006-02/msg00185.php). AFAICS, it
is actually an mistranslated EINTR. There seems some relation between these
issues, but I didn't come up with a complete theory of it.

Regards,
Qingqing




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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Proposal for updatable views
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: [PATCHES] Automatic free space map filling