Re: the s_lock_stuck on perform_spin_delay

Поиск
Список
Период
Сортировка
Искать
От
Andy Fan
Тема
Re: the s_lock_stuck on perform_spin_delay
Дата
Msg-id
8734uz17va.fsf@163.com
Ответ на
Список
Дерево обсуждения
the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Tom Lane <tgl@sss.pgh.pa.us>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Tom Lane <tgl@sss.pgh.pa.us>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Andres Freund <andres@anarazel.de>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Robert Haas <robertmhaas@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>
Re: the s_lock_stuck on perform_spin_delay Matthias van de Meent <boekewurm+postgres@gmail.com>
Re: the s_lock_stuck on perform_spin_delay Andy Fan <zhihuifan1213@163.com>

Robert Haas  writes:

> On Wed, Jan 10, 2024 at 10:17 PM Andy Fan  wrote:
>> fixed in v2.
>
> Timing the spinlock wait seems like a separate patch from the new sanity checks.

Yes, a separate patch would be better, so removed it from v4.

> I suspect that the new sanity checks should only be armed in
> assert-enabled builds.

There are 2 changes in v4. a). Make sure every code is only armed in
assert-enabled builds. Previously there was some counter++ in non
assert-enabled build. b). Record the location of spin lock so that
whenever the Assert failure, we know which spin lock it is. In our
internal testing, that helps a lot.

-- 
Best Regards
Andy Fan
В списке pgsql-hackers по дате отправления
От: jian he
Дата:
От: vignesh C
Дата:
FAQ